topic Re: Customizing the DbSqlSessionFactory in Alfresco Archive

Customizing the DbSqlSessionFactory

subramanya_murt — Thu, 25 Aug 2011 08:14:16 GMT

Hello,I am trying to customize the DbSqlSessionFactory by sub-classing it. Basically, I want to add more specialized database specific queries without having to change DbSqlSessionFactory.Please let me know how do I make the activiti engine to use the subclass of DbSqlSessionFactory without having t

Re: Customizing the DbSqlSessionFactory

frederikherema1 — Thu, 25 Aug 2011 08:38:39 GMT

There is a map "customSessionFactories" on the processEngineConfiguration. Add your factory to it, using the key DbSQLSesison.class. I think that should do the trick…

Re: Customizing the DbSqlSessionFactory

subramanya_murt — Thu, 25 Aug 2011 14:38:15 GMT

Thanks a lot for your input. I could successfully load my custom DbSqlSessionFactory 🙂

Re: Customizing the DbSqlSessionFactory

alandemarest — Wed, 01 Aug 2012 10:10:42 GMT

This is my first post on this forum, so Hi everyone!

I'm trying to do the same, but i'm using spring. And as opposed to Your advice of using map I use list.
MyDbSqlSessionFactory extends DbSqlSessionFactory implements SessionFactory
and has implemented methods as super-class.

So far i have:

…
<bean id="myDbSqlSessionFactory" class="com.my.MyDbSqlSessionFactory"/>
….
and in processEngineConfiguration bean:
….
<property name="customSessionFactories">
  <list>
   <ref bean="myDbSqlSessionFactory"/>
   <ref bean="myManagerSessionFactory"/>
  </list>
</property>

NOTE: myManagerSessionfactory Works just fine

When Jetty initialize the context I have NullPointerException,
which source is shortly speaking sqlSessionFactory field

I'm really stuck. In my Implementation i just want to override getStatement method

Thanks in advance