Oracle Web RowSet
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, fi ve 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 a set of fetched database
table rows, which may be modifi ed without being connected to the database.
Support for Oracle Web RowSet is a new feature in Oracle Database 10g driver.
Oracle Web RowSet precludes the requirement for a persistent connection with
the database. A connection is required only for retrieving data from the
database with a SELECT query and for updating data in the database after all
the required row operations on the retrieved data have been performed. Oracle
Web RowSet is used for queries and modifi cations on the data retrieved from
the database. Oracle Web RowSet, as an XML document representation of a RowSet
facilitates the transfer of data.
In Oracle Database 10g and 11g JDBC drivers, Oracle Web RowSet is implemented in
the oracle.jdbc.rowset package. The OracleWebRowSet class represents a Oracle
Web RowSet. The data in the Web RowSet may be modifi ed without connecting to
the database. The database table may be updated with the OracleWebRowSet class
after the modifi cations to the Web RowSet have been made. A database JDBC
connection is required only for retrieving data from the database and for
updating
the database. An XML document representation of the data in a Web RowSet may be
obtained for data exchange. In this chapter the Web RowSet feature in Oracle
10g database JDBC driver is implemented in JDeveloper 10g. An example Web
RowSet will be created from a database. The Web RowSet will be modifi ed and
stored in the database table.
In this chapter we will learn the following:
-
Creating a Oracle Web RowSet object
-
Adding a row to Oracle Web RowSet
-
Reading a row from Oracle Web RowSet
-
Updating a row in Oracle Web RowSet
-
Deleting a row from Oracle Web RowSet
-
Updating Database Table with modifi ed Oracle Web RowSet
|
Book Excerpt: JDBC 4.0 and Oracle JDeveloper for J2EE Development
This chapter excerpt from
JDBC 4.0 and Oracle JDeveloper for J2EE Development by Deepak
Vohra, is printed with permission from Packt
Publishing, Copyright 2007.
-
Creating a Oracle Web RowSet object
-
Adding a row to Oracle Web RowSet
-
Reading a row from Oracle Web RowSet
-
Updating a row in Oracle Web RowSet
-
Deleting a row from Oracle Web RowSet
-
Updating Database Table with modifi ed Oracle Web RowSet
|
More Related Links
To retrieve data from an Oracle database
using ODP.NET, we need to work with a few of the ODP.NET
classes.....
How do you increase the performance of %LIKE operator?, What is a standby
database? Difference between Physical and logical standby databases, What is
Cache Fusion Technology?, What is simple replication and advance
replication?.............
Describe Oracle architecture in brief, What is the function of SMON?, Explain
different types of segment, Explain SGA memory structures..............
Describe the Oracle backup, i.e. archive log mode, cold and hot backups,
incremental backups..............
What is configure command and recovery catalog?, What are different types of
backup? (Hot, Cold, logical, Physical)?, Whats the Concept of Flashback Query
in Oracle (10g in particular) and how is it beneficial?...............
|
