topic Re: MaxOpenPreparedStatements limit reached exception while migrating to MySql in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/maxopenpreparedstatements-limit-reached-exception-while/m-p/279074#M232204 <HTML><HEAD></HEAD><BODY><SPAN>In your code, are the resources closed properly in finally block ?</SPAN><BR /><SPAN>If not, you need to do it first.</SPAN><BR /><BR /><BR /><SPAN>Also, can you try putting this property in alfresco-global.properties and check ?</SPAN><BR /><BR /><SPAN>db.pool.statements.enable = false </SPAN></BODY></HTML> Thu, 27 Mar 2014 07:57:01 GMT sanket 2014-03-27T07:57:01Z MaxOpenPreparedStatements limit reached exception while migrating to MySql https://connect.hyland.com/t5/alfresco-archive/maxopenpreparedstatements-limit-reached-exception-while/m-p/279073#M232203 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 Thu, 27 Mar 2014 07:13:20 GMT https://connect.hyland.com/t5/alfresco-archive/maxopenpreparedstatements-limit-reached-exception-while/m-p/279073#M232203 pradeepsimha 2014-03-27T07:13:20Z Re: MaxOpenPreparedStatements limit reached exception while migrating to MySql https://connect.hyland.com/t5/alfresco-archive/maxopenpreparedstatements-limit-reached-exception-while/m-p/279074#M232204 <HTML><HEAD></HEAD><BODY><SPAN>In your code, are the resources closed properly in finally block ?</SPAN><BR /><SPAN>If not, you need to do it first.</SPAN><BR /><BR /><BR /><SPAN>Also, can you try putting this property in alfresco-global.properties and check ?</SPAN><BR /><BR /><SPAN>db.pool.statements.enable = false </SPAN></BODY></HTML> Thu, 27 Mar 2014 07:57:01 GMT https://connect.hyland.com/t5/alfresco-archive/maxopenpreparedstatements-limit-reached-exception-while/m-p/279074#M232204 sanket 2014-03-27T07:57:01Z Re: MaxOpenPreparedStatements limit reached exception while migrating to MySql https://connect.hyland.com/t5/alfresco-archive/maxopenpreparedstatements-limit-reached-exception-while/m-p/279075#M232205 <HTML><HEAD></HEAD><BODY><SPAN>Thank you very much <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> Your last statement resolved the issue..</SPAN></BODY></HTML> Thu, 27 Mar 2014 08:56:19 GMT https://connect.hyland.com/t5/alfresco-archive/maxopenpreparedstatements-limit-reached-exception-while/m-p/279075#M232205 pradeepsimha 2014-03-27T08:56:19Z