aspose file tools*
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 Spring in Action this week in the Spring 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBCConnectionException: Cannot open connection