We will use Oracle database to generate an updatable OracleWebRowSet
object. Therefore, install Oracle database 10g including the sample schemas. Connect to the database with the OE schema:
SQL> CONNECT OE/<password>
Create an example database table, Catalog
, with the following SQL script:
CREATE TABLE OE.Catalog(Journal VARCHAR(25), Publisher Varchar(25),
Edition VARCHAR(25), Title Varchar(45), Author Varchar(25));
INSERT INTO OE.Catalog VALUES('Oracle Magazine', 'Oracle
Publishing', 'July-August 2005', 'Tuning Undo Tablespace',
'Kimberly Floss');
INSERT INTO OE.Catalog VALUES('Oracle Magazine', 'Oracle
Publishing', 'March-April 2005', 'Starting with Oracle ADF', 'Steve
Muench');
Configure JDeveloper 10g for Web RowSet implementation. Create a project in JDeveloper. Select File | New | General | Application. In the Create Application window specify an Application Name and click on Next. In the Create Project window specify a Project Name and click on Next...