File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes connection pooling problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "connection pooling problem" Watch "connection pooling problem" New topic

connection pooling problem

priyanka udawat

Joined: Mar 16, 2004
Posts: 2
hi friends,
I am using tomcat4.1 version and have my work in jsp/servlet
i am using connection pooling but it give frequetly connection pool exhausted error,i am having jdk1.4 can some one help me in overcoming this problem.
its urgent please reply soon.
Nathaniel Stoddard
Ranch Hand

Joined: May 29, 2003
Posts: 1258
You need to make sure that you are correctly closing the connections and resultsets so that they are able to be performed to the pool. Otherwise you get nasty errors like yours.
If you're doing that correctly, you will want to either increase the number of connections in your pool (or set it no limit), or increase the timeout so that your program will wait longer for a connection before freaking out. Either one I think will help you out. Most likely, I would guess that the issue is connections and resultsets not being closed all the time.

I agree. Here's the link:
subject: connection pooling problem
It's not a secret anymore!