File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes When is the data in the resultSet brought over ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "When is the data in the resultSet brought over ?" Watch "When is the data in the resultSet brought over ?" New topic
Author

When is the data in the resultSet brought over ?

Per Lovdinger
Ranch Hand

Joined: Jun 11, 2001
Posts: 35
Hi,

Could somebody explain this.
Assuming I'm running this query at host1 and the database
resides at host 2 and the number of rows in the rowset is 1000.
- When is the data in the resultSet brought over to host1 ?
- is it at *1* ?
- at *2* but only 1 row ?
- at *2* but the number of rows depends on "fetchsize" for resultset ?
- some other idea ...

ResultSet results = prepStmt.executeQuery();
*1*
while (results.next())
{
*2*
System.out.println("DAte is " results.getString(2));
}

regards Per
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: When is the data in the resultSet brought over ?
 
Similar Threads
getting ResultSet from Oracle procedure
Using resultset to encapsulate data and pass by
ResultSet and where the data returned actually is located.
How to find no of Rows in my ResultSet
How to find the number of rows in the resultset