wood burning stoves 2.0*
The moose likes JDBC 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
Bookmark "connection pooling problem" Watch "connection pooling problem" New topic
Author

connection pooling problem

priyanka udawat
Greenhorn

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.
priyanka
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.


Nathaniel Stodard<br />SCJP, SCJD, SCWCD, SCBCD, SCDJWS, ICAD, ICSD, ICED
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connection pooling problem
 
Similar Threads
java.sql.SQLException: invalid name pattern
issue with datasource
Connection Pooling java code
This Weeks GiveAway:
Resultset in session