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.
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 ]