topic Multiple Data sources in activiti in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245521#M198651 <HTML><HEAD></HEAD><BODY><SPAN>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 working fine but I do sense that there may be issues here as the same default transaction manager is used by activiti engine to update it's tables and also to update my tables. This transaction manager is the JpaTransactionManager. The datasource field in the transactionmanager is pointing to my database as I have defined it as primary. The transactionfactory defined in SpringProcessEngineConfiguration is pointing to activiti datasource. The transactionFactory is used by the DbSqlSession in mybatis. I am trying to understand how Spring is updating the tables properly here as the datasources are different in both the cases. </SPAN><BR /><BR /><BR /><SPAN>&lt;code language="java"&gt;</SPAN><BR /><BR /><SPAN>@Configuration</SPAN><BR /><SPAN>public class ActivitiConfiguration extends AbstractProcessEngineAutoConfiguration {</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Primary</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean(name = "myDataSource")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@ConfigurationProperties(prefix = "spring.datasource.mine")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public DataSource getMyDataSource() {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return DataSourceBuilder.create().build();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean(name = "activitiDataSource")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@ConfigurationProperties(prefix = "spring.datasource.activiti")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public DataSource getActivitiDataSource() {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return DataSourceBuilder.create().build();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Primary</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean(name = "transactionManager")</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public PlatformTransactionManager transactionManager(@Qualifier("myDataSource") DataSource dataSource) {</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JpaTransactionManager transactionManager = new JpaTransactionManager();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;transactionManager.setDataSource(dataSource);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return transactionManager;</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;@Bean</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;public SpringProcessEngineConfiguration springProcessEngineConfiguration(PlatformTransactionManager activitiTransactionManager,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SpringAsyncExecutor springAsyncExecutor, @Qualifier("activitiDataSource") DataSource dataSource) throws IOException {</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return baseSpringProcessEngineConfiguration(dataSource, activitiTransactionManager, springAsyncExecutor);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;}</SPAN><BR /><BR /><SPAN>}</SPAN><BR /><BR /><SPAN>&lt;/code&gt;</SPAN></BODY></HTML> Mon, 20 Jun 2016 19:11:05 GMT davanna 2016-06-20T19:11:05Z Multiple Data sources in activiti https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245521#M198651 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 Mon, 20 Jun 2016 19:11:05 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245521#M198651 davanna 2016-06-20T19:11:05Z Re: Multiple Data sources in activiti https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245522#M198652 <HTML><HEAD></HEAD><BODY><SPAN>If you have two datasource, you need XA transactions to be configured. A regular JPATransactionManager is not going to cut it.</SPAN></BODY></HTML> Wed, 22 Jun 2016 08:12:47 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245522#M198652 jbarrez 2016-06-22T08:12:47Z Re: Multiple Data sources in activiti https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245523#M198653 <HTML><HEAD></HEAD><BODY><SPAN>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. </SPAN></BODY></HTML> Wed, 22 Jun 2016 17:13:25 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245523#M198653 davanna 2016-06-22T17:13:25Z Re: Multiple Data sources in activiti https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245524#M198654 <HTML><HEAD></HEAD><BODY><SPAN>With two datasources, a regular transactionmanager won't cut it. When you involve multiple databases, you generally need XA transactions.</SPAN></BODY></HTML> Mon, 27 Jun 2016 08:39:49 GMT https://connect.hyland.com/t5/alfresco-archive/multiple-data-sources-in-activiti/m-p/245524#M198654 jbarrez 2016-06-27T08:39:49Z