• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

close on CachedRowSet

 
Nev Mehta
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:-



Thanks
Neville
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic