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

AuditorInstaller

command-line examples, A-8

customizer for debugging, A-4

invoking, A-5

options, A-6

runtime output, A-9

auditors in profiles for debugging, A-4

auto-commit

modifying, 4-26

not supported in server, 11-4

specifying as you define connection, 4-25

backup option (customizer harness), 10-12

backwards compatibility to Oracle8/Oracle7, 5-6

BetterDate (custom Java class), 12-47

BFILE support, 5-23

BigDecimal support, 5-35

binary portability of profiles, 1-5

BLOB support, 5-23

BOOLEAN type (PL/SQL), 5-5

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

cache option (sqlj -cache), 8-61

caching online checker results, 8-61

CALL syntax for stored procedures, 3-56

calling stored functions, 3-57

calling stored procedures, 3-56

calls to runtime, generated, 9-7

case option (JPublisher -case), 6-22

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

class loading in server, 11-27

class schema object naming

generated, 11-21

loaded, 11-9

classpath and path, 2-4

classpath option (sqlj -classpath), 8-21

clauses, SQLJ executable statements, 3-9

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

CLOB support, 5-23

CLOSE_CONNECTION, 7-9

code generation, 9-5

code layers in profiles, A-4

code-parsing, 9-2

collections

about custom Java classes, 6-6

creating collection types, 6-15

CustomDatum specifications, 6-6

datatypes, 6-5

fundamentals, 6-4

introduction to collection support, 6-2

mapping to alternative classes, 6-24

nested tables sample application, 12-35

specifying element mapping, 6-22

specifying type mapping, 6-20

strongly typed in SQLJ, 6-47

VARRAYs sample application, 12-43

weak types, restrictions, 6-63

weak types, support, 6-62

command line (translator)

echoing without executing, 8-13

example, 8-13

overview, 8-2

syntax and arguments, 8-10

commit

automatic vs. manual, 4-24

effect on iterators and result sets, 4-27

manual, 4-26

modifying auto-commit, 4-26

specifying auto-commit, 4-25

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

compilation

compiling in two passes, 8-67

debug option in server, 11-17

during translation, 9-8

enabling/disabling, 8-52

in server, 11-27

compile option (sqlj -compile), 8-52

compiler

classpath option, 8-21

options through SQLJ, 8-48

related options, 8-63

required behavior, 8-62

specifying name, 8-64

compiler encoding support option (sqlj), 8-65

compiler executable option (sqlj), 8-64

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

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

configuration and installation verification, 2-4

connection contexts

connection properties file, 12-2

connections

closing shared connections with JDBC, 7-30

database connection in server, 11-3

JDBC transaction methods, 7-26

modifying auto-commit, 4-26

multiple, sample application, 12-58

multiple, using declared connect contexts, 4-13

Oracle class to connect, 4-13

set up, 2-6

shared connections with JDBC, 7-30

single or multiple using default context, 4-9

specifying auto-commit, 4-25

translator options, 8-31

verify, 2-7

connect.properties file, 12-2

context expressions

evaluation at runtime, 3-20

overview, 3-19

context option (customizer harness), 10-13

converting .ser profiles to .class, 8-54

CORBA server objects with SQLJ, 11-36

CURSOR syntax (nested tables), 6-47

custom Java classes

about custom Java classes, 6-6

compiling, 6-10

creation by JPublisher, 6-18

examples, 6-29

extending or wrapping, 6-33

generation by JPublisher, 6-19

mapping to alternative classes, 6-24

reading and writing data, 6-11

requirements, 6-8

sample class, 12-47

specifying member names, 6-27

support for object methods, 6-8

uses, 6-11

using to serialize object, 6-56

CustomDatum specifications, 6-6

customization

converting .ser profiles to .class, 8-54

creation and registration, 10-7

customizer harness options, 10-11

during translation, 9-10

enabling/disabling, 8-53

error and status messages, 10-9

force customization, 10-22

jar file usage, 10-26

more about customization, 10-5

options, 10-11

Oracle customizer options, 10-20

related SQLJ options, 10-25

show SQL transformations, 10-23

steps in process, 10-6

summary of Oracle features used, 10-24

version compatibility, 10-21

customizer harness

options, 10-11

overview, 10-5

customizer option (customizer harness), 10-13

customizers

choosing, 10-11

option to choose customizer, 10-13

overview, 10-5

passing options through SQLJ, 8-50

specifying default, 8-69

d option (sqlj -d), 8-28

database connection, verify, 2-7

DBMS_JAVA package

full/short name conversion, 11-25

setting server-side options, 11-18

DBMS_LOB package, 5-23

debug option (customizer harness), 10-19

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

debugging

AuditorInstaller command-line examples, A-8

AuditorInstaller customizer, A-4

AuditorInstaller options, A-6

AuditorInstaller runtime output, A-9

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

debug option, customizer harness, 10-19

in JDeveloper, A-11

invoking AuditorInstaller, A-5

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

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

setting with setDefaultContext(), 4-12

default customizer option (sqlj), 8-69

default output device in server, 11-5

default properties files (translator), 8-16

default semantics-checker, 8-56

default URL prefix option (sqlj), 8-39

DefaultContext class

key methods, 4-14

use for single or multiple connections, 4-9

depth option (AuditorInstaller, debugging), A-6

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

dir option (sqlj -dir), 8-29

directory

for generated .class and .ser, 8-28

for generated .java, 8-29

dirty reads, 7-25

driver option (customizer harness), 10-18

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

dropjava, 11-30

dropping Java schema objects, 11-30

echo option, without execution, 8-25

echoing command line without executing, 8-13

element mapping, collections, 6-22

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

overview of character encoding, 9-20

setting at runtime, 9-25

specifying in server, 11-16

using native2ascii, 9-25

encoding option (in server), 11-16

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

Enterprise JavaBeans with SQLJ, 11-35

environment assumptions and requirements, 2-2

environment variable, translator options, 8-17

errors

character encoding for messages, 9-23

customization messages, 10-9

error codes, 4-22

outputting cause and action, 8-45

runtime categories, 9-18

runtime error list, B-42

server-side error output, 11-22

SQL states, 4-22

translator error list, B-2

translator error, warning, info messages, 9-12

exceptions

exception-handling requirements, 4-20

processing, 4-21

set up exception-handling, 4-29

using SQLException subclasses, 4-23

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

control methods, 7-17

creating and specifying, 7-14

method usage, example, 7-18

overview, 7-13

relation to connection contexts, 7-13

relation to multithreading, 7-18

specifying for executable statement, 3-11

status methods, 7-16

synchronization, 7-15

exit codes, translator, 9-15

explain option (sqlj -explain), 8-45

extending JPub-generated classes, 6-33

extensions

overview, 1-6

summary of features used, 10-24

type extensions, 5-22

file name requirements and restrictions, 4-4

flags for special processing, 8-52

force option (Oracle customizer), 10-22

ForUpdate/updateColumns (WITH clause), 3-7

full names vs. short names in server, 11-24

function calls, stored, 3-57

help option (customizer harness), 10-15

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

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

overview, 3-15

restrictions, 3-30

sample application, 12-12

selecting a nested table, 6-49

type support for Oracle8i, 5-2

type support for Oracle8/Oracle7, 5-6

IDE SQLJ integration, 1-19

IMPLEMENTS clause

in connection context declarations, 7-10

in iterator declarations, 7-22

syntax, 3-5

importing required classes, 4-28

informational messages, translator, 9-12

input to translator, 1-10

INSENSITIVE (cursor state), 3-7

installation and configuration verification, 2-4

instrumenting class file (linemap), 8-45

interoperability with JDBC

connection contexts and connections, 7-27

iterators and result sets, 7-31

sample application, 12-57

introduction to SQLJ, 1-2

isolation level settings (transactions), 7-25

iterators

accessing named iterators, 3-42

accessing positional iterators, 3-45

as host variables, 3-47

as iterator columns (nested), 3-50

as stored function returns, 3-59

commit/rollback effect, 4-27

concepts, 3-34

converting from result sets, 7-31

converting to result sets, 7-33

declarations, 3-3

declaring named iterators, 3-40

declaring positional iterators, 3-44

declaring with IMPLEMENTS clause, 7-22

general steps in using, 3-37

instantiating/populating named iterators, 3-41

iterator class functionality, 7-21

named iterator sample application, 12-5

named vs. positional, 3-38

nested iterators for nested tables, 6-52

overview, 3-34

positional iterator sample application, 12-9

selecting objects and references, 6-41

set up named iterator (example), 4-31

using named iterators, 3-39

using positional iterators, 3-43

using weakly typed iterators, 7-34

with serialized objects, 6-59

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

jar file digests option, customization, 10-14

jar files for profiles, 10-26

Java name resolution in server, 11-27

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

Java Option (JServer) configuration, 2-3

Java properties, getProperty(), 9-25

Java VM

classpath option, 8-21

options through SQLJ, 8-47

specifying name, 8-64

javac compatibility, 8-9

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

select for translation, 4-7

select/register for customization, 10-18

select/register for runtime, 4-7

verify, 2-8

JDBC interoperability

connection contexts and connections, 7-27

iterators and result sets, 7-31

sample application, 12-57

JDBC type mapping (JPub), 6-23

JDBC vs. SQLJ, sample application, 12-67

JDeveloper

debugging with, A-11

SQLJ integration, 1-19

JDK resolver spec (in server), 11-29

JPublisher

attribute and element mapping, 6-22

case option, 6-22

creation of custom Java classes, 6-18

custom Java class examples, 6-29

extending generated classes, 6-33

generating custom Java classes, 6-19

generating method wrappers, 6-23

implementation of method wrappers, 6-28

input files, 6-26

mapping option, 6-22

mapping to alternative classes, 6-24

properties files, 6-27

specifying member names, 6-27

specifying type mapping, 6-20

sql option, 6-20

types option, 6-20

user option, 6-21

what JPublisher produces, 6-18

wrapping generated classes, 6-33

JServer (Java Option) configuration, 2-3

KEEP_CONNECTION, 7-9

language support (NLS), 9-21

linemap option (sqlj -linemap), 8-45

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

loading classes/resources into server, 11-6

loading into server

checking uploads, 11-24

source, translating, 11-13

loadjava

loading classes/resources, 11-6

loading source, translating, 11-13

output from loading source, 11-19

resolving classes, 11-29

loadjava compatibility options, SQLJ, 8-8

LOBs

as iterator columns, 5-28

as stored function results, 5-27

FETCH INTO LOB host variables, 5-29

SELECT INTO LOB host variables, 5-28

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

locale

command line example, 9-24

for messages, 9-23

setting at runtime, 9-25

log option (AuditorInstaller, debugging), A-7

mapping option (JPublisher -mapping), 6-22

mapping to alternative classes (UDTs), 6-24

member names (objects), 6-27

message pipe, compiler, 8-66

method support for objects, 6-8

method wrappers (JPub)

generating, 6-23

implementation, 6-28

multiple connections, sample application, 12-58

multithreading

in server, 11-32

in SQLJ, overview, 7-19

relation to execution contexts, 7-18

sample application, 12-55

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

name of compiler, 8-64

name of Java VM, 8-64

name resolution in server, 11-27

named iterators

accessing, 3-42

declaring, 3-40

instantiating and populating, 3-41

using, 3-39

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

generated profile, 11-21

loaded classes, 11-9

loaded resources, 11-10

source, 11-20

native2ascii for encoding, 9-25

nested iterators, 6-52

nested tables

accessing, 6-47

inserting in SQLJ, 6-48

manipulating, 6-51

sample application, 12-35

selecting into host expression, 6-49

types, 6-4

using nested iterator, 6-52

NLS support

overview, 1-19

translator and runtime, 9-19

non-repeatable reads, 7-25

null-handling

examples, 4-19

wrapper classes for null-handling, 4-18

object JDBC type mapping (JPub), 6-23

object method wrappers (JPub), 6-28

object references

selecting into iterators, 6-41

strongly typed in SQLJ, 6-41

updating in SQLJ, 6-45

weak types, restrictions, 6-63

weak types, support, 6-62

objects

offline checking

default checker, Oracle checkers, 8-56

specifying checker, 8-57

offline option (sqlj -offline), 8-57

online checking

caching results, 8-61

default checker, Oracle checkers, 8-56

enabling in server, 11-17

enabling, setting user schema, 8-31

registering drivers, 8-41

setting default URL prefix, 8-39

setting password, 8-35

setting URL, 8-37

specifying checker, 8-59

online option (in server), 11-17

online option (sqlj -online), 8-59

optimizer, SQL, A-3

options (translator)

command line only, 8-20

flags for special processing, 8-52

for connections, 8-31

for customization, 8-69

for javac compatibility, 8-9

for loadjava compatibility, 8-8

for output files and directories, 8-26

for reporting and line mapping, 8-41

for semantics-checking, 8-55

for VM and compiler, 8-63

help, 8-22

order of precedence, 8-17

overview, 8-3

prefixes for passing options, 8-47

summary list, 8-4

support for alternative environments, 8-62

options for customizer harness, 10-11

options for Oracle customizer, 10-20

options for translation in server, 11-16

options, setting in server, 11-18

Oracle class, 4-13

Oracle customizer

force flag, 10-22

options, 10-20

show SQL transformation, 10-23

summary of Oracle features used, 10-24

version compatibility, 10-21

Oracle extensions

overview, 1-6

summary of features used, 10-24

type extensions, 5-22

Oracle Lite with SQLJ, 1-16

Oracle optimizer, A-3

Oracle resolver (in server), 11-28

Oracle resolver spec (in server), 11-29

Oracle type mapping (JPub), 6-23

OracleChecker default checker, 8-56

oracle.sql package, 5-22

output device in server, default, 11-5

output directory

for generated .class and .ser, 8-28

for generated .java, 8-29

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

output file for compiler, 8-66

output from server-side translator, 11-19

output from translator, 1-10

output pipe, compiler messages, 8-66

output, server-side translator errors, 11-22

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

passes option (sqlj -passes), 8-67

passes, two-pass compiling, 8-67

passing options to other executables, 8-47

password option (customizer harness), 10-17

password option for checking (sqlj), 8-35

path and classpath, 2-4

performance enhancements, A-2

phantom reads, 7-25

pipe, compiler output messages, 8-66

PL/SQL blocks in executable statements, 3-13

PL/SQL BOOLEAN type, 5-5

PL/SQL RECORD type, 5-5

PL/SQL TABLE type, 5-5

positional iterators

accessing, 3-45

declaring, 3-44

instantiating and populating, 3-44

using, 3-43

positioned delete, 5-30

positioned update, 5-30

prefetching rows, A-2

prefix option (AuditorInstaller, debugging), A-7

prefixes

to pass options to customizer, 8-50

to pass options to Java compiler, 8-48

to pass options to Java VM, 8-47

print option (customizer harness), 10-18

procedure calls, stored, 3-56

profile customization (see customization), 9-10

profile option (sqlj -profile), 8-53

profile-keys class, 9-6

profiles

auditors for debugging, A-4

binary portability, 1-5

code layers, A-4

creation during code generation, 10-2

debug option, 10-19

functionality at runtime, 10-9

generated profiles, 9-6

more about profiles, 10-2

naming generated profiles in server, 11-21

overview, 1-3

print option, 10-18

sample profile entry, 10-3

use of jar files, 10-26

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

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

recursive SQLJ calls in server, 11-32

REF CURSOR

about REF CURSOR types, 5-33

example, 5-34

sample application, 12-52

SQLJ support, 5-33

register JDBC drivers

for runtime, 4-7

for translation, 8-41

REPEATABLE READ transactions, 7-25

reporting options (translator), 8-41

requirements, environment, 2-3

resolver specs (in server), 11-29

resolver, Oracle (in server), 11-28

resource schema object naming

generated, 11-21

loaded, 11-10

result expressions

evaluation at runtime, 3-20

overview, 3-19

result sets

as host variables, 3-47

as iterator columns, 3-50

as stored function returns, 3-59

commit/rollback effect, 4-27

converting from iterators, 7-33

converting to iterators, 7-31

persistence across calls in server, 11-4

ResultSetIterator (weakly typed), 7-34

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

rollback

effect on iterators and result sets, 4-27

manual, 4-26

row prefetching, A-2

ROWID

as stored function results, 5-31

FETCH INTO ROWID host variable, 5-32

SELECT INTO ROWID host variable, 5-32

support, 5-30

runtime

categories of errors, 9-18

debugging output (AuditorInstaller), A-9

error list, B-42

functionality, 9-16

functionality of profiles, 10-9

generated calls to runtime, 9-7

JDBC driver selection and registration, 4-7

NLS support, 9-19

overview, 1-3

packages, 9-16

set up connection, 2-6

steps in runtime processing, 1-9

test, 2-8

sample applications

host expressions, 12-12

interoperability with JDBC, 12-57

JDBC vs. SQLJ, 12-67

multiple connection contexts, 7-7, 12-59

multiple connection schemas, 12-58

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

multithreading, 12-55

named iterator, 12-5

nested tables, 12-35

objects, 12-26

positional iterator, 12-9

REF CURSOR, 12-52

row prefetching, 12-62

server-side SQLJ, 12-66

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

VARRAYs, 12-43

sample classes

custom Java class (BetterDate), 12-47

SerializableDatum class, 6-60

schema objects

naming generated classes, 11-21

naming generated resources, 11-21

naming loaded classes, 11-9

naming loaded resources, 11-10

naming sources, 11-20

SELECT INTO statements, 3-31

semantics-checking

caching online results, 8-61

default checker, Oracle checkers, 8-56

enabling online in server, 11-17

enabling online, setting user schema, 8-31

options, 8-55

registering drivers, 8-41

setting default URL prefix, 8-39

setting password, 8-35

setting URL, 8-37

specifying offline checker, 8-57

specifying online checker, 8-59

steps involved, 9-2

SENSITIVE (cursor state), 3-7

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

ser profiles (.ser)

converting to .class, 8-54

generated profiles, 9-6

ser2class option (sqlj -ser2class), 8-54

SERIALIZABLE transactions, 7-25

serialized objects

as host variables, 6-59

in iterator columns, 6-59

SerializableDatum class (sample), 6-60

through custom Java class, 6-56

server-side SQLJ

class loading, 11-27

coding considerations, 11-3

compilation, 11-27

connection to database, 11-3

CORBA objects, 11-36

default output device, 11-5

dropjava, 11-30

dropping Java schema objects, 11-30

Enterprise JavaBeans, 11-35

error output, 11-22

generated output from translation, 11-19

introduction, 11-2

Java multithreading, 11-32

Java name resolution, 11-27

JDBC differences, 11-4

loading classes/resources into server, 11-6

loading source into server, translating, 11-13

naming gen'ed resource schema objects, 11-21

naming generated class schema objects, 11-21

naming generated profiles, 11-21

naming loaded class schema objects, 11-9

naming loaded resource schema objects, 11-10

naming source schema objects, 11-20

options, 11-16

Oracle resolver, 11-28

overview, 1-15

recursive calls, 11-32

resolver specs, 11-29

running client program in server, 11-11

sample application, 12-66

setting options, 11-18

SQL names vs. Java names, 11-27

translating in server, 11-13

translating on client, 11-6

verifying code is running in server, 11-33

SET (assignment) statements, 3-54

SET TRANSACTION syntax, 7-24

setup, testing, 2-6

short names vs. full names in server, 11-24

showSQL option (Oracle customizer), 10-23

source file line-mapping, 8-45

source files encoding option, 8-27

source schema object naming, 11-20

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

SQL optimizer, A-3

sql option (JPublisher -sql), 6-20

SQL states (for errors), 4-22

SQLException subclasses, using, 4-23

SQLJ properties file example, 12-2

SQLJ vs. JDBC, sample application, 12-67

SQLJ_OPTIONS environment variable, 8-17

sqljutl package, 2-5

status messages

for customization, 10-9

for translation, 9-14

translator, enabling/disabling, 8-44

status option (sqlj -status), 8-44

stored function calls, 3-57

stored procedure calls, 3-56

streams

as function return values, 5-19

as output parameters, 5-18

classes and methods, 5-20

examples, 5-16

general use in SQLJ, 5-8

precautions, 5-12

processing, 5-15

retrieving data from database, 5-13

sending data to database, 5-9

supporting classes, 5-8

strongly typed collections in SQLJ, 6-47

strongly typed objects and references, 6-41

summary option (Oracle customizer), 10-24

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-47, 6-51

TABLE type (PL/SQL), 5-5

transactions

about transactions, 4-24

access mode settings, 7-25

advanced transaction control, 7-24

automatic commit vs. manual commit, 4-24

basic transaction control, 4-24

isolation level settings, 7-25

JDBC Connection methods, 7-26

manual commit and rollback, 4-26

modifying auto-commit, 4-26

specifying auto-commit, 4-25

TRANSLATE (object member names), 6-27

translating in server to run in server, 11-13

translating on client to run in server, 11-6

translator

basic translation steps, 1-7

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

overview, 1-3

semantics-checking, 9-2

status messages, 9-14

test, 2-8

translator support, alternative environments, 8-62

type extensions, 5-22

type mapping for objects/collections, 6-20

type support for Oracle8i, 5-2

type support for Oracle8/Oracle7, 5-6

types option (JPublisher -types), 6-20

uninstall option (AuditorInstaller, debugging), A-8

updateColumns/ForUpdate (WITH clause), 3-7

url option (customizer harness), 10-17

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

URL, default prefix for online checking, 8-39

user option (customizer harness), 10-16

user option (JPublisher -user), 6-21

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

USER_OBJECTS view, schema objects, 11-24

user-defined types, 6-13

VALUES syntax for stored functions, 3-57

VARRAY types, 6-4

VARRAYs

sample application, 12-43

verbose option (customizer harness), 10-16

version compatibility (Oracle customizer), 10-21

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

VM

classpath option, 8-21

options through SQLJ, 8-47

specifying name, 8-64

vm option (sqlj -vm), 8-64

warn option (sqlj -warn), 8-41

warning messages, translator, 9-12

warnings, translator, enabling/disabling, 8-41

weak object/collection types

restrictions, 6-63

support, 6-62

weakly typed iterators, 7-34

WHERE CURRENT OF, 5-30

Windows, SQLJ development in, 1-20

WITH clause syntax, 3-6

wrapper classes for null-handling, 4-18

wrapping JPub-generated classes, 6-33