Setting the environment
We need to install Oracle Fusion Middleware 11g (http://www.oracle.com/technology/software/products/middleware/index.html). We need to download the following two components from the For Development section.
Oracle WebLogic Server 11g Rel 1 (10.3.2) Net Installer
Oracle JDeveloper 11g Rel 1 (11.1.1.2.0) (JDeveloper + ADF)
First, install JDeveloper 11g Studio Edition. Also install Oracle database 10g/11g/XE (including the sample schemas). We shall be using the XE version in this chapter. Create an Oracle database table CATALOG
with the following SQL script:
CREATE TABLE Catalog(CatalogId VARCHAR(255), Journal VARCHAR(255), Publisher Varchar(255), Edition VARCHAR(255), Title Varchar(255), Author Varchar(255)); INSERT INTO Catalog VALUES('catalog1', 'Oracle Magazine', 'Oracle Publishing', 'September-October 2009','Oracle Fusion Middleware 11g: The Foundation for Innovation', 'David Baum'); INSERT INTO Catalog VALUES('catalog2', 'Oracle Magazine', 'Oracle Publishing', 'September...