topic How to replace DbIdGenerator with a db sequence in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-replace-dbidgenerator-with-a-db-sequence/m-p/105871#M74042 <HTML><HEAD></HEAD><BODY><SPAN>Hello activiti team and community,</SPAN><BR /><BR /><SPAN>we are using activiti starting from the earliest version and since three month also in a production environment - generally with great success.</SPAN><BR /><BR /><SPAN>Now we would like to replace the internal class 'DbIdGenerator' based on activiti tables by a solution using a db-sequence, an oracle sequence in our case. Is there any running reference code to do so? Otherwise we have to implement it ourselves.</SPAN><BR /><BR /><SPAN>The reason for that is a misbehavior of 'DbIdGenerator' in the context of a rollbacked transactions - IMO. The operation of fetching the next 100 IDs (default value) is unfortunately part of the user business transaction. A rollback of this transaction resets also the activiti sequence table but obviously not the active cache in 'DbIdGenerator'. Loading the next 100 IDs ends in fetching the same number block (primary key doubled!) and results periodically in constraint violations. A sequence update has to be executed outside of a user business transaction (RequiresNew). It seems that this problem is well known by activiti, unfortunatly we have not found a work around.</SPAN><BR /><BR /><SPAN>Thx,</SPAN><BR /><SPAN>Micha</SPAN><BR /><BR /><SPAN>Environment:</SPAN><BR /><SPAN>- Activiti 5.9</SPAN><BR /><SPAN>- Libs: activiti-engine / mybatis</SPAN><BR /><SPAN>- the engine is running inside a JBoss container (jboss-5.1)</SPAN><BR /><SPAN>- the activiti command shares our bean-injected EntityManager (Session)</SPAN><BR /><SPAN>- ProcessEngineConfiguration as follows…</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessEngineConfiguration c = ProcessEngineConfiguration<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createStandaloneProcessEngineConfiguration()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setTransactionsExternallyManaged(true)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setHistory(ProcessEngineConfiguration.HISTORY_NONE)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setJpaCloseEntityManager(false)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setJobExecutorActivate(true);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c.setDataSourceJndiName("java:/abis");<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Tue, 29 May 2012 10:51:02 GMT micha1 2012-05-29T10:51:02Z How to replace DbIdGenerator with a db sequence https://connect.hyland.com/t5/alfresco-archive/how-to-replace-dbidgenerator-with-a-db-sequence/m-p/105871#M74042 Hello activiti team and community,we are using activiti starting from the earliest version and since three month also in a production environment - generally with great success.Now we would like to replace the internal class 'DbIdGenerator' based on activiti tables by a solution using a db-sequence, Tue, 29 May 2012 10:51:02 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-replace-dbidgenerator-with-a-db-sequence/m-p/105871#M74042 micha1 2012-05-29T10:51:02Z Re: How to replace DbIdGenerator with a db sequence https://connect.hyland.com/t5/alfresco-archive/how-to-replace-dbidgenerator-with-a-db-sequence/m-p/105872#M74043 <HTML><HEAD></HEAD><BODY><SPAN>if you pass in a transactionmanager in the config, a new transaction IS used for obtaining the next block of id's afaik.</SPAN></BODY></HTML> Tue, 29 May 2012 16:36:08 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-replace-dbidgenerator-with-a-db-sequence/m-p/105872#M74043 ronald_van_kuij 2012-05-29T16:36:08Z