aspose file tools
The moose likes JSP and the fly likes Connection not close Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Java » JSP
Reply Bookmark "Connection not close" Watch "Connection not close" New topic
Author

Connection not close

cairo fivez
Greenhorn

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.
Thanks
Praful Thakare
Ranch Hand

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


All desirable things in life are either illegal, banned, expensive or married to someone else !!!
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Connection not close
 
Similar Threads
Leave connection Open or Close it???
Better approach to get DB Connection
User Login Page
Preloaded servlet
jsp and java beans question