Java Applications on Oracle Database

List of Tables
Title and Copyright Information
Preface
- Audience
- Documentation Accessibility
- Related Documents
- Conventions
Changes in This Release for Oracle Database Java Developer's Guide
- Changes in Oracle Database 19c
  - New Features
1 Introduction to Java in Oracle Database
- 1.1 Overview of Java
- 1.2 About Using Java in Oracle Database
- 1.3 Overview of Oracle JVM
- 1.4 Feature List of Oracle JVM
- 1.5 Main Components of Oracle JVM
- 1.6 Java Programming in Oracle Database
- 1.7 Support for Java 8
- 1.8 Memory Model for Dedicated Mode Sessions
2 Java Applications on Oracle Database
- 2.1 Database Sessions Imposed on Java Applications
- 2.2 Execution Control of Java Applications
- 2.3 Java Code, Binaries, and Resources Storage
- 2.4 About Java Classes Loaded in the Database
- 2.5 Preparing Java Class Methods for Execution
- 2.6 User Interfaces on the Server
- 2.7 Shortened Class Names
- 2.8 Class.forName() in Oracle Database
- 2.9 About Managing Your Operating System Resources
  - 2.9.1 Overview of Operating System Resources
  - 2.9.2 Garbage Collection and Operating System Resources
- 2.10 About Using the Runtime.exec Functionality in Oracle Database
- 2.11 Managing Your Applications Using JMX
- 2.12 Overview of Threading in Oracle Database
  - 2.12.1 Thread Life Cycle
  - 2.12.2 System.exit(), OracleRuntime.exitSession(), and OracleRuntime.exitCall()
- 2.13 Shared Servers Considerations
3 Calling Java Methods in Oracle Database
- 3.1 Invoking Java Methods
- 3.2 How To Tell Whether You Are Running on the Server
- 3.3 About Redirecting Output on the Server
4 Java Installation and Configuration
- 4.1 Initializing a Java-Enabled Database
  - 4.1.1 Configuring the Oracle JVM Option within the Oracle Database Template
  - 4.1.2 Modifying an Existing Oracle Database to Include Oracle JVM
- 4.2 Configuring Oracle JVM
- 4.3 The DBMS_JAVA Package
- 4.4 Enabling the Java Client
  - 4.4.1 Installing Java SE on the Client
  - 4.4.2 Setting Up Environment Variables
- 4.5 Two-Tier Duration for Java Session State
- 4.6 About Setting System Properties
5 Introduction to Nashorn JavaScript Engine
- 5.1 About Using Nashorn JavaScript Engine
  - 5.1.1 Loading JavaScript Code into a Schema
  - 5.1.2 How to run JavaScript in Oracle JVM
- 5.2 JavaScript Data Access using JDBC
- 5.3 REST Enable Your JavaScript Application
6 Developing Java Stored Procedures
- 6.1 Stored Procedures and Run-Time Contexts
- 6.2 Advantages of Stored Procedures
- 6.3 Running Java Stored Procedures
- 6.4 Debugging Java Stored Procedures
7 Publishing Java Classes With Call Specifications
- 7.1 What Are Call Specifications?
- 7.2 Defining Call Specifications
- 7.3 Writing Top-Level Call Specifications
  - 7.3.1 Examples
- 7.4 Writing Packaged Call Specifications
- 7.5 Writing Object Type Call Specifications
  - 7.5.1 About Attributes
  - 7.5.2 Declaring Methods
8 Calling Stored Procedures
- 8.1 Calling Java from the Top Level
  - 8.1.1 Redirecting the Output
  - 8.1.2 Examples of Calling Java Stored Procedures From the Top Level
- 8.2 Calling Java from Database Triggers
- 8.3 Calling Java from SQL DML
- 8.4 Calling Java from PL/SQL
- 8.5 Calling PL/SQL from Java
- 8.6 How Oracle JVM Handles Exceptions
9 Java Stored Procedures Application Example
- 9.1 About Planning the Database Schema
- 9.2 Creating the Database Tables
- 9.3 Writing the Java Classes
- 9.4 Loading the Java Classes
- 9.5 Publishing the Java Classes
- 9.6 Calling the Java Stored Procedures
10 Oracle Database Java Application Performance
- 10.1 Oracle JVM Just-in-Time Compiler (JIT)
- 10.2 About Java Memory Usage
11 Security for Oracle Database Java Applications
- 11.1 Network Connection Security
- 11.2 Database Contents and Oracle JVM Security
- 11.3 Database Authentication Mechanisms Available with Oracle JVM
- 11.4 Secure Use of Runtime.exec Functionality in Oracle Database
12 Native Oracle JVM Support for JNDI
- 12.1 Overview of Oracle JVM Support for JNDI
- 12.2 Requirements for Oracle JVM Support for JNDI
- 12.3 OJDS Command-Line Tools
- 12.4 OJDS APIs and Classes
13 Schema Objects and Oracle JVM Utilities
- 13.1 Overview of Schema Objects
- 13.2 What and When to Load
- 13.3 Resolution of Schema Objects
- 13.4 Compilation of Schema Objects
- 13.5 The ojvmtc Tool
  - 13.5.1 About the ojvmtc Tool
  - 13.5.2 Arguments of ojvmtc Command
- 13.6 The loadjava Tool
- 13.7 The dropjava Tool
- 13.8 The ojvmjava Tool
14 Database Web Services
- 14.1 Overview of Database Web Services
- 14.2 About Using Oracle Database as Web Services Consumer
A DBMS_JAVA Package
- A.1 longname
- A.2 shortname
- A.3 get_compiler_option
- A.4 set_compiler_option
- A.5 reset_compiler_option
- A.6 resolver
- A.7 derivedFrom
- A.8 fixed_in_instance
- A.9 set_output
- A.10 export_source
- A.11 export_class
- A.12 export_resource
- A.13 loadjava
- A.14 dropjava
- A.15 grant_permission
- A.16 grant_permission
- A.17 restrict_permission
- A.18 restrict_permission
- A.19 grant_policy_permission
- A.20 grant_policy_permission
- A.21 revoke_permission
- A.22 disable_permission
- A.23 enable_permission
- A.24 delete_permission
- A.25 set_preference
- A.26 runjava
- A.27 runjava_in_current_session
- A.28 set_property
- A.29 get_property
- A.30 remove_property
- A.31 show_property
- A.32 set_output_to_sql
- A.33 remove_output_to_sql
- A.34 enable_output_to_sql
- A.35 disable_output_to_sql
- A.36 query_output_to_sql
- A.37 set_output_to_java
- A.38 remove_output_to_java
- A.39 enable_output_to_java
- A.40 disable_output_to_java
- A.41 query_output_to_java
- A.42 set_output_to_file
- A.43 remove_output_to_file
- A.44 enable_output_to_file
- A.45 disable_output_to_file
- A.46 query_output_to_file
- A.47 enable_output_to_trc
- A.48 disable_output_to_trc
- A.49 query_output_to_trc
- A.50 endsession
- A.51 endsession_and_related_state
- A.52 set_native_compiler_option
- A.53 unset_native_compiler_option
- A.54 compile_class
- A.55 uncompile_class
- A.56 compile_method
- A.57 uncompile_method
- A.58 start_jmx_agent
- A.59 set_runtime_exec_credentials
B DBMS_JAVASCRIPT Package
- B.1 DBMS_JAVASCRIPT Overview
  - B.1.1 The RUN Procedure
- B.2 DBMS_JAVASCRIPT Security Model
C Classpath Extensions and User Classloaded Metadata
- C.1 Classpath Extensions
- C.2 User Classloaded Metadata
Index

Search

Print

Download

PDF for offline and print

2 Java Applications on Oracle Database

Oracle Database runs standard Java applications. However, the Java-integrated Oracle Database environment is different from a typical Java development environment. This chapter describes the basic differences for writing, installing, and deploying Java applications within Oracle Database in the following sections: