O'Reilly logo

JDBC 4.0 and Oracle JDeveloper for J2EE Development by Deepak Vohra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Oracle Web RowSet

In the previous two chapters we mapped an XML document to a relational database using XSU and a relational database table to an XML document using XSU and XSQL. In this chapter we will use the XML document representation of a result set generated with an SQL query to modify a relational database table.

The ResultSet interface requires a persistent connection with a database to invoke the insert, update, and delete row operations on the database table data. The RowSet interface extends the ResultSet interface and is a container for tabular data that may operate without being connected to the data source. Thus, the RowSet interface reduces the overhead of a persistent connection with the database.

In J2SE 5.0, five new ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required