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