Oracle8
i
Java Stored Procedures Developer's Guide
Release 8.1.5
A64686-01
Library
Product
Index
Contents
Title and Copyright Information
Send Us Your Comments
Preface
1 Introduction
Java in 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
Security
Replication
The Aurora JVM and Its Components
The Aurora JVM versus Client JVMs
Main Components of the Aurora JVM
Developing Stored Procedures: An Overview
Write or Reuse the Procedures
Load the Procedures into the RDBMS
Publish the Procedures in the Oracle Data Dictionary
Call the Procedures from SQL and PL/SQL
2 Loading Stored Procedures
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 Filenames
Examples
Reloading Files
Checking Upload Results
Using dropjava
Specifying Filenames
Examples
Invoker Rights versus Definer Rights
3 Publishing Stored Procedures
Understanding Call Specs
Defining Call Specs: Basic Requirements
Setting Parameter Modes
Mapping Datatypes
Using the Server-Side 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 Exceptions Are Handled
5 Developing an Application
Drawing the Entity-Relationship Diagram
Planning the Database Schema
Creating the Database Tables
Writing the Java Stored Procedures
Loading the Java Stored Procedures
Publishing the Java Stored Procedures
Calling the Java Stored Procedures
Index
Next
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Index
