Oracle9i Java Developers Guide

Maring S.

This book lias been written for the following audiences:■ Management-You may have purchased Oracle9i for reasons other than Java development within the database. However, if you want to know more about Oracle9i Java features, see “Overview of Oracle9i Java Documentation” on page 1-23 for a management perspective.■ Non-Java Developers-Oracle database programming consists of PL/SQL and other non-Java programming. For experienced PL/SQL developers who are not familiar with Java, a brief overview of Java and object-oriented concepts is discussed in the first part of Chapter 1, “Introduction to Java in Oracle9i”. For more detailed information on Java, see “Java Information Resources” at the end of this Preface.■ Java Developers-Pure Java developers are used to a Java environment that follows the Sun Microsvstems specification. However, when Java is combined in the database, both Java and database concepts merge. Thus, the Java environment within Oracle9; is expanded to include database concerns. The bulk of this book discusses how to execute Java in the database. The following outlines the two viewpoints that arise from this merge:”

---

Table of contents :
Oracle9i……Page 1
Send Us Your Comments……Page 9
Preface……Page 11
1 Introduction to Java in Oracle9i……Page 15
Java and Object-Oriented Programming Terminology……Page 16
Classes……Page 17
Attributes……Page 18
Class Hierarchy……Page 19
Interfaces……Page 20
Polymorphism……Page 21
The Java Virtual Machine (JVM)……Page 22
Key Features of the Java Language……Page 25
Multithreading……Page 27
Automated Storage Management……Page 28
How Native Compilers Improve Performance……Page 29
Dynamic Class Loading……Page 30
Oracle’s Java Application Strategy……Page 31
PL/SQL Integration and Oracle RDBMS Functionality……Page 32
SQLJ – Embedded SQL in Java……Page 33
JavaServer Pages……Page 34
Using EJB Components……Page 35
Development Tools……Page 36
Overview of Oracle9i Java Documentation……Page 37
2 Writing Java Applications on Oracle9i……Page 39
Terminology……Page 40
Database Sessions Imposed on Java Applications……Page 41
Java Supported APIs……Page 43
Execution Control……Page 44
Your Development Environment……Page 45
JDBC 2.0……Page 46
Server Applications Using JDBC 2.0……Page 47
Java 2 ORB APIs……Page 48
Oracle9i ORB Interface……Page 49
CORBA ORB Interface……Page 51
Java Code, Binaries, and Resources Storage……Page 52
Compiling Source Through javac……Page 53
Specifying Compiler Options……Page 54
Automatic Recompilation……Page 57
Resolving Class Dependencies……Page 58
ByteCode Verifier……Page 60
Loading Classes……Page 62
Defining the Same Class Twice……Page 64
How to Grant Execute Rights……Page 65
Controlling the Current User……Page 66
Checking Java Uploads……Page 68
Status……Page 69
Publishing……Page 70
User Interfaces on the Server……Page 71
Shortened Class Names……Page 72
Class.forName() in Oracle9i……Page 73
Supply the ClassLoader in Class.forName……Page 74
Supply Class and Schema Names to lookupClass……Page 75
Class.forName Example……Page 76
Managing Your Operating System Resources……Page 77
Operating System Resource Access……Page 78
Garbage Collection and Operating System Resources……Page 79
Operating System Resources Affected Across Calls……Page 81
Threading in Oracle9i……Page 83
Thread Lifecycle……Page 85
3 Invoking Java in the Database……Page 87
Overview……Page 88
Utilizing Java Stored Procedures……Page 89
Utilizing Distributed Objects With CORBA and EJB……Page 92
Naming……Page 93
Creating and Deploying Enterprise JavaBeans……Page 94
Session Shell……Page 95
Utilizing Java Native Interface (JNI) Support……Page 96
SQLJ……Page 97
An Example Comparing JDBC and SQLJ……Page 98
Complete SQLJ Example……Page 99
SQLJ Strong Typing Paradigm……Page 101
Running a SQLJ Program in the Server……Page 102
Interacting with PL/SQL……Page 103
Debugging Server Applications……Page 104
1. Prepare the Code for Debugging……Page 105
2. Start the Debug Proxy……Page 106
3. Starting, Stopping, and Restarting the Debug Agent……Page 107
4. Connecting a Debugger……Page 108
Redirecting Output on the Server……Page 110
4 Java Installation and Configuration……Page 111
Configuring Oracle JVM……Page 112
Java Stored Procedure Configuration……Page 114
Using The DBMS_JAVA Package……Page 115
2. Set up Environment Variables……Page 118
JAR Files Necessary for JDK 1.1 Clients……Page 119
JAR Files Necessary for Java 2 Clients……Page 120
3. Verify the Port/SID……Page 121
4. Test Install with Samples……Page 122
5 Security For Oracle9i Java Applications……Page 123
Database Contents and JVM Security……Page 124
Java 2 Security……Page 125
Setting Permissions……Page 128
Fine-Grain Definition for Each Permission……Page 129
Acquiring Administrative Permission to Update Policy Table……Page 134
Creating Permissions……Page 136
Enabling or Disabling Permissions……Page 140
Permission Types……Page 141
Initial Permission Grants……Page 143
General Permission Definition Assigned to Roles……Page 146
Debugging Permissions……Page 147
Permission for Loading Classes……Page 148
6 Oracle9i Java Application Performance……Page 149
Natively Compiled Code……Page 150
Accelerator Overview……Page 151
Installation Requirements……Page 153
Executing Accelerator……Page 154
Java Memory Usage……Page 155
Configuring Memory Initialization Parameters……Page 156
Initializing Pool Sizes within Database Templates……Page 157
Java Pool Memory……Page 158
Displaying Used Amounts of Java Pool Memory……Page 160
Running out of memory while loading……Page 161
End-of-Call Migration……Page 162
Oracle-Specific Support for End-of-Call Optimization……Page 163
Memory Profiling Utility……Page 167
How MemStat Works……Page 168
Using MemStat……Page 169
MemStat Permissions……Page 170
The MemStat Report Format……Page 171
Glossary……Page 175
Index……Page 181