Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Introduction

Java and the RDBMS: A Robust Combination

Stored Procedures and Run-Time Contexts

Functions and Procedures

Database Triggers

Object-Relational Methods

Advantages of Stored Procedures

Performance

Productivity and Ease of Use

Scalability

Maintainability

Interoperability

Replication

Security

The Oracle JVM and Its Components

The Oracle JVM versus Client JVMs

Main Components of the Oracle JVM

Java Stored Procedure Configuration

Developing Stored Procedures: An Overview

2 Loading Java Classes

Java in the Database

Java Code, Binaries, and Resources Storage

Preparing Java Class Methods for Execution

Compiling Java Classes

Resolving Class Dependencies

Loading Classes

How to Grant Execute Rights

Checking Java Uploads

User Interfaces on the Server

Shortened Class Names

Controlling the Current User

3 Publishing Java Classes

Understanding Call Specs

Defining Call Specs: Basic Requirements

Setting Parameter Modes

Mapping Datatypes

Using the Server-Side Internal JDBC Driver

Using the Server-Side SQLJ Translator

Writing Top-Level Call Specs

Writing Packaged Call Specs

Writing Object Type Call Specs

Declaring Attributes

Declaring Methods

4 Calling Stored Procedures

Calling Java from the Top Level

Redirecting Output

Calling Java from Database Triggers

Calling Java from SQL DML

Restrictions

Calling Java from PL/SQL

Calling PL/SQL from Java

How the JVM Handles Exceptions

5 Developing an Application

Drawing the Entity-Relationship Diagram

Planning the Database Schema

Creating the Database Tables

Writing the Java Classes

Loading the Java Classes

Publishing the Java Classes

Calling the Java Stored Procedures

Index