Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  R  S  T  U  V  W 

---

A

access mode settings (transactions), 7-39

alternative environments, support, 8-72

applets

sample using SQLJ, 12-87

using SQLJ, 1-16

ASENSITIVE (cursor state), 3-7

assignment statements (SET), 3-57

assumptions, environment, 2-2

AuditorInstaller

command-line examples, A-33

customizer for debugging, A-26

invoking, A-27

options, A-29

runtime output, A-28

auditors in profiles for debugging, A-26

auto-commit

modifying in existing connection, 4-28

not supported in server, 11-4

specifying in new connection, 4-27

---

B

backup option (customizer harness), 10-19

backwards compatibility

to Oracle8i, 5-10

to Oracle8/Oracle7, 5-10

backwards compatibility, Oracle SQLJ, 2-6

batch updates

batch limit, A-17

batchable and compatible statements, A-11

batching incompatible statements, A-18

canceling a batch, A-15

cautions, A-20

enabling and disabling, A-12

error conditions during execution, A-21

explicit and implicit batch execution, A-13

overview, A-11

update counts, A-16

using implicit execution contexts, A-19

with respect to recursive call-ins, A-21

BetterDate (custom Java class), 12-49

BFILEs

as stored function results, 5-30

BFILE support, 5-26

BigDecimal mapping (for attributes), 6-34

BigDecimal support, 5-38

binary portability of profiles, 1-6

BLOB support, 5-26

BOOLEAN type (PL/SQL), 5-9

builtintypes option (JPublisher -builtintypes), 6-34

---

C

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

cache option (sqlj -cache), 8-71

caching online checker results, 8-71

caching statements, A-4

CALL syntax for stored procedures, 3-59

calling stored functions, 3-60

calling stored procedures, 3-59

calls to runtime, generated, 9-8

case option (JPublisher -case), 6-33

case-sensitive SQL UDT names, 6-13, 6-14, 6-31, 6-39

cause/action output for errors, 8-46

character encoding

command line example, 9-26

for messages, 9-25

for source, 9-25

overview, 9-22

setting at runtime, 9-31

using native2ascii, 9-32

check source name against. public class, 8-77

check sources, expand resolution search, 8-65

checker option (SQLCheckerCustomizer), 10-45

checkfilename option (sqlj -checkfilename), 8-77

checksource option (sqlj -checksource), 8-65

class loading in server, 11-6

class schema object naming

generated, 11-22

loaded, 11-11

classpath and path, 2-8

classpath option (sqlj -classpath), 8-21

clauses, SQLJ executable statements, 3-10

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

CLOB support, 5-26

close() method (DefaultContext), 4-17

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

CLOSE_CONNECTION, 7-46

code generation

general information, 9-5

Oracle-specific vs. standard, 10-11

translator -codegen option, 8-49

code layers in profiles, A-26

codegen option (SQLJ -codegen), 8-49

code-parsing, 9-2

collections

about custom Java classes, 6-6

creating collection types, 6-22

datatypes, 6-5

fundamentals, 6-4

introduction to collection support, 6-2

mapping to alternative classes, 6-37

nested tables sample application, 12-37

ORAData specifications, 6-7

specifying type mapping, 6-31, 6-33

strongly typed, 6-59

VARRAYs sample application, 12-45

weak types, restrictions, 6-78

weak types, support, 6-77

column definitions (types/sizes)

general information, A-22

Oracle customizer optcols option, 10-31

SQLJ -optcols option, 8-50

command line (translator)

echoing without executing, 8-14

example, 8-13

overview, 8-2

syntax and arguments, 8-10

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), 10-30

compatible option (JPublisher -compatible), 6-30

compilation

compiling in two passes, 8-78

debug option in server, 11-19

during translation, 9-9

enabling/disabling, 8-61

in server, 11-6

compile option (sqlj -compile), 8-61

compiler

classpath option, 8-21

options through SQLJ, 8-57

related options, 8-72

required behavior, 8-74

specifying name, 8-74

compiler encoding support option (sqlj), 8-75

compiler executable option (sqlj), 8-74

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

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

configuration and installation verification, 2-8

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

connection contexts

close connection, 7-9

concepts, 7-2

converting from JDBC connection, 7-45

converting to JDBC connection, 7-42

declaration with IMPLEMENTS clause, 7-11

declarations, 3-4

declaring connection context class, 7-5

get default connection, 7-10

get execution context, 7-9

get JDBC connection, 7-9

implementation and functionality, 7-9

instantiating connection object, 7-6

methods, 7-9

multiple connections, example, 7-7

multiple, sample application, 12-62

relation to execution contexts, 7-16

semantics-checking, 7-12

set default connection, 7-10

specifying connection for statement, 7-7

specifying for executable statement, 3-11

connection properties file, 12-3

connections

closing, 4-10

closing shared connections with JDBC, 7-46

database connection in server, 11-3

JDBC transaction methods, 7-40

modifying auto-commit, 4-28

multiple, sample application, 12-61

multiple, using declared connect contexts, 4-12

Oracle class to connect, 4-12

set up, 2-11

shared connections with JDBC, 7-45

single or multiple using default context, 4-6

specifying auto-commit, 4-27

translator options, 8-31

verify, 2-13

connect.properties file, 12-3

context expressions

evaluation at runtime, 3-21

overview, 3-20

context option (customizer harness), 10-20

converting .ser profiles to .class, 8-64

CORBA server objects with SQLJ, 11-31

CURSOR syntax (nested tables), 6-60

custom Java classes

about custom Java classes, 6-6

compiling, 6-17

creation by JPublisher, 6-25

examples, 6-43

extending, 6-47

generation by JPublisher, 6-29

mapping to alternative classes, 6-37

reading and writing data, 6-18

requirements, 6-11

sample class, 12-49

specifying member names, 6-41

strongly typed, definition, 6-2

support for object methods, 6-10

using to serialize object, 6-71

weakly typed, definition, 6-2

CustomDatum (deprecated), 6-8

customization

converting .ser profiles to .class, 8-64

creation and registration, 10-7

customizer harness connection options, 10-23

customizer harness general options, 10-19

customizer harness options overview, 10-17

defining column types/sizes, 10-31

defining parameter sizes, 10-34

during translation, 9-11

enabling/disabling, 8-62

error and status messages, 10-9

force customization, 10-31

jar file usage, 10-41

more about customization, 10-5

options, 10-17

options to invoke special customizers, 10-25

Oracle customizer options, 10-29

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

parameter default sizes, 10-35

related SQLJ options, 10-40

show SQL transformations, 10-36

statement cache size, 10-37

steps in process, 10-6

summary of Oracle features used, 10-39

version compatibility, 10-30

customizer harness

connection options, 10-23

general options, 10-19

invoke special customizers, 10-25

options overview, 10-17

overview, 10-5

customizer option (customizer harness), 10-20

customizers

choosing, 10-17

option to choose customizer, 10-20

overview, 10-5

passing options through SQLJ, 8-59

specifying default, 8-80

---

D

d option (sqlj -d), 8-28

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

overview, 7-13

requirements, 7-15

database connection, verify, 2-13

DBMS_JAVA package

setting server-side options, 11-19

DBMS_LOB package, 5-27

debug option (customizer harness), 10-26

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

debugging

AuditorInstaller command-line examples, A-33

AuditorInstaller customizer, A-26

AuditorInstaller options, A-29

AuditorInstaller runtime output, A-28

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

debug option, customizer harness, 10-26

in JDeveloper, A-35

invoking AuditorInstaller, A-27

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

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

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

default output device in server, 11-5

default properties files (translator), 8-17

default semantics-checker, 8-66

default URL prefix option (sqlj), 8-41

DefaultContext class

close() method parameters, 4-17

constructors, 4-15

key methods, 4-14

use for single or multiple connections, 4-6

defining column types/sizes, A-22

defining parameter sizes, A-23

depth option (AuditorInstaller), A-30

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

dir option (sqlj -dir), 8-30

directory

for generated .class and .ser, 8-28

for generated .java, 8-30

dirty reads, 7-39

driver option (customizer harness), 10-25

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

dropjava, 11-26

dropping Java schema objects, 11-26

dynamic SQL

defined, 1-2

in JDBC code, 7-42

in PL/SQL within SQLJ, 12-68

dynamic SQL support in SQLJ

examples, 7-55

introduction, 7-52

meta bind expressions, 7-52

runtime behavior, 7-54

translation-time behavior, 7-54

---

E

echo option, without execution, 8-25

echoing command line without executing, 8-14

encoding

character encoding for messages, 9-25

character encoding for source, 9-25

command line example, 9-26

do not pass option to compiler, 8-75

overview of character encoding, 9-22

setting at runtime, 9-31

specifying in server, 11-18

using native2ascii, 9-32

encoding option (in server), 11-18

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

Enterprise JavaBeans with SQLJ, 11-30

environment assumptions and requirements, 2-2

environment variable, translator options, 8-18

errors

character encoding for messages, 9-25

customization messages, 10-9

messages, codes, and SQL states, 4-24

outputting cause and action, 8-46

runtime categories, 9-19

runtime error list, B-47

server-side error output, 11-24

translator error list, B-2

translator error, warning, info messages, 9-13

exceptions

exception-handling requirements, 4-22

processing, 4-23

set up exception-handling, 4-31

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

control methods, 7-20

creating and specifying, 7-17

method usage, example, 7-23

overview, 7-16

relation to connection contexts, 7-16

relation to multithreading, 7-23

specifying for executable statement, 3-11

status methods, 7-19

synchronization, 7-18

update-batching methods, 7-22

exemplar schema, 4-17

exit codes, translator, 9-16

explain option (sqlj -explain), 8-46

extending JPub-generated classes, 6-47

extensions

overview, 1-7

performance extensions, A-2

summary of features used, 10-39

type extensions, 5-25

---

F

FETCH CURRENT syntax (iterators), 7-35

FETCH syntax (scrollable positional iterators), 7-34

file name requirements and restrictions, 4-40

flags for special processing, 8-61

force option (Oracle customizer), 10-31

ForUpdate/updateColumns (WITH clause), 3-7

full names (schema names), 11-21

function calls, stored, 3-60

---

G

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

globalization support

character encoding, language support, 9-21

outside of SQLJ, 9-31

overview, 1-24

related datatypes, 5-5

related Java types, 9-27

related SQLJ and Java settings, 9-24

support for Unicode characters, 9-27

---

H

help option (customizer harness), 10-22

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

hints in code, parameter sizes, A-24

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

host expressions

basic syntax, 3-16

evaluation at runtime, 3-21

examples, 3-18

examples of evaluation at runtime, 3-23

iterators and result sets as host variables, 3-51

overview, 3-15

restrictions, 3-32

sample application, 12-14

selecting a nested table, 6-61

supported types for JDBC 2.0, 5-7

type support for Oracle8i, 5-10

type support for Oracle8/Oracle7, 5-10

type support summary, 5-2

unsupported types, 5-8

---

I

IDE SQLJ integration, 1-24

IMPLEMENTS clause

in connection context declarations, 7-11

in iterator declarations, 7-28

syntax, 3-5

importing required classes, 4-30

informational messages, translator, 9-13

input to translator, 1-12

INSENSITIVE (cursor state), 3-7

installation and configuration verification, 2-8

instrumenting class file (linemap), 8-47

interoperability with JDBC

connection contexts and connections, 7-42

iterators and result sets, 7-47

sample application, 12-59

introduction to SQLJ, 1-2

isolation level settings (transactions), 7-39

iterators

accessing named iterators, 3-45

accessing positional iterators, 3-48

as host variables, 3-51

as iterator columns (nested), 3-54

as stored function returns, 3-62

commit/rollback effect, 4-29

concepts, 3-36

converting from result sets, 7-47

converting to result sets, 7-49

declarations, 3-3

declaring named iterators, 3-43

declaring positional iterators, 3-47

declaring with IMPLEMENTS clause, 7-28

general steps in using, 3-40

instantiating/populating named iterators, 3-44

instantiating/populating positional iterators, 3-48

iterator class functionality, 7-27

named iterator sample application, 12-6

named vs. positional, 3-40

nested iterators for nested tables, 6-64

overview, 3-36

positional iterator sample application, 12-10

positional iterators, using next(), 3-50

result set iterators (weakly typed), 3-40, 7-30

scrollable, 7-30

scrollable result set iterators, 7-36

selecting objects and references, 6-54

set up named iterator (example), 4-34

subclassing, 7-29

subclassing, sample application, 12-65

using named iterators, 3-42

using positional iterators, 3-47

using weakly typed iterators, 7-50

with serialized objects, 6-74

---

J

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

jar file digests option, customization, 10-21

jar files for profiles, 10-41

Java bind expressions (dynamic SQL), 7-53

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

Java Option (Oracle JVM) configuration, 2-7

Java properties, getProperty(), 9-31

Java sockets, 4-3

Java VM

classpath option, 8-21

options through SQLJ, 8-56

specifying name, 8-73

javac compatibility, 8-9

JDBC 2.0

support for LOB types, 5-25

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

types supported, 5-7

JDBC connection methods (transactions), 7-40

JDBC considerations in server, 11-4

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

JDBC drivers

Oracle drivers, 4-2

select for translation, 4-4

select/register for customization, 10-25

select/register for runtime, 4-5

verify, 2-13

JDBC interoperability

connection contexts and connections, 7-42

iterators and result sets, 7-47

sample application, 12-59

JDBC mapping (for attributes), 6-34

JDBC vs. SQLJ, sample application, 12-95

jdblinemap option (sqlj -jdblinemap), 8-48

JDeveloper

debugging with, A-35

SQLJ integration, 1-24

JDK

appropriate JDBC class files, 2-9

supported versions, 2-4

JNDI

name of default data source, 7-15

use for data sources, connections, 7-13

JPublisher

builtintypes option, 6-34

case option, 6-33

compatible option, 6-30

creation of custom Java classes, 6-25

custom Java class examples, 6-43

extending generated classes, 6-47

generating custom Java classes, 6-29

generating wrapper methods, 6-36

implementation of method wrappers, 6-42

input files, 6-39

lobtypes option, 6-34

mapping to alternative classes, 6-37

numbertypes option, 6-34

properties files, 6-40

specifying member names, 6-41

specifying type mapping, 6-31

sql option, 6-31

type categories and mapping options, 6-34

type mapping, 6-33

type mapping modes and option settings, 6-34

types option, 6-31

user option, 6-31

what JPublisher produces, 6-25

---

K

KEEP_CONNECTION, 7-46

---

L

language support (globalization support), 9-24

linemap option (sqlj -linemap), 8-47

line-mapping

SQLJ source to class file, 8-47

SQLJ source to class for jdb, 8-48

loading classes/resources into server, 11-8

loading/translating source in server, 11-16

loadjava

compatibility options, SQLJ, 8-9

loading classes/resources, 11-8

loading source, translating, 11-16

output from loading source, 11-21

LOBs

as iterator columns, 5-32

as stored function results, 5-30

FETCH INTO LOB host variables, 5-32

SELECT INTO LOB host variables, 5-31

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

lobtypes option (JPublisher -lobtypes), 6-34

locale

command line example, 9-26

for messages, 9-25

setting at runtime, 9-31

log option (AuditorInstaller), A-30

---

M

mapping to alternative classes (UDTs), 6-37

member names (objects), 6-41

message pipe, compiler, 8-76

meta bind expressions (dynamic SQL), 7-52

method support for objects, 6-10

method wrappers (JPub)

implementation, 6-42

multiple connections, sample application, 12-61

multithreading

in server, 11-27

in SQLJ, overview, 7-25

relation to execution contexts, 7-23

sample application, 12-57

---

N

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

name of compiler, 8-74

name of Java VM, 8-73

named iterators

accessing, 3-45

declaring, 3-43

instantiating and populating, 3-44

scrollable, 7-33

using, 3-42

naming requirements and restrictions

file names, 4-40

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

SQL namespace, 4-40

SQLJ namespace, 4-40

naming schema objects

generated class, 11-22

generated profile, 11-23

loaded classes, 11-11

loaded resources, 11-11

source, 11-22

National Language Support--see Globalization Support

native2ascii for encoding, 9-32

NCHAR class (globalization support), 9-27

NcharAsciiStream class (globalization support), 9-27

NcharUnicodeStream class (globalization support), 9-27

NCLOB class (globalization support), 9-27

nested iterators, 6-64

nested tables

accessing, 6-60

inserting in SQLJ, 6-60

manipulating, 6-63

sample application, 12-37

selecting into host expression, 6-61

types, 6-4

using nested iterator, 6-64

NLS--see Globalization Support

non-repeatable reads, 7-39

NString class (globalization support), 9-27

null-handling

examples, 4-20

wrapper classes for null-handling, 4-19

numbertypes option (JPublisher -numbertypes), 6-34

---

O

object method wrappers (JPub), 6-42

object references

selecting into iterators, 6-54

strongly typed in SQLJ, 6-53

updating in SQLJ, 6-57

weak types, restrictions, 6-78

weak types, support, 6-77

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

objects

about custom Java classes, 6-6

creating object types, 6-20

datatypes, 6-5

fundamentals, 6-4

inserting in SQLJ, 6-57

introduction to object support, 6-2

mapping to alternative classes, 6-37

method support, 6-10

ORAData specifications, 6-7

sample application, 12-28

selecting into iterators, 6-54

serializing (overview), 6-68

serializing RAW and BLOB columns, 6-68

serializing with custom Java class, 6-71

specifying type mapping, 6-31, 6-33

SQLData specifications, 6-9

strongly typed in SQLJ, 6-53

updating a reference in SQLJ, 6-57

updating in SQLJ, 6-55

weak types, restrictions, 6-78

weak types, support, 6-77

wrapper methods, 6-36

OCI driver (JDBC), 4-3

offline checking

default checker, Oracle checkers, 8-66

specifying checker, 8-67

offline option (sqlj -offline), 8-67

online checking

caching results, 8-71

default checker, Oracle checkers, 8-66

enabling in server, 11-18

enabling, setting user schema, 8-32

registering drivers, 8-42

setting default URL prefix, 8-41

setting password, 8-36

setting URL, 8-38

specifying checker, 8-69

online option (in server), 11-18

online option (sqlj -online), 8-69

optcols option (Oracle customizer), 10-31

optcols option (SQLJ -optcols), 8-50

optimizer, SQL, A-2

options (translator)

command line only, 8-20

flags for special processing, 8-61

for connections, 8-31

for customization, 8-80

for javac compatibility, 8-9

for loadjava compatibility, 8-9

for output files and directories, 8-27

for reporting and line mapping, 8-42

for semantics-checking, 8-66

for VM and compiler, 8-72

help, 8-22

order of precedence, 8-18

overview, 8-3

prefixes for passing options, 8-56

summary list, 8-4

support for alternative environments, 8-72

options for customizer harness

connection options, 10-23

general options, 10-19

invoke special customizers, 10-25

overview, 10-17

options for Oracle customizer, 10-29

options for translation in server

setting options, 11-19

supported options, 11-18

optparamdefaults option (Oracle customizer), 10-35

optparamdefaults option (SQLJ -optparamdefaults), 8-53

optparams option (Oracle customizer), 10-34

optparams option (SQLJ -optparams), 8-52

Oracle class

close() method parameters, 4-14

connect() method, 4-12

for DefaultContext instances, 4-12

getConnection() method, 4-12

Oracle customizer

define column types/sizes, 10-31

define parameter sizes, 10-34

force customization, 10-31

options, 10-29

set default parameter sizes, 10-35

show SQL transformation, 10-36

statement cache size, 10-37

summary of Oracle features used, 10-39

version compatibility, 10-30

Oracle extensions

overview, 1-7

performance extensions, A-2

summary of features used, 10-39

type extensions, 5-25

Oracle JVM (Java Option) configuration, 2-7

Oracle Lite with SQLJ, 1-22

Oracle mapping (for attributes), 6-34

Oracle optimizer, A-2

OracleChecker default checker, 8-66

Oracle-specific code generation

advantages and disadvantages, 10-11

coding considerations, limitations, 10-13

environment requirements, 10-12

server-side considerations, 10-16

translator/customizer usage changes, 10-15

oracle.sql package, 5-26

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

output directory

for generated .class and .ser, 8-28

for generated .java, 8-30

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

output file for compiler, 8-75

output from server-side translator, 11-21

output from translator, 1-12

output pipe, compiler messages, 8-76

output, server-side translator errors, 11-24

---

P

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

parameter definitions (sizes)

general information, A-23

Oracle customizer optparamdefaults option, 10-35

Oracle customizer optparams option, 10-34

SQLJ -optparamdefaults option, 8-53

SQLJ -optparams option, 8-52

passes option (sqlj -passes), 8-78

passes, two-pass compiling, 8-78

passing options to other executables, 8-56

password option (customizer harness), 10-24

password option for checking (sqlj), 8-36

path (connection context WITH clause), 3-8

path and classpath, 2-8

performance enhancements, A-2

phantom reads, 7-39

pipe, compiler output messages, 8-76

PL/SQL

blocks in executable statements, 3-14

BOOLEAN type, 5-9

example for dynamic SQL in SQLJ, 12-68

RECORD type, 5-9

TABLE type, 5-9

positional iterators

accessing, 3-48

declaring, 3-47

instantiating and populating, 3-48

navigation with next(), 3-50

scrollable, 7-34

using, 3-47

positioned delete, 5-34

positioned update, 5-34

prefetching rows, A-3

prefix option (AuditorInstaller), A-31

prefixes

to pass options to customizer, 8-59

to pass options to Java compiler, 8-57

to pass options to Java VM, 8-56

print option (customizer harness), 10-27

procedure calls, stored, 3-59

profile customization (see customization), 9-11

profile option (sqlj -profile), 8-62

profile-keys class, 9-6

profiles

auditors for debugging, A-26

binary portability, 1-6

code layers, A-26

creation during code generation, 10-2

debug option, 10-26

functionality at runtime, 10-10

generated profiles, 9-7

more about profiles, 10-2

naming generated profiles in server, 11-23

overview, 1-5

print option, 10-27

sample profile entry, 10-3

use of jar files, 10-41

verify option, 10-27

properties files (translator)

default properties files, 8-17

example, 12-3

overview, 8-14

setting input file, 8-20

syntax, 8-15

properties, Java, getProperty(), 9-31

props option (sqlj -props), 8-20

public class name / source name check, 8-77

---

R

READ COMMITTED transactions, 7-39

READ ONLY transactions, 7-39

READ UNCOMMITTED transactions, 7-39

READ WRITE transactions, 7-39

RECORD type (PL/SQL), 5-9

recursive SQLJ calls in server, 11-27

REF CURSOR

about REF CURSOR types, 5-36

example, 5-37

sample application, 12-54

SQLJ support, 5-36

register JDBC drivers

for runtime, 4-5

for translation, 8-42

registering column types/sizes, A-22

registering parameter sizes, A-23

REPEATABLE READ transactions, 7-39

reporting options (translator), 8-42

requirements, environment, 2-3

resource schema object naming

generated, 11-23

loaded, 11-11

result expressions

evaluation at runtime, 3-21

overview, 3-20

result set iterators (weakly typed)

general information, 7-30

introduction, 3-40

scrollable, 7-36

result sets

as host variables, 3-51

as iterator columns, 3-54

as stored function returns, 3-62

commit/rollback effect, 4-29

converting from iterators, 7-49

converting to iterators, 7-47

persistence across calls in server, 11-4

ResultSetIterator type, 7-30

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

rollback

effect on iterators and result sets, 4-29

manual, 4-28

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

debugging output (AuditorInstaller), A-28

error list, B-47

functionality, 9-17

functionality of profiles, 10-10

generated calls to runtime, 9-8

globalization support, 9-21

JDBC driver selection and registration, 4-5

overview, 1-4

packages, 9-18

set up connection, 2-11

steps in runtime processing, 1-15

test, 2-14

---

S

sample applet, SQLJ, 12-87

sample applications

demo directories, 12-2

host expressions, 12-14

interoperability with JDBC, 12-59

JDBC vs. SQLJ, 12-95

multiple connection contexts, 7-7, 12-62

multiple connection schemas, 12-61

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

multithreading, 12-57

named iterator, 12-6

nested tables, 12-37

objects, 12-28

positional iterator, 12-10

REF CURSOR, 12-54

row prefetching, 12-78

server-side SQLJ, 12-94

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

subclassing iterator classes, 12-65

VARRAYs, 12-45

sample classes

custom Java class (BetterDate), 12-49

SerializableDatum class, 6-75

schema objects

naming generated classes, 11-22

naming generated resources, 11-23

naming loaded classes, 11-11

naming loaded resources, 11-11

naming sources, 11-22

scrollable iterators

declaring, 7-31

scrollable named iterators, 7-33

scrollable positional iterators, 7-34

sensitivity, 7-31

the scrollable interface, 7-32

ScrollableResultSetIterator type, 7-36

SELECT INTO statements

error conditions, 3-35

examples, 3-34

syntax, 3-33

semantics-checking

caching online results, 8-71

default checker, Oracle checkers, 8-66

enabling online in server, 11-18

enabling online, setting user schema, 8-32

invoking SQLCheckerCustomizer, 10-43

of profiles, via customizer harness, 10-27

options, 8-66

registering drivers, 8-42

setting default URL prefix, 8-41

setting password, 8-36

setting URL, 8-38

specifying offline checker, 8-67

specifying online checker, 8-69

SQLCheckerCustomizer options, 10-44

steps involved, 9-2

SENSITIVE (cursor state), 3-7

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

ser profiles (.ser)

converting to .class, 8-64

generated profiles, 9-7

ser2class option (sqlj -ser2class), 8-64

SERIALIZABLE transactions, 7-39

serialized objects

as host variables, 6-74

in iterator columns, 6-74

overview, 6-68

SerializableDatum class (sample), 6-75

through custom Java class, 6-71

to RAW and BLOB columns, 6-68

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

server-side SQLJ

class loading, 11-6

coding considerations, 11-3

compilation, 11-6

connection to database, 11-3

CORBA objects, 11-31

default output device, 11-5

dropjava, 11-26

dropping Java schema objects, 11-26

Enterprise JavaBeans, 11-30

error output, 11-24

generated output from translation, 11-21

introduction, 11-2

Java multithreading, 11-27

JDBC differences, 11-4

loading classes/resources into server, 11-8

loading source into server, translating, 11-16

naming generated class schema objects, 11-22

naming generated profiles, 11-23

naming generated resource schema objects, 11-23

naming loaded class schema objects, 11-11

naming loaded resource schema objects, 11-11

naming source schema objects, 11-22

options, 11-18

overview, 1-20

recursive calls, 11-27

running client program in server, 11-13

sample application, 12-94

setting options, 11-19

SQL names vs. Java names, 11-7

translating in server, 11-15

translating on client, 11-8

verifying code is running in server, 11-29

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

SET (assignment) statements, 3-57

SET TRANSACTION syntax, 7-38

setup of SQLJ, testing, 2-11

short names (schema names), 11-21

showReturns option (AuditorInstaller), A-31

showSQL option (Oracle customizer), 10-36

showThreads option (AuditorInstaller), A-32

source check for type resolution, 8-65

source file line-mapping

for jdb, 8-48

general, 8-47

source files encoding option, 8-27

source name / public class name check, 8-77

source schema object naming, 11-22

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

SQL optimizer, A-2

sql option (JPublisher -sql), 6-31

SQL replacement code (dynamic SQL), 7-54

SQL states (for errors), 4-24

SQLCheckerCustomizer

for semantics-checking of profiles, 10-43

invoking, 10-43

options, 10-44

SQLData

specifications, 6-9

use in custom Java classes, 6-6

SQLException subclasses, using, 4-25

SQLJ properties file example, 12-3

SQLJ vs. JDBC, sample application, 12-95

SQLJ_OPTIONS environment variable, 8-18

sqljutl package, 2-10

standard code generation, 10-11

statement caching, A-4

static SQL, defined, 1-2

status messages

for customization, 10-9

for translation, 9-16

translator, enabling/disabling, 8-46

status option (sqlj -status), 8-46

stmtcache option (Oracle customizer), 10-37

stored function calls, 3-60

stored procedure calls, 3-59

streams

as function return values, 5-23

as output parameters, 5-22

classes and methods, 5-24

examples, 5-20

general use in SQLJ, 5-12

precautions, 5-16

processing, 5-19

retrieving data, 5-17

sending data to database, 5-13

supporting classes, 5-12

strongly typed collections, 6-59

strongly typed custom Java classes, 6-2

strongly typed objects and references, 6-53

subclassing iterator classes, 7-29

summary option (Oracle customizer), 10-39

Sun JDK

appropriate JDBC class files, 2-9

supported versions, 2-4

synchronization of execution contexts, 7-18

syntax

translator command line, 8-10

translator properties files, 8-15

syntax-checking, 9-2

---

T

TABLE syntax (nested tables), 6-60, 6-63

TABLE type (PL/SQL), 5-9

Thin driver (JDBC), 4-3

transactions

access mode settings, 7-39

advanced transaction control, 7-38

automatic commit vs. manual commit, 4-26

basic transaction control, 4-26

isolation level settings, 7-39

JDBC Connection methods, 7-40

manual commit and rollback, 4-28

modifying auto-commit, 4-28

overview, 4-26

specifying auto-commit, 4-27

transformGroup (connection context WITH clause), 3-8

TRANSLATE (object member names), 6-41

translating in server to run in server, 11-15

translating on client to run in server, 11-8

translator

basic translation steps, 1-9

code generation, 9-5

code-parsing, syntax-checking, 9-2

compilation, 9-9

customization, 9-11

error list, B-2

error, warning, info messages, 9-13

exit codes, 9-16

globalization support, 9-21

input and output, 1-12

internal operations, 9-2

output, server-side, 11-21

overview, 1-4

semantics-checking, 9-2

status messages, 9-16

support for alternative environments, 8-72

test, 2-14

Type, 5-1

type extensions, 5-25

type mapping

BigDecimal mapping, 6-34

JDBC mapping, 6-34

JPublisher mapping option, 6-31

object JDBC mapping, 6-34

Oracle mapping, 6-34

type categories and mapping modes, 6-33

type resolution, expand search, 8-65

typeMap (connection context WITH clause), 3-7

types option (JPublisher -types), 6-31

types supported

for JDBC 2.0, 5-7

for Oracle8i, 5-10

for Oracle8/Oracle7, 5-10

summary of types, 5-2

unsupported types, 5-8

---

U

uninstall option (AuditorInstaller), A-32

update batching

batch limit, A-17

batchable and compatible statements, A-11

batching incompatible statements, A-18

canceling a batch, A-15

cautions, A-20

enabling and disabling, A-12

error conditions during execution, A-21

explicit and implicit batch execution, A-13

overview, A-11

update counts, A-16

using implicit execution contexts, A-19

with respect to recursive call-ins, A-21

updateColumns/ForUpdate (WITH clause), 3-7

url option (customizer harness), 10-24

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

URL, default prefix for online checking, 8-41

user option (customizer harness), 10-23

user option (JPublisher -user), 6-31

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

user-defined types, 6-20

---

V

VALUES syntax for stored functions, 3-60

VARRAYs

sample application, 12-45

VARRAY types, 6-4

verbose option (customizer harness), 10-22

verify option (customizer harness), 10-27

version compatibility (Oracle customizer), 10-30

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

VM

classpath option, 8-21

options through SQLJ, 8-56

specifying name, 8-73

vm option (sqlj -vm), 8-73

---

W

warn option (SQLCheckerCustomizer), 10-46

warn option (sqlj -warn), 8-43

warning messages, translator, 9-13

warnings, translator, enabling/disabling, 8-43

weak object/collection types

restrictions, 6-78

support, 6-77

weakly typed custom Java classes, 6-2

weakly typed iterators, 7-30

WHERE CURRENT OF, 5-34

Windows, SQLJ development in, 1-25

WITH clause syntax, 3-6

wrapper classes for null-handling, 4-19

wrapper methods (JPub), generating, 6-36