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:SERVLET-INTEREST@(protected)
Galbreath, Mark A
Sent: Wednesday, May 05, 2004 9:39 AM
To: SERVLET-INTEREST@(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: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
___________________________________________________________________________
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
