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
