Oracle8i Java Stored Procedures Developer's Guide Release 2 (8.1.6) Part Number A81358-01

Library Service Index

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 JServer JVM and Its Components

The JServer JVM versus Client JVMs

Main Components of the JServer JVM

Developing Stored Procedures: An Overview

Step 1: Create or Reuse the Java Classes

Step 2: Load and Resolve the Java Classes

Step 3: Publish the Java Classes

Step 4: Call the Stored Procedures

Step 5: If Necessary, Debug the Stored Procedures

2 Loading Java Classes

Java in the Database

Managing Java Schema Objects

What to Load

How External References Are Resolved

What the Digest Table Does

How Compilation Is Done

Using loadjava

Specifying the User

Specifying File Names

Examples

Reloading Files

Running loadjava from an Application

Checking Upload Results

Using dropjava

Specifying the User

Specifying File Names

Examples

Invoker Rights versus Definer Rights

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

Example 1

Example 2

Example 3

Example 4

Writing Packaged Call Specs

An Example

Writing Object Type Call Specs

Declaring Attributes

Declaring Methods

Examples

4 Calling Stored Procedures

Calling Java from the Top Level

Redirecting Output

Example 1

Example 2

Calling Java from Database Triggers

Example 1

Example 2

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

Copyright © 1996-2000, Oracle Corporation. All Rights Reserved.

Library Service Index