Oracle8<i>i</i> SQLJ Developer's Guide and Reference -- Index

AuditorInstaller

command-line examples, A-28

customizer for debugging, A-21

invoking, A-22

options, A-24

runtime output, A-23

auditors in profiles for debugging, A-21

auto-commit

modifying in existing connection, 4-30

not supported in server, 11-4

specifying as you define connection, 4-29

backup option (customizer harness), 10-13

backwards compatibility to Oracle8/Oracle7, 5-9

batch updates

batch limit, A-12

batchable and compatible statements, A-6

batching incompatible statements, A-13

canceling a batch, A-10

cautions, A-15

enabling and disabling, A-7

error conditions during execution, A-15

explicit and implicit batch execution, A-8

overview, A-6

update counts, A-11

using implicit execution contexts, A-14

with respect to recursive call-ins, A-16

BetterDate (custom Java class), 12-48

BFILEs

as stored function results, 5-30

support, 5-26

BigDecimal mapping (for attributes), 6-27

BigDecimal support, 5-39

binary portability of profiles, 1-6

BLOB support, 5-26

BOOLEAN type (PL/SQL), 5-8

builtintypes option (JPublisher -builtintypes), 6-27

C prefix (sqlj -C-x), 8-50

cache option (sqlj -cache), 8-64

caching online checker results, 8-64

caching statements, A-3

CALL syntax for stored procedures, 3-57

calling stored functions, 3-58

calling stored procedures, 3-57

calls to runtime, generated, 9-8

case option (JPublisher -case), 6-25

cause/action output for errors, 8-46

character encoding

command line example, 9-24

for messages, 9-23

for source, 9-22

overview, 9-20

setting at runtime, 9-25

using native2ascii, 9-26

check source name against. public class, 8-70

check sources, expand resolution search, 8-58

checker option (SQLCheckerCustomizer), 10-41

checkfilename option (sqlj -checkfilename), 8-70

checksource option (sqlj -checksource), 8-58

class loading in server, 11-5

class schema object naming

generated, 11-20

loaded, 11-9

classpath and path, 2-6

classpath option (sqlj -classpath), 8-20

clauses, SQLJ executable statements, 3-9

client-side translation to run in server, 11-7

CLOB support, 5-26

close() method (DefaultContext), 4-18

close() method (Oracle class), 4-16, 4-18

CLOSE_CONNECTION, 7-32

code generation, 9-5

code layers in profiles, A-21

code-parsing, 9-2

collections

about custom Java classes, 6-6

creating collection types, 6-17

CustomDatum specifications, 6-6

datatypes, 6-5

fundamentals, 6-4

introduction to collection support, 6-2

mapping to alternative classes, 6-31

nested tables sample application, 12-36

specifying type mapping, 6-23, 6-26

strongly typed, 6-51

VARRAYs sample application, 12-45

weak types, restrictions, 6-67

weak types, support, 6-66

column definitions (types/sizes), A-16

command line (translator)

echoing without executing, 8-13

example, 8-13

overview, 8-2

syntax and arguments, 8-10

commit

automatic vs. manual, 4-28

effect on iterators and result sets, 4-31

manual, 4-30

modifying auto-commit in existing connection, 4-30

specifying auto-commit, 4-29

compat(ibility) option (Oracle customizer), 10-24

compilation

compiling in two passes, 8-71

debug option in server, 11-17

during translation, 9-8

enabling/disabling, 8-54

in server, 11-5

compile option (sqlj -compile), 8-54

compiler

classpath option, 8-20

options through SQLJ, 8-50

related options, 8-65

required behavior, 8-67

specifying name, 8-67

compiler encoding support option (sqlj), 8-68

compiler executable option (sqlj), 8-67

compiler message output pipe option (sqlj), 8-69

compiler output file option (sqlj -compiler...), 8-69

configuration and installation verification, 2-5

connect() method (Oracle class), 4-14

connection contexts

connection properties file, 12-2

connections

closing, 4-12

closing shared connections with JDBC, 7-32

database connection in server, 11-3

JDBC transaction methods, 7-26

modifying auto-commit, 4-30

multiple, sample application, 12-60

multiple, using declared connect contexts, 4-14

Oracle class to connect, 4-14

set up, 2-8

shared connections with JDBC, 7-31

single or multiple using default context, 4-8

specifying auto-commit, 4-29

translator options, 8-31

verify, 2-9

connect.properties file, 12-2

context expressions

evaluation at runtime, 3-20

overview, 3-20

context option (customizer harness), 10-14

converting .ser profiles to .class, 8-56

CORBA server objects with SQLJ, 11-28

CURSOR syntax (nested tables), 6-52

custom Java classes

about custom Java classes, 6-6

compiling, 6-12

creation by JPublisher, 6-20

examples, 6-35

extending, 6-39

generation by JPublisher, 6-23

mapping to alternative classes, 6-31

reading and writing data, 6-13

requirements, 6-10

sample class, 12-48

specifying member names, 6-33

support for object methods, 6-9

using to serialize object, 6-60

CustomDatum

additional uses, 6-13

in custom Java classes, 6-6

specifications, 6-6

customization

converting .ser profiles to .class, 8-56

creation and registration, 10-7

customizer harness connection options, 10-17

customizer harness general options, 10-13

customizer harness options overview, 10-12

defining column types/sizes, 10-26

defining parameter sizes, 10-29

during translation, 9-10

enabling/disabling, 8-55

error and status messages, 10-9

force customization, 10-25

jar file usage, 10-37

more about customization, 10-5

options, 10-11

options to invoke special customizers, 10-20

Oracle customizer options, 10-24

overview/syntax of customizer-specific options, 10-23

parameter default sizes, 10-30

related SQLJ options, 10-36

show SQL transformations, 10-32

statement cache size, 10-33

steps in process, 10-6

summary of Oracle features used, 10-34

version compatibility, 10-24

customizer harness

connection options, 10-17

general options, 10-13

invoke special customizers, 10-20

options overview, 10-12

overview, 10-5

customizer option (customizer harness), 10-15

customizers

choosing, 10-11

option to choose customizer, 10-15

overview, 10-5

passing options through SQLJ, 8-52

specifying default, 8-73

d option (sqlj -d), 8-27

database connection, verify, 2-9

DBMS_JAVA package

setting server-side options, 11-17

DBMS_LOB package, 5-27

debug option (customizer harness), 10-20

debug option for compile (in server), 11-17

debugging

AuditorInstaller command-line examples, A-28

AuditorInstaller customizer, A-21

AuditorInstaller options, A-24

AuditorInstaller runtime output, A-23

debug option for compile (in server), 11-17

debug option, customizer harness, 10-20

in JDeveloper, A-31

invoking AuditorInstaller, A-22

line-mapping, SQLJ source to class, 8-46

line-mapping, SQLJ source to class for jdb, 8-47

declarations

connection context declarations, 3-4

IMPLEMENTS clause, 3-5

iterator declarations, 3-3

overview, 3-2

WITH clause, 3-6

default connection

setting with Oracle.connect(), 4-8

setting with setDefaultContext(), 4-12

default customizer option (sqlj), 8-73

default output device in server, 11-4

default properties files (translator), 8-16

default semantics-checker, 8-59

default URL prefix option (sqlj), 8-40

DefaultContext class

close() method parameters, 4-18

constructors, 4-17

key methods, 4-16

use for single or multiple connections, 4-8

defining column types/sizes, A-16

defining parameter sizes, A-18

depth option (AuditorInstaller), A-25

digests option, jar (customizer harness), 10-15

dir option (sqlj -dir), 8-29

directory

for generated .class and .ser, 8-27

for generated .java, 8-29

dirty reads, 7-25

driver option (customizer harness), 10-19

driver registration option (sqlj -driver), 8-41

dropjava, 11-23

dropping Java schema objects, 11-23

dynamic SQL, use of PL/SQL in SQLJ, 12-67

echo option, without execution, 8-24

echoing command line without executing, 8-13

encoding

character encoding for messages, 9-23

character encoding for source, 9-22

command line example, 9-24

do not pass option to compiler, 8-68

overview of character encoding, 9-20

setting at runtime, 9-25

specifying in server, 11-16

using native2ascii, 9-26

encoding option (in server), 11-16

encoding option, source files (sqlj -encoding), 8-26

Enterprise JavaBeans with SQLJ, 11-27

environment assumptions and requirements, 2-2

environment variable, translator options, 8-17

errors

character encoding for messages, 9-23

customization messages, 10-9

messages, codes, and SQL states, 4-26

outputting cause and action, 8-46

runtime categories, 9-18

runtime error list, B-44

server-side error output, 11-22

translator error list, B-2

translator error, warning, info messages, 9-12

exceptions

exception-handling requirements, 4-24

processing, 4-25

set up exception-handling, 4-33

using SQLException subclasses, 4-27

executable statements

examples, 3-12

overview, 3-8

rules, 3-8

specifying connection/execution contexts, 3-11

SQLJ clauses, 3-9

using PL/SQL blocks, 3-13

execution contexts

cancellation method, 7-17

control methods, 7-17

creating and specifying, 7-14

method usage, example, 7-19

overview, 7-13

relation to connection contexts, 7-13

relation to multithreading, 7-19

specifying for executable statement, 3-11

status methods, 7-16

synchronization, 7-15

update-batching methods, 7-18

exemplar schema, 4-19

exit codes, translator, 9-15

explain option (sqlj -explain), 8-46

extending JPub-generated classes, 6-39

extensions

overview, 1-7

performance enhancements, A-2

summary of features used, 10-34

type extensions, 5-25

file name requirements and restrictions, 4-4

flags for special processing, 8-54

force option (Oracle customizer), 10-25

ForUpdate/updateColumns (WITH clause), 3-7

function calls, stored, 3-58

getConnection() method (Oracle class), 4-14

help option (customizer harness), 10-16

help options (sqlj -help-xxxx), 8-21

hints in code, parameter sizes, A-19

holdability (cursor states, WITH clause), 3-7

host expressions

basic syntax, 3-16

evaluation at runtime, 3-20

examples, 3-18

examples of evaluation at runtime, 3-22

iterators and result sets as host variables, 3-49

overview, 3-15

restrictions, 3-31

sample application, 12-13

selecting a nested table, 6-53

type support for JDBC 2.0, 5-7

type support for Oracle8i, 5-2

type support for Oracle8/Oracle7, 5-9

IDE SQLJ integration, 1-21

IMPLEMENTS clause

in connection context declarations, 7-10

in iterator declarations, 7-22

syntax, 3-5

importing required classes, 4-32

informational messages, translator, 9-12

input to translator, 1-10

INSENSITIVE (cursor state), 3-7

installation and configuration verification, 2-5

instrumenting class file (linemap), 8-46

interoperability with JDBC

connection contexts and connections, 7-28

iterators and result sets, 7-33

sample application, 12-59

introduction to SQLJ, 1-2

isolation level settings (transactions), 7-25

iterators

accessing named iterators, 3-43

accessing positional iterators, 3-46

as host variables, 3-49

as iterator columns (nested), 3-52

as stored function returns, 3-60

commit/rollback effect, 4-31

concepts, 3-35

converting from result sets, 7-33

converting to result sets, 7-34

declarations, 3-3

declaring named iterators, 3-41

declaring positional iterators, 3-45

declaring with IMPLEMENTS clause, 7-22

general steps in using, 3-38

instantiating/populating named iterators, 3-42

instantiating/populating positional iterators, 3-46

iterator class functionality, 7-21

named iterator sample application, 12-5

named vs. positional, 3-39

nested iterators for nested tables, 6-56

overview, 3-35

positional iterator sample application, 12-9

selecting objects and references, 6-46

set up named iterator (example), 4-36

subclassing, 7-23

subclassing, sample application, 12-65

using named iterators, 3-40

using positional iterators, 3-45

using weakly typed iterators, 7-35

with serialized objects, 6-63

J prefix (sqlj -J-x), 8-49

jar file digests option, customization, 10-15

jar files for profiles, 10-37

Java names vs. SQL names in server, 11-6

Java Option (JServer) configuration, 2-4

Java properties, getProperty(), 9-25

Java sockets, 4-6

Java VM

classpath option, 8-20

options through SQLJ, 8-49

specifying name, 8-66

javac compatibility, 8-9

JDBC 2.0

Oracle requirements for use, 5-8

support, 5-7

types supported, 5-7

JDBC connection methods (transactions), 7-26

JDBC considerations in server, 11-4

JDBC driver registration option (sqlj -driver), 8-41

JDBC drivers

Oracle drivers, 4-5

select for translation, 4-6

select/register for customization, 10-19

select/register for runtime, 4-7

verify, 2-10

JDBC interoperability

connection contexts and connections, 7-28

iterators and result sets, 7-33

sample application, 12-59

JDBC mapping (for attributes), 6-27

JDBC vs. SQLJ, sample application, 12-90

jdblinemap option (sqlj -jdblinemap), 8-47

JDeveloper

debugging with, A-31

SQLJ integration, 1-21

JDK

appropriate JDBC class files, 2-6

supported versions, 2-3

JPublisher

JServer (Java Option) configuration, 2-4

KEEP_CONNECTION, 7-32

language support (NLS), 9-21

linemap option (sqlj -linemap), 8-46

line-mapping

SQLJ source to class file, 8-46

SQLJ source to class for jdb, 8-47

loading into server

classes/resources, 11-7

source, translating, 11-13

loadjava

loading classes/resources, 11-7

loading source, translating, 11-13

output from loading source, 11-18

loadjava compatibility options, SQLJ, 8-8

LOBs

as iterator columns, 5-32

as stored function results, 5-30

FETCH INTO LOB host variables, 5-33

SELECT INTO LOB host variables, 5-31

support (oracle.sql and DBMS_LOB), 5-26

lobtypes option (JPublisher -lobtypes), 6-26

locale

command line example, 9-24

for messages, 9-23

setting at runtime, 9-25

log option (AuditorInstaller), A-26

mapping to alternative classes (UDTs), 6-31

member names (objects), 6-33

message pipe, compiler, 8-69

method support for objects, 6-9

method wrappers (JPub)

implementation, 6-34

multiple connections, sample application, 12-60

multithreading

in server, 11-24

in SQLJ, overview, 7-20

relation to execution contexts, 7-19

sample application, 12-57

n option (sqlj -n) (echo without execution), 8-24

name of compiler, 8-67

name of Java VM, 8-66

named iterators

accessing, 3-43

declaring, 3-41

instantiating and populating, 3-42

using, 3-40

naming requirements and restrictions

file names, 4-4

local variables, classes (Java namespace), 4-2

SQL namespace, 4-4

SQLJ namespace, 4-3

naming schema objects

generated class, 11-20

generated profile, 11-21

loaded classes, 11-9

loaded resources, 11-10

source, 11-19

native2ascii for encoding, 9-26

nested iterators, 6-56

nested tables

accessing, 6-52

inserting in SQLJ, 6-52

manipulating, 6-55

sample application, 12-36

selecting into host expression, 6-53

types, 6-4

using nested iterator, 6-56

NLS support

overview, 1-21

translator and runtime, 9-19

non-repeatable reads, 7-25

null-handling

examples, 4-22

wrapper classes for null-handling, 4-21

numbertypes option (JPublisher -numbertypes), 6-26

object method wrappers (JPub), 6-34

object references

selecting into iterators, 6-46

strongly typed, 6-45

updating in SQLJ, 6-49

weak types, restrictions, 6-67

weak types, support, 6-66

object-JDBC mapping (for attributes), 6-27

objects

OCI drivers (JDBC), 4-6

offline checking

default checker, Oracle checkers, 8-59

specifying checker, 8-60

offline option (sqlj -offline), 8-60

online checking

caching results, 8-64

default checker, Oracle checkers, 8-59

enabling in server, 11-16

enabling, setting user schema, 8-31

registering drivers, 8-41

setting default URL prefix, 8-40

setting password, 8-36

setting URL, 8-38

specifying checker, 8-62

online option (in server), 11-16

online option (sqlj -online), 8-62

optcols option (Oracle customizer), 10-26

optimizer, SQL, A-2

options (translator)

command line only, 8-19

flags for special processing, 8-54

for connections, 8-31

for customization, 8-73

for javac compatibility, 8-9

for loadjava compatibility, 8-8

for output files and directories, 8-26

for reporting and line mapping, 8-42

for semantics-checking, 8-58

for VM and compiler, 8-65

help, 8-21

order of precedence, 8-17

overview, 8-3

prefixes for passing options, 8-49

summary list, 8-4

support for alternative environments, 8-65

options for customizer harness

connection options, 10-17

general options, 10-13

invoke special customizers, 10-20

overview, 10-12

options for Oracle customizer, 10-24

options in server

for translation, 11-15

setting, 11-17

optparamdefaults option (Oracle customizer), 10-30

optparams option (Oracle customizer), 10-29

Oracle class

close() method parameters, 4-16

connect() method, 4-14

for DefaultContext instances, 4-14

getConnection() method, 4-14

Oracle customizer

column definitions flag, 10-26

default parameter size option, 10-30

force flag, 10-25

options, 10-24

parameter definitions flag, 10-29

show SQL transformation, 10-32

statement cache size, 10-33

summary of Oracle features used, 10-34

version compatibility, 10-24

Oracle extensions

overview, 1-7

performance enhancements, A-2

summary of features used, 10-34

type extensions, 5-25

Oracle Lite with SQLJ, 1-19

Oracle mapping (for attributes), 6-27

Oracle optimizer, A-2

OracleChecker default checker, 8-59

oracle.sql package, 5-26

output device in server, default, 11-4

output directory

for generated .class and .ser, 8-27

for generated .java, 8-29

output file and directory options (translator), 8-26

output for compiler

output file, 8-69

output pipe for messages, 8-69

output from translator, 1-10

output, server-side translator errors, 11-22

P prefix (sqlj -P-x), 8-52

parameter definitions (sizes), A-18

passes option (sqlj -passes), 8-71

passes, two-pass compiling, 8-71

passing options to other executables, 8-49

password option (customizer harness), 10-18

password option for checking (sqlj), 8-36

path and classpath, 2-6

performance enhancements, A-2

phantom reads, 7-25

pipe, compiler output messages, 8-69

PL/SQL in SQLJ

blocks in executable statements, 3-13

BOOLEAN type, 5-8

RECORD type, 5-8

TABLE type, 5-8

use for dynamic SQL, 12-67

positional iterators

accessing, 3-46

declaring, 3-45

instantiating and populating, 3-46

using, 3-45

positioned delete, 5-34

positioned update, 5-34

prefetching rows, A-3

prefix option (AuditorInstaller), A-26

prefixes

to pass options to customizer, 8-52

to pass options to Java compiler, 8-50

to pass options to Java VM, 8-49

print option (customizer harness), 10-21

procedure calls, stored, 3-57

profile customization (see customization), 9-10

profile option (sqlj -profile), 8-55

profile-keys class, 9-6

profiles

auditors for debugging, A-21

binary portability, 1-6

code layers, A-21

creation during code generation, 10-2

debug option, 10-20

functionality at runtime, 10-10

generated profiles, 9-6

more about profiles, 10-2

naming generated profiles in server, 11-21

overview, 1-5

print option, 10-21

sample profile entry, 10-3

use of jar files, 10-37

verify option, 10-21

properties files (translator)

default properties files, 8-16

example, 12-2

overview, 8-13

setting input file, 8-20

syntax, 8-14

properties, Java, getProperty(), 9-25

props option (sqlj -props), 8-20

public class name / source name check, 8-70

READ COMMITTED transactions, 7-25

READ ONLY transactions, 7-25

READ UNCOMMITTED transactions, 7-25

READ WRITE transactions, 7-25

RECORD type (PL/SQL), 5-8

recursive SQLJ calls in server, 11-24

REF CURSOR

about REF CURSOR types, 5-37

example, 5-38

sample application, 12-53

SQLJ support, 5-37

register JDBC drivers

for runtime, 4-7

for translation, 8-41

registering column types/sizes, A-16

registering parameter sizes, A-18

REPEATABLE READ transactions, 7-25

reporting options (translator), 8-42

requirements, environment, 2-3

resource schema object naming

generated, 11-21

loaded, 11-10

result expressions

evaluation at runtime, 3-20

overview, 3-20

result sets

as host variables, 3-49

as iterator columns, 3-52

as stored function returns, 3-60

commit/rollback effect, 4-31

converting from iterators, 7-34

converting to iterators, 7-33

persistence across calls in server, 11-4

ResultSetIterator (weakly typed), 7-35

returnability (cursor states, WITH clause), 3-7

rollback

effect on iterators and result sets, 4-31

manual, 4-30

row prefetching, A-3

ROWID

as stored function results, 5-35

FETCH INTO ROWID host variable, 5-36

SELECT INTO ROWID host variable, 5-36

support, 5-34

runtime

categories of errors, 9-18

debugging output (AuditorInstaller), A-23

error list, B-44

functionality, 9-16

functionality of profiles, 10-10

generated calls to runtime, 9-8

JDBC driver selection and registration, 4-7

NLS support, 9-19

overview, 1-4

packages, 9-16

set up connection, 2-8

steps in runtime processing, 1-14

test, 2-10

sample applet, 12-82

sample applications

host expressions, 12-13

interoperability with JDBC, 12-59

JDBC vs. SQLJ, 12-90

multiple connection contexts, 7-7, 12-62

multiple connection schemas, 12-60

multiple-row query (named iterator), 4-37

multithreading, 12-57

named iterator, 12-5

nested tables, 12-36

objects, 12-27

positional iterator, 12-9

REF CURSOR, 12-53

row prefetching, 12-73

server-side SQLJ, 12-89

single-row query (SELECT INTO), 4-35

subclassing iterator classes, 12-65

VARRAYs, 12-45

sample classes

custom Java class (BetterDate), 12-48

SerializableDatum class, 6-64

schema objects

naming generated classes, 11-20

naming generated resources, 11-21

naming loaded classes, 11-9

naming loaded resources, 11-10

naming sources, 11-19

SELECT INTO statements, 3-32

semantics-checking

caching online results, 8-64

default checker, Oracle checkers, 8-59

enabling online in server, 11-16

enabling online, setting user schema, 8-31

invoking SQLCheckerCustomizer, 10-39

of profiles, via customizer harness, 10-21

options, 8-58

registering drivers, 8-41

setting default URL prefix, 8-40

setting password, 8-36

setting URL, 8-38

specifying offline checker, 8-60

specifying online checker, 8-62

SQLCheckerCustomizer options, 10-41

steps involved, 9-2

SENSITIVE (cursor state), 3-7

sensitivity (cursor states, WITH clause), 3-7

ser profiles (.ser)

converting to .class, 8-56

generated profiles, 9-6

ser2class option (sqlj -ser2class), 8-56

SERIALIZABLE transactions, 7-25

serialized objects

as host variables, 6-63

in iterator columns, 6-63

SerializableDatum class (sample), 6-64

through custom Java class, 6-60

server-side internal driver (JDBC), 4-6

server-side SQLJ

class loading, 11-5

coding considerations, 11-3

compilation, 11-5

connection to database, 11-3

CORBA objects, 11-28

default output device, 11-4

dropjava, 11-23

dropping Java schema objects, 11-23

Enterprise JavaBeans, 11-27

error output, 11-22

generated output from translation, 11-18

introduction, 11-2

Java multithreading, 11-24

JDBC differences, 11-4

loading classes/resources into server, 11-7

loading source into server, translating, 11-13

naming generated class schema objects, 11-20

naming generated profiles, 11-21

naming generated resource schema objects, 11-21

naming loaded class schema objects, 11-9

naming loaded resource schema objects, 11-10

naming source schema objects, 11-19

options, 11-15

overview, 1-17

recursive calls, 11-24

running client program in server, 11-12

sample application, 12-89

setting options, 11-17

SQL names vs. Java names, 11-6

translating in server, 11-13

translating on client, 11-7

verifying code is running in server, 11-26

server-side Thin driver (JDBC), 4-6

SET (assignment) statements, 3-55

SET TRANSACTION syntax, 7-24

setup, testing database, JDBC, SQLJ, 2-8

showReturns option (AuditorInstaller), A-27

showSQL option (Oracle customizer), 10-32

showThreads option (AuditorInstaller), A-27

source check for type resolution, 8-58

source file line-mapping

for jdb, 8-47

typical, 8-46

source files encoding option, 8-26

source name / public class name check, 8-70

source schema object naming, 11-19

SQL names vs. Java names in server, 11-6

SQL optimizer, A-2

sql option (JPublisher -sql), 6-23

SQL states (for errors), 4-26

SQLCheckerCustomizer

for semantics-checking of profiles, 10-39

invoking, 10-39

options, 10-41

SQLData

in custom Java classes, 6-6

specifications, 6-8

SQLException subclasses, using, 4-27

SQLJ properties file example, 12-2

SQLJ vs. JDBC, sample application, 12-90

SQLJ_OPTIONS environment variable, 8-17

sqljutl package, 2-7

statement caching, A-3

status messages

for customization, 10-9

for translation, 9-14

translator, enabling/disabling, 8-45

status option (sqlj -status), 8-45

stmtcache option (Oracle customizer), 10-33

stored function calls, 3-58

stored procedure calls, 3-57

streams

as function return values, 5-23

as output parameters, 5-22

classes and methods, 5-24

examples, 5-19

general use in SQLJ, 5-11

precautions, 5-15

processing, 5-18

retrieving data from database, 5-16

sending data to database, 5-12

supporting classes, 5-11

strongly typed

collections, 6-51

objects and references, 6-45

subclassing iterator classes, 7-23

summary option (Oracle customizer), 10-34

Sun JDK

appropriate JDBC class files, 2-6

supported versions, 2-3

synchronization of execution contexts, 7-15

syntax

translator command line, 8-10

translator properties files, 8-14

syntax-checking, 9-2

TABLE syntax (nested tables), 6-52, 6-55

TABLE type (PL/SQL), 5-8

Thin driver (JDBC), 4-6

transactions

access mode settings, 7-25

advanced transaction control, 7-24

automatic commit vs. manual commit, 4-28

basic transaction control, 4-28

isolation level settings, 7-25

JDBC Connection methods, 7-26

manual commit and rollback, 4-30

modifying auto-commit, 4-30

overview, 4-28

specifying auto-commit, 4-29

TRANSLATE (object member names), 6-33

translating in server to run in server, 11-13

translating on client to run in server, 11-7

translator

basic translation steps, 1-8

code generation, 9-5

code-parsing, syntax-checking, 9-2

compilation, 9-8

customization, 9-10

error list, B-2

error, warning, info messages, 9-12

exit codes, 9-15

input and output, 1-10

internal operations, 9-2

NLS support, 9-19

output, server-side, 11-18

overview, 1-4

semantics-checking, 9-2

status messages, 9-14

support for alternative environments, 8-65

test, 2-10

type extensions, 5-25

type mapping

BigDecimal mapping, 6-27

for objects/collections, 6-23

JDBC mapping, 6-27

object JDBC mapping, 6-27

options in JPublisher, 6-26

Oracle mapping, 6-27

type resolution, expand search, 8-58

type support

for JDBC 2.0, 5-7

for Oracle8i, 5-2

for Oracle8/Oracle7, 5-9

types option (JPublisher -types), 6-24

uninstall option (AuditorInstaller), A-28

update batching

batch limit, A-12

batchable and compatible statements, A-6

batching incompatible statements, A-13

canceling a batch, A-10

cautions, A-15

enabling and disabling, A-7

error conditions during execution, A-15

explicit and implicit batch execution, A-8

overview, A-6

update counts, A-11

using implicit execution contexts, A-14

with respect to recursive call-ins, A-16

updateColumns/ForUpdate (WITH clause), 3-7

url option (customizer harness), 10-19

url option for checking (sqlj -url), 8-38

URL, default prefix for online checking, 8-40

user option (customizer harness), 10-18

user option (JPublisher -user), 6-24

user option for checking (sqlj -user), 8-31

user-defined types, 6-15

usertypes option (JPublisher -usertypes), 6-26

VALUES syntax for stored functions, 3-58

VARRAYs

sample application, 12-45

types, 6-4

verbose option (customizer harness), 10-17

verify option (customizer harness), 10-21

version compatibility (Oracle customizer), 10-24

version number options (sqlj -version-xxxx), 8-23

VM

classpath option, 8-20

options through SQLJ, 8-49

specifying name, 8-66

vm option (sqlj -vm), 8-66

warn option (SQLCheckerCustomizer), 10-42

warn option (sqlj -warn), 8-42

warning messages, translator, 9-12

warnings, translator, enabling/disabling, 8-42

weak object/collection types

restrictions, 6-67

support, 6-66

weakly typed iterators, 7-35

WHERE CURRENT OF, 5-34

Windows, SQLJ development in, 1-22

WITH clause syntax, 3-6

wrapper classes for null-handling, 4-21

wrapper methods (JPub), generating, 6-29