close on CachedRowSet

[Nev Mehta]

I have some code that had lots of (oracle) database accesses. I encountered 'too many open cursors' errors. Although i checked thoughroghly, i think i was missing out on closing some resources. I changed my source code to have a single method that executed queries and returned a CachedRowSet. My question is, being a disconnected resultset is it absolutely necessary to close the CachedRowSet? I did close the Statement objects and ResultSet objects from which i got the CachedRowSet object. Wont just resetting the old CachedRowSet with a new one be ok? Something like:-

CachedRowSet crowsSet;
crs = select("select * from X", conn)
// do something with crs
crs = select("select * from Y", conn)
// do something with crs

Thanks
Neville

[Wendy L Gibbons]

having scaned the documentation and example for cached row set, it appears to be a hybrid of a statement and result set all in one.
I think it deffinatley needs closing.