Statement.close() will close the underlying ResultSet - Is this a guranteed behaviour ?

[Prabhat Jha]

Hi,

Statement close method will close the underlying ResultSet object. I wanted to check if this is a guranteed behaviour ?

[Fatih Keles]

Note: A Statement object is automatically closed when it is garbage collected. When a Statement object is closed, its current ResultSet object, if one exists, is also closed.

It says so.

Regards,

Fatih.

[PrasannaKumar Sathiyanantham]

yes it is a guaranteed behavior

[David O'Meara]

No it is the recommended behaviour according to the JDBC specification ie documented rather than actual behaviour.
People have gotten it wrong before, it is safer to lose the ResultSet explicitly (in my opinion)