topic Re: With Spring integration, MyBatis closed db connection early in Alfresco Archive

With Spring integration, MyBatis closed db connection early

xml2008 — Sat, 27 Nov 2010 05:20:49 GMT

Hi,I am trying to embed activiti (5.0rc1) engine in my web app with spring integration,and doing something like following codeublic class UserBean { /** injected by Spring */ private RuntimeService runtimeService; @Transactional public void hello() { // here you can do transactional stuff i

Re: With Spring integration, MyBatis closed db connection early

jbarrez — Mon, 29 Nov 2010 10:12:27 GMT

Probably your datasource is not correctly specified. Could you give your spring config ?

Re: With Spring integration, MyBatis closed db connection early

xml2008 — Mon, 29 Nov 2010 13:00:31 GMT

Thanks for your attention.

My dataSource is just defined as following:


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close" >
        <property name="driverClassName">
            <value>${database.driver_class}</value>
        </property>
        <property name="url">
            <value>${database.url}</value>
        </property>
        <property name="username">
            <value>${database.username}</value>
        </property>
        <property name="password">
            <value>${database.password}</value>
        </property>
        <property name="defaultAutoCommit">
            <value>false</value>
        </property>
        <property name="maxActive">
            <value>${database.maxActive}</value>
        </property>
  <!–
        <property name="validationQuery">
            <value>select * from Test</value>
        </property>–>
    </bean>

After I debug through the code, I found that :

when a new SqlSession is created by DefaultSqlSessionFactory.openSession method:

public SqlSession openSession() {
return openSessionFromDataSource(configuration.getDefaultExecutorType(), null, false);
}

a new db connection is obtained from datasource instead of spring's managed thread local connection.

But when MyBatis's ManagedTransaction.commit method is invoked:

public void commit() throws SQLException {
// Does nothing
}

previous connection is closed without commitment, so nothing is saved to database at all.

Is that the desired behavior?

Re: With Spring integration, MyBatis closed db connection early

tombaeyens — Tue, 30 Nov 2010 16:48:44 GMT

Did you use the ProcessEngineFactoryBean to build the process engine?

If that is the case and you still experience a problem with tomorrow's 5.0 release, file a jira for this with the full spring configuration file.

Re: With Spring integration, MyBatis closed db connection early

jbarrez — Thu, 02 Dec 2010 09:38:32 GMT

You need to wrap the datasource in a TransactionalAwareDatasource, that should fix your problem (check the Spring example configs that are shipped with Activiti).

Re: With Spring integration, MyBatis closed db connection early

xml2008 — Sat, 04 Dec 2010 01:17:14 GMT

The problem is solved after I upgrated to 5.0GA. Thanks for your help.

Re: With Spring integration, MyBatis closed db connection early

dli — Wed, 02 Sep 2015 02:25:23 GMT

I do have this problem when i using acticiti5.17 with spring now,i don't know how to do.

look at my spring config:

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
     <property name="dataSource" ref="mysql" />
     <property name="transactionManager" ref="transactionManager" />
     <property name="databaseSchemaUpdate" value="false" />
     <property name="jobExecutorActivate" value="false" />
     <property name="asyncExecutorEnabled" value="true" />
     <property name="asyncExecutorActivate" value="false" />
</bean>

<bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean" lazy-init="true">
    <property name="processEngineConfiguration" ref="processEngineConfiguration" />
</bean>

Re: With Spring integration, MyBatis closed db connection early

jbarrez — Tue, 08 Sep 2015 09:59:08 GMT

Your xml is missing, you have to use code tags to post xml.