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, 2.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, 1.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, 1.1.5
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, 3.8.3.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, 1.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.4
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
mapping to alternative classes, 6.4.2
ORAData specifications, 6.2.1
overview of collection support, 6.1.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 output file option (sqlj -compiler...), 8.4.1
components option (sqlj -components), 8.2.5
configuration and installation verification, 1.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, 1.3.1
use of database service names, 1.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, 1.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, 1.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, 3.8.2, 3.8.2
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, 1.3.2
database URL
default prefix for online checking, 8.2.3
SIDs deprecated, 1.3.1
use of database service names, 1.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, 1.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
directory
for generated .class and .ser, 8.2.2
for generated .java, 8.2.2
dirty reads, 7.5.3
DMS support
command-line options for DMS, 8.2.5, 10.3.2
examples, 10.3.5
overview of DMS support, 10.3.1
runtime commands for DMS, 10.3.3
sensors and metrics, 10.3.4
SQLJ DMS properties files, 10.3.3
driver option (customizer harness), A.3.3.4
driver registration option (sqlj -driver), 8.2.3
dropjava, 11.5
dropping Java schema objects, 11.5
Dynamic Monitoring Service, SQLJ support, 10.3
dynamic SQL
defined, 2.1
in JDBC code, 7.6
in PL/SQL code, 4.2.5
dynamic SQL support in SQLJ
examples, 7.7.2
introduction, 7.7
meta bind expressions, 7.7.1
runtime behavior, 7.7.1
translation-time behavior, 7.7.1

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, 1.1
environment variable, translator options, 8.1.4
environments--scenarios and limitations, 1.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, 2.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.10.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, 2.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 summary, 5.1.1
host variables, 2.4.1

I

IDE SQLJ integration, 2.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, 2.4.2
INSENSITIVE (cursor state), 4.1.5.1
installation and configuration verification, 1.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
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 (strongly typed), 4.5.1.1
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, 1.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, 2.5
jdblinemap option (sqlj -jdblinemap), 8.2.4
JDeveloper
debugging with, 10.2.4
SQLJ integration, 2.7.2
JDK
supported versions, 1.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
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.11
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.10.4
local variables, classes (Java namespace), 3.10.1
SQL namespace, 3.10.3
SQLJ namespace, 3.10.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
mapping to alternative classes, 6.4.2
method support, 6.2.2
ORAData specifications, 6.2.1
overview of object support, 6.1.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, 2.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, 1.3.1
OracleChecker default checker, 8.3.3
Oracle-specific code generation
advantages and disadvantages, 3.7.4
coding considerations, limitations, 3.7.1
introduction, 3.7, 3.9
server-side considerations, 3.7.3
translator/customizer usage changes, 3.7.2
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, 2.4.2
output, server-side translator errors, 11.4.4
Overview of SQLJ, 2.1

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, 1.2.3
performance enhancements, 10.1
performance monitoring, DMS support, 10.3
phantom reads, 7.5.3
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, 3.8.5.2
profile-keys class, 3.8.4, 9.1.3
profiles
auditors for debugging, A.6.1
binary portability, 3.8.3.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, 3.8.3
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
register JDBC drivers
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, 1.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 (strongly typed)
Overview, 4.5.1.1
result set iterators (weakly typed)
general information, 7.4.4
Overview, 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, 2.2.2, 3.8.2
packages, 9.3.1
set up connection, 1.3.1
steps in runtime processing, 2.4.3
test, 1.3.4

S

sample applications
JDBC vs. SQLJ, 2.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
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, 11.1
overview, 2.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, 1.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, 1.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, 2.5
SQLJ_OPTIONS environment variable, 8.1.4
SqljConnBean for simple connection, 7.1.10
SqljConnCacheBean for connection caching, 7.1.10
sqljutl package, 1.2.4
statement caching, 10.1.2
static SQL, defined, 2.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
supported versions, 1.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, 1.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, 2.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, 2.4.2
internal operations, 9.1
Java and SQLJ code-parsing, syntax-checking, 9.1.1
output, server-side, 11.4.3
overview, 2.2.1, 3.8.2
SQL semantics-checking and offline parsing, 9.1.2
status messages, 9.2.2
support for alternative environments, 8.4
test, 1.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
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, 1.3.1
use of database service names, 1.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
VM
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, 2.7.3
WITH clause syntax, 4.1.5
wrapper classes for null-handling, 3.3.1
wrapper methods (JPub), generating, 6.4.2