Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC object closing

 
Divyajot Ahluwalia
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
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.
Regards,
dj
 
prabhat kumar
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ya u shuld also close the resultsets if any.
 
jlrober
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic