Oracle9i Java Stored Procedures Developer's Guide
Release 1 (9.0.1)

Part Number A90210-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback

Go to next page

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


Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Index
Index

Master Index

Feedback