File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes Connection not close Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "Connection not close" Watch "Connection not close" New topic

Connection not close

cairo fivez

Joined: Nov 29, 2002
Posts: 6
Hi all,
I've with one application consist of servlets and jsp (hundred of files). I'm going to deploy this application on sun one and use sun one data source connection pooling.
The problem is that this apps open a connection in various places (jsp&servlet) but never close it. Is there any way that I can do to ask the connection pooling to close the connection. This is becase it's hard for me to manually close all open connection as there are many jsps and some of the servlet/classes couldn't be decompile (We're missing the source code)
Appreciate if someone could give an idea/hint on how to tacke this issue.
Praful Thakare
Ranch Hand

Joined: Feb 10, 2001
Posts: 642
Hi Cairo,
If it is possible to decompile & change your connection pool class,you can
manipulate close method ,overridden from java.sql.Connection.

All desirable things in life are either illegal, banned, expensive or married to someone else !!!
I agree. Here's the link:
subject: Connection not close
It's not a secret anymore!