• Post Reply Bookmark Topic Watch Topic
  • New Topic

restoring ResultSet after reconnection

 
Vladimir Podlesny
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how to restore ResultSet after reconnection to DB (after iterruption) ?
 
Wendy Gibbons
Bartender
Posts: 1111
Eclipse IDE Oracle VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the ranch Vladimir.
i am afraid the answer is you can't, the result set is part of the connection, so once the connection is interyupted the result set is interupted.

If you know you are going to have problems keeping the connection, fetching the data is lots of little batches may be the best answer.
 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
 
Vladimir Podlesny
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Whether effectively to use for a solution of this problem of OracleCachedRowSet ?



 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!