This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes About Number of Connection Statement and RsultSet objects Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "About Number of Connection Statement and RsultSet objects" Watch "About Number of Connection Statement and RsultSet objects" New topic
Author

About Number of Connection Statement and RsultSet objects

hem kum
Greenhorn

Joined: Dec 23, 2007
Posts: 9
HI all, I'm just curious to know if there is any way to know how many instances of Connection objects , Statement objects or ResultSet objects are being used in my application and even if i forget to close some instances, Still how many are left behind. I'm using jndi connectin with mysql database and netbeans IDE.
Thank you all...
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

Most profilers will give you that kind of information. I believe that Netbeans includes a profiler, but I don't know anything about it.
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 860
Jamon tracks that and more.


http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: About Number of Connection Statement and RsultSet objects
 
Similar Threads
Interfaces in JDBC
Is there a limit to # of Statements over a Connection object
Closing DBObjects
String object garbage Collection
How to Ensure I'm NOT Passing RMI Objects I don't Mean to