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:tkoc@(protected)]
Sent: Wednesday, May 05, 2004 10:37 AM
To: SERVLET-INTEREST@(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 #$@#$%

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 listserv@(protected)
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 listserv@(protected)
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