Making the Most of JDBC with WebRowSet

Discussions

News: Making the Most of JDBC with WebRowSet

  1. Making the Most of JDBC with WebRowSet (2 messages)

    OnJava.com has published Sharad Acharya's "Making the Most of JDBC with WebRowSet" article, which is a part of JDBC 3.0. WebRowSet offers the capability to translate a RowSet - an enhanced ResultSet - directly to XML, as well as offering the RowSet's enhanced data manipulation features. RowSets provide "the ability to operate on it without always being connected to the data source. Further, it is scrollable, updatable, and serializable. In addition to databases, it can work with other data sources with a tabular format, such as spreadsheets." WebRowSets add the ability to output the data to XML, as stated, and also allows the use of XML as input to the RowSet. RowSets have more data associated with them than ResultSets, partially because of extended metadata, and partially because they can disconnect from the original database, which mandates that the data be loaded before the RowSet can be used. However, the capabilities they offer may be worth investigating, especially as JDBC 3 becomes more popular and JDBC 4.0 also begins to propagate.
  2. The .NET implementation of disconnected results and the ability to perform operations on it is superior. You can filter, sort and join in-memory data tables and you can also override the SQL used to update/delete/insert them. And you don't need to first create a resultset and then populate a webresultset.
  3. The .NET implementation of disconnected results and the ability to perform operations on it is superior. You can filter, sort and join in-memory data tables and you can also override the SQL used to update/delete/insert them. And you don't need to first create a resultset and then populate a webresultset.
    mmm... kart, did you really check JDBC RowSet capabilities? ----- Gustavo.