Seems to me that the connection is not getting back (returned) to the pool after the request. Have you used your own implementation of Connection Pool? Maybe you should debug the number of connections in the pool on each request.
BTW there are some great industry-strength implementations of JDBC connection pools but each have their pros and cons. Affan -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED] Behalf Of Tom K Sent: Wednesday, May 05, 2004 9:50 AM To: [EMAIL PROTECTED] Subject: Re: How should a connection pool act? OK, I'm not closing the connection but I still have the problem. When I close the connection, pagination stops working. -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED] On Behalf Of Qureshi, Affan Sent: Wednesday, May 05, 2004 9:45 AM To: [EMAIL PROTECTED] Subject: Re: How should a connection pool act? Depends on your Connection pool implementation I believe. If you are using dbcp, it doesn't actually "close" the connection but returns it to the pool on conn.close(). Affan -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED] Behalf Of Galbreath, Mark A Sent: Wednesday, May 05, 2004 9:39 AM To: [EMAIL PROTECTED] Subject: Re: How should a connection pool act? I don't think you do not want to close the connection if you are pooling. Mark -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 10:37 AM To: [EMAIL PROTECTED] Subject: How should a connection pool act? After submitting a form, which queries my database the results come back fine. If I keep resubmitting my form I get the error: "Cannot get a connection, pool exhausted". Should I get this error? Doesn't the submission use a single pool resource? Arhhhhh [EMAIL PROTECTED] Yea...I know, make sure your closing your connection! OOOhAhhhhh --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 ________________________________________________________________________ ___ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ________________________________________________________________________ ___ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ________________________________________________________________________ ___ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
