Index

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

Index

Symbols A B C D E F G H I J K L M N O P R S T U V W

Symbols

.class files 2.3, 2.5.4
.java files 2.3, 2.5.4
.properties files 2.3
.ser files 2.3
.sqlj files 2.3, 2.5.4

A

act method 2.13.2
application
- compiling 2.5.1
- developing 9
- development 2.1
- executing in a session 2.1
- execution control 2.2
- execution rights 2.5.5
- invoking 3.1
- running on the server 3.2
- threading 2.12
attributes 6.1.3, 7.5
- declaring 7.5.1
authentication 11.1
- mechanisms 11.3
AUTHID clause 7.3, 7.4, 7.5

B

BasicPermission 11.2.2.1.3
body
- package 7.4
- SQL object type 7.5
bytecode
- defined 1.1.3
- definition 1.5.2
- verifier 2.5.2.2

C

call
- definition 1.3
- managing resources across calls 2.13.7
Callback class
- act method 2.13.2
call memory 2.1
call specification 3.1.1, 7.1
- defining 7.2
- mapping data types 7.2.2
- object type 7.5
- packaged 7.4
- top-level 7.3
calss
- loader 1.5.4
class
- auditing 2.5.9
- definition 1.1.1.1
- dynamic loading 1.2.6
- execution 2.2
- fields 1.1.1.1
- hierarchy 1.1.4
- inheritance 1.1.4
- interpretation 2.2
- loading 2.2, 2.5.4
- loading permission 11.2.4
- marking valid 2.5.2
- methods 1.1.1.1
- name 2.7
- publish 2.5.8, 7
- resolving dependencies 2.5.2
- resolving reference 2.5.2
- schema object 2.3, 2.5.2, 2.5.4
- shortened name 2.7
- single inheritance 1.1.1.4
ClassForName
- lookupClass method 2.8.3
classForNameAndSchema method 2.8.2
Class interface
- forName method 2.8
class schema object 2.5.4, 13.1, 13.3
client
- install JDK 4.4.1
- setup 4.4.1
- set up environment variables 4.4.2
compiling 1.5.2, 2.5
- error messages 2.5.1.2, 13.4
- options 2.5.1.4, 13.4
- run time 2.5.1, 2.5.1.3
configuration 4
- JVM 4.2
- performance 10.2
connection
- security 11.1
constructor methods 7.5.2.2
context
- run-time 6.1
- stored procedures 6.1
CREATE JAVA statement 6.3

D

database
- privileges 11.2
- schema plan 9.1
- trigger 8.2
- triggers 6.1.2
database triggers
- calling Java 8.2
data confidentiality 11.1
data types
- mapping 7.2.2
DBA_JAVA_POLICY view 11.2.2.1.4
DBMS_JAVA package 4.3, 8.1.1
- compile_class A.54
- compile_method A.56
- delete_permission method 11.2.2.1.4, A.24
- derivedFrom method A.7
- disable_output_to_file A.45
- disable_output_to_java A.40
- disable_output_to_sql A.35
- disable_output_to_trc A.48
- disable_permission method 11.2.2.1.4, A.22
- dropjava method A.14
- enable_output_to_file A.44
- enable_output_to_java A.39
- enable_output_to_sql A.34
- enable_output_to_trc A.47
- enable_permission method 11.2.2.1.4, A.23
- endsession A.50
- endsession_and_related_state A.51
- export_class method A.11
- export_resource method A.12
- export_source method A.10
- fixed_in_instance method A.8
- get_compiler_option method A.3
- get property A.29
- grant_permission method 11.2.2.1.1, A.15, A.16
- grant_policy_permission method 11.2.2.1.2, 11.2.2.1.3, A.19, A.20
- loadjava method A.13
- longname method 2.5.7, 2.7, A.1
- modifying permissions 11.2.2.1.4
- modifying PolicyTable permissions 11.2.2.1.1, 11.2.2.1.2
- query_output_to_file A.46
- query_output_to_sql A.36
- query_output_to_trc A.49
- remove_output_to_file A.43
- remove_output_to_java A.38
- remove_output_to_sql A.33
- remove property A.30
- reset_compiler_option method A.5
- resolver method A.6
- restrict_permission method 11.2.2.1.1, A.17, A.18
- revoke_permission method 11.2.2.1.4, A.21
- runjava A.26
- runjava_in_current_session A.27
- set_compiler_option method A.4
- set_native_compiler_option A.52
- set_output_to_file A.42
- set_output_to_java A.37
- set_output_to_sql A.32
- set_output method A.9
- set_preference method A.25
- set property A.28
- setting permissions 11.2.2
- shortname method 2.5.7, 2.7, A.2
- show property A.31
- start_jmx_agent A.58
- uncompile_class A.55
- uncompile_method A.57
- unset_native_compiler_option A.53
DBMS_JAVA query_output_to_java A.41
DBMS_OUTPUT package A.9
DbmsJava class see DBMS_JAVA package 4.3
deadlock 2.12
DeadlockError exception 2.12
debugging
- Java stored procedures 6.4
- permissions 11.2.3
default java.security resource 11.2.5
definer rights 2.5.6
delete_permission method A.24
delete method 11.2.2.1.4
derivedFrom method A.7
DETERMINISTIC hint 7.3
Directory Context 12.2.2.1
disable_permission method A.22
disable method 11.2.2.1.4
dropjava method A.14
dropjava tool 2.5.4, 13.7

E

ease of use 6.2.2
echo command 13.8.4.2
enable_permission method A.23
enable method 11.2.2.1.4
encapsulation 1.1.1.5
end-of-call Migration 2.13.1
EndOfCallRegistry class
- registerCallback method 2.13.2
errors
- compilation 2.5.1.2
exception
- DeadlockError 2.12
- how Oracle JVM handles 8.6
- LimboError 2.12
exitCall method 2.12.1
exit command 13.8.4.2
export_class method A.11
export_resource method A.12
export_source method A.10

F

fields
- definition 1.1.1.1
- types of 1.1.1.1
file names
- dropjava tool 13.7.3
- loadjava tool 13.6.3
files 2.9.1
- lifetime 2.13.7
finalizers 2.9.2
fixed_in_instance method A.8
footprint 1.2.4, 2.1
foreign key 9.1
forName method 2.8
full name, Java 2.4
functions 6.1.1

G

garbage collection 2.1
- managing resources 2.9
- misuse 2.9.2
garbage collectoion
- purpose 2.9.2
get_compiler_option method 2.5.1.4.3, A.3
grant_permission method 11.2.2.1.1, A.15, A.16
grant_policy_permission method 11.2.2.1.2, A.19, A.20
granting permissions 11.2.1
grant method 11.2.2.1.1
grantPolicyPermission method 11.2.2.1.2
graphical user interface see GUI 1.3.3
GUI 1.3.3, 2.6

H

help command 13.8.4.2

I

inheritance 1.1.1.3, 1.1.1.4
installation 4
integrated development environment (IDE) 1.3.4
integrity 11.1
interface 1.1.1.4
internal JDBC driver 1.5.6
interoperability 6.2.5
interpreter 1.5.3

J

J2SE
- install 4.4.1
Java
- applications 2, 2.5.4
- calling from database triggers 8.2
- calling from PL/SQL 8.4
- calling from SQL DML 8.3
- calling from the top level 8.1
- calling restrictions 8.3
- checking loaded classes 2.5.7
- classes 1.1.1.1
- client setup 4.4
- compiling 2.5.1
- development environment 2.3
- development tools 1.6.5
- execution control 2.2
- execution in database 6.1
- execution rights 2.5.5
- fields 1.1.1.1
- full name 2.4
- in the database 1.2, 2
- invoking 3.1
- key features 1.1.2
- loading applications 2.5.4
- loading classes 2.2
- methods 1.1.1.1
- overview 1.1
- polymorphism 1.1.1.6
- publishing 2.3, 7
- resolving classes 2.5.2
- short name 2.4
- stored procedures see stored procedures 8
JAVA_ADMIN
- granting permission 11.2, 11.2.1, 11.2.2.1.2, 11.2.2.1.5
JAVA_ADMIN example 11.2.2.1.2
java_jit_enabled 10.1.1
JAVA_SOFT_SESSIONSPACE_LIMIT parameter 10.2.1
JAVA$OPTIONS table 2.5.1.4
Java2
- security 11.2
Java2 Platform, Standard Edition see Java SE 4.4.1
Java audit
- object level 2.5.9
- statement level 2.5.9
java command 13.8.4.2
Java Compatibility Kit see JCK 1.1.3
Java Database Connectivity see JDBC 1.1.2
JAVADEBUGPRIV role 11.2.2.1.6
Java Development Kit see JDK 4.4.1
java interpreter 2.2
Java Language Specification see JLS 1.1.1.1
Java Naming and Directory Interface see JNDI 1.1.2
Java Native Interface see JNI 3.1.2
Java session initialization, duration and entrypoints 1.3.2
Java stored procedures see stored procedures 8
JAVASYSPRIV role 11.2.2.1.6
JAVAUSERPRIV role 11.2.2.1.6
Java virtual machine see JVM 1.1.3
JCK 1.1.3
JDBC 1.1.2, 10.1
- accessing SQL 1.6.4
- defined 3.1.3
- driver 1.5
- drivers 1.6.4.1
- driver types 1.6.4.1, 3.1.3.1
- example 3.1.3.3
- security 11.1
- server-side internal driver 1.5.6
JDeveloper
- development environment 1.6.5
JDK
- install 4.4.1
JIT
- advantages 10.1.2
- overview 10.1.1
JLS 1.1.1.1, 1.1.3
JNDI 1.1.2
JNDI support
- overview 12.1
- requirements 12.2
  - Namespace 12.2.1
  - namespace browser 12.2.3
  - Oracle Java Directory Service JNDI Name Space Provider 12.2.2
JNI
- support 3.1.2
Just-in-Time Compiler see JIT 10.1
JVM 1.1.3
- bytecode 1.1.3
- configure 4
- defined 1.1
- garbage collection 1.2.2, 1.2.3
- install 4
- multithreading 1.2.2
- responsibilities 2.1

K

key
- foreign 9.1
- primary 9.1

L

library manager 1.5.1
LimboError exception 2.12
loader, class 1.5.4
loading 2.5.4
- checking results 2.5.4, 2.5.7
- class 1.2.6, 2.2, 2.5, 2.5.4
- compilation option 2.5.1
- granting execution 2.5.5
- reloading classes 2.5.4.4
- restrictions 2.5.4.2
loadjava method A.13
loadjava tool
- compiling source 2.5.1.4, 10.2.4
- example 3.1.1, 6.3.2
- execution rights 2.5.5, 11.2
- loading class 2.5.4
- resolution modes 13.3
- using memory 10.2.1
logging 2.5.3
LogManager 2.5.3
longname method 2.7, A.1
lookupClass method 2.8.3

M

main method 2.2
maintainability 6.2.4
map methods 7.5.2.1
memory
- across calls 2.9.2
- call 2.1
- Java pool 10.2.2
- leaks 2.9.2
- lifetime 2.9.1, 2.13.7
- performance configuration 10.2
- session 2.1
methods 1.1.1.1, 6.1.3, 7.5
- constructor 7.5.2.2
- declaring 7.5.2
- map and order 7.5.2.1
- object-relational 6.1.3
missing classes 13.6.2
modes
- parameter 7.2.1
multiple inheritance 1.1.1.4
multithreading 1.2.2

N

NAME clause 7.3
namespace 13.8
native compilation
- methods 1.2.5
- performance 1.2.5
native Java interface 3.1.5

O

object 1.1.1.2
- full to short name conversion 2.5.7
- lifetime 2.13.7
- schema 2.3
- serialization 2.8.4
- SQL type 6.1.3
- table 7.5.2.3
- writing call specifications 7.5
ObjectFactories 12.2.2.3
object-relational methods 6.1.3
OJDS 12.1
- APIs and classes 12.4
- command-line tools 12.3
  - bind 12.3.10
  - bindds 12.3.11
  - bindurl 12.3.12
  - cd 12.3.2
  - chmod 12.3.9
  - chown 12.3.4
  - ln 12.3.7
  - ls 12.3.1
  - mkdir 12.3.5
  - mv 12.3.8
  - pwd 12.3.3
  - rm 12.3.6
OJDS URL Support 12.2.2.4
ojvmjava tool
operating system
- resources 2.9
operating system resources
- access 2.9.1
- across calls 2.13.7
- closing 2.9.2
- garbage collection 2.9.2
- lifetime 2.9.1
- managing 2.9
- overview 2.9.1
- performance 10.2
oracle.aurora.jndi.ojds.OjdsClientContext 12.4.1
oracle.aurora.jndi.ojds.OjdsInitialContextFactory 12.4.3
oracle.aurora.jndi.ojds.OjdsServerContext 12.4.2
oracle.aurora.jndi.ojds.OjdsURLContext 12.4.5
oracle.aurora.jndi.ojds.OjdsURLContextFactory 12.4.4
Oracle Java Directory Service 12.1
Oracle JVM
- class loader 1.5.4
- compiler 1.5.2
- configuration requirements 4.2
- interpreter 1.5.3
- JDBC internal driver 1.5.5, 1.5.6
- library manager 1.5.1
- main components 1.5
- SQLJ translator 1.5.7
- verifier 1.5.5
Oracle Net Services Connection Manager 1.2.1
order methods 7.5.2.1
output
- redirecting 3.3, 8.1.1

P

package DBMS_JAVA 4.3, 8.1.1
packaged call specifications, writing 7.4
PARALLEL_ENABLE option 7.3
parameter modes 7.2.1
performance 6.2.1, 10
- native compilation 1.2.5
permission
- Oracle-specific 11.2.2.1.5
- types 11.2.2.1.4
Permission class 11.2.2, 11.2.2.1, 11.2.2.1.2
permissions
- administrating 11.2.2.1.2
- assigning 11.2.1, 11.2.2
- debugging 11.2.3
- deleting 11.2.2.1.4
- granting 11.2.1, 11.2.2.1.1
- granting, example 11.2.2.1.1
- granting policy 11.2.2.1.2
- grouped into roles 11.2.2.2
- JAVADEBUGPRIV role 11.2.2.1.6
- JAVASYSPRIV role 11.2.2.1.6
- JAVAUSERPRIV role 11.2.2.1.6
- limiting 11.2.1, 11.2.2.1.1
- limiting, example 11.2.2.1.1
- PUBLIC 11.2.2.1.6
- restricting 11.2.1, 11.2.2.1.1
- restricting, example 11.2.2.1.1
- specifying policy 11.2.1
- SYS permission 11.2.2.1.6
- types 11.2.2.1.5
PL/SQL
- calling Java from 8.4
- packages 7.4
policy table
- managing 11.2.2.1.2
- modifying 11.2.2
- setting permissions 11.2.2
- viewing 11.2.2
PolicyTable class
- updating 11.2.1
PolicyTableManager class
- delete method 11.2.2.1.4
- disable method 11.2.2.1.4
- enable method 11.2.2.1.4
polymorphism 1.1.1.6
primary key 9.1
privileges
- database 11.2
procedures 6.1.1
productivity 6.2.2
PUBLIC permissions 11.2.2.1.6
publishing 2.2, 2.5, 2.5.8
- example 3.1.1, 6.3.3

R

redirecting output 3.3, 8.1.1
registerCallback method 2.13.2
replication 6.2.6
reset_compiler_option method 2.5.1.4.3, A.5
resolver 2.5.2, 13.3
- default 2.5.2
- defined 2.3, 2.5, 2.8
- example 3.1.1, 6.3.2
- ignoring non-existent references 2.5.2, 2.5.2.2
resolver method A.6
resolver specification
- definition 2.5.2
resource schema object 2.5.4, 13.1
restrict_permission method 11.2.2.1.1, A.17, A.18
restrict method 11.2.2.1.1
revoke_permission method 11.2.2.1.4, A.21
revoke method 11.2.2.1.4
row trigger 8.2
Runtime.exec 2.10
run-time contexts, stored procedures 6.1

S

scalability 6.2.3
scavenging 1.2.3
security 6.2.7
session 1.3
- namespace 13.8
session memory 2.1
set_compiler_option method 2.5.1.4.3, A.4
set_output method A.9
set_preference method A.25
SHARED_POOL_SIZE parameter 10.2.1
shell commands 13.8.4.2
short name, Java 2.4
shortname method A.2
single inheritance 1.1.1.3
source schema object 2.5.4, 13.1
SQLJ
- server-side translator 1.5.7
- tarnslator 1.5.7
start_jmx_agent A.58
StateFactories 12.2.2.2
statement trigger 8.2
stored procedures
- advantages 6.2
- calling 8
- defined 1.6.2, 1.6.3
- developing 6, 9
- example 9
- introduction 6
- invoking 3.1
- publishing 7
- steps 6.3

T

threading
- model 1.2.2, 2.12
threads
- across calls 2.13.7
- Oracle JVM 2.9.1
- threading in Oracle Database 2.12
top-level call specifications, writing 7.3
triggers
- calling Java from 8.2
- database 6.1.2, 8.2
- row 8.2
- statement 8.2
- using Java stored procedures 3.1.1, 6.3

U

USER_JAVA_POLICY view 11.2.2.1.4
USER_OBJECTS
- accessing, example 2.5.7
user interface 2.6

V

V$SGASTAT table 10.2.3
variables
- static 2.1
verifier 1.5.5
version
- retrieving 3.2
version command 13.8.4.2

W

Web services
- call-outs from database 14.2.2
- Oracle Database features 14.2.3
- overview 14.1
- service consumer 14.2