Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes JDBC object closing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC object closing" Watch "JDBC object closing" New topic

JDBC object closing

Divyajot Ahluwalia
Ranch Hand

Joined: Nov 03, 2000
Posts: 46
what are the jdbc objects we must close after finishing a process?
db - mysql
web server - apache + tomcat
in a servlet i use a connection broker from javaexchange and in the service method get a connection and towards the end free the connection. I close the statement and the prepared statements. Should i also close the result set.
My application is repeatedly throwing a servlet exception and therefore stops.
Can u please help.
prabhat kumar
Ranch Hand

Joined: Apr 11, 2001
Posts: 114
ya u shuld also close the resultsets if any.

Joined: Jun 25, 2001
Posts: 10
Actually, if you close the Statement only, it will automatically call ResultSet.close() on any resultsets using the statement closed. So you don't "HAVE" to close the resultset explicitly, but it may just be good habit.
I agree. Here's the link:
subject: JDBC object closing
It's not a secret anymore!