resultset is an iterator?

From: mistral (vlamos_playa_at_hotmail.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 17:17:04 GMT

Hello,

1)If a execute a statement : SELECT * FROM balaba.
And I retrieve this statement as a resultset. Then is this result set
totally filled with the table => the resultset contains the whole table
blabla.
OR is this just an interator and every time I do a next the database is
contacted and the next record is retrieved.

This is important because you don't want a whole db table in your memory :)

2) Is the com.mysql.jdbc.resultset better than java.sql.resultset?

Thanks !

Tom

Relevant Pages

  • Re: Invalid cursor state - Am I completely stupid?
    ... > I am going crazy trying to accomplish the simplest of tasks: retrieve ... > cursor state SQLException whenever I access the Resultset.get* ... > executes and the Resultset exists as I can read the ResultSetMetaData ... Did you remember to do the setup stuff using "ODBC Data Source ...
    (comp.lang.java.programmer)
  • Re: resultset is an iterator?
    ... Silvio Bierman wrote: ... >> And I retrieve this statement as a resultset. ... > Sorry Tom, that is completely dependent on the resultset implementation ...
    (comp.lang.java.databases)
  • resultset an iterator?
    ... 1)If a execute a statement: SELECT * FROM balaba. ... And I retrieve this statement as a resultset. ...
    (comp.lang.java.programmer)
  • Re: resultset is an iterator?
    ... > And I retrieve this statement as a resultset. ... that is completely dependent on the resultset implementation done ... by the JDBC driver and the database backend. ... is caused by an inability of the MySQL server to provide resultsets as a ...
    (comp.lang.java.databases)
  • Re: recordset not opening even though query analyzer returns resul
    ... I'm convinced that VB can execute this complex SP. ... > only way i could get an earlier version of it to return in a recordset. ... > table into a cursor and add up th evalues of the ccjs based on values in ... >> execute a query the SQL engine returns a resultset. ...
    (microsoft.public.vb.database.ado)