wood burning stoves 2.0*
The moose likes JDBC and the fly likes Connection problem in DB2, Urgent please Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection problem in DB2, Urgent please" Watch "Connection problem in DB2, Urgent please" New topic
Author

Connection problem in DB2, Urgent please

Reddy B.K
Greenhorn

Joined: Mar 10, 2003
Posts: 5
Thanks in Advance
I am using JSP with Universal DB2,The problem is even though i am closing the connection(Eg. if (conn!=null) conn.close() in Finally block of my servlet, some connections are still in the open mode, can any one have the way to close the connections.
Thanks
ReddyBK
Barry Gaunt
Ranch Hand

Joined: Aug 03, 2002
Posts: 7729
Do you mean try{}catch{}finally{} or are you using finalize? If the former, write to a log each time you close a connection and check the connection with isClosed().
Are you using connection pooling? That will keep the real DB connections open.


Ask a Meaningful Question and HowToAskQuestionsOnJavaRanch
Getting someone to think and try something out is much more useful than just telling them the answer.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connection problem in DB2, Urgent please