Customizing the DbSqlSessionFactory

[subramanya_murt]

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 to change anything in the activiti code as such.

I guess this should be possible, even though I am not able to figure out how.

Thanks in advance.

[frederikherema1]

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…

[subramanya_murt]

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

[alandemarest]

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