Tomcat does not release database connection

[neltan]

Dear all,

I am using tomcat 5.0.27, postgresql 7.3.4, crystalreport report application server 9

My jsp webapp open 20-40 connection to postgresql for calculation. The calculation last for 30sec to 120sec. After finishing the report, the db connection does not release when I monitor from PGAdmin3. If I shutdown tomcat, the db connection return to previous number.

I'm sure all connections are "close" and has set to "null" in servlet, bean and jsp.

Can somebody tell me? Why tomcat hold the connection and not release until it being shutdown?

 

[sedj]

crosspost with thread877-977888

Click here to learn Ways to help with Tsunami Relief
--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk