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]]On 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 #$@#$%
 
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