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:SERVLET-INTEREST@(protected)
Sent: Wednesday, May 05, 2004 9:50 AM
To: SERVLET-INTEREST@(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:SERVLET-INTEREST@(protected)
Qureshi, Affan
Sent: Wednesday, May 05, 2004 9:45 AM
To: SERVLET-INTEREST@(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: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)
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 listserv@(protected)
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 listserv@(protected)
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 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
