topic Configuring JTA with Activiti in Alfresco Archive

Configuring JTA with Activiti

suad — Sun, 21 Aug 2011 10:30:00 GMT

I am trying to configure activiti (5.6) to use Bitronix as Transaction Manager through JtaProcessEngineConfiguration. I am using MySQL as a database. Currently I am running the application as a standalone. I am getting the below exception.[2011-08-21 13:57:06,579] DEBUG main java.sql.PreparedStateme

Re: Configuring JTA with Activiti

chris_joelly — Sun, 21 Aug 2011 11:22:18 GMT

for me setting the properties RelaxAutoCommit and ElideSetAutoCommits to true in the JDBC MySQL connection pool in Glassfish helped with this issue

Re: Configuring JTA with Activiti

ronald_van_kuij — Sun, 21 Aug 2011 16:34:46 GMT

Thanks for mentioning this Chris. I'd think the error was obvious as would have been searching for the answer in a glassfish forum or something. But thanks anyway

Re: Configuring JTA with Activiti

suad — Mon, 22 Aug 2011 08:46:37 GMT

Hi Chris/Ronald,

I have tried setting the properties but I am still getting the same exception. Please note that I am using the XA datasource and not the regular datasource.

moreover, the same configuration (MySQL XA datasource + Bitronix) works fine in my application without using activiti. But once I integrate it with activiti I get the exception?

Re: Configuring JTA with Activiti

chris_joelly — Mon, 22 Aug 2011 17:51:55 GMT

just one thought, because i have no other idea

did u try setting:


<property name="transactionsExternallyManaged" value="true" />

in the processEngineConfiguration?

when i asked regarding this problem at the Glassfish mailinglist i got answer
that it is defined in JDBC4 spec that after closing a transaction a JDBC driver
should set autocommit to true again, so statements executed outside of an
transaction gets commited immediately. So this behavior is ok i think. Maybe
setting the properties RelaxAutoCommit end ElideAutoCommit… did not work?

Re: Configuring JTA with Activiti

frankee787 — Mon, 22 Aug 2011 18:08:08 GMT

Does a Spring managed JTA transaction(with an implementation of Bitronix) and a Application Service (Glassfish) managed JTA transaction make any difference for Activiti?

Re: Configuring JTA with Activiti

ronald_van_kuij — Mon, 22 Aug 2011 22:34:28 GMT

If thay are not the same transaction manager, sure it makes a difference, not only for activiti, but for any system. 2 jta transaction managers does not make any sense at all to me

Re: Configuring JTA with Activiti

frankee787 — Tue, 23 Aug 2011 04:10:31 GMT

If thay are not the same transaction manager, sure it makes a difference, not only for activiti, but for any system. 2 jta transaction managers does not make any sense at all to me

I think you misunderstood my question. The question should have be like this

Does a Spring managed JTA transaction(with an implementation of Bitronix) OR an Application Server (Glassfish) managed JTA transaction make any difference for Activiti?

Regards,
Franklin

Re: Configuring JTA with Activiti

ronald_van_kuij — Tue, 23 Aug 2011 06:33:54 GMT

So I did not misunderstand your question 😉 at least not fully

For Activiti, both need to be spring wrapped I would think. I've not seen a directly used jta manager in Activiti, but that can be a lack of knowledge from my side.

Re: Configuring JTA with Activiti

suad — Tue, 23 Aug 2011 06:50:45 GMT

Hi Chris,

Thanks…. setting the property solved the issue.