AnsweredAssumed Answered

MaxOpenPreparedStatements limit reached exception while migrating to MySql

Question asked by pradeepsimha on Mar 27, 2014
Latest reply on Mar 27, 2014 by pradeepsimha

I am trying to change the database of Alfresco to MySql and I followed the steps mentioned here: but when I try to start the service I am getting below error:

### Cause: java.sql.SQLException: MaxOpenPreparedStatements limit reached
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; MaxOpenPreparedStatements limit reached; nested exception is java.sql.SQLException: MaxOpenPreparedStatements limit reached
Caused by: java.sql.SQLException: MaxOpenPreparedStatements limit reached
   at org.apache.commons.dbcp.PoolingConnection.prepareStatement(
   at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(
Caused by: java.util.NoSuchElementException: Pool exhausted
   at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(
   at org.apache.commons.dbcp.PoolingConnection.prepareStatement(
   … 101 more

Service starts from Windows, but if I see the tomcat logs, it is just stuck here:

INFO: Deploying web application archive C:\Alfresco\tomcat\webapps\alfresco.war
Mar 27, 2014 12:28:01 PM org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: is already defined
Mar 27, 2014 12:28:02 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext

If I try to hit url in browser, it keeps on saying "Waiting for localhost.." nothing gonna come.

This is my content related to

Can someone kindly help me? What maybe the cause of this exception. All these were working fine when I try to use default database, but suddenly got this exceptions when I try to migrate to MySql.