Oracle9i Java Developers Guide

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:" 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