JDBC Rowset

Aino Andriessen

Do you still think the only way to retrieve data from the database is to use the java.sql.ResultSet? Try the new (hum) javax.sql.RowSet. One of the coolest features is to use it in a disconnected manner. Sounds familiar? Take a look at the .NET DataSet, the only đŸ˜‰ way for .NET developers to retrieve data from the database; why bother converting records to objects ;-). This article compares the JDBC and the .NET classes.

This RowSet is available since Java 1.4 and JDBC 2.x, but it’s part of the JDBC optional package (javax.sql). The Oracle implementation is available for some time in the oracle.jdbc.rowset package (at least since 9i, but probably even earlier). The latest version implements the mandatory JDBC 3.0 features and also an implementation of the WebRowSet (JSR-114), that offers XML ‘access’ to the content. More information on the OTN JDBC page.

 

Next Post

On Web 2.0, RIA, AJAX and Java Server Faces - 2 May 2006: Presentation and Demonstration by Backbase (16.30 Nieuwegein)

Who is not raving about Web 2.0, the advent of Rich Internet Applications, the marvels of AJAX and of course the wonderful, productive world of Java Web application development using Java Server Faces. Amsterdam based tool vendor Backbase brings these worlds together. Backbase offers – in a free community edition […]