JDBC Rowset

0
Share this on .. Tweet about this on Twitter0Share on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on TumblrBuffer this page

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.

 

Share this on .. Tweet about this on Twitter0Share on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on TumblrBuffer this page

About Author

Aino Andriessen is principal consultant and expertise lead 'Continuous Delivery'. His focus is on Oracle Fusion Middleware ADF and SOA development, Continuous Delivery, architecture, improving the software development proces and quality management. He is a frequent presenter at Oracle Open World, ODTUG Kaleidoscope, UKOUG Technology Conference and OUGN VÃ¥rseminar. He writes articles and publishes at the AMIS technology blog (http://technology.amis.nl/blog/).

Comments are closed.