Oracle 8i and Java

Elio Bonazzi and Glenn Stokol begin with an overview of the Oracle 8i object-relational database and the SQL language. Next, they compare Java and PL/SQL solutions for building stored procedures, and introduce Oracle's Business Components for Java Framework, which streamlines the creation and reuse of business application logic, makes it possible to access views of data efficiently from Java and HTML user interfaces, and simplifies customization. They demonstrate how to use Java and Oracle's XML support to integrate diverse systems; then present in-depth coverage of middleware solutions utilizing servlets, JavaServer Pages, and the Oracle Application Server. The book includes detailed coverage of e-Commerce and e-Business development, practical solutions for eliminating SQL code bottlenecks, and much more.

For all IT professionals who are familiar with Java and want to use it with Oracle to build enterprise or e-Business applications.

Contents

Preface

1: Introduction to Oracle Object-Relational Database Design and Architecture

Relational Model and Design for the Bookstore

Importance of the Database Model and Design

Transforming an ERD into a Table Design

Transforming Supertype and Subtype Entities

Generic Subtype Design

Table or System Design

Object Model and Design for the Bookstore

Mapping the Class Model to an Oracle Database

Object to Relational Mapping Rules

Summary

2: Data Definition Language (DDL) Statements

Overview of SQL Statements

A Brief Introduction to Oracle SQL*Plus

Generic DDL Syntax

Oracle Naming Rules for Database Structures

Oracle8 Built-in Data Types

Relational Tables

Alternative CREATE TABLE Syntax

Relational Views

Oracle Sequences

Oracle Synonyms

Oracle Object Types

Oracle Object Tables

Oracle Object Views

Security: Access-Control Statements

Summary

3: Query Processing

SELECT Statements

Single Row Functions

WHERE CLAUSE to Restrict Rows Retrieved

Table Join Operations

ORDER BY

Aggregate Functions

GROUP BY Clauses

HAVING Clauses

Subqueries

Querying Object Structures

Summary

4: Data Manipulation Language (DML) Statements and Transactions

DML on Relational Tables

DML on Object Tables

DML on Collection Objects

Getting More Performance with DML

Transactions in Oracle SQL

Summary

5: Oracle Architecture and Performance Considerations

Architectural Elements

Performance Tuning

Summary

6: Internet Security and Oracle security

Network Firewalls

Oracle Security

The Demilitarized Zone

Using Oracle Security and Synonyms to Implement a Development Environment

New Oracle Security Features

Summary

7: Introduction to PL/SQL

Anonymous Blocks

PL/SQL Variables and Data Types

Conditional and Sequential Controls

Using SQL Statements in PL/SQL

Cursors

PL/SQL Tables and Varying Arrays

User-Defined/Object Types in PL/SQL

Summary

8: PL/SQL Procedures, Functions, Packages, and Exceptions

Stored Procedures and Functions

PL/SQL Packages

PL/SQL and Object Types

Exception Handling in PL/SQL

Transactions in PL/SQL

Java and PL/SQL: A Comparison

Performance Considerations

Summary

9: Data Access with JDBC-Java Database Connectivity

Introducing the JDBC Architecture

The Driver Manager and JDBC Drivers

Overview of JDBC Interfaces and Classes

Using JDBC Objects

Summary

10: Enhanced Database Access with JDBC

Extensions to Oracle JDBC Drivers

Support for the JDBC 2

0 Optional Package

Summary

11: Data Access with SQLJ-Embedding SQL in Java

An Overview of SQLJ

Connecting to a Database in SQLJ

Executing SQL Statements Using SQLJ

Processing Oracle SQL Object Types

Processing SQL Collections

Managing Large Data Types

Executing Stored Procedures and Functions

Summary

12: Java Stored Procedures In Oracle

Java Code Running in the Oracle Kernel

Three Steps to Develop and Deploy Stored Procedures

Making Java and PL/SQL Interact

PL/SQL versus Java: Choosing the Right Tool for Your Task

Summary

13: Business Components for Java and XML

The Business Component for Java Framework

Introduction to XML Basics

Creating a Business Component Application Module

Testing Components and the Application Module

Creating BC4J Client Applications

Customizing the Components

Deploying a Business Component

Summary

14: Data Access Using Java Servlets and Connection Pooling

Multiple Threads, Session State, and Security

Connection Pooling

A Servlet Example

BookServlet: Pros and Cons

Running BookServlet

Summary

15: Java Server Pages and Active Server Pages

JSP: An Overview

ASP: An Overview

JSP and ASP Compared

Reworking BookServlet Using JSP

Summary

16: Using Java in Oracle Application Server

Evolution of Oracle Application Server

Oracle Application Server Architecture

Configuring PL/SQL Applications

Configuring Java Applications

Introducing Oracle9i Application Server

Summary

17: Web-Enabling Legacy Applications Using Network Sockets

The Mediator Design Pattern

Java Sockets

Summary

18: Web-Enabling Legacy Applications Using JNI

Oracle Pre-Compilers

Java Native Methods

Setting Up Your Environment to Run the Example

Debugging JNI Functions

Summary

19: Accessing Oracle Advanced Queuing Through Java

Application Queues

Oracle Advanced Queuing

Examples of Advanced Queuing

Summary

20: Using Oracle Replication to Build Distributed Systems

Data Replication

Basic Replication in Oracle

An Example of Data Replication

Summary

21: The Enterprise JavaBean: An Introduction

EJB Environment and Structure

Creating an Enterprise JavaBean

Creating EJB Client Application

Creating an EJB and Client with JDeveloper

Running the Enterprise JavaBean

Summary

22: Deploying and Using an Enterprise JavaBean

Preparing to Run Oracle8i EJB Services

Deploying an EJB with Command-Line Utilities

Running the Client Application after Deployment

Transaction-Enabling an Enterprise JavaBean

Restrictions and Limitations with Oracle8i EJBs

EJB Security in Oracle8i

Removing an EJB from Oracle8i Server

Deploying an Enterprise JavaBean to Oracle Application Server

Summary

23: CORBA and Its Implementation in Oracle8i: An Overview

Distributed Computing: Historical Background

The Common Object Broker Architecture

Putting It All Together: The First CORBA Program

The Java Transaction Service (JTS)

Summary

24: Advanced CORBA Topics

More on Interface Definition Language

Managing the Oracle Name Space

Using the CORBA Tie Mechanism

Further References

Summary