Oracle9i Java Stored Procedures Developer's Guide -- Index

Accelerator, 1-14

application

compiling, 2-4

developing, 5-1

execution rights, 2-16

attributes, 1-6, 3-18

declaring, 3-19

AUTHID clause, 3-11, 3-15, 3-18

body

package, 3-15

SQL object type, 3-18

bytecode

definition, 1-12

verification, 2-11

call specs, 1-3

basic requirements for defining, 3-3

definition, 1-20

example, 1-21

understanding, 3-2

writing object type, 3-18

writing packaged, 3-15

writing top-level, 3-11

class

loader, 1-13

loading, 2-12

marking valid, 2-9

name, 2-19

resolving references, 2-9

schema object, 2-3, 2-9, 2-12, 2-13

.class files, 2-3, 2-12, 2-13

CLASSPATH, 2-3

compiling, 1-12, 2-4

error messages, 2-5

options, 2-5

runtime, 2-4

components, Oracle JVM, 1-9

constructor methods, 3-20

contexts, stored procedure run-time, 1-3

conventions, notational, viii

CREATE JAVA statement, 2-1

database

Java, 2-2

sample tables, x

schema plan, 5-5

triggers, 1-5, 4-6

database triggers

calling Java from, 4-6

datatypes

mapping, 3-4

DBMS_JAVA package, 4-2

longname method, 2-17, 2-20

shortname method, 2-17, 2-20

debug

compiler option, 2-6

stored procedures, 1-19

definer rights, 2-20

versus invoker rights, 2-20

DETERMINISTIC hint, 3-11

dropjava tool, 2-14

ease of use, 1-7

encoding

compiler option, 2-6

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

errors

compilation, 2-5

exceptions, how handled, 4-15

execution rights, 2-16

foreign key, 5-5

full name, Java, 2-3

functions, 1-4

garbage collection, 1-10, 1-12

get_compiler_option method, 2-6

Graphical User Interface, see GUI

GUI, 1-10, 2-18

IDE (integrated development environment), 1-10

interfaces

user, 2-18

interoperability, 1-7

interpreter, 1-12

invoker rights, 2-20

advantages, 2-21

versus definer rights, 2-20

Java

applications, 2-4

loading, 2-12

calling from database triggers, 4-6

calling from PL/SQL, 4-12

calling from SQL DML, 4-10

calling from the top level, 4-2

calling restrictions, 4-11

compiling, 2-4

development environment, 2-3

execution rights, 2-16

full name, 2-3

in the RDBMS, 2-2

loading classes

checking results, 2-16

Oracle database execution, 1-2

resolving classes, 2-9

schema objects, managing, 2-20

short name, 2-3

.java files, 2-3, 2-12, 2-13

Java stored procedures

calling, 4-1

configuring, 1-16

defined, 1-17

developing, 5-1

introduction to, 1-1

loading, 2-1

publishing, 3-1

Java virtual machine. See JVM

JAVA$OPTIONS table, 2-5

JDBC driver. See server-side JDBC driver

JVM, 1-10

client JVMs versus Oracle JVM, 1-10

components, 1-9

garbage collection, 1-10, 1-12

multithreading, 1-10

key

foreign, 5-5

primary, 5-5

library manager, 1-11

loader, class, 1-13

loading, 2-12 to 2-18

checking results, 2-14, 2-16

class, 2-4

compilation option, 2-4

granting execution, 2-16

JAR or ZIP files, 2-15

necessary privileges and permissions, 2-15

reloading classes, 2-15

restrictions, 2-14

loadjava tool, 2-13 to 2-15, 2-20

compiling source, 2-4

example, 1-20

execution rights, 2-16

loading class, 2-12

loading ZIP or JAR files, 2-15

restrictions, 2-14

logging, 2-5

longname method, 2-17, 2-20

main method, 1-10

maintainability, 1-7

manager

library, 1-11

memory, 1-12

map methods, 3-20

memory manager, 1-12, 2-4

methods, 1-6, 3-18

constructor, 3-20

declaring, 3-19

map and order, 3-20

object-relational, 1-6

modes, parameter, 3-3

Multi-Threaded Server (MTS), 1-7

multithreading, 1-10

NAME clause, 3-11

notational conventions, viii

object

full to short name conversion, 2-17

schema, 2-3

short name, 2-17

SQL type, 1-6

table, 3-21

type

call specs, writing, 3-18

object-relational methods, 1-6

online

compiler option, 2-6

Oracle Net Services Connection Manager, 1-2

order methods, 3-20

output, redirecting, 4-2

package DBMS_JAVA, 4-2

packaged call specs, writing, 3-15

PARALLEL_ENABLE option, 3-11

parameter modes, 3-3

performance, 1-6

PL/SQL

calling Java from, 4-12

packages, 3-15

primary key, 5-5

procedures, 1-4

advantages of stored, 1-6

productivity, 1-7

.properties files, 2-3, 2-12, 2-14

publications, related, xi

publishing, 2-4

example, 1-20

purity rules, 4-11

redirecting output, 4-2

ref, 3-21

replication, 1-8

reset_compiler_option method, 2-6

resolver, 2-9 to 2-12

default, 2-10

defined, 2-3, 2-4, 2-10

example, 1-20

ignoring non-existent references, 2-10, 2-12

resource schema object, 2-3, 2-12, 2-14

rights, invoker versus definer, 2-20

row trigger, 4-6

rules, purity, 4-11

run-time contexts, stored procedure, 1-3

sample database tables, x

scalability, 1-7

schema object

defined, 2-12

managing Java, 2-20

name, 2-19

names, maximum length, 2-3

using, 2-3

security, 1-8

.ser files, 2-3, 2-12, 2-14

server-side JDBC driver, 1-14

using, 3-7

server-side SQLJ translator, 1-14

using, 3-9

set_compiler_option method, 2-6

short name, Java, 2-3

shortname method, 2-17, 2-20

side effects

controlling, 4-11

source schema object, 2-3, 2-12, 2-13

spec

package, 3-15

SQL object type, 3-18

SQL

DML, calling Java from, 4-10

object type, 1-6, 3-18

.sqlj files, 2-3, 2-12, 2-13

SQLJ translator. See server-side SQLJ translator

statement trigger, 4-6

stored procedures

advantages of, 1-6

calling, 4-1

developing, 1-17, 5-1

introduction to, 1-1

loading, 2-1

publishing, 3-1

tables, sample database, x

threading

model, 1-10

top-level call specs, writing, 3-11

trigger

database, 1-5, 4-6

row, 4-6

statement, 4-6

using Java stored procedures, 1-17

user interface, 2-18

USER_ERRORS view, 2-5

USER_OBJECTS view, 2-14, 2-16

utilities

loadjava, 2-20

verifier, 1-13

Index

A

B

C

D

E

F

G

I

J

K

L

M

N

O

P

R

S

T

U

V