topic Re: Multiple Data sources in activiti in Alfresco Archive

Multiple Data sources in activiti

davanna — Mon, 20 Jun 2016 19:11:05 GMT

I have written a spring boot application. I have a two data sources - one is used by activiti engine for it's database and another datasource for updating my tables. The database updates to my tables are done in the event listeners. I have configured both the data sources as follows. The code is wor

Re: Multiple Data sources in activiti

jbarrez — Wed, 22 Jun 2016 08:12:47 GMT

If you have two datasource, you need XA transactions to be configured. A regular JPATransactionManager is not going to cut it.

Re: Multiple Data sources in activiti

davanna — Wed, 22 Jun 2016 17:13:25 GMT

Thanks for the reply. I finally ended using the JTATransaction. But the above code works perfectly fine with my integration tests. Ideally with TransactionMaanger pointing to first datasource and working on second datasource, the db operations on second datasoruce must fail. It is not happening here. Just want to validate my theory that mybatis using second datasource is using the default autocommit feature and the transaction enclosing this operation is a no-op.

Re: Multiple Data sources in activiti

jbarrez — Mon, 27 Jun 2016 08:39:49 GMT

With two datasources, a regular transactionmanager won't cut it. When you involve multiple databases, you generally need XA transactions.