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.5.2

alternative environments, support, 8.4

applets, using SQLJ, 1.6.1

arrays

as iterator columns, 5.1.2

VARRAYs, 6.1.3

ASENSITIVE (cursor state), 4.1.5.1

assignment statements (SET), 4.6

assumptions, environment, 2.1.1

AuditorInstaller

command-line examples, A.6.5

customizer for debugging, A.6

invoking, A.6.2

options, A.6.4

runtime output, A.6.3

auditors in profiles for debugging, A.6.1

auto-commit

modifying in existing connection, 3.5.4

not supported in server, 11.2.2

specifying in new connection, 3.5.3

B

backup option (customizer harness), A.3.2.1

backward compatibility

Oracle SQLJ, general, 2.1.5

to Oracle8i, 5.1.4

batch updates

batch limit, 10.1.3

batchable and compatible statements, 10.1.3

batching incompatible statements, 10.1.3

canceling a batch, 10.1.3

cautions, 10.1.3

enabling and disabling, 10.1.3

error conditions during execution, 10.1.3

explicit and implicit batch execution, 10.1.3

overview, 10.1.3

update counts, 10.1.3

using implicit execution contexts, 10.1.3

with respect to recursive call-ins, 10.1.3

BetterDate (custom Java class), 6.2.6

BFILEs

as stored function results, 5.3.2

BFILE support, 5.3.2

BigDecimal

mapping (for attributes), 6.4.2

support, 5.3.6

binary portability of profiles, 1.2.2.2

bind-by-identifier option (sqlj -bind-by-identifier), 8.3.2

BLOB support, 5.3.2

BOOLEAN type (PL/SQL), 5.1.3

builtintypes option (JPublisher -builtintypes), 6.4.2

C

C prefix (sqlj -C-x), 8.3.1

cache option (sqlj -cache), 8.3.3

caching online checker results, 8.3.3

caching statements, 10.1.2

CALL syntax for stored procedures, 4.7.1

calling stored functions, 4.7.2

calling stored procedures, 4.7.1

calls to runtime, generated, 9.1.3

case option (JPublisher -case), 6.4.2

case-sensitive SQL UDT names, 6.2.3, 6.2.3, 6.4.2, 6.4.3

cause/action output for errors, 8.2.4

CHAR comparisons, blank padding, 8.2.6, A.3.6.7

character encoding

command line example, 9.4.2

for messages, 9.4.2

for source, 9.4.2

overview, 9.4.1

setting at runtime, 9.4.4

using native2ascii, 9.4.4

check source name against. public class, 8.4.1

check sources, expand resolution search, 8.3.2

checker option (SQLCheckerCustomizer), A.5.2.1

checkfilename option (sqlj -checkfilename), 8.4.1

checksource option (sqlj -checksource), 8.3.2

class loading in server, 11.2.4

class schema object naming

generated, 11.4.3

loaded, 11.3.2

classpath and path, 2.2.3

classpath option (sqlj -classpath), 8.2.1

clauses, SQLJ executable statements, 4.2.2

client-side translation to run in server, 11.3

CLOB support, 5.3.2

close() method (DefaultContext), 3.2.5

close() method (ExecutionContext), 7.2.4.6

close() method (Oracle class), 3.2.4, 3.2.5

CLOSE_CONNECTION, 7.6.1

code generation

general information, 9.1.3

Oracle-specific vs. ISO standard, 3.7.1

translator -codegen option, 8.2.6

code layers in profiles, A.6.1

codegen option (SQLJ -codegen), 8.2.6

collections

about custom Java classes, 6.2

creating collection types, 6.3

datatypes, 6.1.4

fundamentals, 6.1.3

introduction to collection support, 6.1.1

mapping to alternative classes, 6.4.2

ORAData specifications, 6.2.1

specifying type mapping, 6.4.2, 6.4.2

strongly typed, 6.6

weak types, restrictions, 6.8.2

weak types, support, 6.8.1

column definitions (types/sizes)

general information, 10.1.4

Oracle customizer optcols option, A.3.6.4

SQLJ -optcols option, 8.2.6

command line (translator)

echoing without executing, 8.1.2

example, 8.1.2

overview, 8.1

syntax and arguments, 8.1.2

commit

automatic vs. manual, 3.5.2

effect on iterators and result sets, 3.5.6

manual, 3.5.5

modifying auto-commit in existing connection, 3.5.4

specifying auto-commit in new connection, 3.5.3

compat(ibility) option (Oracle customizer), A.3.6.2

compatible option (JPublisher -compatible), 6.4.2

compilation

compiling in two passes, 8.4.1

debug option in server, 11.4.2

during translation, 9.1.4

enabling/disabling, 8.3.2

in server, 11.2.4

compile option (sqlj -compile), 8.3.2

compiler

classpath option, 8.2.1

option support for javac, 8.1.1

options through SQLJ, 8.3.1

related options, 8.4.1

required behavior, 8.4.1

specifying name, 8.4.1

compiler encoding support option (sqlj), 8.4.1

compiler executable option (sqlj), 8.4.1

compiler message output pipe option (sqlj), 8.4.1

compiler output file option (sqlj -compiler...), 8.4.1

components option (sqlj -components), 8.2.5

configuration and installation verification, 2.2

connect string

for OCI driver, 3.1.1

for Thin driver, 3.1.1

server-side internal driver, 3.1.1

server-side Thin driver, 3.1.1

SIDs deprecated, 2.3.1

use of database service names, 2.3.1

connect() method (Oracle class), 3.2.4

connection contexts

close connection, 7.1.5

concepts, 7.1.1

converting from JDBC connection, 7.6.1

converting to JDBC connection, 7.6.1

declaration with IMPLEMENTS clause, 7.1.6

declarations, 4.1.3

declaring connection context class, 7.1.3

from SQLJ data sources, 7.1.9, 7.1.10

get default connection, 7.1.5

get execution context, 7.1.5

get JDBC connection, 7.1.5

implementation and functionality, 7.1.5

instantiating connection object, 7.1.3

methods, 7.1.5

multiple connections, example, 7.1.4

relation to execution contexts, 7.2.1

semantics-checking, 7.1.7

set default connection, 7.1.5

specifying connection for statement, 7.1.3

specifying for executable statement, 4.2.3

connections

closing, 3.2.2

closing shared connections with JDBC, 7.6.1

database connection in server, 11.2.1

from SQLJ data sources, 7.1.9, 7.1.10

JDBC transaction methods, 7.5.4

modifying auto-commit, 3.5.4

multiple, using declared connect contexts, 3.2.3

Oracle class to connect, 3.2.4

set up, 2.3.1

shared connections with JDBC, 7.6.1

single or multiple using default context, 3.2.1

specifying auto-commit, 3.5.3

translator options, 8.2.3

verify, 2.3.2

context expressions

evaluation at runtime, 4.3.5

overview, 4.3.4

context option (customizer harness), A.3.2.2

converting .ser profiles to .class, 8.3.2

CURSOR syntax (nested tables), 6.6.1

custom Java classes

about custom Java classes, 6.2

compiling, 6.2.4

creation by JPublisher, 6.4

examples, 6.4.6

extending, 6.4.7

generation by JPublisher, 6.4.2

mapping to alternative classes, 6.4.2

reading and writing data, 6.2.5

requirements, 6.2.3

sample class, 6.2.6

specifying member names, 6.4.4

strongly typed, definition, 6.1.1

support for object methods, 6.2.2

using to serialize object, 6.7.2

weakly typed, definition, 6.1.1

CustomDatum (deprecated), 6.2.1

customization

converting .ser profiles to .class, 8.3.2

creation and registration, A.2.3

customizer harness connection options, A.3.3

customizer harness general options, A.3.2

customizer harness options overview, A.3.1

defining column types/sizes, A.3.6.4

defining parameter sizes, A.3.6.5

during translation, 9.1.5

enabling/disabling, 8.3.2

error and status messages, A.2.4

force customization, A.3.6.3

jar file usage, A.4

more about customization, A.2

options, A.3

options to invoke special customizers, A.3.4

Oracle customizer options, A.3.6

overview/syntax of customizer-specific options, A.3.5

parameter default sizes, A.3.6.6

related SQLJ options, A.3.8

show SQL transformations, A.3.6.8

statement cache size, A.3.6.9

steps in process, A.2.2

summary of Oracle features used, A.3.6.10

version compatibility, A.3.6.2

customizer, 1.2.1

customizer harness

connection options, A.3.3

general options, A.3.2

invoke special customizers, A.3.4

options overview, A.3.1

overview, A.2.1

customizer option (customizer harness), A.3.2.3

customizers

choosing, A.3

option to choose customizer, A.3.2.3

overview, A.2.1

passing options through SQLJ, 8.3.1

specifying default, 8.4.2

D

d option (sqlj -d), 8.2.2

data source support

associating a connection, 7.1.8

associating a default context, 7.1.8

auto-commit mode, 7.1.8

dataSource (WITH clause), 4.1.5.1

general overview, 7.1.8

requirements, 7.1.8

SQLJ data source classes, 7.1.9

SQLJ data source interfaces, 7.1.9

SQLJ-specific data sources, 7.1.9

database connection, verify, 2.3.2

database URL

default prefix for online checking, 8.2.3

SIDs deprecated, 2.3.1

use of database service names, 2.3.1

DBMS_JAVA package

set server output device, 11.2.3

set server-side options, 11.4.2

DBMS_LOB package, 5.3.2

debug option (customizer harness), A.3.4.1

debug option for compile (in server), 11.4.2

debugging

AuditorInstaller command-line examples, A.6.5

AuditorInstaller customizer, A.6

AuditorInstaller options, A.6.4

AuditorInstaller runtime output, A.6.3

debug option for compile (in server), 11.4.2

debug option, customizer harness, A.3.4.1

in JDeveloper, 10.2.4

invoking AuditorInstaller, A.6.2

line-mapping, SQLJ source to class, 8.2.4

line-mapping, SQLJ source to class for jdb, 8.2.4

declarations

connection context declarations, 4.1.3

IMPLEMENTS clause, 4.1.4

iterator declarations, 4.1.2

overview, 4.1

WITH clause, 4.1.5

default connection

setting with Oracle.connect(), 3.2.1

setting with setDefaultContext(), 3.2.1

default customizer option (sqlj), 8.4.2

default output device in server, 11.2.3

default properties files (translator), 8.1.3

default semantics-checker, 8.3.3

default URL prefix option (sqlj), 8.2.3

DefaultContext class

close() method parameters, 3.2.5

constructors, 3.2.5

key methods, 3.2.5

use for single or multiple connections, 3.2.1

defining column types/sizes, 10.1.4

defining parameter sizes, 10.1.5

demo applications (SQLJ), availability, 2.2.1

depth option (AuditorInstaller), A.6.4.1

digests option, jar (customizer harness), A.3.2.4

dir option (sqlj -dir), 8.2.2

E

echo option, without execution, 8.2.1

echoing command line without executing, 8.1.2

encoding

character encoding for messages, 9.4.2

character encoding for source, 9.4.2

command line example, 9.4.2

do not pass option to compiler, 8.4.1

overview of character encoding, 9.4.1

setting at runtime, 9.4.4

specifying in server, 11.4.2

using native2ascii, 9.4.4

encoding option (in server), 11.4.2

encoding option, source files (sqlj -encoding), 8.2.2

environment assumptions and requirements, 2.1

environment variable, translator options, 8.1.4

environments--scenarios and limitations, 2.1.3

errors

character encoding for messages, 9.4.2

customization messages, A.2.4

messages, codes, and SQL states, 3.4.2

outputting cause and action, 8.2.4

runtime categories, 9.3.2

server-side error output, 11.4.4

translator error, warning, info messages, 9.2.1

exceptions

exception-handling requirements, 3.4.1

processing, 3.4.2

set up exception-handling, 3.6

using SQLException subclasses, 3.4.3

executable statements

examples, 4.2.4

overview, 4.2

rules, 4.2.1

specifying connection/execution contexts, 4.2.3

SQLJ clauses, 4.2.2

using PL/SQL blocks, 4.2.5

execution contexts

cancellation method, 7.2.4.3

close() method, 7.2.4.6

control methods, 7.2.4.2

creating and specifying, 7.2.2

method usage, example, 7.2.4.7

overview, 7.2

relation to connection contexts, 7.2.1

relation to multithreading, 7.2.5

savepoint methods, 7.2.4.5

specifying for executable statement, 4.2.3

status methods, 7.2.4.1

synchronization, 7.2.3

update-batching methods, 7.2.4.4

exemplar schema, 3.2.6

exit codes, translator, 9.2.3

explain option (sqlj -explain), 8.2.4

extending iterator classes, 7.4.3

extending JPub-generated classes, 6.4.7

extensions

overview, 1.3

performance extensions, 10.1

summary of features used, A.3.6.10

type extensions, 5.3

F

FETCH CURRENT syntax (iterators), 7.4.5

FETCH syntax (scrollable positional iterators), 7.4.5

file name requirements and restrictions, 3.8.4

fixedchar option (Oracle customizer), A.3.6.7

fixedchar option (SQLJ -fixedchar), 8.2.6

flags for special processing, 8.3.2

force option (Oracle customizer), A.3.6.3

ForUpdate/updateColumns (WITH clause), unsupported, 4.1.5.1

full names (schema names), 11.3.2

function calls, stored, 4.7.2

G

getConnection() method (Oracle class), 3.2.4

globalization support

character encoding, language support, 9.4.1

outside of SQLJ, 9.4.4

overview, 1.7.1

related datatypes, 5.1.1

related Java types, 9.4.3

related SQLJ and Java settings, 9.4.2

support for Unicode characters, 9.4.3

H

help option (customizer harness), A.3.2.5

help options (sqlj -help-xxxx), 8.2.1

hints in code, parameter sizes, 10.1.5

holdability (cursor states, WITH clause), unsupported, 4.1.5.1

host expressions

basic syntax, 4.3.2

bind by identifier, 8.3.2

evaluation at runtime, 4.3.5

examples, 4.3.3

examples of evaluation at runtime, 4.3.6

iterators and result sets as host variables, 4.5.6

overview, 4.3.1

restrictions, 4.3.7

selecting a nested table, 6.6.3

supported types for JDBC 2.0, 5.1.2

type support for Oracle8i, 5.1.4

type support summary, 5.1.1

host variables, 1.4.1

I

IDE SQLJ integration, 1.7.2

IMPLEMENTS clause

in connection context declarations, 7.1.6

in iterator declarations, 7.4.2

syntax, 4.1.4

importing required classes, 3.6

informational messages, translator, 9.2.1

input to translator, 1.4.2

INSENSITIVE (cursor state), 4.1.5.1

installation and configuration verification, 2.2

instrument option (sqlj -instrument), 8.2.5

instrumenting class file (linemap), 8.2.4

interoperability with JDBC

connection contexts and connections, 7.6.1

iterators and result sets, 7.6.2

introduction to SQLJ, 1.1

isolation level settings (transactions), 7.5.3

iterators

accessing named iterators, 4.5.4

accessing positional iterators, 4.5.5

array columns, 5.1.2

as host variables, 4.5.6

as iterator columns (nested), 4.5.7

as stored function returns, 4.7.3

commit/rollback effect, 3.5.6

concepts, 4.5.1

converting from result sets, 7.6.2

converting to result sets, 7.6.2

declarations, 4.1.2

declaring named iterators, 4.5.4

declaring positional iterators, 4.5.5

declaring with IMPLEMENTS clause, 7.4.2

extending, 7.4.3

general steps in using, 4.5.2

instantiating/populating named iterators, 4.5.4

instantiating/populating positional iterators, 4.5.5

iterator class functionality, 7.4.1

named vs. positional, 4.5.3

nested iterators for nested tables, 6.6.5

overview, 4.5

positional iterators, using next(), 4.5.5

result set iterators (weakly typed), 4.5.1.2, 7.4.4

scrollable, 7.4.5

scrollable result set iterators, 7.4.5

selecting objects and references, 6.5.1

set up named iterator (example), 3.6

subclassing, 7.4.3

using named iterators, 4.5.4

using positional iterators, 4.5.5

using weakly typed iterators, 7.6.2

with serialized objects, 6.7.3

J

J prefix (sqlj -J-x), 8.3.1

jar file digests option, customization, A.3.2.4

jar files for profiles, A.4

Java bind expressions (dynamic SQL), 7.7.1

Java names vs. SQL names in server, 11.2.5

Java properties, getProperty(), 9.4.4

Java VM

classpath option, 8.2.1

options through SQLJ, 8.3.1

specifying name, 8.4.1

JavaBeans for SQLJ connections, 7.1.10

javac compatibility, 8.1.1

JDBC 2.0

support for LOB types, 5.3

support for weakly typed Struct, Ref, Array, 6.8

types supported, 5.1.2

JDBC connection methods (transactions), 7.5.4

JDBC considerations in server, 11.2.2

JDBC driver registration option (sqlj -driver), 8.2.3

JDBC drivers

Oracle drivers, 3.1.1

select for translation, 3.1.2

select/register for customization, A.3.3.4

select/register for runtime, 3.1.3

verify, 2.3.3

JDBC interoperability

connection contexts and connections, 7.6.1

iterators and result sets, 7.6.2

JDBC mapping (for attributes), 6.4.2

JDBC vs. SQLJ, sample application, 1.5

jdblinemap option (sqlj -jdblinemap), 8.2.4

JDeveloper

debugging with, 10.2.4

SQLJ integration, 1.7.2

JDK

appropriate JDBC class files, 2.2.3

supported versions, 2.1.3

JNDI

name of default data source, 7.1.8

use for data sources, connections, 7.1.8

JPublisher

builtintypes option, 6.4.2

case option, 6.4.2

compatible option, 6.4.2

creation of custom Java classes, 6.4

custom Java class examples, 6.4.6

extending generated classes, 6.4.7

generating custom Java classes, 6.4.2

generating wrapper methods, 6.4.2

implementation of method wrappers, 6.4.5

input files, 6.4.3

lobtypes option, 6.4.2

mapping to alternative classes, 6.4.2

numbertypes option, 6.4.2

properties files, 6.4.3

specifying member names, 6.4.4

specifying type mapping, 6.4.2

sql option, 6.4.2

type categories and mapping options, 6.4.2

type mapping, 6.4.2

type mapping modes and option settings, 6.4.2

types option, 6.4.2

user option, 6.4.2

what JPublisher produces, 6.4.1

K

KEEP_CONNECTION, 7.6.1

L

language support (globalization support), 9.4.1

linemap option (sqlj -linemap), 8.2.4

line-mapping

SQLJ source to class file, 8.2.4

SQLJ source to class for jdb, 8.2.4

loading classes/resources into server, 11.3.1

loading/translating source in server, 11.4.1

loadjava

compatibility options, SQLJ, 8.1.1

loading classes/resources, 11.3.1

loading source, translating, 11.4.1

output from loading source, 11.4.3

LOBs

as iterator columns, 5.3.2

as stored function results, 5.3.2

FETCH INTO LOB host variables, 5.3.2

SELECT INTO LOB host variables, 5.3.2

support (oracle.sql and DBMS_LOB), 5.3.2

lobtypes option (JPublisher -lobtypes), 6.4.2

locale

command line example, 9.4.2

for messages, 9.4.2

setting at runtime, 9.4.4

log option (AuditorInstaller), A.6.4.2

M

mapping to alternative classes (UDTs), 6.4.2

member names (objects), 6.4.4

message pipe, compiler, 8.4.1

meta bind expressions (dynamic SQL), 7.7.1

method support for objects, 6.2.2

method wrappers (JPub), implementation, 6.4.5

middle-tier considerations, 3.9

multithreading

in server, 11.6.1

in SQLJ, overview, 7.3

relation to execution contexts, 7.2.5

sample application, 7.3

N

n option (sqlj -n) (echo without execution), 8.2.1

name of compiler, 8.4.1

name of Java VM, 8.4.1

named iterators

accessing, 4.5.4

declaring, 4.5.4

instantiating and populating, 4.5.4

scrollable, 7.4.5

using, 4.5.4

naming requirements and restrictions

file names, 3.8.4

local variables, classes (Java namespace), 3.8.1

SQL namespace, 3.8.3

SQLJ namespace, 3.8.2

naming schema objects

generated class, 11.4.3

loaded classes, 11.3.2

loaded resources, 11.3.2

source, 11.4.3

native2ascii for encoding, 9.4.4

NCHAR class (globalization support), 9.4.3

NcharAsciiStream class (globalization support), 9.4.3

ncharconv translator option, 8.1.1, 9.4.3

NcharUnicodeStream class (globalization support), 9.4.3

NCLOB class (globalization support), 9.4.3

nested iterators, 6.6.5

nested tables

accessing, 6.6.1

inserting in SQLJ, 6.6.2

manipulating, 6.6.4

selecting into host expression, 6.6.3

types, 6.1.3

using nested iterator, 6.6.5

non-repeatable reads, 7.5.3

NString class, 9.4.3

NString class (globalization support), 9.4.3

null-handling

examples, 3.3.2

wrapper classes for null-handling, 3.3.1

numbertypes option (JPublisher -numbertypes), 6.4.2

O

object method wrappers (JPub), 6.4.5

object references

selecting into iterators, 6.5.1

strongly typed in SQLJ, 6.5

updating in SQLJ, 6.5.4

weak types, restrictions, 6.8.2

weak types, support, 6.8.1

object-JDBC mapping (for attributes), 6.4.2

objects

about custom Java classes, 6.2

creating object types, 6.3

datatypes, 6.1.4

fundamentals, 6.1.2

inserting in SQLJ, 6.5.3

introduction to object support, 6.1.1

mapping to alternative classes, 6.4.2

method support, 6.2.2

ORAData specifications, 6.2.1

selecting into iterators, 6.5.1

serializing (overview), 6.7

serializing RAW and BLOB columns, 6.7.1

serializing with custom Java class, 6.7.2

specifying type mapping, 6.4.2, 6.4.2

SQLData specifications, 6.2.1

strongly typed in SQLJ, 6.5

updating a reference in SQLJ, 6.5.4

updating in SQLJ, 6.5.2

weak types, restrictions, 6.8.2

weak types, support, 6.8.1

wrapper methods, 6.4.2

OCI driver (JDBC), 3.1.1

offline checking

default checker, Oracle checkers, 8.3.3

specifying checker, 8.3.3

offline option (sqlj -offline), 8.3.3

offline parsing

sqlj -parse option, 8.3.3

steps involved, 9.1.2

vs. online checking, 8.3.3

online checking

caching results, 8.3.3

default checker, Oracle checkers, 8.3.3

enabling in server, 11.4.2

enabling, setting user schema, 8.2.3

registering drivers, 8.2.3

setting default URL prefix, 8.2.3

setting password, 8.2.3

setting URL, 8.2.3

specifying checker, 8.3.3

vs. offline parsing, 8.3.3

online option (in server), 11.4.2

online option (sqlj -online), 8.3.3

opaque types, 6.9

optcols option (Oracle customizer), A.3.6.4

optcols option (SQLJ -optcols), 8.2.6

optimizer, SQL, 10.1, 10.1

options (translator)

command line only, 8.2.1

flags for special processing, 8.3.2

for connections, 8.2.3

for customization, 8.4.2

for javac compatibility, 8.1.1

for loadjava compatibility, 8.1.1

for output files and directories, 8.2.2

for reporting and line-mapping, 8.2.4

for semantics-checking, offline parsing, 8.3.3

for VM and compiler, 8.4.1

help, 8.2.1

order of precedence, 8.1.5

overview, 8.1.1

prefixes for passing options, 8.3.1

summary list, 8.1.1

support for alternative environments, 8.4

options for customizer harness

connection options, A.3.3

general options, A.3.2

invoke special customizers, A.3.4

overview, A.3.1

options for Oracle customizer, A.3.6

options for translation in server

fixed settings, 11.4.2

setting options, 11.4.2

supported options, 11.4.2

optparamdefaults option (Oracle customizer), A.3.6.6

optparamdefaults option (SQLJ -optparamdefaults), 8.2.6

optparams option (Oracle customizer), A.3.6.5

optparams option (SQLJ -optparams), 8.2.6

Oracle class

close() method parameters, 3.2.4

connect() method, 3.2.4

for DefaultContext instances, 3.2.4

getConnection() method, 3.2.4

Oracle customizer

blank padding for CHAR comparisons, A.3.6.7

define column types/sizes, A.3.6.4

define parameter sizes, A.3.6.5

force customization, A.3.6.3

options, A.3.6

set default parameter sizes, A.3.6.6

show SQL transformation, A.3.6.8

statement cache size, A.3.6.9

summary of Oracle features used, A.3.6.10

version compatibility, A.3.6.2

Oracle extensions

overview, 1.3

performance extensions, 10.1

summary of features used, A.3.6.10

type extensions, 5.3

Oracle mapping (for attributes), 6.4.2

Oracle optimizer, 10.1, 10.1

Oracle system identifiers (SIDs) in connect strings, deprecated, 2.3.1

OracleChecker default checker, 8.3.3

Oracle-specific code generation

advantages and disadvantages, 3.7.1

coding considerations, limitations, 3.7.3

environment requirements, 3.7.2

introduction, 1.1.2, 3.7

server-side considerations, 3.7.5

translator/customizer usage changes, 3.7.4

oracle.sql package, 5.3.1

ORAData

additional uses, 6.2.6

specifications, 6.2.1

use in custom Java classes, 6.2

versus CustomDatum, 6.2.1

output device in server, default, 11.2.3

output directory

for generated .class and .ser, 8.2.2

for generated .java, 8.2.2

output file and directory options (translator), 8.2.2

output file for compiler, 8.4.1

output from server-side translator, 11.4.3

output from translator, 1.4.2

output pipe, compiler messages, 8.4.1

output, server-side translator errors, 11.4.4

P

P prefix (sqlj -P-x), 8.3.1

parameter definitions (sizes)

general information, 10.1.5

Oracle customizer optparamdefaults option, A.3.6.6

Oracle customizer optparams option, A.3.6.5

SQLJ -optparamdefaults option, 8.2.6

SQLJ -optparams option, 8.2.6

parse option (sqlj -parse), 8.3.3

passes option (sqlj -passes), 8.4.1

passes, two-pass compiling, 8.4.1

passing options to other executables, 8.3.1

password option (customizer harness), A.3.3.2

password option for checking (sqlj), 8.2.3

path (WITH clause), unsupported, 4.1.5.1

path and classpath, 2.2.3

performance enhancements, 10.1

performance monitoring, DMS support, 10.3

phantom reads, 7.5.3

pipe, compiler output messages, 8.4.1

PL/SQL

blocks in executable statements, 4.2.5

BOOLEAN type, 5.1.3

RECORD type, 5.1.3

TABLE type, 5.1.3

positional iterators

accessing, 4.5.5

declaring, 4.5.5

instantiating and populating, 4.5.5

navigation with next(), 4.5.5

scrollable, 7.4.5

using, 4.5.5

positioned delete, 5.3.3

positioned update, 5.3.3

prefetching rows, 10.1.1

prefix option (AuditorInstaller), A.6.4.3

prefixes

to pass options to customizer, 8.3.1

to pass options to Java compiler, 8.3.1

to pass options to Java VM, 8.3.1

print option (customizer harness), A.3.4.2

procedure calls, stored, 4.7.1

profile customization (see customization), 9.1.5

profile option (sqlj -profile), 8.3.2

profile-keys class, 1.4.1, 9.1.3

profiles

auditors for debugging, A.6.1

binary portability, 1.2.2.2

code layers, A.6.1

creation during code generation, A.1.1

debug option, A.3.4.1

functionality at runtime, A.2.5

generated profiles, 9.1.3

more about profiles, A.1

overview, 1.2.2

print option, A.3.4.2

sample profile entry, A.1.2

use of jar files, A.4

verify option, A.3.4.3

properties files (translator)

default properties files, 8.1.3

overview, 8.1.3

setting input file, 8.2.1

syntax, 8.1.3

properties files, SQLJ DMS, 10.3.3

properties, Java, getProperty(), 9.4.4

props option (sqlj -props), 8.2.1

public class name /source name check, 8.4.1

R

READ COMMITTED transactions, 7.5.3

READ ONLY transactions, 7.5.2

READ UNCOMMITTED transactions, 7.5.3

READ WRITE transactions, 7.5.2

RECORD type (PL/SQL), 5.1.3

recursive SQLJ calls in server, 11.6.2

REF CURSOR

about REF CURSOR types, 5.3.4

example, 5.3.4

SQLJ support, 5.3.4

for runtime, 3.1.3

for translation, 8.2.3

registering column types/sizes, 10.1.4

registering parameter sizes, 10.1.5

REPEATABLE READ transactions, 7.5.3

reporting options (translator), 8.2.4

requirements, environment, 2.1.2

resource schema object naming

loaded, 11.3.2

result expressions

evaluation at runtime, 4.3.5

overview, 4.3.4

result set iterators (weakly typed)

general information, 7.4.4

introduction, 4.5.1.2

scrollable, 7.4.5

result sets

as host variables, 4.5.6

as iterator columns, 4.5.7

as stored function returns, 4.7.3

commit/rollback effect, 3.5.6

converting from iterators, 7.6.2

converting to iterators, 7.6.2

persistence across calls in server, 11.2.2

ResultSetIterator type, 7.4.4

returnability (cursor states, WITH clause), 4.1.5.1, 4.1.5.3

rollback

effect on iterators and result sets, 3.5.6

manual, 3.5.5

with savepoint, 3.5.7

row prefetching, 10.1.1

ROWID

as stored function results, 5.3.3

FETCH INTO ROWID host variable, 5.3.3

SELECT INTO ROWID host variable, 5.3.3

support, 5.3.3

runtime

categories of errors, 9.3.2

debugging output (AuditorInstaller), A.6.3

functionality, 9.3

functionality of profiles, A.2.5

generated calls to runtime, 9.1.3

globalization support, 9.4

JDBC driver selection and registration, 3.1.3

overview, 1.2.1

packages, 9.3.1

set up connection, 2.3.1

steps in runtime processing, 1.4.3

test, 2.3.4

S

sample applications

JDBC vs. SQLJ, 1.5

multiple connection contexts, 7.1.4

multiple-row query (named iterator), 3.6

multithreading, 7.3

single-row query (SELECT INTO), 3.6

sample classes

custom Java class (BetterDate), 6.2.6

SerializableDatum class, 6.7.4

savepoints

ExecutionContext savepoint methods, 7.2.4.5

ISO syntax, 3.5.7

Oracle syntax, 3.5.7

savepoint statements, 3.5.7

schema objects

naming generated classes, 11.4.3

naming loaded classes, 11.3.2

naming loaded resources, 11.3.2

naming sources, 11.4.3

scrollable iterators

declaring, 7.4.5

scrollable named iterators, 7.4.5

scrollable positional iterators, 7.4.5

sensitivity, 7.4.5

the scrollable interface, 7.4.5

ScrollableResultSetIterator type, 7.4.5

SELECT INTO statements

error conditions, 4.4.4

examples, 4.4.2, 4.4.3

syntax, 4.4.1

semantics-checking

caching online results, 8.3.3

default checker, Oracle checkers, 8.3.3

enabling online in server, 11.4.2

enabling online, setting user schema, 8.2.3

invoking SQLCheckerCustomizer, A.5.1

of profiles, via customizer harness, A.3.4.3

options, 8.3.3

registering drivers, 8.2.3

setting default URL prefix, 8.2.3

setting password, 8.2.3

setting URL, 8.2.3

specifying offline checker, 8.3.3

specifying online checker, 8.3.3

SQLCheckerCustomizer options, A.5.2

steps involved, 9.1.2

SENSITIVE (cursor state), 4.1.5.1

sensitivity (cursor states, WITH clause), 4.1.5.1

ser profiles (.ser)

converting to .class, 8.3.2

generated profiles, 9.1.3

ser2class option (sqlj -ser2class), 8.3.2

SERIALIZABLE transactions, 7.5.3

serialized objects

as host variables, 6.7.3

in iterator columns, 6.7.3

overview, 6.7

SerializableDatum class (sample), 6.7.4

through custom Java class, 6.7.2

to RAW and BLOB columns, 6.7.1

server-side internal driver (JDBC), 3.1.1

server-side SQLJ

class loading, 11.2.4

coding considerations, 11.2

compilation, 11.2.4

connection to database, 11.2.1

default output device, 11.2.3

dropjava, 11.5

dropping Java schema objects, 11.5

error output, 11.4.4

fixed settings, 11.4.2

generated output from translation, 11.4.3

introduction, 11.1

Java multithreading, 11.6.1

JDBC differences, 11.2.2

loading classes/resources into server, 11.3.1

loading source into server, translating, 11.4.1

naming generated class schema objects, 11.4.3

naming loaded class schema objects, 11.3.2

naming loaded resource schema objects, 11.3.2

naming source schema objects, 11.4.3

options, 11.4.2

overview, 1.6.2

recursive calls, 11.6.2

running client program in server, 11.3.4

setting options, 11.4.2

SQL names vs. Java names, 11.2.5

translating in server, 11.4

translating on client, 11.3

verifying code is running in server, 11.6.3

server-side Thin driver (JDBC), 3.1.1

SET (assignment) statements, 4.6

SET TRANSACTION syntax, 7.5.1

setFormOfUse method, 9.4.3

setup of SQLJ, testing, 2.3

short names (schema names), 11.3.2

showReturns option (AuditorInstaller), A.6.4.4

showSQL option (Oracle customizer), A.3.6.8

showThreads option (AuditorInstaller), A.6.4.5

SIDs in connect strings, deprecated, 2.3.1

source check for type resolution, 8.3.2

source file line-mapping

for jdb, 8.2.4

general, 8.2.4

source files encoding option, 8.2.2

source name /public class name check, 8.4.1

source schema object naming, 11.4.3

SQL names vs. Java names in server, 11.2.5

SQL optimizer, 10.1, 10.1

sql option (JPublisher -sql), 6.4.2

SQL replacement code (dynamic SQL), 7.7.1

SQL states (for errors), 3.4.2

SQLCheckerCustomizer

for semantics-checking of profiles, A.5

invoking, A.5.1

options, A.5.2

SQLData

specifications, 6.2.1

use in custom Java classes, 6.2

SQLException subclasses, using, 3.4.3

SQLJ vs. JDBC, sample application, 1.5

SQLJ_OPTIONS environment variable, 8.1.4

SqljConnBean for simple connection, 7.1.10

SqljConnCacheBean for connection caching, 7.1.10

sqljutl package, 2.2.4

statement caching, 10.1.2

static SQL, defined, 1.1.1

status messages

for customization, A.2.4

for translation, 9.2.2

translator, enabling/disabling, 8.2.4

status option (sqlj -status), 8.2.4

stmtcache option (Oracle customizer), A.3.6.9

stored function calls, 4.7.2

stored procedure calls, 4.7.1

streams

as function return values, 5.2.8

as output parameters, 5.2.8

classes and methods, 5.2.6

examples, 5.2.7

general use in SQLJ, 5.2.1

precautions, 5.2.4

retrieving data, 5.2.5

sending data to database, 5.2.3

supporting classes, 5.2

strongly typed collections, 6.6

strongly typed custom Java classes, 6.1.1

strongly typed objects and references, 6.5

subclassing iterator classes, 7.4.3

summary option (Oracle customizer), A.3.6.10

Sun JDK

appropriate JDBC class files, 2.2.3

supported versions, 2.1.3

synchronization of execution contexts, 7.2.3

syntax

translator command line, 8.1.2

translator properties files, 8.1.3

system identifiers (SIDs) in connect strings, deprecated, 2.3.1

T

TABLE syntax (nested tables), 6.6.1, 6.6.4

TABLE type (PL/SQL), 5.1.3

Thin driver (JDBC), 3.1.1

transactions

access mode settings, 7.5.2

advanced transaction control, 7.5

automatic commit vs. manual commit, 3.5.2

basic transaction control, 3.5

isolation level settings, 7.5.3

JDBC Connection methods, 7.5.4

manual commit and rollback, 3.5.5

modifying auto-commit, 3.5.4

overview, 3.5.1

savepoints for rollbacks, 3.5.7

specifying auto-commit, 3.5.3

transformGroup ( WITH clause), unsupported, 4.1.5.1

TRANSLATE (object member names), 6.4.4

translating in server to run in server, 11.4

translating on client to run in server, 11.3

translator

basic translation steps, 1.4.1

code generation, 9.1.3

compilation, 9.1.4

customization, 9.1.5

error, warning, info messages, 9.2.1

exit codes, 9.2.3

globalization support, 9.4

input and output, 1.4.2

internal operations, 9.1

Java and SQLJ code-parsing, syntax-checking, 9.1.1

output, server-side, 11.4.3

overview, 1.2.1

SQL semantics-checking and offline parsing, 9.1.2

status messages, 9.2.2

support for alternative environments, 8.4

test, 2.3.4

type extensions, 5.3

type mapping

BigDecimal mapping, 6.4.2

JDBC mapping, 6.4.2

JPublisher mapping option, 6.4.2

object JDBC mapping, 6.4.2

Oracle mapping, 6.4.2

type categories and mapping modes, 6.4.2

type resolution, expand search, 8.3.2

typeMap (WITH clause), 4.1.5.1

types option (JPublisher -types), 6.4.2

types supported

for JDBC 2.0, 5.1.2

for Oracle8i, 5.1.4

summary of types, 5.1.1

U

uninstall option (AuditorInstaller), A.6.4.6

update batching

batch limit, 10.1.3

batchable and compatible statements, 10.1.3

batching incompatible statements, 10.1.3

canceling a batch, 10.1.3

cautions, 10.1.3

enabling and disabling, 10.1.3

error conditions during execution, 10.1.3

explicit and implicit batch execution, 10.1.3

overview, 10.1.3

update counts, 10.1.3

using implicit execution contexts, 10.1.3

with respect to recursive call-ins, 10.1.3

updateColumns/ForUpdate (WITH clause), unsupported, 4.1.5.1

url option (customizer harness), A.3.3.3

url option for checking (sqlj -url), 8.2.3

URL, database

default prefix for online checking, 8.2.3

SIDs deprecated, 2.3.1

use of database service names, 2.3.1

user option (customizer harness), A.3.3.1

user option (JPublisher -user), 6.4.2

user option for checking (sqlj -user), 8.2.3

user-defined types, 6.3

V

VALUES syntax for stored functions, 4.7.2

VARRAYs

inserting a row, 6.6.7

selecting into host expression, 6.6.6

VARRAY types, 6.1.3

verbose option (customizer harness), A.3.2.6

verify option (customizer harness), A.3.4.3

version compatibility (Oracle customizer), A.3.6.2

version number options (sqlj -version-xxxx), 8.2.1

classpath option, 8.2.1

options through SQLJ, 8.3.1

specifying name, 8.4.1

vm option (sqlj -vm), 8.4.1

W

warn option (SQLCheckerCustomizer), A.5.2.2

warn option (sqlj -warn), 8.2.4

warning messages, translator, 9.2.1

warnings, translator, enabling/disabling, 8.2.4

weak object/collection types

restrictions, 6.8.2

support, 6.8.1

weakly typed custom Java classes, 6.1.1

weakly typed iterators, 7.4.4

WHERE CURRENT OF, 5.3.3

WHERE CURRENT OF clause, 5.3.3

Windows, SQLJ development in, 1.7.3

WITH clause syntax, 4.1.5

wrapper classes for null-handling, 3.3.1

wrapper methods (JPub), generating, 6.4.2