topic Db connections number in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/db-connections-number/m-p/201779#M154909 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>I use Activiti Enginein my webapp deployed on JBoss.</SPAN><BR /><SPAN>I don't use jdbc directly, but JNDI datasource:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />processEngine = ProcessEngineConfiguration<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.createStandaloneInMemProcessEngineConfiguration()<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setDatabaseSchemaUpdate(<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setDataSourceJndiName("java:jboss/datasources/ActivitiDS")<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>I enabled pooling in JBoss by adding into the standalone.xml:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;pool&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;min-pool-size&gt;50&lt;/min-pool-size&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;max-pool-size&gt;200&lt;/max-pool-size&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;prefill&gt;true&lt;/prefill&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/pool&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>But anyway when I concurrently start 100 workflows in separate threads by doing:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />runtimeService = processEngine.getRuntimeService();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessInstance startProcessInstanceByKey = runtimeService<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.startProcessInstanceByKey("emptyParent", request);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>I am getting freezed threads and exception at the end:</SPAN><BR /><BR /><SPAN>Error updating database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "ACT_HI_PROCINST";.</SPAN><BR /><BR /><SPAN>How to cure that?</SPAN><BR /><BR /></BODY></HTML> Sun, 30 Nov 2014 17:14:50 GMT alper 2014-11-30T17:14:50Z Db connections number https://connect.hyland.com/t5/alfresco-archive/db-connections-number/m-p/201779#M154909 Hi,I use Activiti Enginein my webapp deployed on JBoss.I don't use jdbc directly, but JNDI datasource<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />rocessEngine = ProcessEngineConfiguration&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.createStandaloneInMemProcessEngineConfiguration()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.setDatabaseSchemaUpdate(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ProcessEngineConfiguration.DB_SCHEMA_UP Sun, 30 Nov 2014 17:14:50 GMT https://connect.hyland.com/t5/alfresco-archive/db-connections-number/m-p/201779#M154909 alper 2014-11-30T17:14:50Z Re: Db connections number https://connect.hyland.com/t5/alfresco-archive/db-connections-number/m-p/201780#M154910 <HTML><HEAD></HEAD><BODY><SPAN>It works without exception for 50 concurrent threads, but for 100 threads 4 of them freeze with this exception.</SPAN></BODY></HTML> Mon, 01 Dec 2014 09:35:44 GMT https://connect.hyland.com/t5/alfresco-archive/db-connections-number/m-p/201780#M154910 alper 2014-12-01T09:35:44Z Re: Db connections number https://connect.hyland.com/t5/alfresco-archive/db-connections-number/m-p/201781#M154911 <HTML><HEAD></HEAD><BODY><SPAN>Ok, I increased pool size in the JBoss and everything works well</SPAN></BODY></HTML> Tue, 02 Dec 2014 11:40:34 GMT https://connect.hyland.com/t5/alfresco-archive/db-connections-number/m-p/201781#M154911 alper 2014-12-02T11:40:34Z