Oracle9i SQLJ Developer's Guide and Reference -- Index

access mode settings (transactions), 7-50

alternative environments, support, 8-80

applets

using SQLJ, 1-25

ASENSITIVE (cursor state), 3-7

assignment statements (SET), 3-58

assumptions, environment, 2-2

AuditorInstaller

command-line examples, A-51

customizer for debugging, A-44

invoking, A-45

options, A-47

runtime output, A-46

auditors in profiles for debugging, A-44

auto-commit

modifying in existing connection, 4-28

not supported in server, 11-5

specifying in new connection, 4-27

backup option (customizer harness), A-14

backward compatibility

Oracle SQLJ, general, 2-9

to Oracle8i, 5-11

to Oracle8/Oracle7, 5-12

batch updates

batch limit, 10-19

batchable and compatible statements, 10-13

batching incompatible statements, 10-20

canceling a batch, 10-17

cautions, 10-22

enabling and disabling, 10-14

error conditions during execution, 10-22

explicit and implicit batch execution, 10-14

overview, 10-12

update counts, 10-18

using implicit execution contexts, 10-21

with respect to recursive call-ins, 10-23

BetterDate (custom Java class), 6-19

BFILEs

as stored function results, 5-34

BFILE support, 5-30

BigDecimal

mapping (for attributes), 6-38

support, 5-42

binary portability of profiles, 1-7

bind-by-identifier option (sqlj -bind-by-identifier), 8-70

BLOB support, 5-30

BOOLEAN type (PL/SQL), 5-9

builtintypes option (JPublisher -builtintypes), 6-37

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

cache option (sqlj -cache), 8-78

caching online checker results, 8-78

caching statements, 10-4

CALL syntax for stored procedures, 3-60

calling stored functions, 3-61

calling stored procedures, 3-60

calls to runtime, generated, 9-8

case option (JPublisher -case), 6-36

case-sensitive SQL UDT names, 6-13, 6-14, 6-34, 6-43

cause/action output for errors, 8-49

CHAR comparisons, blank padding, 8-58, A-32

character encoding

command line example, 9-25

for messages, 9-23

for source, 9-23

overview, 9-20

setting at runtime, 9-29

using native2ascii, 9-30

check source name against. public class, 8-85

check sources, expand resolution search, 8-69

checker option (SQLCheckerCustomizer), A-42

checkfilename option (sqlj -checkfilename), 8-85

checksource option (sqlj -checksource), 8-69

class loading in server, 11-7

class schema object naming

generated, 11-23

loaded, 11-12

classpath and path, 2-12

classpath option (sqlj -classpath), 8-23

clauses, SQLJ executable statements, 3-10

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

CLOB support, 5-30

close() method (DefaultContext), 4-17

close() method (ExecutionContext), 7-32

close() method (Oracle class), 4-14, 4-17

CLOSE_CONNECTION, 7-57

code generation

general information, 9-5

Oracle-specific vs. ISO standard, 4-39

translator -codegen option, 8-52

code layers in profiles, A-44

codegen option (SQLJ -codegen), 8-52

collections

about custom Java classes, 6-6

creating collection types, 6-25

datatypes, 6-5

fundamentals, 6-4

introduction to collection support, 6-2

mapping to alternative classes, 6-41

ORAData specifications, 6-7

specifying type mapping, 6-34, 6-37

strongly typed, 6-62

weak types, restrictions, 6-81

weak types, support, 6-80

column definitions (types/sizes)

general information, 10-23

Oracle customizer optcols option, A-27

SQLJ -optcols option, 8-53

command line (translator)

echoing without executing, 8-16

example, 8-15

overview, 8-2

syntax and arguments, 8-12

commit

automatic vs. manual, 4-26

effect on iterators and result sets, 4-29

manual, 4-28

modifying auto-commit in existing connection, 4-28

specifying auto-commit in new connection, 4-27

compat(ibility) option (Oracle customizer), A-25

compatible option (JPublisher -compatible), 6-33

compilation

compiling in two passes, 8-86

debug option in server, 11-20

during translation, 9-9

enabling/disabling, 8-65

in server, 11-7

compile option (sqlj -compile), 8-65

compiler

classpath option, 8-23

option support for javac, 8-10

options through SQLJ, 8-62

related options, 8-80

required behavior, 8-82

specifying name, 8-82

compiler encoding support option (sqlj), 8-83

compiler executable option (sqlj), 8-82

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

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

configuration and installation verification, 2-11

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

connection contexts

connections

closing, 4-11

closing shared connections with JDBC, 7-57

database connection in server, 11-4

from SQLJ data sources, 7-16, 7-20

JDBC transaction methods, 7-51

modifying auto-commit, 4-28

multiple, using declared connect contexts, 4-12

Oracle class to connect, 4-12

set up, 2-14

shared connections with JDBC, 7-56

single or multiple using default context, 4-6

specifying auto-commit, 4-27

translator options, 8-34

verify, 2-16

context expressions

evaluation at runtime, 3-22

overview, 3-21

context option (customizer harness), A-14

converting .ser profiles to .class, 8-68

CURSOR syntax (nested tables), 6-62

custom Java classes

about custom Java classes, 6-6

compiling, 6-17

creation by JPublisher, 6-28

examples, 6-47

extending, 6-51

generation by JPublisher, 6-32

mapping to alternative classes, 6-41

reading and writing data, 6-17

requirements, 6-11

sample class, 6-19

specifying member names, 6-45

strongly typed, definition, 6-2

support for object methods, 6-10

using to serialize object, 6-74

weakly typed, definition, 6-2

CustomDatum (deprecated), 6-8

customization

customizer harness

connection options, A-18

general options, A-14

invoke special customizers, A-21

options overview, A-12

overview, A-5

customizer option (customizer harness), A-15

customizers

choosing, A-11

option to choose customizer, A-15

overview, A-5

passing options through SQLJ, 8-63

specifying default, 8-88

d option (sqlj -d), 8-30

data source support

associating a connection, 7-13

associating a default context, 7-15

auto-commit mode, 7-14

dataSource (connection context WITH clause), 3-7

general overview, 7-13

requirements, 7-15

SQLJ data source classes, 7-17

SQLJ data source interfaces, 7-16

SQLJ-specific data sources, 7-16

database connection, verify, 2-16

DBMS_JAVA package

set server output device, 11-6

set server-side options, 11-20

DBMS_LOB package, 5-31

debug option (customizer harness), A-21

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

debugging

AuditorInstaller command-line examples, A-51

AuditorInstaller customizer, A-44

AuditorInstaller options, A-47

AuditorInstaller runtime output, A-46

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

debug option, customizer harness, A-21

in JDeveloper, 10-29

invoking AuditorInstaller, A-45

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

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

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

setting with setDefaultContext(), 4-10

default customizer option (sqlj), 8-88

default output device in server, 11-6

default properties files (translator), 8-19

default semantics-checker, 8-71

default URL prefix option (sqlj), 8-43

DefaultContext class

close() method parameters, 4-17

constructors, 4-15

key methods, 4-15

use for single or multiple connections, 4-6

defining column types/sizes, 10-23

defining parameter sizes, 10-25

depth option (AuditorInstaller), A-48

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

dir option (sqlj -dir), 8-32

directory

for generated .class and .ser, 8-30

for generated .java, 8-32

dirty reads, 7-50

driver option (customizer harness), A-20

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

dropjava, 11-25

dropping Java schema objects, 11-25

dynamic SQL

defined, 1-2

in JDBC code, 7-53

in PL/SQL code, 3-14

dynamic SQL support in SQLJ

examples, 7-65

introduction, 7-63

meta bind expressions, 7-63

runtime behavior, 7-65

translation-time behavior, 7-65

echo option, without execution, 8-27

echoing command line without executing, 8-16

encoding

character encoding for messages, 9-23

character encoding for source, 9-23

command line example, 9-25

do not pass option to compiler, 8-83

overview of character encoding, 9-20

setting at runtime, 9-29

specifying in server, 11-19

using native2ascii, 9-30

encoding option (in server), 11-19

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

environment assumptions and requirements, 2-2

environment variable, translator options, 8-19

environments--scenarios and limitations, 2-4

errors

character encoding for messages, 9-23

customization messages, A-9

messages, codes, and SQL states, 4-24

outputting cause and action, 8-49

runtime categories, 9-18

runtime error list, B-47

server-side error output, 11-24

translator error list, B-2

translator error, warning, info messages, 9-12

exceptions

exception-handling requirements, 4-22

processing, 4-23

set up exception-handling, 4-32

using SQLException subclasses, 4-25

executable statements

examples, 3-12

overview, 3-9

rules, 3-9

specifying connection/execution contexts, 3-11

SQLJ clauses, 3-10

using PL/SQL blocks, 3-14

execution contexts

cancellation method, 7-30

close() method, 7-32

control methods, 7-28

creating and specifying, 7-26

method usage, example, 7-33

overview, 7-24

relation to connection contexts, 7-25

relation to multithreading, 7-33

savepoint methods, 7-31

specifying for executable statement, 3-11

status methods, 7-28

synchronization, 7-27

update-batching methods, 7-30

exemplar schema, 4-17

exit codes, translator, 9-15

explain option (sqlj -explain), 8-49

extending JPub-generated classes, 6-51

extensions

overview, 1-8

performance extensions, 10-2

summary of features used, A-35

type extensions, 5-29

FETCH CURRENT syntax (iterators), 7-46

FETCH syntax (scrollable positional iterators), 7-45

file name requirements and restrictions, 4-47

fixedchar option (Oracle customizer), A-32

fixedchar option (SQLJ -fixedchar), 8-58

flags for special processing, 8-65

force option (Oracle customizer), A-26

ForUpdate/updateColumns (WITH clause), 3-7

full names (schema names), 11-11

function calls, stored, 3-61

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

globalization support

character encoding, language support, 9-19

outside of SQLJ, 9-29

overview, 1-32

related datatypes, 5-5

related Java types, 9-26

related SQLJ and Java settings, 9-22

support for Unicode characters, 9-25

help option (customizer harness), A-16

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

hints in code, parameter sizes, 10-26

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

host expressions

basic syntax, 3-17

bind by identifier, 8-70

evaluation at runtime, 3-22

examples, 3-20

examples of evaluation at runtime, 3-24

iterators and result sets as host variables, 3-52

overview, 3-16

restrictions, 3-33

selecting a nested table, 6-64

supported types for JDBC 2.0, 5-8

type support for Oracle8i, 5-11

type support for Oracle8/Oracle7, 5-12

type support summary, 5-2

IDE SQLJ integration, 1-32

IMPLEMENTS clause

in connection context declarations, 7-11

in iterator declarations, 7-40

syntax, 3-5

importing required classes, 4-31

informational messages, translator, 9-12

input to translator, 1-13

INSENSITIVE (cursor state), 3-7

installation and configuration verification, 2-11

instrumenting class file (linemap), 8-50

interoperability with JDBC

connection contexts and connections, 7-53

iterators and result sets, 7-58

introduction to SQLJ, 1-2

isolation level settings (transactions), 7-50

iterators

accessing named iterators, 3-46

accessing positional iterators, 3-49

as host variables, 3-52

as iterator columns (nested), 3-55

as stored function returns, 3-63

commit/rollback effect, 4-29

concepts, 3-37

converting from result sets, 7-58

converting to result sets, 7-60

declarations, 3-3

declaring named iterators, 3-44

declaring positional iterators, 3-48

declaring with IMPLEMENTS clause, 7-40

general steps in using, 3-41

instantiating/populating named iterators, 3-45

instantiating/populating positional iterators, 3-49

iterator class functionality, 7-38

named vs. positional, 3-42

nested iterators for nested tables, 6-67

overview, 3-37

positional iterators, using next(), 3-51

result set iterators (weakly typed), 3-41, 7-41

scrollable, 7-42

scrollable result set iterators, 7-47

selecting objects and references, 6-55

set up named iterator (example), 4-35

subclassing, 7-40

using named iterators, 3-43

using positional iterators, 3-48

using weakly typed iterators, 7-61

with serialized objects, 6-77

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

jar file digests option, customization, A-15

jar files for profiles, A-38

Java bind expressions (dynamic SQL), 7-64

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

Java properties, getProperty(), 9-29

Java VM

classpath option, 8-23

options through SQLJ, 8-60

specifying name, 8-81

JavaBeans for SQLJ connections, 7-20

javac compatibility, 8-10

JDBC 2.0

support for LOB types, 5-29

support for weakly typed Struct, Ref, Array, 6-80

types supported, 5-8

JDBC connection methods (transactions), 7-51

JDBC considerations in server, 11-5

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

JDBC drivers

Oracle drivers, 4-2

select for translation, 4-4

select/register for customization, A-20

select/register for runtime, 4-5

verify, 2-16

JDBC interoperability

connection contexts and connections, 7-53

iterators and result sets, 7-58

JDBC mapping (for attributes), 6-37

JDBC vs. SQLJ, sample application, 1-18

jdblinemap option (sqlj -jdblinemap), 8-50

JDeveloper

debugging with, 10-29

SQLJ integration, 1-32

JDK

appropriate JDBC class files, 2-12

supported versions, 2-4

JNDI

name of default data source, 7-15

use for data sources, connections, 7-13

JPublisher

KEEP_CONNECTION, 7-57

language support (globalization support), 9-22

linemap option (sqlj -linemap), 8-49

line-mapping

SQLJ source to class file, 8-49

SQLJ source to class for jdb, 8-50

loading classes/resources into server, 11-9

loading/translating source in server, 11-16

loadjava

compatibility options, SQLJ, 8-9

loading classes/resources, 11-9

loading source, translating, 11-16

output from loading source, 11-22

LOBs

as iterator columns, 5-36

as stored function results, 5-34

FETCH INTO LOB host variables, 5-36

SELECT INTO LOB host variables, 5-35

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

lobtypes option (JPublisher -lobtypes), 6-37

locale

command line example, 9-25

for messages, 9-23

setting at runtime, 9-29

log option (AuditorInstaller), A-48

mapping to alternative classes (UDTs), 6-41

member names (objects), 6-45

message pipe, compiler, 8-84

meta bind expressions (dynamic SQL), 7-63

method support for objects, 6-10

method wrappers (JPub), implementation, 6-46

middle-tier considerations, 4-48

multithreading

in server, 11-26

in SQLJ, overview, 7-35

relation to execution contexts, 7-33

sample application, 7-36

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

name of compiler, 8-82

name of Java VM, 8-81

named iterators

accessing, 3-46

declaring, 3-44

instantiating and populating, 3-45

scrollable, 7-44

using, 3-43

naming requirements and restrictions

file names, 4-47

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

SQL namespace, 4-47

SQLJ namespace, 4-46

naming schema objects

generated class, 11-23

loaded classes, 11-12

loaded resources, 11-12

source, 11-22

National Language Support--see Globalization Support

native2ascii for encoding, 9-30

NCHAR class (globalization support), 9-25

NcharAsciiStream class (globalization support), 9-25

NcharUnicodeStream class (globalization support), 9-25

NCLOB class (globalization support), 9-25

nested iterators, 6-67

nested tables

accessing, 6-62

inserting in SQLJ, 6-63

manipulating, 6-65

selecting into host expression, 6-64

types, 6-4

using nested iterator, 6-67

NLS--see Globalization Support

non-repeatable reads, 7-50

NString class (globalization support), 9-25

null-handling

examples, 4-20

wrapper classes for null-handling, 4-19

numbertypes option (JPublisher -numbertypes), 6-37

object method wrappers (JPub), 6-46

object references

selecting into iterators, 6-55

strongly typed in SQLJ, 6-55

updating in SQLJ, 6-60

weak types, restrictions, 6-81

weak types, support, 6-80

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

objects

OCI driver (JDBC), 4-3

offline checking

default checker, Oracle checkers, 8-71

specifying checker, 8-75

offline option (sqlj -offline), 8-75

offline parsing

sqlj -parse option, 8-79

steps involved, 9-2

vs. online checking, 8-73

online checking

caching results, 8-78

default checker, Oracle checkers, 8-71

enabling in server, 11-19

enabling, setting user schema, 8-34

registering drivers, 8-44

setting default URL prefix, 8-43

setting password, 8-39

setting URL, 8-41

specifying checker, 8-76

vs. offline parsing, 8-73

online option (in server), 11-19

online option (sqlj -online), 8-76

opaque types, 6-82

optcols option (Oracle customizer), A-27

optcols option (SQLJ -optcols), 8-53

optimizer, SQL, 10-2

options (translator)

command line only, 8-22

flags for special processing, 8-65

for connections, 8-34

for customization, 8-87

for javac compatibility, 8-10

for loadjava compatibility, 8-9

for output files and directories, 8-29

for reporting and line-mapping, 8-45

for semantics-checking, offline parsing, 8-71

for VM and compiler, 8-80

help, 8-24

order of precedence, 8-20

overview, 8-3

prefixes for passing options, 8-60

summary list, 8-3

support for alternative environments, 8-80

options for customizer harness

connection options, A-18

general options, A-14

invoke special customizers, A-21

overview, A-12

options for Oracle customizer, A-24

options for translation in server

fixed settings, 11-18

setting options, 11-20

supported options, 11-18

optparamdefaults option (Oracle customizer), A-30

optparamdefaults option (SQLJ -optparamdefaults), 8-56

optparams option (Oracle customizer), A-29

optparams option (SQLJ -optparams), 8-55

Oracle class

close() method parameters, 4-14

connect() method, 4-13

for DefaultContext instances, 4-12

getConnection() method, 4-13

Oracle customizer

blank padding for CHAR comparisons, A-32

define column types/sizes, A-27

define parameter sizes, A-29

force customization, A-26

options, A-24

set default parameter sizes, A-30

show SQL transformation, A-32

statement cache size, A-34

summary of Oracle features used, A-35

version compatibility, A-25

Oracle extensions

overview, 1-8

performance extensions, 10-2

summary of features used, A-35

type extensions, 5-29

Oracle mapping (for attributes), 6-37

Oracle optimizer, 10-2

Oracle9i Lite with SQLJ, 1-30

OracleChecker default checker, 8-71

Oracle-specific code generation

advantages and disadvantages, 4-39

coding considerations, limitations, 4-41

environment requirements, 4-40

introduction, 1-3, 4-39

server-side considerations, 4-44

translator/customizer usage changes, 4-42

oracle.sql package, 5-30

ORAData

additional uses, 6-18

specifications, 6-7

use in custom Java classes, 6-6

versus CustomDatum, 6-8

output device in server, default, 11-6

output directory

for generated .class and .ser, 8-30

for generated .java, 8-32

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

output file for compiler, 8-83

output from server-side translator, 11-22

output from translator, 1-13

output pipe, compiler messages, 8-84

output, server-side translator errors, 11-24

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

parameter definitions (sizes)

general information, 10-25

Oracle customizer optparamdefaults option, A-30

Oracle customizer optparams option, A-29

SQLJ -optparamdefaults option, 8-56

SQLJ -optparams option, 8-55

parse option (sqlj -parse), 8-79

passes option (sqlj -passes), 8-86

passes, two-pass compiling, 8-86

passing options to other executables, 8-60

password option (customizer harness), A-19

password option for checking (sqlj), 8-39

path (connection context WITH clause), 3-8

path and classpath, 2-12

performance enhancements, 10-2

phantom reads, 7-50

pipe, compiler output messages, 8-84

PL/SQL

blocks in executable statements, 3-14

positional iterators

instantiating and populating, 3-49

navigation with next(), 3-51

scrollable, 7-45

using, 3-48

positioned delete, 5-38

positioned update, 5-38

prefetching rows, 10-3

prefix option (AuditorInstaller), A-49

prefixes

to pass options to customizer, 8-63

to pass options to Java compiler, 8-62

to pass options to Java VM, 8-60

print option (customizer harness), A-22

procedure calls, stored, 3-60

profile customization (see customization), 9-10

profile option (sqlj -profile), 8-66

profile-keys class, 9-5

profiles

auditors for debugging, A-44

binary portability, 1-7

code layers, A-44

creation during code generation, A-2

debug option, A-21

functionality at runtime, A-9

generated profiles, 9-6

more about profiles, A-2

overview, 1-6

print option, A-22

sample profile entry, A-3

use of jar files, A-38

verify option, A-22

properties files (translator)

default properties files, 8-19

overview, 8-16

setting input file, 8-23

syntax, 8-17

properties, Java, getProperty(), 9-29

props option (sqlj -props), 8-23

public class name / source name check, 8-85

READ COMMITTED transactions, 7-50

READ ONLY transactions, 7-50

READ UNCOMMITTED transactions, 7-50

READ WRITE transactions, 7-50

RECORD type (PL/SQL), 5-9

recursive SQLJ calls in server, 11-26

REF CURSOR

about REF CURSOR types, 5-40

example, 5-41

SQLJ support, 5-41

register JDBC drivers

for runtime, 4-5

for translation, 8-44

registering column types/sizes, 10-23

registering parameter sizes, 10-25

REPEATABLE READ transactions, 7-50

reporting options (translator), 8-45

requirements, environment, 2-3

resource schema object naming

loaded, 11-12

result expressions

evaluation at runtime, 3-22

overview, 3-21

result set iterators (weakly typed)

general information, 7-41

introduction, 3-41

scrollable, 7-47

result sets

as host variables, 3-52

as iterator columns, 3-55

as stored function returns, 3-63

commit/rollback effect, 4-29

converting from iterators, 7-60

converting to iterators, 7-58

persistence across calls in server, 11-5

ResultSetIterator type, 7-41

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

rollback

effect on iterators and result sets, 4-29

manual, 4-28

with savepoint, 4-30

row prefetching, 10-3

ROWID

as stored function results, 5-39

FETCH INTO ROWID host variable, 5-39

SELECT INTO ROWID host variable, 5-39

support, 5-37

runtime

categories of errors, 9-18

debugging output (AuditorInstaller), A-46

error list, B-47

functionality, 9-16

functionality of profiles, A-9

generated calls to runtime, 9-8

globalization support, 9-19

JDBC driver selection and registration, 4-5

overview, 1-5

packages, 9-16

set up connection, 2-14

steps in runtime processing, 1-16

test, 2-17

sample applications

JDBC vs. SQLJ, 1-18

multiple connection contexts, 7-7

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

multithreading, 7-36

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

sample classes

custom Java class (BetterDate), 6-19

SerializableDatum class, 6-78

savepoints

ExecutionContext savepoint methods, 7-31

savepoint statements, 4-30

schema objects

naming generated classes, 11-23

naming loaded classes, 11-12

naming loaded resources, 11-12

naming sources, 11-22

scrollable iterators

declaring, 7-42

scrollable named iterators, 7-44

scrollable positional iterators, 7-45

sensitivity, 7-42

the scrollable interface, 7-43

ScrollableResultSetIterator type, 7-47

SELECT INTO statements

error conditions, 3-36

examples, 3-35

syntax, 3-34

semantics-checking

caching online results, 8-78

default checker, Oracle checkers, 8-71

enabling online in server, 11-19

enabling online, setting user schema, 8-34

invoking SQLCheckerCustomizer, A-40

of profiles, via customizer harness, A-22

options, 8-71

registering drivers, 8-44

setting default URL prefix, 8-43

setting password, 8-39

setting URL, 8-41

specifying offline checker, 8-75

specifying online checker, 8-76

SQLCheckerCustomizer options, A-41

steps involved, 9-2

SENSITIVE (cursor state), 3-7

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

ser profiles (.ser)

converting to .class, 8-68

generated profiles, 9-6

ser2class option (sqlj -ser2class), 8-68

SERIALIZABLE transactions, 7-50

serialized objects

as host variables, 6-77

in iterator columns, 6-77

overview, 6-71

SerializableDatum class (sample), 6-78

through custom Java class, 6-74

to RAW and BLOB columns, 6-71

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

server-side SQLJ

class loading, 11-7

coding considerations, 11-4

compilation, 11-7

connection to database, 11-4

default output device, 11-6

dropjava, 11-25

dropping Java schema objects, 11-25

error output, 11-24

fixed settings, 11-18

generated output from translation, 11-22

introduction, 11-2

Java multithreading, 11-26

JDBC differences, 11-5

loading classes/resources into server, 11-9

loading source into server, translating, 11-16

naming generated class schema objects, 11-23

naming loaded class schema objects, 11-12

naming loaded resource schema objects, 11-12

naming source schema objects, 11-22

options, 11-18

overview, 1-29

recursive calls, 11-26

running client program in server, 11-14

setting options, 11-20

SQL names vs. Java names, 11-8

translating in server, 11-16

translating on client, 11-9

verifying code is running in server, 11-28

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

SET (assignment) statements, 3-58

SET TRANSACTION syntax, 7-49

setup of SQLJ, testing, 2-14

short names (schema names), 11-11

showReturns option (AuditorInstaller), A-49

showSQL option (Oracle customizer), A-32

showThreads option (AuditorInstaller), A-50

source check for type resolution, 8-69

source file line-mapping

for jdb, 8-50

general, 8-49

source files encoding option, 8-29

source name / public class name check, 8-85

source schema object naming, 11-22

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

SQL optimizer, 10-2

sql option (JPublisher -sql), 6-34

SQL replacement code (dynamic SQL), 7-65

SQL states (for errors), 4-24

SQLCheckerCustomizer

for semantics-checking of profiles, A-40

invoking, A-40

options, A-41

SQLData

specifications, 6-9

use in custom Java classes, 6-6

SQLException subclasses, using, 4-25

SQLJ vs. JDBC, sample application, 1-18

SQLJ_OPTIONS environment variable, 8-19

SqljConnBean for simple connection, 7-21

SqljConnCacheBean for connection caching, 7-22

sqljutl package, 2-13

statement caching, 10-4

static SQL, defined, 1-2

status messages

for customization, A-9

for translation, 9-15

translator, enabling/disabling, 8-48

status option (sqlj -status), 8-48

stmtcache option (Oracle customizer), A-34

stored function calls, 3-61

stored procedure calls, 3-60

streams

as function return values, 5-28

as output parameters, 5-27

classes and methods, 5-22

examples, 5-24

general use in SQLJ, 5-14

precautions, 5-19

retrieving data, 5-20

sending data to database, 5-16

supporting classes, 5-14

strongly typed collections, 6-62

strongly typed custom Java classes, 6-2

strongly typed objects and references, 6-55

subclassing iterator classes, 7-40

summary option (Oracle customizer), A-35

Sun JDK

appropriate JDBC class files, 2-12

supported versions, 2-4

synchronization of execution contexts, 7-27

syntax

translator command line, 8-12

translator properties files, 8-17

TABLE syntax (nested tables), 6-62, 6-65

TABLE type (PL/SQL), 5-9

Thin driver (JDBC), 4-3

transactions

access mode settings, 7-50

advanced transaction control, 7-49

automatic commit vs. manual commit, 4-26

basic transaction control, 4-26

isolation level settings, 7-50

JDBC Connection methods, 7-51

manual commit and rollback, 4-28

modifying auto-commit, 4-28

overview, 4-26

savepoints for rollbacks, 4-30

specifying auto-commit, 4-27

transformGroup (connection context WITH clause), 3-8

TRANSLATE (object member names), 6-45

translating in server to run in server, 11-16

translating on client to run in server, 11-9

translator

basic translation steps, 1-10

error, warning, info messages, 9-12

exit codes, 9-15

globalization support, 9-19

input and output, 1-13

internal operations, 9-2

Java and SQLJ code-parsing, syntax-checking, 9-2

output, server-side, 11-22

overview, 1-5

SQL semantics-checking and offline parsing, 9-2

status messages, 9-15

support for alternative environments, 8-80

test, 2-17

Type, 5-1

type extensions, 5-29

type mapping

BigDecimal mapping, 6-38

JDBC mapping, 6-37

JPublisher mapping option, 6-34

object JDBC mapping, 6-37

Oracle mapping, 6-37

type categories and mapping modes, 6-37

type resolution, expand search, 8-69

typeMap (connection context WITH clause), 3-7

types option (JPublisher -types), 6-34

types supported

for JDBC 2.0, 5-8

for Oracle8i, 5-11

for Oracle8/Oracle7, 5-12

summary of types, 5-2

uninstall option (AuditorInstaller), A-51

update batching

batch limit, 10-19

batchable and compatible statements, 10-13

batching incompatible statements, 10-20

canceling a batch, 10-17

cautions, 10-22

enabling and disabling, 10-14

error conditions during execution, 10-22

explicit and implicit batch execution, 10-14

overview, 10-12

update counts, 10-18

using implicit execution contexts, 10-21

with respect to recursive call-ins, 10-23

updateColumns/ForUpdate (WITH clause), 3-7

url option (customizer harness), A-20

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

URL, default prefix for online checking, 8-43

user option (customizer harness), A-18

user option (JPublisher -user), 6-35

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

user-defined types, 6-23

VALUES syntax for stored functions, 3-61

VARRAYs

inserting a row, 6-70

selecting into host expression, 6-69

VARRAY types, 6-4

verbose option (customizer harness), A-17

verify option (customizer harness), A-22

version compatibility (Oracle customizer), A-25

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

VM

classpath option, 8-23

options through SQLJ, 8-60

specifying name, 8-81

vm option (sqlj -vm), 8-81

warn option (SQLCheckerCustomizer), A-43

warn option (sqlj -warn), 8-45

warning messages, translator, 9-12

warnings, translator, enabling/disabling, 8-45

weak object/collection types

restrictions, 6-81

support, 6-80

weakly typed custom Java classes, 6-2

weakly typed iterators, 7-41

WHERE CURRENT OF, 5-38

Windows, SQLJ development in, 1-33

WITH clause syntax, 3-6

wrapper classes for null-handling, 4-19

wrapper methods (JPub), generating, 6-39