topic Re: Ibatis exception in Alfresco Archive

Ibatis exception

luisalves00 — Sun, 14 Aug 2011 08:57:07 GMT

I'm getting this exception:Caused by: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit. Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successf

Re: Ibatis exception

ronald_van_kuij — Sun, 14 Aug 2011 10:36:22 GMT

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.

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.

Re: Ibatis exception

luisalves00 — Mon, 15 Aug 2011 09:12:34 GMT

did some changes (need more time to know if it's working):


org.apache.commons.dbcp.BasicDataSource bds = new org.apache.commons.dbcp.BasicDataSource();
            bds.setDefaultAutoCommit(false); //as I had on the file

….

 ProcessEngine processEngine = ProcessEngineConfiguration
                    .createStandaloneProcessEngineConfiguration().setDataSource(bds)

…..

Ronald, I'm using the programmatic way to obfuscate the Data Source credentials…