#5 Problem with Connection Pool.

[Cristian Romanescu]

Hello, I have a problem with JRF connection pool.

Our application worked fine until a month ago when the
application started to broke because of the database
connection.

The logs are full of exception:

net.sf.jrf.exceptions.DatabaseException:
java.sql.SQLException: Maximum connections (200) in
use. Unable to provide a connection.: Unable to get a
database connection.:
Maximum connections (200) in use. Unable to provide a
connection.
at
net.sf.jrf.domain.AbstractDomain.assureDatabaseConnection(AbstractDomain.java:1649)
at
net.sf.jrf.domain.AbstractDomain.findLong(AbstractDomain.java:4767)

I am not sure what is the problem. I suspect that
connection pool is.
Of counrse we have limited in jrf.properties
connections to 200, but is there any other option that
might affect this behaviour?

Environment is Tomcat 4/MysQL 4.0.20/JDK 1.4.1.

A sample of bug can be found here:
http://eunis.eea.eu.int/habitats-code-browser.jsp

Any help would be very appreciated.
Thank you,
Cristian.

[Nobody/Anonymous]

Logged In: NO

We found that the problem lied within mysql jdbc driver
which didn't properly closed the connections. Later
versions of mysql driver fixed this problem.