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-15

for user applications, 10-5

installation requirements, 10-5

ncomp tool, 10-7

overview, 10-2, 10-3

statusnc tool, 10-17

act method, 2-38

ALREADY_NCOMPED status, 10-17

application

compiling, 2-9

developing, 8-1

development, 2-3

executing in a session, 2-3

execution control, 2-5

execution rights, 2-20

invoking, 3-2, 3-8

threading, 2-35

attributes, 5-4, 6-15

declaring, 6-16

definition, 1-6

types of, 1-7

authentication, 9-2

AUTHID clause, 6-8, 6-13, 6-16

B

BasicPermission, 9-14

body

package, 6-12

SQL object type, 6-15

bytecode

defined, 1-10

definition, 1-23

verification, 2-16

C

call

definition, 2-2

managing resources across calls, 2-42

static fields, 2-5

call specification, 3-4, 3-5

call specifications--see call specs

call specs, 5-2

basic requirements for defining, 6-3

definition, 5-11

example, 5-11

understanding, 6-2

writing object type, 6-15

writing packaged, 6-12

writing top-level, 6-8

Callback class

act method, 2-38

class

attributes, 1-6, 1-7

definition, 1-6

dynamic loading, 1-19

execution, 2-2

hierarchy, 1-7

inheritance, 1-7, 1-9

loader, 1-23

loading, 2-2, 2-5, 2-17, 3-2

marking valid, 2-14

methods, 1-6, 1-7

name, 2-26

protected, 9-26

publish, 2-2, 2-24, 3-2

resolving references, 2-13, 3-2

schema object, 2-6, 2-14, 2-17, 2-18

.class files, 2-7, 2-17, 2-18

Class interface

forName method, 2-27

class schema object, 11-2, 11-3

ClassForName class

lookupClass method, 2-30

classForNameAndSchema method, 2-29

ClassNotFoundException, 2-27

CLASSPATH, 2-6, 2-27

client

setup, 4-3

code

native compilation, 10-2, 12-2

CodeSource class, 9-5

equals method, 9-5

implies method, 9-5

compiling, 1-23, 2-9

error messages, 2-10, 11-5

options, 2-10, 11-5

runtime, 2-9

configuration, 4-1

JVM, 4-2

performance, 10-19

connection

security, 9-2

constructor methods, 6-17

contexts, stored procedure run-time, 5-2

CREATE JAVA statement, 5-7

D

data confidentiality, 9-2

database

configuration, 4-2

privileges, 9-2

schema plan, 8-4

triggers, 5-3, 7-5

database triggers

calling Java from, 7-5

datatypes

mapping, 6-4

DBA_JAVA_POLICY view, 9-6, 9-18, 9-20

DBMS_JAVA package, 4-3, 7-2

defined, 9-5

delete_permission method, 9-19, A-5

disable_permission method, 9-18, A-5

dropjava method, A-4

enable_permission method, 9-18, A-5

get_compiler_option method, A-1

grant_permission method, 9-8, 9-9, A-5

grant_policy_permission method, 9-12, 9-20, A-5

loadjava method, A-4

longname method, 2-23, 2-26, 4-3

modifying permissions, 9-19

modifying PolicyTable permissions, 9-9, 9-12

reset_compiler_option method, A-1

restart_debugging method, A-3

restrict_permission method, 9-9, 9-10, A-5

revoke_permission method, 9-18, A-5

set_compiler_option method, A-1

set_output method, 3-8, A-3

setting permissions, 9-5

shortname method, 2-23, 2-26, 4-3

start_debugging method, A-5

stop_debugging method, A-5

DBMS_OUTPUT package, A-3

DbmsJava class, see DBMS_JAVA package

DbmsObjectInputStream class, 2-30

DbmsObjectOutputStream class, 2-30

deadlock, 2-35

DeadlockError exception, 2-35

debug

compiler option, 2-11, 11-6

stored procedures, 5-9

debugging, 9-25, A-3

Java applications, 3-7

necessary permissions, 9-25

definer rights, 2-21

delete method, 9-19

delete_permission method, 9-19, A-5

deploync tool, 10-15

DETERMINISTIC hint, 6-8

digest table, 11-4, 11-5

disable method, 9-18

disable_permission method, 9-18, A-5

dropjava

method, A-4

tool, 2-18

dropjava tool, 11-22

E

ease of use, 5-5

enable method, 9-19

enable_permission method, 9-18, A-5

encoding

compiler option, 2-10, 11-6

end-of-call migration, 2-37

EndOfCallRegistry class, 2-37

registerCallback method, 2-38

endSession method, 2-36

entity-relationship (E-R) diagram, drawing an, 8-2

equals method, 9-5

errors

compilation, 2-10

exception

ClassNotFoundException, 2-27

DeadlockError, 2-35

IOException, 2-42

LimboError, 2-35

ThreadDeathException, 2-36

exceptions, how handled, 7-13

execution rights, 2-20

exit command, 11-31

exitCall method, 2-36

F

file names

dropjava, 11-25

loadjava, 11-16

FilePermission, 9-7, 9-19, 9-21, 9-23, 10-6

files, 2-32

across calls, 2-34

lifetime, 2-42

finalizers, 2-34

footprint, 1-17, 2-4

foreign key, 8-4

forName method, 2-27

full name, Java, 2-8

functions, 5-2

G

garbage collection, 1-15, 1-16, 2-5

managing resources, 2-32

misuse, 2-33

purpose, 2-33

get_compiler_option method, 2-11, 11-6, A-1

getCallerClass method, 2-28

getClassLoader method, 2-28

getProperty method, 3-8

grant method, 9-8

grant_permission method, 9-8, 9-9, A-5

grant_policy_permission method, 9-12, 9-20, A-5

granting permission, 9-5

grantPolicyPermission method, 9-13

Graphical User Interface--see GUI

GUI, 1-20, 2-25

H

help command, 11-31

I

IDE (integrated development environment), 1-21

implies method, 9-5

inheritance, 1-7, 1-9

installation, 4-1, 4-2

integrity, 9-2

interfaces

defined, 1-9

user, 2-25

interoperability, 5-5

interpreter, 1-23

INVALID status, 10-17

invoker rights, 2-21

advantages, 2-21

IOException, 2-42

J

Java

applications, 2-1, 2-9

loading, 2-17

attributes, 1-6

calling from database triggers, 7-5

calling from PL/SQL, 7-11

calling from SQL DML, 7-9

calling from the top level, 7-2

calling restrictions, 7-10

class, 1-6

client

setup, 4-3

compiling, 2-9

development environment, 2-6

differences from Sun JDK, 2-3

documentation, 1-2

execution control, 2-5

execution rights, 2-20

features, 1-13

full name, 2-8

in the database, 1-2, 1-14, 2-1, 2-2

interpreter, 2-2

introduction, 1-xiii

invoking, 2-2, 3-2

loading classes, 2-5, 3-2

checking results, 2-23

methods, 1-6

natively compiling, 10-2

Oracle database execution, 5-2

overview, 1-2, 1-5

permissions, A-5

polymorphism, 1-9

programming models, 1-xv

publishing, 2-6

resolving classes, 2-13

resources, 1-5

short name, 2-8

stored procedures, see Java stored procedures

Java 2

migrating from JDK 1.1, 1-2

security, 9-2

java command, 11-31

Java Compatibility Kit, see JCK

.java files, 2-7, 2-17, 2-18

java interpreter, 2-2, 2-5

Java language specification, see JLS

Java Native Interface, see JNI

Java stored procedures, 1-xv, 2-5

calling, 7-1

configuring, 5-7

defined, 1-24, 1-25, 3-3, 5-7

developing, 8-1

introduction to, 5-1

invoking, 3-2

loading, 2-1, 5-7

publishing, 2-24, 6-1

Java virtual machine, see JVM

JAVA$OPTIONS table, 2-10, 11-5

JAVA_ADMIN role

assigned permissions, 9-21

example, 9-14

granting permission, 9-3, 9-5, 9-12, 9-20

JAVA_DEPLOY role, 10-6

JAVA_MAX_SESSIONSPACE_SIZE parameter, 10-20

JAVA_POOL_SIZE parameter

default, 4-2

defined, 10-19, 10-21

JAVA_SOFT_SESSIONSPACE_LIMIT parameter, 10-19

JAVADEBUGPRIV role, 9-24, 9-25

JAVASYSPRIV role, 9-3, 9-23, 9-24

JAVAUSERPRIV role, 9-3, 9-23, 9-24

JCK, 1-12

JDBC

accessing SQL, 1-25

defined, 1-24, 3-2, 3-5

driver types, 1-25, 3-6

example, 3-6

security, 9-2

JDBC driver--see server-side JDBC driver

JDeveloper

development environment, 1-26, 4-5

JLS

specification, 1-12

JNI support, 3-5

JServerPermission, 9-8, 9-19, 9-20, 9-21, 9-22, 9-23, 9-24

defined, 9-20

JVM

bytecodes, 1-10

configure, 4-1

defined, 1-5, 1-10

garbage collection, 1-15, 1-16

install, 4-1, 4-2

multithreading, 1-15

responsibilities, 2-4

security, A-5

specification, 1-12

K

key

foreign, 8-4

primary, 8-4

L

library manager, 1-22

LimboError exception, 2-35

loader, class, 1-23

loading, 2-17

checking results, 2-19, 2-23

class, 1-19, 2-5, 2-9

compilation option, 2-9

granting execution, 2-20

JAR or ZIP files, 2-20

necessary privileges and permissions, 2-19

reloading classes, 2-20

restrictions, 2-19

loadjava method, A-4

loadjava tool, 2-17 to 2-19, 11-7 to 11-22

compiling source, 2-9, 10-24

example, 3-4, 5-11

execution rights, 2-20, 9-3

loading class, 2-17

loading ZIP or JAR files, 2-20

restrictions, 2-19

using memory, 10-19

logging, 2-10

longname method, 2-23, 2-26, 4-3

lookupClass method, 2-30

M

main method, 1-20, 2-5

maintainability, 5-5

manager

library, 1-22

map methods, 6-17

memory

across calls, 2-33

call, 2-5

java pool, 10-22

leaks, 2-33

lifetime, 2-32, 2-42

manager, 2-7

performance configuration, 10-19

session, 2-5, 2-38

methods, 1-6, 1-7, 5-4, 6-15

constructor, 6-17

declaring, 6-16

map and order, 6-17

object-relational, 5-4

modes, parameter, 6-3

multithreading, 1-15

N

NAME clause, 6-9

namespace, 11-26

native compilation, 1-18, 10-2, 12-2

Accelerator, 10-3

classes loaded in database, 10-13

classes not loaded in database, 10-13

compile subset, 10-14

deploync tool, 10-15

designating build directory, 10-14

errors, 10-12

execution time, 10-8

force recompile, 10-13

ncomp tool, 10-7

scenarios, 10-12

statusnc tool, 10-17

ncomp tool, 10-5, 10-7

executing, 10-7

security, 10-6

NEED_NCOMPING status, 10-17

NEED_NCOMPING status message, 10-12

NetPermission, 9-7, 9-19, 9-21, 9-22

O

object

full to short name conversion, 2-23

lifetime, 2-42

schema, 2-6

serialization, 2-30

short name, 2-23

SQL type, 5-4

table, 6-18

type

call specs, writing, 6-15

ObjectInputStream class, 2-30

ObjectOutputStream class, 2-30

object-relational methods, 5-4

ojvmjava tool, 11-26 to 11-30

online

compiler option, 2-11

operating system

resources, 2-31, 2-32

across calls, 2-42

lifetime, 2-33

performance, 10-18

Oracle Net Services Connection Manager, 1-15

OracleRuntime class

exitCall method, 2-36

getCallerClass method, 2-28

getClassLoader method, 2-28

order methods, 6-17

output

redirecting, 3-8

output, redirecting, 7-2

P

package DBMS_JAVA, 7-2

packaged call specs, writing, 6-12

packages

DBMS_JAVA, 4-3

protected, 9-26

PARALLEL_ENABLE option, 6-8

parameter modes, 6-3

performance, 1-18, 5-4, 10-1 to 10-24

Permission class, 9-7, 9-13, 9-14, 9-19

permissions, 9-2 to 9-25, A-5

administrating, 9-12

assigning, 9-4, 9-5

creating, 9-14

deleting, 9-19

disabling, 9-18

enabling, 9-18

FilePermission, 10-6

granting, 9-5, 9-8, 9-9

granting policy, 9-12

grouped into roles, 9-24

JAVA_ADMIN role, 9-21

JAVA_DEPLOY role, 10-6

JAVADEBUGPRIV role, 9-24

JAVASYSPRIV role, 9-23

JAVAUSERPRIV role, 9-23

PUBLIC, 9-22

restricting, 9-5, 9-9, 9-10

specifying policy, 9-4

SYS permissions, 9-22

types, 9-7, 9-19

PL/SQL

calling Java from, 7-11

packages, 6-12

policy table

managing, 9-12

modifying, 9-5

setting permissions, 9-5

viewing, 9-5

PolicyTable class

specifying policy, 9-4

updating, 9-5, 9-15

PolicyTableManager class

delete method, 9-19

disable method, 9-18

enable method, 9-19

revoke method, 9-18

PolicyTablePermission, 9-8, 9-12, 9-19, 9-20, 9-21, 9-22

polymorphism, 1-9

primary key, 8-4

privileges

database, 9-2

procedures, 5-2

advantages of stored, 5-4

productivity, 5-5

.properties files, 2-7, 2-17, 2-18

PropertyPermission, 9-7, 9-19, 9-21, 9-22, 9-24

PUBLIC permissions, 9-22

publishing, 2-6, 2-9, 2-24, 3-2

example, 3-4, 5-11

purity rules, 7-10

R

redirecting output, 7-2

ref, 6-18

ReflectPermission, 9-8, 9-19, 9-21, 9-22

registerCallback method, 2-38

replication, 5-6

reset_compiler_option method, 2-11, 11-6, A-1

resolver, 2-13 to 2-17, 11-3

default, 2-14

defined, 2-6, 2-9, 2-14, 2-27, 3-2

example, 3-4, 5-10

ignoring non-existent references, 2-14, 2-16

resource schema object, 2-6, 2-17, 2-18, 11-2

restart_debugging method, A-5

restrict method, 9-9

restrict_permission method, 9-9, 9-10, A-5

revoke method, 9-18

revoke_permission method, 9-18, A-5

row trigger, 7-5

rules, purity, 7-10

run-time contexts, stored procedure, 5-2

RuntimePermission, 9-8, 9-19, 9-21, 9-22, 9-23, 9-24

S

scalability, 5-5

schema object, 11-2

defined, 2-17

name, 2-26

names, maximum length, 2-8

using, 2-6

security, 5-6, 9-1 to 9-26

book recommendations, 9-4

Java 2, 9-3

JDBC, 9-2

JVM, A-5

network, 9-2

SecurityManager class, 9-4

SecurityPermission, 9-8, 9-19, 9-21, 9-22

.ser files, 2-7, 2-17, 2-18

SerializablePermission, 9-7, 9-19, 9-21, 9-23

serialization, 2-30

server-side JDBC driver, 1-24

using, 6-6

ServerSocket class, 2-44

sess_sh

commands in a script file, 11-28

redirecting output, 11-28

session

coordination with JVM, 2-4

definition, 2-2

footprint, 1-17

namespace, 11-26

role in Java execution, 2-3

set_compiler_option method, 2-11, 11-6, A-1

set_output method, 3-8, A-3

shared server, 5-5

SHARED_POOL_SIZE parameter

default, 4-2

defined, 10-19

short name, Java, 2-8

shortname method, 2-23, 2-26, 4-3

side effects

controlling, 7-10

Socket class, 2-44

SocketPermission, 9-8, 9-19, 9-21, 9-23, 9-24

sockets

across calls, 2-32, 2-44

defined, 2-44

lifetime, 2-42, 2-44

source schema object, 2-6, 2-17, 2-18, 11-2, 11-5

spec

package, 6-12

SQL object type, 6-15

SQL

DML, calling Java from, 7-9

object type, 5-4, 6-15

query, 3-2, 3-5

SQLJ

accessing SQL, 1-25

defined, 1-24, 3-2, 3-5

.sqlj files, 2-7, 2-17, 2-18

start_debugging method, A-5

statement trigger, 7-5

static variable, 2-5

end of call migration, 2-37

statusnc tool, 10-17

stop_debugging method, A-5

stored procedures

advantages of, 5-4

calling, 7-1

developing, 5-7, 8-1

introduction to, 5-1

loading, 2-1, 5-7

publishing, 6-1

SYS

assigned permissions, 9-22

security permissions, 9-20

System class

getProperty method, 3-8

T

ThreadDeathException, 2-36

threading, 2-32

applications, 2-35

lifecycle, 2-35

model, 1-15, 2-34

top-level call specs, writing, 6-8

trigger

database, 5-3, 7-5

row, 7-5

statement, 7-5

using Java stored procedures, 3-3, 5-7

U

user interface, 2-25

USER_ERRORS view, 2-10

USER_JAVA_POLICY view, 9-6, 9-20

USER_OBJECTS view, 2-19, 2-23, A-1

V

V$SGASTAT table, 10-22

variables

static, 2-5

verifier, 1-23

version

retrieving, 3-8

W

Web services

support for call-ins to database, 12-4