ConnectionLess or ConnectionOriented ResultSet

From: indo3 (indo34_at_gmx.de)
Date: 11/30/04 

Date: 30 Nov 2004 07:05:16 -0800

Hello,
In JDBC, ResultSet represents a select-result-table from a select-sql-statement
to a database. Question: does ResultSet need an active connection to
the database or is the contents "offline"?
In .NET, there are two approaches: IDataReader for fetching
the next result online, or DataSet for fetching all content and then
going offline if one like. Dont know where to put ResultSet, any idea?

THANKS

Relevant Pages

  • Re: java resultset
    ... populate it with data. ... A resultset is stored in memory - I'm unsure what you mean about "offline". ... The newer RowSet interface lets you disconnect from the database while using the results, ...
    (comp.lang.java.databases)
  • Re: java resultset
    ... populate it with data. ... When the database is offline, ... A resultset is stored in memory - I'm unsure what you mean about "offline". ...
    (comp.lang.java.databases)
  • statement.executeUpdate(String sql) - not inserting results in correct order
    ... I am trying to insert the values of a resultset into an oracle ... particular table in a SQL server database, ... and then inserting that data from resultset into an oracle ... GRDPRODPWRMAX, GRDPRODPWRMIN," + ...
    (comp.lang.java.databases)
  • Question about ResultSet
    ... I'm making a database populated and manipulated through a JTable, SQL ... the ResultSet. ... public void setValueAt(Object value, int row, int col) ...
    (comp.lang.java.databases)
  • inserting data from resultset into oracle database - but not inserting in correct order
    ... I am trying to insert the values of a resultset into an oracle ... particular table in a SQL server database, ... and then inserting that data from resultset into an oracle ... The range of data selected from the SQL database, ...
    (comp.lang.java.databases)