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
