Oracle8
i
Java Stored Procedures Developer's Guide
Release 2 (8.1.6)
A81358-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
A
Accelerator, JServer, 1-13
advantages of stored procedures, 1-6
application, developing an, 5-1
attributes, 1-5,
3-17
declaring, 3-18
AUTHID clause, 3-10,
3-14,
3-17
B
body
package, 3-14
SQL object type, 3-17
bytecodes, 1-12
C
call specs, 1-3
understanding, 3-2
writing object type, 3-17
writing packaged, 3-14
writing top-level, 3-10
calling Java
from database triggers, 4-6
from PL/SQL, 4-12
from SQL DML, 4-10
from the top level, 4-2
restrictions, 4-11
calling stored procedures, 4-1
checking upload results, 2-15
class loader, 1-12
CLASSPATH versus resolver spec, 2-5
client JVMs versus JServer JVM, 1-10
collection, garbage, 1-11
compilation
how done, 2-7
options, 2-7
compiler, 1-12
components, JServer JVM, 1-9
constructor methods, 3-19
contexts, stored procedure run-time, 1-3
conventions, notational, ix
CREATE JAVA statement, 2-1
D
database
Java in, 2-2
sample tables, xi
schema plan, 5-5
database triggers, 1-4,
4-6
calling Java from, 4-6
datatypes, mapping, 3-4
DBMS_JAVA package, 2-8,
2-14,
2-16,
4-2
debugging, 1-17
declaring attributes, 3-18
declaring methods, 3-18
definer rights
versus invoker rights, 2-21
definer rights versus invoker rights, 2-21
defining call specs, basic requirements for, 3-3
DETERMINISTIC hint, 3-10
developing an application, 5-1
developing stored procedures, overview of, 1-15
digest table, 2-7
displaying Java schema objects, 2-15
drawing an entity-relationship (E-R) diagram, 5-2
dropjava utility, 2-18
options, 2-18
E
ease of use, 1-6
entity-relationship (E-R) diagram, drawing an, 5-2
exceptions, how handled, 4-15
external references, 2-4
F
filenames
how to specify, 2-12,
2-19
files
kinds accepted by loadjava, 2-12
reloading, 2-14
foreign key, 5-5
full name, Java, 2-3
functions, 1-4
G
garbage collection, 1-11
graphical user interface (GUI), 1-10
GUI (graphical user interface), 1-10
I
IDE (integrated development environment), 1-10
integrated development environment (IDE), 1-10
interoperability, 1-7
interpreter, 1-12
invoker rights
advantages, 2-21
versus definer rights, 2-21
invoker rights versus definer rights, 2-21
J
Java full name, 2-3
Java in the Oracle database, 1-2
Java in the RDBMS, 2-2
Java schema objects, displaying, 2-15
Java schema objects, managing, 2-4
Java short name, 2-3
Java stored procedures
calling, 4-1
developing, 5-1
introduction to, 1-1
loading, 2-1
publishing, 3-1
Java virtual machine. See JServer JVM
JDBC driver. See server-side JDBC driver
JServer Accelerator, 1-13
JServer JVM
components, 1-9
versus client JVMs, 1-10
K
key
foreign, 5-5
primary, 5-5
L
library manager, 1-11
loader, class, 1-12
loading stored procedures, 2-1
when necessary, 2-4
loadjava utility, 2-9
options, 2-10
M
main method, 1-10
maintainability, 1-7
manager
library, 1-11
memory, 1-11
managing Java schema objects, 2-4
map methods, 3-19
mapping datatypes, 3-4
memory manager, 1-11
methods, 1-5,
3-17
constructor, 3-19
declaring, 3-18
map and order, 3-19
object-relational, 1-5
modes, parameter, 3-3
Multi-Threaded Server (MTS), 1-7
multi-threading, 1-10
N
NAME clause, 3-10
name resolution, 2-4
name spec, 2-6
Net8 Connection Manager, 1-2
notational conventions, ix
O
object table, 3-20
object type call specs, writing, 3-17
object type, SQL, 1-5
object-relational methods, 1-5
online Java sources, xiii
order methods, 3-19
output, redirecting, 4-2
P
package DBMS_JAVA, 2-8,
2-14,
2-16,
4-2
packaged call specs, writing, 3-14
PARALLEL_ENABLE option, 3-10
parameter modes, setting, 3-3
performance, 1-6
planning a database schema, 5-5
PL/SQL
calling Java from, 4-12
packages, 3-14
primary key, 5-5
procedures, 1-4
advantages of stored, 1-6
productivity, 1-6
publications, related, xii
publishing stored procedures, 3-1
purity rules, 4-11
R
reading, suggested, xii
redirecting output, 4-2
ref, 3-20
references, external, 2-4
related publications, xii
replication, 1-7
resolution, name, 2-4
resolver, 2-5
resolver spec, 2-5
kinds of, 2-6
resolver spec versus CLASSPATH, 2-5
restrictions on calling Java from SQL DML, 4-11
rights, invoker versus definer, 2-21
row trigger, 4-6
rules, purity, 4-11
run-time contexts, stored procedure, 1-3
S
sample database tables, xi
scalability, 1-7
schema object names
maximum length, 2-3
schema objects, managing Java, 2-4
schema spec, 2-6
security, 1-8
server-side JDBC driver, 1-13
using, 3-6
server-side SQLJ translator, 1-13
using, 3-8
setting parameter modes, 3-3
short name, Java, 2-3
side effects
controlling, 4-11
spec
name, 2-6
package, 3-14
resolver, 2-5
schema, 2-6
SQL object type, 3-17
SQL DML, calling Java from, 4-10
SQL object type, 1-5,
3-17
SQLJ translator. See server-side SQLJ translator
statement trigger, 4-6
stored procedures
advantages of, 1-6
calling, 4-1
developing, 5-1
introduction to, 1-1
loading, 2-1
publishing, 3-1
suggested reading, xii
T
table, digest, 2-7
tables, sample database, xi
top level, calling Java from, 4-2
top-level call specs, writing, 3-10
trigger
database, 1-4,
4-6
row, 4-6
statement, 4-6
U
upload results, checking, 2-15
USER_OBJECTS view, 2-15
columns in, 2-17
utilities
dropjava, 2-18
loadjava, 2-9
V
verifier, 1-12
Prev
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents