• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need to close statement object?

 
Mike London
Ranch Hand
Posts: 1208
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When I create a query using a connection and returning a ResultSet via anexecuteQuery(), do I need to worry about closing the local variable statement object in the method that creates the ResultSet, IF I close the ResultSet in the calling method once I'm done with it?

It seems the answer is "no" since closing the statement object removes the results from the ResultSet.

Still, I wanted to see if I should do things in a different order or whatever.

Thanks in advance for any replies.

M
 
Scott Selikoff
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should also close result set, statements, and connections (in that order) as soon as your are done with them since this allows the garbage collector to make optimum use of memory and connections.

In fact, most people will tell you that such things should be closed inside a finally block (connections in particular) to make absolutely sure your application does not accidentally leave connections open in cases where your application throws an exception.
[ September 18, 2007: Message edited by: Scott Selikoff ]
 
Mike London
Ranch Hand
Posts: 1208
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks very much for your reply!!!

Much appreciated.



Mike
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic