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

AuditorInstaller

command-line examples, A-27

customizer for debugging, A-20

invoking, A-21

options, A-24

runtime output, A-22

auditors in profiles for debugging, A-20

auto-commit

modifying, 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-14

enabling and disabling, A-7

error conditions during execution, A-15

explicit and implicit batch execution, A-8

overview, A-5

update counts, A-11

using implicit execution contexts, A-14

with respect to recursive call-ins, A-16

BetterDate (custom Java class), 12-48

BFILE support, 5-26

BFILEs

as stored function results, 5-30

BigDecimal mapping (for attributes), 6-30

BigDecimal support, 5-38

binary portability of profiles, 1-7

BLOB support, 5-26

BOOLEAN type (PL/SQL), 5-8

builtintypes option (JPublisher -builtintypes), 6-30

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

cache option (sqlj -cache), 8-62

caching online checker results, 8-62

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

cause/action output for errors, 8-45

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

check sources, expand resolution search, 8-57

checker option (SQLCheckerCustomizer), 10-40

checkfilename option (sqlj -checkfilename), 8-69

checksource option (sqlj -checksource), 8-57

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-15, 4-18

CLOSE_CONNECTION, 7-40

code generation, 9-5

code layers in profiles, A-20

code-parsing, 9-2

collections

about custom Java classes, 6-6

creating collection types, 6-20

CustomDatum specifications, 6-6

datatypes, 6-5

fundamentals, 6-4

introduction to collection support, 6-2

mapping to alternative classes, 6-33

nested tables sample application, 12-36

specifying type mapping, 6-26, 6-29

strongly typed in SQLJ, 6-54

VARRAYs sample application, 12-45

weak types, restrictions, 6-72

weak types, support, 6-71

column definitions (types/sizes), A-16

command line (translator)

echoing without executing, 8-13

example, 8-12

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, 4-30

specifying auto-commit, 4-29

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

compilation

compiling in two passes, 8-70

debug option in server, 11-17

during translation, 9-8

enabling/disabling, 8-53

in server, 11-5

compile option (sqlj -compile), 8-53

compiler

classpath option, 8-20

options through SQLJ, 8-49

related options, 8-64

required behavior, 8-66

specifying name, 8-66

compiler encoding support option (sqlj), 8-67

compiler executable option (sqlj), 8-66

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

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

configuration and installation verification, 2-6

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

connection contexts

connection properties file, 12-2

connections

closing, 4-12

closing shared connections with JDBC, 7-40

database connection in server, 11-3

JDBC transaction methods, 7-34

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

shared connections with JDBC, 7-39

single or multiple using default context, 4-8

specifying auto-commit, 4-29

translator options, 8-30

verify, 2-10

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

custom Java classes

about custom Java classes, 6-6

compiling, 6-15

creation by JPublisher, 6-23

examples, 6-38

extending, 6-42

generation by JPublisher, 6-26

mapping to alternative classes, 6-33

reading and writing data, 6-16

requirements, 6-10

sample class, 12-48

specifying member names, 6-36

support for object methods, 6-9

using to serialize object, 6-63

CustomDatum

additional uses, 6-16

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

defining column types/sizes, 10-25

defining parameter sizes, 10-27

during translation, 9-10

enabling/disabling, 8-54

error and status messages, 10-9

force customization, 10-24

jar file usage, 10-36

more about customization, 10-5

options, 10-11

options to invoke special customizers, 10-19

Oracle customizer options, 10-23

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

parameter default sizes, 10-29

related SQLJ options, 10-34

show SQL transformations, 10-31

statement cache size, 10-32

steps in process, 10-6

summary of Oracle features used, 10-33

version compatibility, 10-23

customizer harness

connection options, 10-17

general options, 10-13

invoke special customizers, 10-19

options overview, 10-11

overview, 10-5

customizer option (customizer harness), 10-14

customizers

choosing, 10-11

option to choose customizer, 10-14

overview, 10-5

passing options through SQLJ, 8-51

specifying default, 8-71

d option (sqlj -d), 8-27

database connection, verify, 2-10

dataSource (connection context WITH clause), 3-7

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

AuditorInstaller customizer, A-20

AuditorInstaller options, A-24

AuditorInstaller runtime output, A-22

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

debug option, customizer harness, 10-20

in JDeveloper, A-30

invoking AuditorInstaller, A-21

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

default output device in server, 11-4

default properties files (translator), 8-16

default semantics-checker, 8-58

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

depth option (AuditorInstaller), A-24

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

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

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

outputting cause and action, 8-45

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

processing, 4-24

set up exception-handling, 4-33

using SQLException subclasses, 4-26

executable statements

examples, 3-12

overview, 3-9

rules, 3-9

specifying connection/execution contexts, 3-11

SQLJ clauses, 3-9

using PL/SQL blocks, 3-13

execution contexts

cancellation method, 7-20

control methods, 7-19

creating and specifying, 7-16

method usage, example, 7-21

overview, 7-15

relation to connection contexts, 7-15

relation to multithreading, 7-22

specifying for executable statement, 3-11

status methods, 7-18

synchronization, 7-17

update-batching methods, 7-21

exemplar schema, 4-19

exit codes, translator, 9-15

explain option (sqlj -explain), 8-45

extending JPub-generated classes, 6-42

extensions

overview, 1-8

summary of features used, 10-33

type extensions, 5-25

file name requirements and restrictions, 4-4

flags for special processing, 8-53

force option (Oracle customizer), 10-24

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

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

overview, 3-15

restrictions, 3-31

sample application, 12-13

selecting a nested table, 6-56

type support for JDBC 2.0, 5-6

type support for Oracle8i, 5-2

type support for Oracle8/Oracle7, 5-9

IDE SQLJ integration, 1-23

IMPLEMENTS clause

in connection context declarations, 7-10

in iterator declarations, 7-26

syntax, 3-5

importing required classes, 4-32

informational messages, translator, 9-12

input to translator, 1-11

INSENSITIVE (cursor state), 3-7

installation and configuration verification, 2-6

instrumenting class file (linemap), 8-46

interoperability with JDBC

connection contexts and connections, 7-36

iterators and result sets, 7-41

sample application, 12-58

introduction to SQLJ, 1-2

isolation level settings (transactions), 7-33

iterators

accessing named iterators, 3-43

accessing positional iterators, 3-46

as host variables, 3-48

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

converting to result sets, 7-42

declarations, 3-3

declaring named iterators, 3-41

declaring positional iterators, 3-45

declaring with IMPLEMENTS clause, 7-26

general steps in using, 3-38

instantiating/populating named iterators, 3-42

iterator class functionality, 7-25

named iterator sample application, 12-5

named vs. positional, 3-39

nested iterators for nested tables, 6-59

overview, 3-35

positional iterator sample application, 12-9

selecting objects and references, 6-48

set up named iterator (example), 4-36

subclassing, 7-27

subclassing, sample application, 12-64

using named iterators, 3-40

using positional iterators, 3-44

using weakly typed iterators, 7-43

with serialized objects, 6-68

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

jar file digests option, customization, 10-15

jar files for profiles, 10-36

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

specifying name, 8-65

javac compatibility, 8-9

JDBC 2.0

Oracle requirements for use, 5-8

support, 5-6

types supported, 5-7

JDBC connection methods (transactions), 7-34

JDBC considerations in server, 11-3

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

JDBC interoperability

connection contexts and connections, 7-36

iterators and result sets, 7-41

sample application, 12-58

JDBC mapping (for attributes), 6-30

JDBC vs. SQLJ, sample application, 12-90

jdblinemap option (sqlj -jdblinemap), 8-47

JDeveloper

debugging with, A-30

SQLJ integration, 1-23

JDK

appropriate JDBC class files, 2-6

supported versions, 2-4

JPublisher

JServer (Java Option) configuration, 2-4

KEEP_CONNECTION, 7-40

language support (NLS), 9-21

linemap option (sqlj -linemap), 8-46

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

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

loading classes/resources into server, 11-7

loading into server

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

locale

command line example, 9-24

for messages, 9-23

setting at runtime, 9-25

log option (AuditorInstaller), A-25

mapping to alternative classes (UDTs), 6-33

member names (objects), 6-36

message pipe, compiler, 8-68

method support for objects, 6-9

method wrappers (JPub)

implementation, 6-37

multiple connections, sample application, 12-60

multithreading

in server, 11-24

in SQLJ, overview, 7-23

relation to execution contexts, 7-22

sample application, 12-56

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

name of compiler, 8-66

name of Java VM, 8-65

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

nested tables

accessing, 6-54

inserting in SQLJ, 6-55

manipulating, 6-58

sample application, 12-36

selecting into host expression, 6-56

types, 6-4

using nested iterator, 6-59

NLS support

overview, 1-23

translator and runtime, 9-19

non-repeatable reads, 7-33

null-handling

examples, 4-21

wrapper classes for null-handling, 4-20

numbertypes option (JPublisher -numbertypes), 6-29

object method wrappers (JPub), 6-37

object references

selecting into iterators, 6-48

strongly typed in SQLJ, 6-48

updating in SQLJ, 6-52

weak types, restrictions, 6-72

weak types, support, 6-71

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

objects

OCI drivers (JDBC), 4-6

offline checking

default checker, Oracle checkers, 8-58

specifying checker, 8-59

offline option (sqlj -offline), 8-59

online checking

caching results, 8-62

default checker, Oracle checkers, 8-58

enabling in server, 11-16

enabling, setting user schema, 8-31

registering drivers, 8-41

setting default URL prefix, 8-40

setting password, 8-35

setting URL, 8-37

specifying checker, 8-61

online option (in server), 11-16

online option (sqlj -online), 8-61

optcols option (Oracle customizer), 10-25

optimizer, SQL, A-2

options (translator)

command line only, 8-19

flags for special processing, 8-53

for connections, 8-30

for customization, 8-71

for javac compatibility, 8-9

for loadjava compatibility, 8-8

for output files and directories, 8-25

for reporting and line mapping, 8-41

for semantics-checking, 8-57

for VM and compiler, 8-64

help, 8-21

order of precedence, 8-17

overview, 8-3

prefixes for passing options, 8-48

summary list, 8-4

support for alternative environments, 8-64

options for customizer harness

connection options, 10-17

general options, 10-13

invoke special customizers, 10-19

overview, 10-11

options for Oracle customizer, 10-23

options for translation in server, 11-15

options, setting in server, 11-17

optparamdefaults option (Oracle customizer), 10-29

optparams option (Oracle customizer), 10-27

Oracle class

close() method parameters, 4-15

connect() method, 4-14

for DefaultContext instances, 4-14

getConnection() method, 4-14

Oracle customizer

force flag, 10-24

optcols flag, 10-25

options, 10-23

optparamdefaults option, 10-29

optparams flag, 10-27

show SQL transformation, 10-31

statement cache size, 10-32

summary of Oracle features used, 10-33

version compatibility, 10-23

Oracle extensions

overview, 1-8

summary of features used, 10-33

type extensions, 5-25

Oracle Lite with SQLJ, 1-20

Oracle mapping (for attributes), 6-30

Oracle optimizer, A-2

OracleChecker default checker, 8-58

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

output file for compiler, 8-68

output from server-side translator, 11-18

output from translator, 1-11

output pipe, compiler messages, 8-68

output, server-side translator errors, 11-22

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

parameter definitions (sizes), A-17

passes option (sqlj -passes), 8-70

passes, two-pass compiling, 8-70

passing options to other executables, 8-48

password option (customizer harness), 10-18

password option for checking (sqlj), 8-35

path (connection context WITH clause), 3-7

path and classpath, 2-6

performance enhancements, A-2

phantom reads, 7-33

pipe, compiler output messages, 8-68

PL/SQL blocks in executable statements, 3-13

PL/SQL BOOLEAN type, 5-8

PL/SQL RECORD type, 5-8

PL/SQL TABLE type, 5-8

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

positional iterators

accessing, 3-46

declaring, 3-45

instantiating and populating, 3-46

using, 3-44

positioned delete, 5-34

positioned update, 5-34

prefetching rows, A-3

prefix option (AuditorInstaller), A-25

prefixes

to pass options to customizer, 8-51

to pass options to Java compiler, 8-49

to pass options to Java VM, 8-48

print option (customizer harness), 10-20

procedure calls, stored, 3-57

profile customization (see customization), 9-10

profile option (sqlj -profile), 8-54

profile-keys class, 9-6

profiles

auditors for debugging, A-20

binary portability, 1-7

code layers, A-20

creation during code generation, 10-2

debug option, 10-20

functionality at runtime, 10-9

generated profiles, 9-6

more about profiles, 10-2

naming generated profiles in server, 11-21

overview, 1-6

print option, 10-20

sample profile entry, 10-3

use of jar files, 10-36

verify option, 10-21

properties files (translator)

default properties files, 8-16

example, 12-2

overview, 8-13

setting input file, 8-19

syntax, 8-14

properties, Java, getProperty(), 9-25

props option (sqlj -props), 8-19

public class name / source name check, 8-69

READ COMMITTED transactions, 7-33

READ ONLY transactions, 7-33

READ UNCOMMITTED transactions, 7-33

READ WRITE transactions, 7-33

RECORD type (PL/SQL), 5-8

recursive SQLJ calls in server, 11-24

REF CURSOR

about REF CURSOR types, 5-36

example, 5-37

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

REPEATABLE READ transactions, 7-33

reporting options (translator), 8-41

requirements, environment, 2-2

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

as iterator columns, 3-52

as stored function returns, 3-60

commit/rollback effect, 4-31

converting from iterators, 7-42

converting to iterators, 7-41

persistence across calls in server, 11-3

ResultSetIterator (weakly typed), 7-43

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

SELECT INTO ROWID host variable, 5-35

support, 5-33

runtime

categories of errors, 9-18

debugging output (AuditorInstaller), A-22

error list, B-44

functionality, 9-16

functionality of profiles, 10-9

generated calls to runtime, 9-8

JDBC driver selection and registration, 4-7

NLS support, 9-19

overview, 1-5

packages, 9-16

set up connection, 2-9

steps in runtime processing, 1-14

test, 2-11

sample applications

host expressions, 12-13

interoperability with JDBC, 12-58

JDBC vs. SQLJ, 12-90

multiple connection contexts, 7-7, 12-61

multiple connection schemas, 12-60

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

multithreading, 12-56

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

VARRAYs, 12-45

sample classes

custom Java class (BetterDate), 12-48

SerializableDatum class, 6-69

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

default checker, Oracle checkers, 8-58

enabling online in server, 11-16

enabling online, setting user schema, 8-31

invoking SQLCheckerCustomizer, 10-38

of profiles, via customizer harness, 10-21

options, 8-57

registering drivers, 8-41

setting default URL prefix, 8-40

setting password, 8-35

setting URL, 8-37

specifying offline checker, 8-59

specifying online checker, 8-61

SQLCheckerCustomizer options, 10-39

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

serialized objects

as host variables, 6-68

in iterator columns, 6-68

SerializableDatum class (sample), 6-69

through custom Java class, 6-63

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

loading classes/resources into server, 11-7

loading source into server, translating, 11-13

naming gen'ed resource schema objects, 11-21

naming generated class schema objects, 11-20

naming generated profiles, 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-19

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

setup, testing, 2-9

showReturns option (AuditorInstaller), A-26

showSQL option (Oracle customizer), 10-31

showThreads option (AuditorInstaller), A-27

source check for type resolution, 8-57

source file line-mapping, 8-46

source file line-mapping for jdb, 8-47

source files encoding option, 8-26

source name / public class name check, 8-69

source schema object naming, 11-19

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

SQL optimizer, A-2

sql option (JPublisher -sql), 6-26

SQL states (for errors), 4-25

SQLCheckerCustomizer

for semantics-checking of profiles, 10-38

invoking, 10-38

options, 10-39

SQLData

specifications, 6-8

SQLException subclasses, using, 4-26

SQLJ properties file example, 12-2

SQLJ vs. JDBC, sample application, 12-90

SQLJ_OPTIONS environment variable, 8-17

sqljutl package, 2-8

statement caching, A-3

status messages

for customization, 10-9

for translation, 9-14

translator, enabling/disabling, 8-44

status option (sqlj -status), 8-44

stmtcache option (Oracle customizer), 10-32

stored function calls, 3-58

stored procedure calls, 3-57

streams

as function return values, 5-22

as output parameters, 5-21

classes and methods, 5-23

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 in SQLJ, 6-54

strongly typed objects and references, 6-48

subclassing iterator classes, 7-27

summary option (Oracle customizer), 10-33

Sun JDK

appropriate JDBC class files, 2-6

supported versions, 2-4

synchronization of execution contexts, 7-17

syntax

translator command line, 8-10

translator properties files, 8-14

syntax-checking, 9-2

TABLE syntax (nested tables), 6-54, 6-58

TABLE type (PL/SQL), 5-8

Thin driver (JDBC), 4-6

transactions

access mode settings, 7-33

advanced transaction control, 7-32

automatic commit vs. manual commit, 4-28

basic transaction control, 4-28

isolation level settings, 7-33

JDBC Connection methods, 7-34

manual commit and rollback, 4-30

modifying auto-commit, 4-30

overview, 4-28

specifying auto-commit, 4-29

transformGroup (connection context WITH clause), 3-7

TRANSLATE (object member names), 6-36

translating in server to run in server, 11-13

translating on client to run in server, 11-7

translator

basic translation steps, 1-9

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

internal operations, 9-2

NLS support, 9-19

output, server-side, 11-18

overview, 1-5

semantics-checking, 9-2

status messages, 9-14

test, 2-11

translator support, alternative environments, 8-64

type extensions, 5-25

type mapping

BigDecimal mapping, 6-30

JDBC mapping, 6-30

object JDBC mapping, 6-30

Oracle mapping, 6-30

type mapping for objects/collections, 6-26

type mapping, objects and collections, 6-29

type resolution, expand search, 8-57

type support

for JDBC 2.0, 5-6

for Oracle8i, 5-2

for Oracle8/Oracle7, 5-9

typeMap (connection context WITH clause), 3-7

types option (JPublisher -types), 6-27

uninstall option (AuditorInstaller), A-27

update batching

batch limit, A-12

batchable and compatible statements, A-6

batching incompatible statements, A-13

canceling a batch, A-10

cautions, A-14

enabling and disabling, A-7

error conditions during execution, A-15

explicit and implicit batch execution, A-8

overview, A-5

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

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

URL, default prefix for online checking, 8-40

user option (customizer harness), 10-17

user option (JPublisher -user), 6-27

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

user-defined types, 6-18

usertypes option (JPublisher -usertypes), 6-29

VALUES syntax for stored functions, 3-58

VARRAY types, 6-4

VARRAYs

sample application, 12-45

verbose option (customizer harness), 10-16

verify option (customizer harness), 10-21

version compatibility (Oracle customizer), 10-23

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

VM

classpath option, 8-20

options through SQLJ, 8-48

specifying name, 8-65

vm option (sqlj -vm), 8-65

warn option (SQLCheckerCustomizer), 10-40

warn option (sqlj -warn), 8-42

warning messages, translator, 9-12

warnings, translator, enabling/disabling, 8-42

weak object/collection types

restrictions, 6-72

support, 6-71

weakly typed iterators, 7-43

WHERE CURRENT OF, 5-34

Windows, SQLJ development in, 1-24

WITH clause syntax, 3-6

wrapper classes for null-handling, 4-20

wrapper methods (JPub)

generating, 6-32