Originally posted by Wayne L Johnson:
Once the connection is closed you can no longer use any of the resources (statements, prepared statements, result sets). So you need to do all of your processing while the resources are open.
You should explicitly close the result sets, statements and connections when you are done, to make sure the resources are released on the database side.
okey once connection get closed , resultset is automaticaaly get closed.
but why is it so ?? why is resultset is on connection dependent.