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.
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 ...