Go to main content
17/17
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)
1
alternative environments, support
1
applets, using SQLJ
1
arrays
as iterator columns
1
VARRAYs
1
assignment statements (SET)
1
assumptions, environment
1
AuditorInstaller
command-line examples
1
customizer for debugging
1
invoking
1
options
1
runtime output
1
auditors in profiles for debugging
1
auto-commit
modifying in existing connection
1
specifying in new connection
1
B
backup option (customizer harness)
1
backward compatibility
Oracle SQLJ, general
1
to Oracle8i
1
batch updates
batchable and compatible statements
1
batching incompatible statements
1
batch limit
1
canceling a batch
1
cautions
1
enabling and disabling
1
error conditions during execution
1
explicit and implicit batch execution
1
overview
1
update counts
1
using implicit execution contexts
1
with respect to recursive call-ins
1
BetterDate (custom Java class)
1
BFILEs
as stored function results
1
BFILE support
1
BigDecimal
support
1
binary portability of profiles
1
bind-by-identifier option (sqlj -bind-by-identifier)
1
BLOB support
1
BOOLEAN type (PL/SQL)
1
C
cache option (sqlj -cache)
1
caching online checker results
1
caching statements
1
calling stored functions
1
calling stored procedures
1
calls to runtime, generated
1
CALL syntax for stored procedures
1
case-sensitive SQL UDT names
1
cause/action output for errors
1
character encoding
command line example
1
for messages
1
for source
1
overview
1
setting at runtime
1
using native2ascii
1
CHAR comparisons, blank padding
1
,
2
checker option (SQLCheckerCustomizer)
1
checkfilename option (sqlj -checkfilename)
1
check source name against. public class
1
checksource option (sqlj -checksource)
1
check sources, expand resolution search
1
classpath and path
1
classpath option (sqlj -classpath)
1
clauses, SQLJ executable statements
1
CLOB support
1
CLOSE_CONNECTION
1
close() method (DefaultContext)
1
close() method (ExecutionContext)
1
close() method (Oracle class)
1
,
2
code generation
general information
1
Oracle-specific vs. ISO standard
1
translator -codegen option
1
codegen option (SQLJ -codegen)
1
code layers in profiles
1
collections
about custom Java classes
1
creating collection types
1
data types
1
fundamentals
1
ORAData specifications
1
overview of collection support
1
strongly typed
1
weak types, restrictions
1
weak types, support
1
column definitions (types/sizes)
general information
1
Oracle customizer optcols option
1
SQLJ -optcols option
1
command line (translator)
echoing without executing
1
example
1
overview
1
syntax and arguments
1
commit
automatic vs. manual
1
effect on iterators and result sets
1
manual
1
modifying auto-commit in existing connection
1
specifying auto-commit in new connection
1
compat(ibility) option (Oracle customizer)
1
compilation
compiling in two passes
1
during translation
1
enabling/disabling
1
compile option (sqlj -compile)
1
compiler
classpath option
1
options through SQLJ
1
option support for javac
1
related options
1
required behavior
1
specifying name
1
compiler encoding support option (sqlj)
1
compiler executable option (sqlj)
1
compiler message output pipe option (sqlj)
1
compiler output file option (sqlj -compiler...)
1
components option (sqlj -components)
1
configuration and installation verification
1
connect() method (Oracle class)
1
connection context
concepts
1
declaring and using
1
example
1
implementation and functionality
1
logistics
1
semantics-checking
1
connection contexts
close connection
1
concepts
1
converting from JDBC connection
1
converting to JDBC connection
1
declarations
1
declaration with IMPLEMENTS clause
1
declaring connection context class
1
from SQLJ data sources
1
,
2
get default connection
1
get execution context
1
get JDBC connection
1
implementation and functionality
1
instantiating connection object
1
methods
1
multiple connections, example
1
relation to execution contexts
1
semantics-checking
1
set default connection
1
specifying connection for statement
1
specifying for executable statement
1
connections
closing
1
closing shared connections with JDBC
1
from SQLJ data sources
1
,
2
JDBC transaction methods
1
modifying auto-commit
1
multiple, using declared connect contexts
1
Oracle class to connect
1
set up
1
shared connections with JDBC
1
single or multiple using default context
1
specifying auto-commit
1
translator options
1
verify
1
connect string
for OCI driver
1
for Thin driver
1
server-side internal driver
1
server-side Thin driver
1
SIDs deprecated
1
use of database service names
1
context expressions
evaluation at runtime
1
overview
1
context option (customizer harness)
1
converting .ser profiles to .class
1
C prefix (sqlj -C-x)
1
CURSOR syntax (nested tables)
1
customization
converting .ser profiles to .class
1
creation and registration
1
customizer harness connection options
1
customizer harness general options
1
customizer harness options overview
1
defining column types/sizes
1
defining parameter sizes
1
during translation
1
enabling/disabling
1
error and status messages
1
force customization
1
jar file usage
1
more about customization
1
options
1
options to invoke special customizers
1
Oracle customizer options
1
overview/syntax of customizer-specific options
1
parameter default sizes
1
related SQLJ options
1
show SQL transformations
1
statement cache size
1
steps in process
1
summary of Oracle features used
1
version compatibility
1
customizer
1
customizer harness
connection options
1
general options
1
invoke special customizers
1
options overview
1
overview
1
customizer option (customizer harness)
1
customizers
choosing
1
option to choose customizer
1
overview
1
passing options through SQLJ
1
specifying default
1
custom Java classes
about custom Java classes
1
compiling
1
reading and writing data
1
requirements
1
sample class
1
strongly typed, definition
1
support for object methods
1
using to serialize object
1
weakly typed, definition
1
D
database connection, verify
1
database URL
default prefix for online checking
1
SIDs deprecated
1
use of database service names
1
data source support
associating a connection
1
associating a default context
1
auto-commit mode
1
general overview
1
requirements
1
SQLJ data source classes
1
SQLJ data source interfaces
1
SQLJ-specific data sources
1
DBMS_LOB package
1
debugging
AuditorInstaller command-line examples
1
AuditorInstaller customizer
1
AuditorInstaller options
1
AuditorInstaller runtime output
1
debug option, customizer harness
1
in JDeveloper
1
invoking AuditorInstaller
1
line-mapping, SQLJ source to class
1
line-mapping, SQLJ source to class for jdb
1
debug option (customizer harness)
1
declarations
connection context declarations
1
IMPLEMENTS clause
1
iterator declarations
1
overview
1
WITH clause
1
default connection
setting with Oracle.connect()
1
setting with setDefaultContext()
1
DefaultContext class
close() method parameters
1
constructors
1
key methods
1
use for single or multiple connections
1
default customizer option (sqlj)
1
default properties files (translator)
1
default semantics-checker
1
default URL prefix option (sqlj)
1
defining column types/sizes
1
defining parameter sizes
1
demo applications (SQLJ), availability
1
depth option (AuditorInstaller)
1
digests option, jar (customizer harness)
1
directory
for generated .class and .ser
1
for generated .java
1
dir option (sqlj -dir)
1
dirty reads
1
DMS support
command-line options for DMS
1
,
2
examples
1
overview of DMS support
1
runtime commands for DMS
1
sensors and metrics
1
SQLJ DMS properties files
1
d option (sqlj -d)
1
driver option (customizer harness)
1
driver registration option (sqlj -driver)
1
Dynamic Monitoring Service, SQLJ support
1
dynamic SQL
defined
1
in JDBC code
1
in PL/SQL code
1
dynamic SQL support in SQLJ
examples
1
introduction
1
meta bind expressions
1
runtime behavior
1
translation-time behavior
1
E
echoing command line without executing
1
echo option, without execution
1
encoding
character encoding for messages
1
character encoding for source
1
command line example
1
do not pass option to compiler
1
overview of character encoding
1
setting at runtime
1
using native2ascii
1
encoding option, source files (sqlj -encoding)
1
environment assumptions and requirements
1
environments--scenarios and limitations
1
environment variable, translator options
1
errors
character encoding for messages
1
customization messages
1
messages, codes, and SQL states
1
outputting cause and action
1
runtime categories
1
translator error, warning, info messages
1
exceptions
exception-handling requirements
1
processing
1
set up exception-handling
1
using SQLException subclasses
1
executable statements
examples
1
overview
1
rules
1
specifying connection/execution contexts
1
SQLJ clauses
1
using PL/SQL blocks
1
execution contexts
cancellation method
1
close() method
1
control methods
1
creating and specifying
1
method usage, example
1
overview
1
relation to connection contexts
1
relation to multithreading
1
savepoint methods
1
specifying for executable statement
1
status methods
1
synchronization
1
update-batching methods
1
exemplar schema
1
exit codes, translator
1
explain option (sqlj -explain)
1
extending iterator classes
1
extensions
overview
1
performance extensions
1
summary of features used
1
type extensions
1
F
FETCH CURRENT syntax (iterators)
1
file name requirements and restrictions
1
fixedchar option (Oracle customizer)
1
fixedchar option (SQLJ -fixedchar)
1
flags for special processing
1
force option (Oracle customizer)
1
function calls, stored
1
G
getConnection() method (Oracle class)
1
globalization support
character encoding, language support
1
outside of SQLJ
1
overview
1
related data types
1
related Java types
1
related SQLJ and Java settings
1
support for Unicode characters
1
H
help option (customizer harness)
1
help options (sqlj -help-xxxx)
1
hints in code, parameter sizes
1
host expressions
basic syntax
1
bind by identifier
1
evaluation at runtime
1
examples
1
examples of evaluation at runtime
1
iterators and result sets as host variables
1
overview
1
restrictions
1
selecting a nested table
1
supported types for JDBC 2.0
1
type support for Oracle8i
1
type support summary
1
host variables
1
I
IDE SQLJ integration
1
IMPLEMENTS clause
in connection context declarations
1
in iterator declarations
1
syntax
1
importing required classes
1
informational messages, translator
1
input to translator
1
installation and configuration verification
1
instrumenting class file (linemap)
1
instrument option (sqlj -instrument)
1
interoperability with JDBC
connection contexts and connections
1
iterators and result sets
1
isolation level settings (transactions)
1
iterators
accessing named iterators
1
accessing positional iterators
1
array columns
1
as host variables
1
as iterator columns (nested)
1
as stored function returns
1
commit/rollback effect
1
concepts
1
converting from result sets
1
converting to result sets
1
declarations
1
declaring named iterators
1
declaring positional iterators
1
declaring with IMPLEMENTS clause
1
extending
1
general steps in using
1
instantiating/populating named iterators
1
instantiating/populating positional iterators
1
iterator class functionality
1
named vs. positional
1
nested iterators for nested tables
1
overview
1
positional iterators, using next()
1
result set iterators (strongly typed)
1
result set iterators (weakly typed)
1
,
2
scrollable
1
scrollable result set iterators
1
selecting objects and references
1
set up named iterator (example)
1
subclassing
1
using named iterators
1
using positional iterators
1
using weakly typed iterators
1
with serialized objects
1
J
jar file digests option, customization
1
jar files for profiles
1
JavaBeans for SQLJ connections
1
Java bind expressions (dynamic SQL)
1
javac compatibility
1
Java properties, getProperty()
1
Java VM
classpath option
1
options through SQLJ
1
specifying name
1
JDBC 2.0
support for LOB types
1
support for weakly typed Struct, Ref, Array
1
types supported
1
JDBC connection methods (transactions)
1
JDBC driver registration option (sqlj -driver)
1
JDBC drivers
Oracle drivers
1
select/register for customization
1
select/register for runtime
1
select for translation
1
verify
1
JDBC interoperability
connection contexts and connections
1
iterators and result sets
1
JDBC vs. SQLJ, sample application
1
jdblinemap option (sqlj -jdblinemap)
1
JDeveloper
debugging with
1
SQLJ integration
1
JDK
supported versions
1
JNDI
name of default data source
1
use for data sources, connections
1
J prefix (sqlj -J-x)
1
K
KEEP_CONNECTION
1
L
language support (globalization support)
1
linemap option (sqlj -linemap)
1
line-mapping
SQLJ source to class file
1
SQLJ source to class for jdb
1
loadjava
compatibility options, SQLJ
1
LOBs
as iterator columns
1
as stored function results
1
FETCH INTO LOB host variables
1
SELECT INTO LOB host variables
1
support (oracle.sql and DBMS_LOB)
1
locale
command line example
1
for messages
1
setting at runtime
1
log option (AuditorInstaller)
1
M
message pipe, compiler
1
meta bind expressions (dynamic SQL)
1
method support for objects
1
middle-tier considerations
1
multithreading
in SQLJ, overview
1
relation to execution contexts
1
sample application
1
N
named iterators
accessing
1
declaring
1
instantiating and populating
1
scrollable
1
using
1
name of compiler
1
name of Java VM
1
naming requirements and restrictions
file names
1
local variables, classes (Java namespace)
1
SQLJ namespace
1
SQL namespace
1
native2ascii for encoding
1
NcharAsciiStream class (globalization support)
1
NCHAR class (globalization support)
1
NcharUnicodeStream class (globalization support)
1
NCLOB class (globalization support)
1
nested iterators
1
nested tables
accessing
1
inserting in SQLJ
1
manipulating
1
selecting into host expression
1
types
1
using nested iterator
1
non-repeatable reads
1
n option (sqlj -n) (echo without execution)
1
NString class
1
NString class (globalization support)
1
null-handling
examples
1
wrapper classes for null-handling
1
O
object references
selecting into iterators
1
strongly typed in SQLJ
1
updating in SQLJ
1
weak types, restrictions
1
weak types, support
1
objects
about custom Java classes
1
creating object types
1
data types
1
fundamentals
1
inserting in SQLJ
1
method support
1
ORAData specifications
1
overview of object support
1
selecting into iterators
1
serializing (overview)
1
serializing RAW and BLOB columns
1
serializing with custom Java class
1
SQLData specifications
1
strongly typed in SQLJ
1
updating a reference in SQLJ
1
updating in SQLJ
1
weak types, restrictions
1
weak types, support
1
OCI driver (JDBC)
1
offline checking
default checker, Oracle checkers
1
specifying checker
1
offline option (sqlj -offline)
1
offline parsing
sqlj -parse option
1
steps involved
1
vs. online checking
1
online checking
caching results
1
default checker, Oracle checkers
1
enabling, setting user schema
1
registering drivers
1
setting default URL prefix
1
setting password
1
setting URL
1
specifying checker
1
vs. offline parsing
1
online option (sqlj -online)
1
opaque types
1
optcols option (Oracle customizer)
1
optcols option (SQLJ -optcols)
1
optimizer, SQL
1
options (translator)
command line only
1
flags for special processing
1
for connections
1
for customization
1
for javac compatibility
1
for loadjava compatibility
1
for output files and directories
1
for reporting and line-mapping
1
for semantics-checking, offline parsing
1
for VM and compiler
1
help
1
order of precedence
1
overview
1
prefixes for passing options
1
summary list
1
support for alternative environments
1
options for customizer harness
connection options
1
general options
1
invoke special customizers
1
overview
1
options for Oracle customizer
1
optparamdefaults option (Oracle customizer)
1
optparamdefaults option (SQLJ -optparamdefaults)
1
optparams option (Oracle customizer)
1
optparams option (SQLJ -optparams)
1
oracle.sql package
1
OracleChecker default checker
1
Oracle class
close() method parameters
1
connect() method
1
for DefaultContext instances
1
getConnection() method
1
Oracle customizer
blank padding for CHAR comparisons
1
define column types/sizes
1
define parameter sizes
1
force customization
1
options
1
set default parameter sizes
1
show SQL transformation
1
statement cache size
1
summary of Oracle features used
1
version compatibility
1
Oracle extensions
overview
1
performance extensions
1
summary of features used
1
type extensions
1
Oracle optimizer
1
Oracle-specific code generation
advantages and disadvantages
1
coding considerations, limitations
1
environment requirements
1
introduction
1
,
2
translator/customizer usage changes
1
Oracle system identifiers (SIDs) in connect strings, deprecated
1
ORAData
additional uses
1
specifications
1
output directory
for generated .class and .ser
1
for generated .java
1
output file and directory options (translator)
1
output file for compiler
1
output from translator
1
output pipe, compiler messages
1
Overview of SQLJ
1
P
parameter definitions (sizes)
general information
1
Oracle customizer optparamdefaults option
1
Oracle customizer optparams option
1
SQLJ -optparamdefaults option
1
SQLJ -optparams option
1
parse option (sqlj -parse)
1
passes, two-pass compiling
1
passes option (sqlj -passes)
1
passing options to other executables
1
password option (customizer harness)
1
password option for checking (sqlj)
1
path and classpath
1
performance enhancements
1
performance monitoring, DMS support
1
phantom reads
1
pipe, compiler output messages
1
PL/SQL
blocks in executable statements
1
BOOLEAN type
1
RECORD type
1
TABLE type
1
plan baselines
command-line options
1
generated Java file
1
generated log file
1
generated SQL file
1
property file options
1
positional iterators
accessing
1
declaring
1
instantiating and populating
1
navigation with next()
1
scrollable
1
using
1
positioned delete
1
positioned update
1
P prefix (sqlj -P-x)
1
prefetching rows
1
prefixes
to pass options to customizer
1
to pass options to Java compiler
1
to pass options to Java VM
1
prefix option (AuditorInstaller)
1
print option (customizer harness)
1
procedure calls, stored
1
profile customization (see customization)
1
profile-keys
1
profile-keys class
1
,
2
profile option (sqlj -profile)
1
profiles
auditors for debugging
1
binary portability
1
code layers
1
creation during code generation
1
debug option
1
functionality at runtime
1
generated profiles
1
more about profiles
1
overview
1
print option
1
sample profile entry
1
use of jar files
1
verify option
1
properties, Java, getProperty()
1
properties files, SQLJ DMS
1
properties files (translator)
default properties files
1
overview
1
setting input file
1
syntax
1
props option (sqlj -props)
1
public class name / source name check
1
R
READ COMMITTED transactions
1
READ ONLY transactions
1
READ UNCOMMITTED transactions
1
READ WRITE transactions
1
RECORD type (PL/SQL)
1
REF CURSOR
about REF CURSOR types
1
example
1
SQLJ support
1
registering column types/sizes
1
registering parameter sizes
1
register JDBC drivers
for runtime
1
for translation
1
REPEATABLE READ transactions
1
reporting options (translator)
1
requirements, environment
1
result expressions
evaluation at runtime
1
overview
1
result set iterators (strongly typed)
Overview
1
result set iterators (weakly typed)
general information
1
Overview
1
scrollable
1
ResultSetIterator type
1
result sets
as host variables
1
as iterator columns
1
as stored function returns
1
commit/rollback effect
1
converting from iterators
1
converting to iterators
1
returnability (cursor states, WITH clause)
1
rollback
effect on iterators and result sets
1
manual
1
with savepoint
1
ROWID
as stored function results
1
FETCH INTO ROWID host variable
1
SELECT INTO ROWID host variable
1
support
1
row prefetching
1
runtime
categories of errors
1
debugging output (AuditorInstaller)
1
functionality
1
functionality of profiles
1
generated calls to runtime
1
globalization support
1
JDBC driver selection and registration
1
overview
1
,
2
packages
1
set up connection
1
steps in runtime processing
1
test
1
S
sample applications
JDBC vs. SQLJ
1
multiple connection contexts
1
multiple-row query (named iterator)
1
multithreading
1
single-row query (SELECT INTO)
1
sample classes
custom Java class (BetterDate)
1
SerializableDatum class
1
savepoints
ExecutionContext savepoint methods
1
ISO syntax
1
Oracle syntax
1
savepoint statements
1
scrollable iterators
declaring
1
scrollable named iterators
1
scrollable positional iterators
1
sensitivity
1
the scrollable interface
1
ScrollableResultSetIterator type
1
SELECT INTO statements
error conditions
1
examples
1
,
2
syntax
1
semantics-checking
caching online results
1
default checker, Oracle checkers
1
enabling online, setting user schema
1
invoking SQLCheckerCustomizer
1
of profiles, via customizer harness
1
options
1
registering drivers
1
setting default URL prefix
1
setting password
1
setting URL
1
specifying offline checker
1
specifying online checker
1
SQLCheckerCustomizer options
1
steps involved
1
ser2class option (sqlj -ser2class)
1
SERIALIZABLE transactions
1
serialized objects
as host variables
1
in iterator columns
1
overview
1
SerializableDatum class (sample)
1
through custom Java class
1
to RAW and BLOB columns
1
ser profiles (.ser)
converting to .class
1
generated profiles
1
server-side internal driver (JDBC)
1
server-side Thin driver (JDBC)
1
SET (assignment) statements
1
setFormOfUse method
1
SET TRANSACTION syntax
1
setup of SQLJ, testing
1
showReturns option (AuditorInstaller)
1
showSQL option (Oracle customizer)
1
showThreads option (AuditorInstaller)
1
SIDs in connect strings, deprecated
1
source check for type resolution
1
source file line-mapping
for jdb
1
general
1
source files encoding option
1
source name / public class name check
1
SQLCheckerCustomizer
for semantics-checking of profiles
1
invoking
1
options
1
SQLData
specifications
1
SQLException subclasses, using
1
SQLJ_OPTIONS environment variable
1
SqljConnBean for simple connection
1
SqljConnCacheBean for connection caching
1
sqljutl package
1
SQLJ vs. JDBC, sample application
1
SQL optimizer
1
SQL replacement code (dynamic SQL)
1
SQL states (for errors)
1
statement caching
1
static SQL, defined
1
status messages
for customization
1
for translation
1
translator, enabling/disabling
1
status option (sqlj -status)
1
stmtcache option (Oracle customizer)
1
stored function calls
1
stored outlines
configuration files
1
generation parameters
1
options
1
stored procedure calls
1
streams
as function return values
1
as output parameters
1
classes and methods
1
examples
1
general use in SQLJ
1
precautions
1
retrieving data
1
sending data to database
1
supporting classes
1
strongly typed collections
1
strongly typed custom Java classes
1
strongly typed objects and references
1
subclassing iterator classes
1
summary option (Oracle customizer)
1
Sun JDK
supported versions
1
support for global transactions
1
support for pluggable databases
1
synchronization of execution contexts
1
syntax
translator command line
1
translator properties files
1
system identifiers (SIDs) in connect strings, deprecated
1
T
TABLE syntax (nested tables)
1
,
2
TABLE type (PL/SQL)
1
Thin driver (JDBC)
1
transactions
access mode settings
1
advanced transaction control
1
automatic commit vs. manual commit
1
basic transaction control
1
isolation level settings
1
JDBC Connection methods
1
manual commit and rollback
1
modifying auto-commit
1
overview
1
savepoints for rollbacks
1
specifying auto-commit
1
translator
basic translation steps
1
code generation
1
compilation
1
customization
1
error, warning, info messages
1
exit codes
1
globalization support
1
input and output
1
internal operations
1
Java and SQLJ code-parsing, syntax-checking
1
overview
1
,
2
SQL semantics-checking and offline parsing
1
status messages
1
support for alternative environments
1
test
1
type extensions
1
type resolution, expand search
1
types supported
for JDBC 2.0
1
for Oracle8i
1
summary of types
1
U
uninstall option (AuditorInstaller)
1
update batching
batchable and compatible statements
1
batching incompatible statements
1
batch limit
1
canceling a batch
1
cautions
1
enabling and disabling
1
error conditions during execution
1
explicit and implicit batch execution
1
overview
1
update counts
1
using implicit execution contexts
1
with respect to recursive call-ins
1
URL, database
default prefix for online checking
1
SIDs deprecated
1
use of database service names
1
url option (customizer harness)
1
url option for checking (sqlj -url)
1
user-defined types
1
user option (customizer harness)
1
user option for checking (sqlj -user)
1
V
VALUES syntax for stored functions
1
VARRAYs
inserting a row
1
selecting into host expression
1
VARRAY types
1
verbose option (customizer harness)
1
verify option (customizer harness)
1
version compatibility (Oracle customizer)
1
version number options (sqlj -version-xxxx)
1
VM
classpath option
1
options through SQLJ
1
specifying name
1
vm option (sqlj -vm)
1
W
warning messages, translator
1
warnings, translator, enabling/disabling
1
warn option (SQLCheckerCustomizer)
1
warn option (sqlj -warn)
1
weakly typed custom Java classes
1
weakly typed iterators
1
weak object/collection types
restrictions
1
support
1
WHERE CURRENT OF
1
WHERE CURRENT OF clause
1
Windows, SQLJ development in
1
WITH clause syntax
1
wrapper classes for null-handling
1
Scripting on this page enhances content navigation, but does not change the content in any way.