Index

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

A

Accelerator

deploync tool, 10.1.7

for user applications, 10.1.3

installation requirements, 10.1.3.1

ncomp tool, 10.1.5

overview, 10.1, 10.1.1

statusnc tool, 10.1.8

act method, 2.11.1.1

ALREADY_NCOMPED status, 10.1.8

application

compiling, 2.5

developing, 8

development, 2.1

executing in a session, 2.2

execution control, 2.3

execution rights, 2.5.4

invoking, 3.2, 3.4

threading, 2.10

attributes, 5.1.3, 6.5

declaring, 6.5.1, 6.5.1

definition, 1.3.1.1

types of, 1.3.1.2

authentication, 9.1

AUTHID clause, 6.3, 6.4, 6.5

B

BasicPermission, 9.2.2.3.1

body

package, 6.4

SQL object type, 6.5

bytecode

defined, 1.3.5

definition, 1.7.2

verification, 2.5.2.2

C

call

definition, 2.1

managing resources across calls, 2.11.2

static fields, 2.2

call specification, 3.2.1, 3.2.1

call specifications--see call specs

call specs, 5.1

basic requirements for defining, 6.2

definition, 5.4

example, 5.4

understanding, 6.1

writing object type, 6.5

writing packaged, 6.4

writing top-level, 6.3

Callback class

act method, 2.11.1.1

class

attributes, 1.3.1.1, 1.3.1.3

definition, 1.3.1.1

dynamic loading, 1.5.5

execution, 2.1

hierarchy, 1.3.1.3

inheritance, 1.3.1.3, 1.3.3

loader, 1.7.4

loading, 2.1, 2.3, 2.5.3, 3.1

marking valid, 2.5.2

methods, 1.3.1.1, 1.3.1.3

name, 2.7

protected, 9.2.4

publish, 2.1, 2.5.7, 3.1

resolving references, 2.5.2, 3.1

schema object, 2.4, 2.5.2, 2.5.3, 2.5.3

.class files, 2.4, 2.5.3, 2.5.3

Class interface

forName method, 2.8

class schema object, 11.1, 11.3

ClassForName class

lookupClass method, 2.8.3

classForNameAndSchema method, 2.8.2

ClassNotFoundException, 2.8

CLASSPATH, 2.4, 2.8

client

setup, 4.4

code

native compilation, 10.1, 12.1

CodeSource class, 9.2.1

equals method, 9.2.1

implies method, 9.2.1

compiling, 1.7.2, 2.5

error messages, 2.5.1.2, 11.5

options, 2.5.1.4, 11.5

runtime, 2.5.1

configuration, 4

JVM, 4.2

performance, 10.2

connection

security, 9.1

constructor methods, 6.5.2.2

contexts, stored procedure run-time, 5.1

CREATE JAVA statement, 5.4

D

data confidentiality, 9.1

database

configuration, 4.2

privileges, 9.2

schema plan, 8.2, 8.2

triggers, 5.1.2, 7.2

database triggers

calling Java from, 7.2

datatypes

mapping, 6.2.2

DBA_JAVA_POLICY view, 9.2.2, 9.2.2.4, 9.2.2.5.1

DBMS_JAVA package, 4.3, 7.1.1

defined, 9.2.1

delete_permission method, 9.2.2.4, A

disable_permission method, 9.2.2.4, A

dropjava method, A

enable_permission method, 9.2.2.4, A

get_compiler_option method, A

grant_permission method, 9.2.2.1, 9.2.2.1, A

grant_policy_permission method, 9.2.2.2, 9.2.2.5.1, A

loadjava method, A

longname method, 2.5.6.1, 2.7, 4.3

modifying permissions, 9.2.2.5

modifying PolicyTable permissions, 9.2.2.1, 9.2.2.2

reset_compiler_option method, A

restart_debugging method, A

restrict_permission method, 9.2.2.1, 9.2.2.1, A

revoke_permission method, 9.2.2.4, A

set_compiler_option method, A

set_output method, 3.5, A

setting permissions, 9.2.2

shortname method, 2.5.6.1, 2.7, 4.3

start_debugging method, A

stop_debugging method, A

DBMS_OUTPUT package, A

DbmsJava class, see DBMS_JAVA package

DbmsObjectInputStream class, 2.8.4

DbmsObjectOutputStream class, 2.8.4

deadlock, 2.10

DeadlockError exception, 2.10

debug

compiler option, 2.5.1.4.1, 11.5

stored procedures, 5.4

debugging, 9.2.3, A

Java applications, 3.3

necessary permissions, 9.2.3

definer rights, 2.5.5

delete method, 9.2.2.4

delete_permission method, 9.2.2.4, A

deploync tool, 10.1.7

DETERMINISTIC hint, 6.3

digest table, 11.4, 11.4

disable method, 9.2.2.4

disable_permission method, 9.2.2.4, A

dropjava

method, A

tool, 2.5.3

dropjava tool, 11.7

E

ease of use, 5.2.2

enable method, 9.2.2.4

enable_permission method, 9.2.2.4, A

encoding

compiler option, 2.5.1.4.1, 11.5

end-of-call migration, 2.11.1

EndOfCallRegistry class, 2.11.1

registerCallback method, 2.11.1.1

endSession method, 2.10.1

entity-relationship (E-R) diagram, drawing an, 8.1

equals method, 9.2.1

errors

compilation, 2.5.1.2

exception

ClassNotFoundException, 2.8

DeadlockError, 2.10

IOException, 2.11.2

LimboError, 2.10

ThreadDeathException, 2.10.1

exceptions, how handled, 7.6

execution rights, 2.5.4

exit command, 11.8.4.2

exitCall method, 2.10.1

F

file names

dropjava, 11.7.3

loadjava, 11.6.3

FilePermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6, 9.2.2.6, 10.1.3.1

files, 2.9.1

across calls, 2.9.2

lifetime, 2.11.2

finalizers, 2.9.2

footprint, 1.5.3, 2.2

foreign key, 8.2

forName method, 2.8

full name, Java, 2.4.1

functions, 5.1.1

G

garbage collection, 1.5.1, 1.5.2, 2.2

managing resources, 2.9

misuse, 2.9.2

purpose, 2.9.2

get_compiler_option method, 2.5.1.4.3, 11.5, A

getCallerClass method, 2.8.1

getClassLoader method, 2.8.1

getProperty method, 3.4

grant method, 9.2.2.1

grant_permission method, 9.2.2.1, 9.2.2.1, A

grant_policy_permission method, 9.2.2.2, 9.2.2.5.1, A

granting permission, 9.2.1, 9.2.1

grantPolicyPermission method, 9.2.2.2

Graphical User Interface--see GUI

GUI, 1.6.2, 2.6

H

help command, 11.8.4.3

I

IDE (integrated development environment), 1.6.3

implies method, 9.2.1

inheritance, 1.3.1.3, 1.3.3

installation, 4, 4.1

integrity, 9.1

interfaces

defined, 1.3.3

user, 2.6

interoperability, 5.2.5

interpreter, 1.7.3

INVALID status, 10.1.8

invoker rights, 2.5.5

advantages, 2.5.5

IOException, 2.11.2

J

Java

applications, 2, 2.5

loading, 2.5.3

attributes, 1.3.1.1

calling from database triggers, 7.2

calling from PL/SQL, 7.4

calling from SQL DML, 7.3

calling from the top level, 7.1

calling restrictions, 7.3.1

class, 1.3.1.1

client

setup, 4.4

compiling, 2.5

development environment, 2.4

differences from Sun JDK, 2.1

documentation, 1.1

execution control, 2.3

execution rights, 2.5.4

features, 1.3.6

full name, 2.4.1

in the database, 1.1, 1.4, 2, 2.1

interpreter, 2.1

introduction, Preface

invoking, 2.1, 3.2

loading classes, 2.3, 3.1

checking results, 2.5.6

methods, 1.3.1.1

natively compiling, 10.1

Oracle database execution, 5.1

overview, 1.1, 1.3

permissions, A

polymorphism, 1.3.3

programming models, Preface

publishing, 2.3

resolving classes, 2.5.2

resources, 1.3.1

short name, 2.4.1

stored procedures, see Java stored procedures

Java 2

migrating from JDK 1.1, 1.2.1

security, 9.2

java command, 11.8.4.4

Java Compatibility Kit, see JCK

.java files, 2.4, 2.5.3, 2.5.3

java interpreter, 2.1, 2.3

Java language specification, see JLS

Java Native Interface, see JNI

Java stored procedures, Preface, 2.2.1

calling, 7, 7

configuring, 5.3

defined, 1.8.1, 1.8.2, 3.2.1, 5.4

developing, 8

introduction to, 5

invoking, 3.1

loading, 2, 5.4

publishing, 2.5.7, 6

Java virtual machine, see JVM

JAVA$OPTIONS table, 2.5.1.4, 11.5

JAVA_ADMIN role

assigned permissions, 9.2.2.6

example, 9.2.2.2

granting permission, 9.2, 9.2.1, 9.2.2.2, 9.2.2.5.1

JAVA_DEPLOY role, 10.1.3.1

JAVA_MAX_SESSIONSPACE_SIZE parameter, 10.2.1

JAVA_POOL_SIZE parameter

default, 4.2

defined, 10.2.1, 10.2.2

JAVA_SOFT_SESSIONSPACE_LIMIT parameter, 10.2.1

JAVADEBUGPRIV role, 9.2.2.6, 9.2.2.7, 9.2.3

JAVASYSPRIV role, 9.2.1, 9.2.2.6, 9.2.2.7

JAVAUSERPRIV role, 9.2.1, 9.2.2.6, 9.2.2.7

JCK, 1.3.5

JDBC

accessing SQL, 1.8.3

defined, 1.8.1, 3.1, 3.1, 3.2.3, 3.2.3

driver types, 1.8.3.1, 3.2.3.1

example, 3.2.4

security, 9.1

JDBC driver--see server-side JDBC driver

JDeveloper

development environment, 1.8.4, 4.4.3

JLS

specification, 1.3.5

JNI support, 3.2.2

JServerPermission, 9.2.2.1, 9.2.2.5, 9.2.2.5, 9.2.2.6, 9.2.2.6, 9.2.2.6, 9.2.2.6

defined, 9.2.2.5.2

JVM

bytecodes, 1.3.5

configure, 4

defined, 1.3, 1.3.5

garbage collection, 1.5.1, 1.5.2

install, 4, 4.1

multithreading, 1.5.1

responsibilities, 2.2

security, A

specification, 1.3.5

K

key

foreign, 8.2

primary, 8.2

L

library manager, 1.7.1

LimboError exception, 2.10

loader, class, 1.7.4

loading, 2.5.3

checking results, 2.5.3, 2.5.6

class, 1.5.5, 2.3, 2.5

compilation option, 2.5.1

granting execution, 2.5.4

JAR or ZIP files, 2.5.3.3

necessary privileges and permissions, 2.5.3.2

reloading classes, 2.5.3.3

restrictions, 2.5.3.1

loadjava method, A

loadjava tool, 2.5.3, 11.6

compiling source, 2.5.1, 10.2.4

example, 3.2.1, 5.4

execution rights, 2.5.4, 9.2

loading class, 2.5.3

loading ZIP or JAR files, 2.5.3.3

restrictions, 2.5.3.1

using memory, 10.2.1

logging, 2.5.1.2

longname method, 2.5.6.1, 2.7, 4.3

lookupClass method, 2.8.3

M

main method, 1.6.1, 2.3

maintainability, 5.2.4

manager

library, 1.7.1

map methods, 6.5.2.1

memory

across calls, 2.9.2

call, 2.2

java pool, 10.2.3

leaks, 2.9.2

lifetime, 2.9.1, 2.11.2

manager, 2.4

performance configuration, 10.2

session, 2.2, 2.11.1.1

methods, 1.3.1.1, 1.3.1.3, 5.1.3, 6.5

constructor, 6.5.2.2

declaring, 6.5.2, 6.5.2

map and order, 6.5.2.1

object-relational, 5.1.3

modes, parameter, 6.2.1

multithreading, 1.5.1

N

NAME clause, 6.3

namespace, 11.8

native compilation, 1.5.4, 10.1, 12.1

Accelerator, 10.1

classes loaded in database, 10.1.6.1

classes not loaded in database, 10.1.6.2

compile subset, 10.1.6.5

deploync tool, 10.1.7

designating build directory, 10.1.6.4

errors, 10.1.5.4

execution time, 10.1.5

force recompile, 10.1.6.3

ncomp tool, 10.1.5

scenarios, 10.1.6

statusnc tool, 10.1.8

ncomp tool, 10.1.3, 10.1.5

executing, 10.1.4

security, 10.1.3.1

NEED_NCOMPING status, 10.1.8

NEED_NCOMPING status message, 10.1.5.4

NetPermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6

O

object

full to short name conversion, 2.5.6.1

lifetime, 2.11.2

schema, 2.4

serialization, 2.8.4

short name, 2.5.6.1, 2.5.6.1

SQL type, 5.1.3

table, 6.5.2.2

type

call specs, writing, 6.5

ObjectInputStream class, 2.8.4

ObjectOutputStream class, 2.8.4

object-relational methods, 5.1.3

ojvmjava tool, 11.8

online

compiler option, 2.5.1.4.1

operating system

resources, 2.9, 2.9.1

across calls, 2.11.2

lifetime, 2.9.1.2

performance, 10.2

Oracle Net Services Connection Manager, 1.5

OracleRuntime class

exitCall method, 2.10.1

getCallerClass method, 2.8.1

getClassLoader method, 2.8.1

order methods, 6.5.2.1

output

redirecting, 3.5

output, redirecting, 7.1.1

P

package DBMS_JAVA, 7.1.1

packaged call specs, writing, 6.4

packages

DBMS_JAVA, 4.3

protected, 9.2.4

PARALLEL_ENABLE option, 6.3

parameter modes, 6.2.1

performance, 1.5.4, 5.2.1, 10

Permission class, 9.2.2.1, 9.2.2.2, 9.2.2.3.1, 9.2.2.5

permissions, 9.2, A

administrating, 9.2.2.2

assigning, 9.2.1, 9.2.2

creating, 9.2.2.3

deleting, 9.2.2.4

disabling, 9.2.2.4

enabling, 9.2.2.4

FilePermission, 10.1.3.1

granting, 9.2.1, 9.2.2.1, 9.2.2.1

granting policy, 9.2.2.2, 9.2.2.2

grouped into roles, 9.2.2.7

JAVA_ADMIN role, 9.2.2.6

JAVA_DEPLOY role, 10.1.3.1

JAVADEBUGPRIV role, 9.2.2.6

JAVASYSPRIV role, 9.2.2.6

JAVAUSERPRIV role, 9.2.2.6

PUBLIC, 9.2.2.6

restricting, 9.2.1, 9.2.2.1, 9.2.2.1

specifying policy, 9.2.1

SYS permissions, 9.2.2.6

types, 9.2.2.1, 9.2.2.5

PL/SQL

calling Java from, 7.4

packages, 6.4

policy table

managing, 9.2.2.2

modifying, 9.2.2

setting permissions, 9.2.2

viewing, 9.2.2

PolicyTable class

specifying policy, 9.2.1

updating, 9.2.1, 9.2.2.3.2

PolicyTableManager class

delete method, 9.2.2.4

disable method, 9.2.2.4

enable method, 9.2.2.4

revoke method, 9.2.2.4

PolicyTablePermission, 9.2.2.1, 9.2.2.2, 9.2.2.5, 9.2.2.5, 9.2.2.6, 9.2.2.6, 9.2.2.6

polymorphism, 1.3.3

primary key, 8.2

privileges

database, 9.2

procedures, 5.1.1

advantages of stored, 5.2

productivity, 5.2.2

.properties files, 2.4, 2.5.3, 2.5.3

PropertyPermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6, 9.2.2.6, 9.2.2.7

PUBLIC permissions, 9.2.2.6

publishing, 2.3, 2.5, 2.5.7, 3.1

example, 3.2.1, 5.4

purity rules, 7.3.1

R

redirecting output, 7.1.1

ref, 6.5.2.2

ReflectPermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6

registerCallback method, 2.11.1.1

replication, 5.2.6

reset_compiler_option method, 2.5.1.4.3, 11.5, A

resolver, 2.5.2, 11.3, 11.3

default, 2.5.2

defined, 2.4, 2.5, 2.5.2, 2.8, 3.1

example, 3.2.1, 5.4

ignoring non-existent references, 2.5.2, 2.5.2.2

resource schema object, 2.4, 2.5.3, 2.5.3, 11.1

restart_debugging method, A

restrict method, 9.2.2.1

restrict_permission method, 9.2.2.1, 9.2.2.1, A

revoke method, 9.2.2.4

revoke_permission method, 9.2.2.4, A

row trigger, 7.2

rules, purity, 7.3.1

run-time contexts, stored procedure, 5.1

RuntimePermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6, 9.2.2.6, 9.2.2.6, 9.2.2.6

S

scalability, 5.2.3

schema object, 11.1

defined, 2.5.3

name, 2.7

names, maximum length, 2.4.1

using, 2.4

security, 5.2.7, 9

book recommendations, 9.2.1

Java 2, 9.2.1

JDBC, 9.1

JVM, A

network, 9.1

SecurityManager class, 9.2.1

SecurityPermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6

.ser files, 2.4, 2.5.3, 2.5.3

SerializablePermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6

serialization, 2.8.4

server-side JDBC driver, 1.7.6

using, 6.2.3

ServerSocket class, 2.11.2.2

sess_sh

commands in a script file, 11.8.3.2

redirecting output, 11.8.3.1

session

coordination with JVM, 2.2

definition, 2.1

footprint, 1.5.3

namespace, 11.8

role in Java execution, 2.2

set_compiler_option method, 2.5.1.4.3, 11.5, A

set_output method, 3.5, A

shared server, 5.2.3

SHARED_POOL_SIZE parameter

default, 4.2

defined, 10.2.1

short name, Java, 2.4.1

shortname method, 2.5.6.1, 2.7, 4.3

side effects

controlling, 7.3.1

Socket class, 2.11.2.2

SocketPermission, 9.2.2.1, 9.2.2.5, 9.2.2.6, 9.2.2.6, 9.2.2.6, 9.2.2.6

sockets

across calls, 2.9.1, 2.11.2.2

defined, 2.11.2.2

lifetime, 2.11.2, 2.11.2.2

source schema object, 2.4, 2.5.3, 2.5.3, 11.1, 11.5

spec

package, 6.4

SQL object type, 6.5

SQL

DML, calling Java from, 7.3

object type, 5.1.3, 6.5

query, 3.1, 3.1, 3.2.3

SQLJ

accessing SQL, 1.8.3

defined, Preface, 1.8.1, 3.1, 3.1, 3.2.3

.sqlj files, 2.4, 2.5.3, 2.5.3

start_debugging method, A

statement trigger, 7.2

static variable, 2.2

end of call migration, 2.11.1

statusnc tool, 10.1.8

stop_debugging method, A

stored procedures

advantages of, 5.2

calling, 7

developing, 5.4, 8

introduction to, 5

loading, 2, 5.4

publishing, 6

SYS

assigned permissions, 9.2.2.6

security permissions, 9.2.2.5

System class

getProperty method, 3.4

T

ThreadDeathException, 2.10.1

threading, 2.9.1

applications, 2.10

lifecycle, 2.10

model, 1.5.1, 2.10

top-level call specs, writing, 6.3

trigger

database, 5.1.2, 7.2

row, 7.2

statement, 7.2

using Java stored procedures, 3.2.1, 5.4

U

user interface, 2.6

USER_ERRORS view, 2.5.1.2

USER_JAVA_POLICY view, 9.2.2, 9.2.2.5.1

USER_OBJECTS view, 2.5.3, 2.5.6, A

V

V$SGASTAT table, 10.2.3

variables

static, 2.2

verifier, 1.7.5

version

retrieving, 3.4

W

Web services

support for call-ins to database, 12.2.1