Hi there

is there anyone here who knows about OracleCachedRowSet?

My class calls a method in an existing DAO class which returns an
OracleCachedRowSet to me, containing data from the database. Do I need to
"close" this object after I have used it?

I don't really understand how this object works - it extends ResutSet and a
ResultSet really should be closed after use (although I realise that the
driver should handle tidying up when the Connection is closed). But my
experimentations with OracleCachedRowSet show that if I create my own
Connection, and obtain an OracleCachedRowSet from a query, when I close the
OracleCachedRowSet  then the Connection also becomes closed!

Thanks,
Peter