topic Ibatis exception in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/ibatis-exception/m-p/53579#M31765 <HTML><HEAD></HEAD><BODY><SPAN>I'm getting this exception:</SPAN><BR /><BR /><SPAN>Caused by: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.&nbsp; Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 46.810.842 milliseconds ago.&nbsp; The last packet sent successfully to the server was 46.810.842 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:47)</SPAN><BR /><BR /><SPAN>This happens since I changed the way to config activiti. </SPAN><BR /><SPAN>At first I was using the properties file. Now I use a programmatic configuration as in the next code block.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />public static void initActiviti() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //ProcessEngines.init();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessEngine processEngine = ProcessEngineConfiguration<BR />&nbsp;&nbsp;&nbsp;&nbsp;&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;&nbsp;&nbsp;&nbsp;&nbsp; .setJdbcUrl(ApplicationConfig.getConfigParam("activiti.url"))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setJdbcDriver(ApplicationConfig.getConfigParam("activiti.driverClassName"))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setJdbcUsername(ApplicationConfig.getEncryptedConfigParamDecrypted("activiti.username"))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setJdbcPassword(ApplicationConfig.getEncryptedConfigParamDecrypted("activiti.password"))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setJdbcMaxActiveConnections(Integer.parseInt(ApplicationConfig.getConfigParam("activiti.jdbcMaxActiveConnections")))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setJdbcMaxIdleConnections(Integer.parseInt(ApplicationConfig.getConfigParam("activiti.jdbcMaxIdleConnections")))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setDatabaseType(ApplicationConfig.getConfigParam("activiti.databaseType"))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setDatabaseSchemaUpdate(ApplicationConfig.getConfigParam("activiti.databaseSchemaUpdate"))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setHistory(ApplicationConfig.getConfigParam("activiti.history"))<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .setProcessEngineName(ACTIVITI_ENGINE_NAME)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .buildProcessEngine();<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessEngines.registerProcessEngine(processEngine);<BR /><BR />//do deployments here<BR />} catch (Exception e) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.log(Priority.FATAL, "Couldn't initialize Activiti Engine ", e);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>config params</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;context-param&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param-name&gt;activiti.url&lt;/param-name&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param-value&gt;jdbc:mysql://localhost:3306/activiti?autoReconnect=true&lt;/param-value&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/context-param&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;context-param&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param-name&gt;activiti.driverClassName&lt;/param-name&gt;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;param-value&gt;com.mysql.jdbc.Driver&lt;/param-value&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;/context-param&gt;<BR /><BR />&nbsp; ….<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>How to fix this? is this an ibatis issue or activiti?</SPAN></BODY></HTML> Sun, 14 Aug 2011 08:57:07 GMT luisalves00 2011-08-14T08:57:07Z Ibatis exception https://connect.hyland.com/t5/alfresco-archive/ibatis-exception/m-p/53579#M31765 I'm getting this exception:Caused by: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.&nbsp; Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.&nbsp; Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successf Sun, 14 Aug 2011 08:57:07 GMT https://connect.hyland.com/t5/alfresco-archive/ibatis-exception/m-p/53579#M31765 luisalves00 2011-08-14T08:57:07Z Re: Ibatis exception https://connect.hyland.com/t5/alfresco-archive/ibatis-exception/m-p/53580#M31766 <HTML><HEAD></HEAD><BODY><SPAN>A combination of both. Not all MyBatis db connection params can be configured via the programmatic way. Personally I'd stick with the config file way. </SPAN><BR /><BR /><SPAN>You miss some connection validity checking params now. See the MySQL driver config things to figure out which ones, or look in the config file you formerly used.</SPAN></BODY></HTML> Sun, 14 Aug 2011 10:36:22 GMT https://connect.hyland.com/t5/alfresco-archive/ibatis-exception/m-p/53580#M31766 ronald_van_kuij 2011-08-14T10:36:22Z Re: Ibatis exception https://connect.hyland.com/t5/alfresco-archive/ibatis-exception/m-p/53581#M31767 <HTML><HEAD></HEAD><BODY><SPAN>did some changes (need more time to know if it's working):</SPAN><BR /><BR /><CODE><BR />org.apache.commons.dbcp.BasicDataSource bds = new org.apache.commons.dbcp.BasicDataSource();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bds.setDefaultAutoCommit(false); //as I had on the file<BR /><BR />….<BR /><BR /> ProcessEngine processEngine = ProcessEngineConfiguration<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .createStandaloneProcessEngineConfiguration().setDataSource(bds)<BR /><BR />…..</CODE><BR /><SPAN>Ronald, I'm using the programmatic way to obfuscate the Data Source credentials…</SPAN></BODY></HTML> Mon, 15 Aug 2011 09:12:34 GMT https://connect.hyland.com/t5/alfresco-archive/ibatis-exception/m-p/53581#M31767 luisalves00 2011-08-15T09:12:34Z