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 implementations of RowSet—JdbcRowSet, CachedRowSet, WebRowSet, FilteredRowSet, and JoinRowSet—were introduced. The WebRowSet
interface extends the RowSet
interface and is the XML document representation of a RowSet
object. A WebRowSet
object represents...