RowSet vs Hibernate, JDO, etc.

From: Ivan (ivan_p_at_mail2world.com)
Date: 12/26/04


Date: Sun, 26 Dec 2004 11:50:43 +0100

I just read "JDBC RowSet Implementations Tutorial.pdf" and something I don't
understand.

RowSet can do this:
-connect to database
-make query i.e. fill it with data and disconnect from db
-can be transfered over "wire" because it implement serializable
-have cursor and can scroll through data
-can insert new data when is disconnected and latter can connect to db and
insert that new data in db automatically

If I read well, RowSet memorize which data was taken from db i.e. where was
data taken from db, and automatically make update if data change?
And if new data are added to disconnect RowSet with new connection to db
data are automatically inserted?
Did I miss something here???

Why then Hibernate, JDO, etc., when RowSet make things easier, I mean
everything is simplified, specially automatic insert and update?
And I think that's easy to work with RowSet and data-aware JSF and
Swing/AWT/SWT component?

I know Sun have RowSet implementation, do you know for other?



Relevant Pages

  • RowSet vs Hibernate, JDO, etc.
    ... I just read "JDBC RowSet Implementations Tutorial.pdf" and something I don't ... -make query i.e. fill it with data and disconnect from db ... And if new data are added to disconnect RowSet with new connection to db ...
    (comp.lang.java.programmer)
  • Re: dr.Read()
    ... When you execute any query that does not return ... a rowset, the DataReader returns as "closed". ... William (Bill) Vaughn ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: The stored procedure executed successfully but did not return any records
    ... > with the .NextRecordset method of the Recordset object. ... When I run this through Query Analyzer this ... >> to generate a single rowset, however when I run in through the .ADP it ...
    (microsoft.public.access.adp.sqlserver)
  • Re: The stored procedure executed successfully but did not return any records
    ... with the .NextRecordset method of the Recordset object. ... When I run this through Query Analyzer this ... > to generate a single rowset, however when I run in through the .ADP it ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ATL OLE DB Consumer Code problem
    ... The accessor is of type CAccessor, ... is of type CRowset and there is a single rowset returned by the query. ... query used is either a simple SQL SELECT Statement or a stored procedure call. ... The same behavior is observed with either SQL Server OLE DB Provider or SQL ...
    (microsoft.public.data.oledb)