OpenEMM Technical Support Forum

Posted: **Thu Apr 24, 2008 2:37 pm**

Hi,

I have seen this error mentioned with older versions of OpenEMM, but I am having it with 5.4.0 importing csv files. I receive a batch of about 7 files to be imported one at a time (I have tried one big file and it generates errors) and generally I get a 'pool exhausted' error after 3 imports and have to stop/restart OpenEMM:

An error occurred
Cause: javax.servlet.ServletException: javax.servlet.ServletException: javax.servlet.jsp.JspTagException: Error: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

Any thoughts?

Thanks

Posted: **Thu Apr 24, 2008 4:05 pm**

Your installation ran out of database connections. Try to increase the connection pool via the file emm.properties and restart OpenEMM.

Posted: **Fri Apr 25, 2008 1:43 am**

ma wrote:Your installation ran out of database connections. Try to increase the connection pool via the file emm.properties and restart OpenEMM.

Thanks for the quick reply. I have found the file but no specific 'pool' related variable - is this the right one: "jdbc.maxCount=5"??

L3K

Posted: **Fri Apr 25, 2008 6:49 am**

Exactly!

Posted: **Fri Apr 25, 2008 10:08 am**

Thanks - I have added this to the wiki