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
posted 12 years ago
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.