Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

BookMark for disconnected resultset  RSS feed

 
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
Sheriff
Posts: 37382
531
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
Boost this thread!