*
The moose likes JDBC and the fly likes Result Set in memory or connected to database ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Result Set in memory or connected to database ?" Watch "Result Set in memory or connected to database ?" New topic
Author

Result Set in memory or connected to database ?

Nitin Dubey
Ranch Hand

Joined: Oct 30, 2000
Posts: 126

Hello folks,
I have a simple doubt. And it grew to be a topic of debate between my friends . But no conclusion yet.
Here's a statement :
1. ResultSet object has all the fields fetched from database in memory(RAM). (Assuming that we are using JDBC ODBC Driver for SQL Server).
(True/False)
nitin
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
False. In general, ResultSets are connected objects, and the JDBC driver will not load the entire set in memory. As far as I know the jdbc-odbc bridge is no exception.
- Peter
 
jQuery in Action, 2nd edition
 
subject: Result Set in memory or connected to database ?
 
Similar Threads
TomCat 3.0
Is this Memory Lekage?
Designing in Hibernate
Those better be some damn good looking women
Palm m100