This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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
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.