Oracle9i Java Stored Procedures Developer’s Guide

Portfolio T.

Anyone developing Java applications for Oracle9i will benefit from reading this guide. Written especially for programmers, it will also be of value to architects, systems analysts, project managers, and others interested in network-centric database applications. To use this guide effectively, you must have a working knowledge of Java, SQL, PL/SQL, and Oracle9i.

---

Table of contents :
Send Us Your Comments……Page 7
Preface……Page 9
1 Introduction……Page 17
Java and the RDBMS: A Robust Combination……Page 18
Stored Procedures and Run-Time Contexts……Page 19
Functions and Procedures……Page 20
Database Triggers……Page 21
Performance……Page 22
Interoperability……Page 23
Security……Page 24
The Oracle JVM and Its Components……Page 25
The Oracle JVM versus Client JVMs……Page 26
Main Components of the Oracle JVM……Page 27
Java Stored Procedure Configuration……Page 32
Developing Stored Procedures: An Overview……Page 33
2 Loading Java Classes……Page 39
Java in the Database……Page 40
Java Code, Binaries, and Resources Storage……Page 41
Compiling Java Classes……Page 42
Resolving Class Dependencies……Page 47
Loading Classes……Page 50
Checking Java Uploads……Page 54
User Interfaces on the Server……Page 56
Shortened Class Names……Page 57
Controlling the Current User……Page 58
3 Publishing Java Classes……Page 61
Understanding Call Specs……Page 62
Setting Parameter Modes……Page 63
Mapping Datatypes……Page 64
Using the Server-Side Internal JDBC Driver……Page 67
Using the Server-Side SQLJ Translator……Page 69
Writing Top-Level Call Specs……Page 71
Writing Packaged Call Specs……Page 75
Writing Object Type Call Specs……Page 78
Declaring Methods……Page 79
4 Calling Stored Procedures……Page 89
Redirecting Output……Page 90
Calling Java from Database Triggers……Page 94
Calling Java from SQL DML……Page 98
Restrictions……Page 99
Calling Java from PL/SQL……Page 100
Calling PL/SQL from Java……Page 102
How the JVM Handles Exceptions……Page 103
5 Developing an Application……Page 105
Drawing the Entity-Relationship Diagram……Page 106
Planning the Database Schema……Page 109
Creating the Database Tables……Page 111
Writing the Java Classes……Page 113
Loading the Java Classes……Page 119
Publishing the Java Classes……Page 120
Calling the Java Stored Procedures……Page 122
Index……Page 125