Oracle Database Java Developer’s Guide

4-4 Java Developer’s. Check that the samples work before using build more complex environments such as. Visual Cafe, JDeveloper ….

More PDF Content

Oracle Database Java Developer\’s Guide, Contents:

  • 1 Introduction to Java in Oracle Database
  • Overview of Java … 1-1
  • Java and Object-Oriented Programming Terminology … 1-2
  • Classes … 1-2
  • Objects … 1-2
  • Interfaces … 1-3
  • Encapsulation … 1-3
  • Inheritance … 1-3
  • Polymorphism … 1-4
  • Key Features of the Java Language … 1-5
  • The JVM… 1-6
  • Java Class Hierarchy… 1-7
  • Using Java in Oracle Database… 1-8
  • Java and RDBMS: A Robust Combination … 1-8
  • Multithreading… 1-9
  • Automated Storage Management With Garbage Collection … 1-10
  • Footprint … 1-11
  • Performance … 1-12
  • Dynamic Class Loading … 1-13
  • The Oracle JVM … 1-14
  • Process Area… 1-15
  • The main() Method … 1-15
  • The GUI … 1-15
  • The IDE … 1-15
  • Main Components of the Oracle JVM… 1-15
  • Library Manager… 1-16
  • Compiler… 1-17
  • Interpreter… 1-17
  • Class Loader… 1-17
  • Verifier … 1-17
  • Server-Side JDBC Internal Driver … 1-17
  • Server-Side SQLJ Translator … 1-18
  • Java Application Strategy of Oracle … 1-18
  • Java in Database Application Development … 1-18
  • Java Programming Environment … 1-18
  • Java Stored Procedures… 1-19
  • PL/SQL Integration and Oracle RDBMS Functionality … 1-19
  • JDBC Drivers … 1-19
  • SQLJ … 1-20
  • JPublisher … 1-20
  • Development Tools … 1-21
  • Desupport of J2EE Technologies in the Oracle Database … 1-21
  • Memory Model for Dedicated Mode Sessions… 1-21
  • What\’s New in this Release? … 1-22
  • Upgrading to J2SE 1.4.2… 1-22
  • Auditing SQL Statements Related to Java Schema Objects … 1-22
  • The PGA_AGGREGATE_TARGET parameter… 1-22
  • 2 Java Applications on Oracle Database
  • Database Sessions Imposed on Java Applications … 2-1
  • Execution Control… 2-3
  • Java Code, Binaries, and Resources Storage … 2-3
  • Preparing Java Class Methods for Execution… 2-5
  • Compiling Java Classes … 2-5
  • Compiling Source Through javac … 2-6
  • Compiling Source Through loadjava … 2-6
  • Compiling Source at Run Time… 2-6
  • Specifying Compiler Options… 2-6
  • Recompiling Automatically… 2-8
  • Resolving Class Dependencies… 2-9
  • Loading Classes… 2-12
  • Granting Execute Rights … 2-14
  • Controlling the Current User … 2-14
  • Checking Java Uploads … 2-16
  • Publishing… 2-17
  • Auditing… 2-18
  • User Interfaces on the Server … 2-19
  • Shortened Class Names… 2-20
  • Class.forName() in Oracle Database… 2-20
  • Supply ClassLoader in Class.forName()… 2-21
  • Supply Class and Schema Names to classForNameAndSchema()… 2-22
  • Supply Class and Schema Names to lookupClass()… 2-23
  • Supply Class and Schema Names when Serializing… 2-23
  • Class.forName Example… 2-23
  • Managing Your Operating System Resources… 2-24
  • Overview of Operating System Resources… 2-25
  • Garbage Collection and Operating System Resources … 2-25
  • Threading in Oracle Database … 2-26
  • Shared Servers Considerations… 2-29
  • End-of-Call Migration … 2-29
  • Oracle-Specific Support for End-of-Call Optimization … 2-30
  • The EndOfCallRegistry.registerCallback() Method… 2-33
  • The EndOfCallRegistry.runCallbacks() Method … 2-33
  • The Callback Interface … 2-33
  • The Callback.act() method … 2-34
  • Operating System Resources Affected Across Calls … 2-34
  • 3 Calling Java Methods in Oracle Database
  • Invoking Java Methods… 3-1
  • Utilizing Java Stored Procedures … 3-1
  • Utilizing JNI Support… 3-3
  • Utilizing SQLJ and JDBC for Querying the Database… 3-3
  • JDBC… 3-4
  • SQLJ … 3-4
  • Example Comparing JDBC and SQLJ … 3-4
  • Complete SQLJ Example… 3-6
  • SQLJ Strong Typing Paradigm… 3-7
  • Translating a SQLJ Program… 3-7
  • Running a SQLJ Program in the Server … 3-8
  • Converting a Client Application to Run on the Server … 3-8
  • Interacting with PL/SQL… 3-8
  • Debugging Server Applications… 3-9
  • How To Tell You Are Running on the Server … 3-9
  • Redirecting Output on the Server … 3-9
  • Support for Calling Java Stored Procedures Directly … 3-9
  • Using the Native Java Interface… 3-11
  • 4 Java Installation and Configuration
  • Initializing a Java-Enabled Database … 4-1
  • Configuring with Oracle Database Template … 4-1
  • Modifying an Existing Oracle Database to Include Oracle JVM… 4-1
  • Configuring Oracle JVM… 4-2
  • Using The DBMS_JAVA Package… 4-2
  • Enabling the Java Client … 4-2
  • Install J2SE on the Client … 4-2
  • Set Up Environment Variables… 4-2
  • Test Install with Samples … 4-3
  • 5 Developing Java Stored Procedures
  • Stored Procedures and Run-Time Contexts … 5-1
  • Functions and Procedures… 5-2
  • Database Triggers… 5-2
  • Object-Relational Methods… 5-2
  • Advantages of Stored Procedures … 5-3
  • Performance … 5-3
  • Productivity and Ease of Use … 5-3
  • Scalability … 5-4
  • Maintainability … 5-4
  • Interoperability… 5-4
  • Replication… 5-4
  • Security … 5-4
  • Java Stored Procedure Configuration… 5-5
  • Java Stored Procedures Steps… 5-5
  • Step 1: Create or Reuse the Java Classes… 5-6
  • Step 2: Load and Resolve the Java Classes … 5-6
  • Step 3: Publish the Java Classes … 5-7
  • Step 4: Call the Stored Procedures… 5-7
  • Step 5: Debug the Stored Procedures, if Necessary … 5-7
  • 6 Publishing Java Classes With Call Specifications
  • Understanding Call Specifications … 6-1
  • Defining Call Specifications… 6-2
  • Setting Parameter Modes… 6-2
  • Mapping Data Types … 6-3
  • Using the Server-Side Internal JDBC Driver … 6-5
  • Writing Top-Level Call Specifications… 6-6
  • Writing Packaged Call Specifications … 6-10
  • Writing Object Type Call Specifications… 6-12
  • Declaring Attributes … 6-13
  • Declaring Methods… 6-13
  • Map and Order Methods … 6-14
  • Constructor Methods… 6-14
  • Examples … 6-14
  • 7 Calling Stored Procedures
  • Calling Java from the Top Level… 7-1
  • Redirecting Output … 7-2
  • Examples of Calling Java Stored Procedures From the Top Level … 7-2
  • Calling Java from Database Triggers … 7-4
  • Calling Java from SQL DML… 7-7
  • Calling Java from PL/SQL … 7-8
  • Calling PL/SQL from Java … 7-10
  • How Oracle JVM Handles Exceptions … 7-10
  • 8 Java Stored Procedures Application Example
  • Drawing the Entity-Relationship Diagram… 8-1
  • Planning the Database Schema … 8-4
  • Creating the Database Tables … 8-4
  • Writing the Java Classes… 8-5
  • Loading the Java Classes… 8-9
  • Publishing the Java Classes… 8-10
  • Calling the Java Stored Procedures… 8-11
  • 9 Security for Oracle Database Java Applications
  • Network Connection Security … 9-1
  • Database Contents and Oracle JVM Security… 9-2
  • Java2 Security… 9-2
  • Setting Permissions… 9-4
  • Fine-Grain Definition for Each Permission … 9-5
  • General Permission Definition Assigned to Roles … 9-16
  • Debugging Permissions … 9-17
  • Permission for Loading Classes … 9-17
  • Database Authentication Mechanisms … 9-17
  • 10 Oracle Database Java Application Performance
  • Natively Compiled Code … 10-1
  • Accelerator Overview… 10-2
  • Oracle Database Core Java Class Libraries… 10-3
  • Natively Compiling Java Application Class Libraries… 10-3
  • Running the Accelerator … 10-4
  • The ncomp Tool… 10-5
  • Native Compilation Usage Scenarios… 10-8
  • The deploync Tool… 10-10
  • The statusnc Tool … 10-11
  • Java Memory Usage … 10-12
  • Configuring Memory Initialization Parameters … 10-13
  • Initializing Pool Sizes within Database Templates … 10-14
  • Java Pool Memory… 10-14
  • Displaying Used Amounts of Java Pool Memory … 10-15
  • Correcting Out of Memory Errors … 10-16
  • 11 Schema Objects and Oracle JVM Utilities
  • Schema Objects Overview… 11-1
  • What and When to Load… 11-2
  • Resolution… 11-2
  • Digest Table … 11-3
  • Compilation… 11-4
  • The loadjava Tool… 11-4
  • Syntax… 11-5
  • Argument Summary… 11-6
  • Argument Details… 11-11
  • The dropjava Tool … 11-15
  • Syntax… 11-16
  • Argument Summary… 11-16
  • Argument Details… 11-17
  • Dropping Resources … 11-18
  • The ojvmjava Tool … 11-18
  • Syntax… 11-19
  • Argument Summary… 11-19
  • Example … 11-20
  • Functionality … 11-20
  • ojvmjava Options … 11-20
  • Shell Commands … 11-22
  • 12 Database Web Services
  • Overview of Database Web Services… 12-1
  • Using Oracle Database as Service Provider for Web Services … 12-1
  • How to Use JPublisher for Web Services Call-Ins… 12-2
  • Features of Oracle Database as a Web Service Provider … 12-2
  • JPublisher Support for Web Services Call-Ins to Oracle Database … 12-3
  • Using Oracle Database as Service Consumer for Web Services … 12-3
  • How to Use Oracle Database for Web Services Call-Outs … 12-3
  • Web Service Data Sources (Virtual Table Support) … 12-4
  • Features of Oracle Database as a Web Service Consumer … 12-5
  • JPublisher Generation Overview… 12-5
  • Adjusting the Mapping of SQL Types … 12-7
  • A DBMS_JAVA Package
  • longname… A-1
  • shortname… A-1
  • get_compiler_option … A-1
  • set_compiler_option… A-1
  • reset_compiler_option… A-2
  • resolver … A-2
  • derivedFrom … A-2
  • fixed_in_instance… A-3
  • set_output… A-3
  • start_debugging … A-3
  • stop_debugging … A-4
  • restart_debugging… A-4
  • export_source… A-4
  • export_class… A-4
  • export_resource… A-4
  • loadjava … A-4
  • dropjava… A-5
  • grant_permission… A-5
  • restrict_permission… A-5
  • grant_policy_permission… A-5
  • revoke_permission… A-6
  • disable_permission … A-6
  • enable_permission … A-6
  • delete_permission … A-6
  • set_preference … A-6

List of Figures

  • 1–1 Classes and Instances … 1-3
  • 1–2 Java Component Structure … 1-6
  • 1–3 Oracle Database Java Component Structure… 1-7
  • 1–4 Class Hierarchy … 1-8
  • 1–5 Two-Tier Client/Server Configuration… 1-9
  • 1–6 Garbage Collection … 1-11
  • 1–7 Interpreter versus Accelerator … 1-13
  • 1–8 Main Components of the Oracle JVM… 1-16
  • 2–1 Java Environment Within Each Database Session … 2-2
  • 2–2 Loading Java into Oracle Database … 2-4
  • 2–3 Rights to Run Classes … 2-14
  • 2–4 Invoker-Rights Solution … 2-15
  • 2–5 Indirect Access… 2-16
  • 3–1 Native Java Interface … 3-11
  • 5–1 Calling a Stored Procedure… 5-1
  • 6–1 Calling a Java Method … 6-2
  • 8–1 Rule for Drawing an E-R Diagram … 8-2
  • 8–2 E-R Diagram for Purchase Order Application… 8-3
  • 8–3 Schema Plan for Purchase Order Application … 8-4
  • 10–1 Native Compilation Using Accelerator … 10-2
  • 10–2 Configuring Oracle JVM Memory Parameters… 10-14
  • 12–1 Web Services Call-In to the Database … 12-2
  • 12–2 Calling Web Services From Within the Database … 12-4
  • 12–3 Storing Results from Request in a Virtual Table … 12-5
  • 12–4 Creating Web Services Call-Out Stubs … 12-6

 

Download Oracle Database Java Developer's Guide pdf from stmain.st.utoledo.edu, 220 pages, 4050.38KB.