Free PDF eBook | FileMount.com

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