OracleCachedRowSet

From: Peter Kirk (peter)
Date: 03/24/04 

Date: 24 Mar 2004 08:59:16 +0100

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

Relevant Pages

  • Re: OracleCachedRowSet
    ... "> My class calls a method in an existing DAO class which returns an ... > OracleCachedRowSet to me, ... > driver should handle tidying up when the Connection is closed). ... the underlying connection to the database - if there is one open. ...
    (comp.lang.java.databases)
  • OracleCachedRowSet
    ... can someone help with OracleCachedRowSet? ... I have a method in a DAO class which returns some data from a database in an ... Do I (the caller) have to "close" this rowset? ... like a "value object" which holds the data from the database? ...
    (comp.lang.java.help)