wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes JDBCConnectionException: Cannot open connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "JDBCConnectionException: Cannot open connection" Watch "JDBCConnectionException: Cannot open connection" New topic
Author

JDBCConnectionException: Cannot open connection

Kris Reid
Ranch Hand

Joined: Jan 05, 2005
Posts: 247
Hi

Sometimes my application is throwing JDBCConnectionException: Cannot open connection
I can't for the life of me work out why.

It is a web app running on tomcat and using hibernate.
I'm using a session filter that starts the transaction then processes the users action then closes the transaction.
So I don't think that connections are getting left open.

Do I have C3P0 configured properly?
<property name="hibernate.c3p0.acquire_increment">3</property>
<property name="hibernate.c3p0.idle_test_period">14400</property> <!-- seconds -->
<property name="hibernate.c3p0.timeout">25200</property> <!-- seconds -->
<property name="hibernate.c3p0.max_size">100</property>
<property name="hibernate.c3p0.min_size">10</property>
<property name="hibernate.c3p0.max_statements">0</property>


This is the game Mob Warrior if you're interested
 
 
subject: JDBCConnectionException: Cannot open connection
 
Similar Threads
.JDBCConnectionException
APPARENT DEADLOCK Hibernate and c3p0 error site goes down please help
Exception while getting transaction
c3p0 pool size exceeds maxpoolsize
APPARENT DEADLOCK site goes down please help