When using a data source to access a database is "connection.close();" going to close the associated statement and resultSet?
I have read a number of articles posted on a number of sites,
almost all agree that it is good practice to close the resultSet, statement and connection individually.
I have also read that the JDBC specification details that closing the connection will also close any associated resources (resultSet and statements).
There does not seem to be a right or wrong answer.
So would code closing just the connection be appropriate or should we always close all three?