Oracle9i Java Stored Procedures Developer's Guide

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. 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