The hands-on tutorial for Java developers who want to integrate their applications with the industy leading Oracle 8i and 9i databases.
As an aid to your work with Java Oracle Database Development, we are making available for download the source code for all significant examples from the book (ZIP archive).
1. Java, Databases, and Oracle.
The Right Tool at the Right Time. Types of Databases. Oracle and Java.
Tables, Columns, and Rows. Oracle Datatypes. Designing a Database.
Data Definition Language. Data Manipulation Language. SQL Functions. Transactions.
Aggregate Functions, GROUP BY and HAVING. Putting Data in Order. Combining Data from Different Tables. Subqueries. Views.
Getting Started with PL/SQL. Basic PL/SQL Language Elements. Program Elements. Java Stored Procedures.
Object Types. Inheritance and Object Evolution in Oracle 9i.
SQLJ Statements and the SQLJ Translator.
Connecting to the Database. Executing SQL Statements. Executing SQL Queries. Large Objects—BLOBs and CLOBs.
Connection Options. JDBC Driver Types. Using DataSource Instead of DriverManager. Scrollable, Sensitive, Updateable ResultSets. RowSets. Using Oracle Object-Relational Features with JDBC.
A J2EE Overview. Designing a J2EE Application. The Oracle Containers for J2EE, OC4J. Deploying the Web Application. EJBs and Web Applications.
The EJB Distributed Object Model. Introduction to Bean Building: A Stateless Session Bean. Debugging with Jdeveloper. Packaging and Deploying the EJB—Overview. Session Beans, Value Objects, and Data Access Objects. A Bean-Managed Persistent Entity Bean. The Sample Client Application.
Java Data Objects. Class Relationships and Persistence.