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


Install the JDeveloper 10.1.3 IDE. Install the Oracle 10g database including the sample schemas. In SQL Plus, create an example database table from which a panel grid will be generated. The SQL script to generate the example database table is as follows:

CREATE TABLE OE.Catalog(CatalogId INTEGER PRIMARY KEY, Journal
VARCHAR(25), Publisher VARCHAR(25), Edition VARCHAR(25), Title
Varchar(45), Author Varchar(25), HREF VARCHAR(125));
INSERT INTO OE.Catalog VALUES('1', 'Oracle Magazine', 'Oracle
Publishing', 'Nov-Dec 2004', 'Database Resource Manager', 'Kimberly
Floss', 'http://www.oracle.com/technology/oramag/oracle/04-
nov/o64tuning.html');
INSERT INTO OE.Catalog VALUES('2', 'Oracle Magazine', 'Oracle
Publishing', 'Nov-Dec 2004', 'From ADF UIX to JSF', 'Jonas
Jacobi','http://www.oracle.com/technology/oramag/oracle/04-
nov/o64jsf.html');
INSERT INTO OE.Catalog VALUES('3', 'Oracle Magazine', 'Oracle
Publishing', 'March-April 2005', 'Starting with Oracle ADF ',
'Steve Muench...