Ramesh Mandapati

Originally posted by Jeanne Boyarsky:
Ramesh,
The data is brought back to the client side in batches. If your statement happens to hit the end of a batch, it will bring more data. If you use absolute() with a number that skips a whole batch of data, none of that data will be brought to the client side.

What happens if I use resultset.last(); resultset.getRowCount();
does data will be brought to client side?

Thx,
-Ramesh

After executing SELECT * FROM EMP;
if I use resultset.next(), resultset.absolute(5) methods on the resultset does it causes data to be fetched to client side? OR it just moves the pointer in the backend cursor.

Thanks,

Did anybody used any of the above caching systems in production environment?