Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connection pooling problem

 
priyanka udawat
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1258
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic