posted 13 years ago
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.
author & internet detective