Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Does data will be fecthed to client side?

 
Ramesh Mandapati
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ramesh Mandapati
Greenhorn
Posts: 3
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ramesh,
Again, it depends on the driver. Rowcount() isn't the most efficient way to get the number of rows though.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic