Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Overview of this book

Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface

Setting the Environment


Business components are developed in JDeveloper 10g. Install the JDeveloper 10g IDE. Install the Oracle 10g database. Create an instance of the database. Create an example table in the database from which business components will be generated. The SQL script to create the example table Catalog is listed below.

CREATE TABLE OE.Catalog(CatlogId VARCHAR(25) PRIMARY KEY, Journal
VARCHAR(25), Publisher Varchar(25),Edition VARCHAR(25), Section
VARCHAR(25), Title Varchar(75), Author Varchar(25));
INSERT INTO OE.Catalog VALUES('catalog1', 'Oracle Magazine', 'Oracle
Publishing', 'Nov-Dec 2004','ORACLE DEVELOPER', 'From ADF UIX to
JSF', 'Jonas Jacobi');
INSERT INTO OE.Catalog VALUES('catalog2', 'Oracle Magazine', 'Oracle
Publishing', 'Nov-Dec 2004', 'TECHNOLOGY', 'Database Resource
Manager', 'Kimberly Floss');
INSERT INTO OE.Catalog VALUES('catalog3', 'Oracle Magazine','Oracle
Publishing','March-April 2005','ORACLE DEVELOPER','Starting with
Oracle ADF', 'Steve Muench');

Next...