• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

BookMark for disconnected resultset

 
Joe Nguyen
Ranch Hand
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When keeping the cursor open, I can page through the resultset to get the the next 10 records or the previous 10 records, but keeping the cursor open is expensive operation. To avoid this, I would like to get a hold of the current record physical address and return a connection back to the pool. Later, using the physical address and a new connection, I can retrieve the previous 10 records. I am not sure whether JDBC provides this capability. If it does, could someone point me to the right direction? Thanks in advance.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Joey,
I don't think it is possible to do this in a database independent way. What database are you using?

For example, in Oracle, you could use the rowid. This uses a hash to get you right back to the row you need.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic