I have a fairly simple tomcat 5.19 app, that queries a db, stores the
results in a bean, and forwards the request to a result jsp.

I use pagination with a pooled connection. I get my my datasource
connection in the bean. If I try to close my connection after the first
query and try to page back or forward I lose my connection.

If I don’t close the connection, everything works fine until I run out
of pooled connections!

ANY IDEAS?


TIA

Tom K.

---
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