topic MaxOpenPreparedStatements limit reached exception while migrating to MySql in Alfresco Archive

MaxOpenPreparedStatements limit reached exception while migrating to MySql

pradeepsimha — Thu, 27 Mar 2014 07:13:20 GMT

Hi,I am trying to change the database of Alfresco to MySql and I followed the steps mentioned here: http://docs.alfresco.com/4.1/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Ftasks%2Fmysql-config.html but when I try to start the service I am getting below error:### Cause: java.sql.SQLException: M

Re: MaxOpenPreparedStatements limit reached exception while migrating to MySql

sanket — Thu, 27 Mar 2014 07:57:01 GMT

In your code, are the resources closed properly in finally block ?
If not, you need to do it first.

Also, can you try putting this property in alfresco-global.properties and check ?

db.pool.statements.enable = false

Re: MaxOpenPreparedStatements limit reached exception while migrating to MySql

pradeepsimha — Thu, 27 Mar 2014 08:56:19 GMT

Thank you very much Your last statement resolved the issue..