1. Index

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) 8.5.2
  • alternative environments, support 9.4
  • applets, using SQLJ 3.6.1
  • arrays
  • assignment statements (SET) 5.6
  • assumptions, environment 2.1.1
  • AuditorInstaller
  • auditors in profiles for debugging A.6.1
  • auto-commit
    • modifying in existing connection 4.5.4
    • specifying in new connection 4.5.3

B

  • backup option (customizer harness) A.3.2.1
  • backward compatibility
  • batch updates
    • batchable and compatible statements 11.1.3
    • batching incompatible statements 11.1.3
    • batch limit 11.1.3
    • canceling a batch 11.1.3
    • cautions 11.1.3
    • enabling and disabling 11.1.3
    • error conditions during execution 11.1.3
    • explicit and implicit batch execution 11.1.3
    • overview 11.1.3
    • update counts 11.1.3
    • using implicit execution contexts 11.1.3
    • with respect to recursive call-ins 11.1.3
  • BetterDate (custom Java class) 7.2.6
  • BFILEs
    • as stored function results 6.3.2
    • BFILE support 6.3.2
  • BigDecimal
  • binary portability of profiles 4.8.3.2
  • bind-by-identifier option (sqlj -bind-by-identifier) 9.3.2
  • BLOB support 6.3.2
  • BOOLEAN type (PL/SQL) 6.1.3

C

  • cache option (sqlj -cache) 9.3.3
  • caching online checker results 9.3.3
  • caching statements 11.1.2
  • calling stored functions 5.7.2
  • calling stored procedures 5.7.1
  • calls to runtime, generated 10.1.3
  • CALL syntax for stored procedures 5.7.1
  • case-sensitive SQL UDT names 7.2.3
  • cause/action output for errors 9.2.4
  • character encoding
  • CHAR comparisons, blank padding 9.2.6, A.3.6.7
  • checker option (SQLCheckerCustomizer) A.5.2.1
  • checkfilename option (sqlj -checkfilename) 9.4.1
  • check source name against. public class 9.4.1
  • checksource option (sqlj -checksource) 9.3.2
  • check sources, expand resolution search 9.3.2
  • classpath and path 2.2.3
  • classpath option (sqlj -classpath) 9.2.1
  • clauses, SQLJ executable statements 5.2.2
  • CLOB support 6.3.2
  • CLOSE_CONNECTION 8.6.1
  • close() method (DefaultContext) 4.2.5
  • close() method (ExecutionContext) 8.2.4.6
  • close() method (Oracle class) 4.2.4, 4.2.5
  • code generation
    • general information 10.1.3
    • Oracle-specific vs. ISO standard 4.7.4
    • translator -codegen option 9.2.6
  • codegen option (SQLJ -codegen) 9.2.6
  • code layers in profiles A.6.1
  • collections
    • about custom Java classes 7.2
    • creating collection types 7.3
    • data types 7.1.4
    • fundamentals 7.1.3
    • ORAData specifications 7.2.1
    • overview of collection support 7.1.1
    • strongly typed 7.5
    • weak types, restrictions 7.7.2
    • weak types, support 7.7.1
  • column definitions (types/sizes)
    • general information 11.1.4
    • Oracle customizer optcols option A.3.6.4
    • SQLJ -optcols option 9.2.6
  • command line (translator)
  • commit
    • automatic vs. manual 4.5.2
    • effect on iterators and result sets 4.5.6
    • manual 4.5.5
    • modifying auto-commit in existing connection 4.5.4
    • specifying auto-commit in new connection 4.5.3
  • compat(ibility) option (Oracle customizer) A.3.6.2
  • compilation
    • compiling in two passes 9.4.1
    • during translation 10.1.4
    • enabling/disabling 9.3.2
  • compile option (sqlj -compile) 9.3.2
  • compiler
    • classpath option 9.2.1
    • options through SQLJ 9.3.1
    • option support for javac 9.1.1
    • related options 9.4.1
    • required behavior 9.4.1
    • specifying name 9.4.1
  • compiler encoding support option (sqlj) 9.4.1
  • compiler executable option (sqlj) 9.4.1
  • compiler message output pipe option (sqlj) 9.4.1
  • compiler output file option (sqlj -compiler...) 9.4.1
  • components option (sqlj -components) 9.2.5
  • configuration and installation verification 2.2
  • connect() method (Oracle class) 4.2.4
  • connection context
  • connection contexts 8.1
    • close connection 8.1.5
    • concepts 8.1.1
    • converting from JDBC connection 8.6.1
    • converting to JDBC connection 8.6.1
    • declarations 5.1.3
    • declaration with IMPLEMENTS clause 8.1.6
    • declaring connection context class 8.1.3
    • from SQLJ data sources 8.1.9, 8.1.10
    • get default connection 8.1.5
    • get execution context 8.1.5
    • get JDBC connection 8.1.5
    • implementation and functionality 8.1.5
    • instantiating connection object 8.1.3
    • methods 8.1.5
    • multiple connections, example 8.1.4
    • relation to execution contexts 8.2.1
    • semantics-checking 8.1.7
    • set default connection 8.1.5
    • specifying connection for statement 8.1.3
    • specifying for executable statement 5.2.3
  • connections
    • closing 4.2.2
    • closing shared connections with JDBC 8.6.1
    • from SQLJ data sources 8.1.9, 8.1.10
    • JDBC transaction methods 8.5.4
    • modifying auto-commit 4.5.4
    • multiple, using declared connect contexts 4.2.3
    • Oracle class to connect 4.2.4
    • set up 2.3.1
    • shared connections with JDBC 8.6.1
    • single or multiple using default context 4.2.1
    • specifying auto-commit 4.5.3
    • translator options 9.2.3
    • verify 2.3.2
  • connect string
    • for OCI driver 4.1.1
    • for Thin driver 4.1.1
    • server-side internal driver 4.1.1
    • server-side Thin driver 4.1.1
    • SIDs deprecated 2.3.1
    • use of database service names 2.3.1
  • context expressions
  • context option (customizer harness) A.3.2.2
  • converting .ser profiles to .class 9.3.2
  • C prefix (sqlj -C-x) 9.3.1
  • CURSOR syntax (nested tables) 7.5.1
  • customization
    • converting .ser profiles to .class 9.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 10.1.5
    • enabling/disabling 9.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 4.8.2
  • customizer harness
  • 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 9.3.1
    • specifying default 9.4.2
  • custom Java classes
    • about custom Java classes 7.2
    • compiling 7.2.4
    • reading and writing data 7.2.5
    • requirements 7.2.3
    • sample class 7.2.6
    • strongly typed, definition 7.1.1
    • support for object methods 7.2.2
    • using to serialize object 7.6.2
    • weakly typed, definition 7.1.1

D

  • database connection, verify 2.3.2
  • database URL
    • default prefix for online checking 9.2.3
    • SIDs deprecated 2.3.1
    • use of database service names 2.3.1
  • data source support
    • associating a connection 8.1.8
    • associating a default context 8.1.8
    • auto-commit mode 8.1.8
    • general overview 8.1.8
    • requirements 8.1.8
    • SQLJ data source classes 8.1.9
    • SQLJ data source interfaces 8.1.9
    • SQLJ-specific data sources 8.1.9
  • DBMS_LOB package 6.3.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, customizer harness A.3.4.1
    • in JDeveloper 11.2.3
    • invoking AuditorInstaller A.6.2
    • line-mapping, SQLJ source to class 9.2.4
    • line-mapping, SQLJ source to class for jdb 9.2.4
  • debug option (customizer harness) A.3.4.1
  • declarations
    • connection context declarations 5.1.3
    • IMPLEMENTS clause 5.1.4
    • iterator declarations 5.1.2
    • overview 5.1
    • WITH clause 5.1.5
  • default connection
    • setting with Oracle.connect() 4.2.1
    • setting with setDefaultContext() 4.2.1
  • DefaultContext class
    • close() method parameters 4.2.5
    • constructors 4.2.5
    • key methods 4.2.5
    • use for single or multiple connections 4.2.1
  • default customizer option (sqlj) 9.4.2
  • default properties files (translator) 9.1.3
  • default semantics-checker 9.3.3
  • default URL prefix option (sqlj) 9.2.3
  • defining column types/sizes 11.1.4
  • defining parameter sizes 11.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
  • directory
    • for generated .class and .ser 9.2.2
    • for generated .java 9.2.2
  • dir option (sqlj -dir) 9.2.2
  • dirty reads 8.5.3
  • DMS support
  • d option (sqlj -d) 9.2.2
  • driver option (customizer harness) A.3.3.4
  • driver registration option (sqlj -driver) 9.2.3
  • Dynamic Monitoring Service, SQLJ support 11.3
  • dynamic SQL
  • dynamic SQL support in SQLJ
    • examples 8.7.2
    • introduction 8.7
    • meta bind expressions 8.7.1
    • runtime behavior 8.7.1
    • translation-time behavior 8.7.1

E

  • echoing command line without executing 9.1.2
  • echo option, without execution 9.2.1
  • encoding
    • character encoding for messages 10.4.2
    • character encoding for source 10.4.2
    • command line example 10.4.2
    • do not pass option to compiler 9.4.1
    • overview of character encoding 10.4.1
    • setting at runtime 10.4.4
    • using native2ascii 10.4.4
  • encoding option, source files (sqlj -encoding) 9.2.2
  • environment assumptions and requirements 2.1
  • environments--scenarios and limitations 2.1.3
  • environment variable, translator options 9.1.4
  • errors
    • character encoding for messages 10.4.2
    • customization messages A.2.4
    • messages, codes, and SQL states 4.4.2
    • outputting cause and action 9.2.4
    • runtime categories 10.3.2
    • translator error, warning, info messages 10.2.1
  • exceptions
    • exception-handling requirements 4.4.1
    • processing 4.4.2
    • set up exception-handling 4.6
    • using SQLException subclasses 4.4.3
  • executable statements
  • execution contexts
  • exemplar schema 4.2.6
  • exit codes, translator 10.2.3
  • explain option (sqlj -explain) 9.2.4
  • extending iterator classes 8.4.3
  • extensions
    • overview 3.3
    • performance extensions 11.1
    • summary of features used A.3.6.10
    • type extensions 6.3

F

  • FETCH CURRENT syntax (iterators) 8.4.5
  • file name requirements and restrictions 4.10.4
  • fixedchar option (Oracle customizer) A.3.6.7
  • fixedchar option (SQLJ -fixedchar) 9.2.6
  • flags for special processing 9.3.2
  • force option (Oracle customizer) A.3.6.3
  • function calls, stored 5.7.2

G

  • getConnection() method (Oracle class) 4.2.4
  • globalization support
    • character encoding, language support 10.4.1
    • outside of SQLJ 10.4.4
    • overview 3.7.1
    • related data types 6.1.1
    • related Java types 10.4.3
    • related SQLJ and Java settings 10.4.2
    • support for Unicode characters 10.4.3

H

  • help option (customizer harness) A.3.2.5
  • help options (sqlj -help-xxxx) 9.2.1
  • hints in code, parameter sizes 11.1.5
  • host expressions
    • basic syntax 5.3.2
    • bind by identifier 9.3.2
    • evaluation at runtime 5.3.5
    • examples 5.3.3
    • examples of evaluation at runtime 5.3.6
    • iterators and result sets as host variables 5.5.6
    • overview 5.3.1
    • restrictions 5.3.7
    • selecting a nested table 7.5.3
    • supported types for JDBC 2.0 6.1.2
    • type support for Oracle8i 6.1.4
    • type support summary 6.1.1
  • host variables 3.4.1

I

  • IDE SQLJ integration 3.7.2
  • IMPLEMENTS clause
    • in connection context declarations 8.1.6
    • in iterator declarations 8.4.2
    • syntax 5.1.4
  • importing required classes 4.6
  • informational messages, translator 10.2.1
  • input to translator 3.4.2
  • installation and configuration verification 2.2
  • instrumenting class file (linemap) 9.2.4
  • instrument option (sqlj -instrument) 9.2.5
  • interoperability with JDBC
    • connection contexts and connections 8.6.1
    • iterators and result sets 8.6.2
  • isolation level settings (transactions) 8.5.3
  • iterators
    • accessing named iterators 5.5.4
    • accessing positional iterators 5.5.5
    • array columns 6.1.2
    • as host variables 5.5.6
    • as iterator columns (nested) 5.5.7
    • as stored function returns 5.7.3
    • commit/rollback effect 4.5.6
    • concepts 5.5.1
    • converting from result sets 8.6.2
    • converting to result sets 8.6.2
    • declarations 5.1.2
    • declaring named iterators 5.5.4
    • declaring positional iterators 5.5.5
    • declaring with IMPLEMENTS clause 8.4.2
    • extending 8.4.3
    • general steps in using 5.5.2
    • instantiating/populating named iterators 5.5.4
    • instantiating/populating positional iterators 5.5.5
    • iterator class functionality 8.4.1
    • named vs. positional 5.5.3
    • nested iterators for nested tables 7.5.5
    • overview 5.5
    • positional iterators, using next() 5.5.5
    • result set iterators (strongly typed) 5.5.1.1
    • result set iterators (weakly typed) 5.5.1.2, 8.4.4
    • scrollable 8.4.5
    • scrollable result set iterators 8.4.5
    • selecting objects and references 7.4.1
    • set up named iterator (example) 4.6
    • subclassing 8.4.3
    • using named iterators 5.5.4
    • using positional iterators 5.5.5
    • using weakly typed iterators 8.6.2
    • with serialized objects 7.6.3

J

  • jar file digests option, customization A.3.2.4
  • jar files for profiles A.4
  • JavaBeans for SQLJ connections 8.1.10
  • Java bind expressions (dynamic SQL) 8.7.1
  • javac compatibility 9.1.1
  • Java properties, getProperty() 10.4.4
  • Java VM
  • JDBC 2.0
    • support for LOB types 6.3
    • support for weakly typed Struct, Ref, Array 7.7
    • types supported 6.1.2
  • JDBC connection methods (transactions) 8.5.4
  • JDBC driver registration option (sqlj -driver) 9.2.3
  • JDBC drivers
    • Oracle drivers 4.1.1
    • select/register for customization A.3.3.4
    • select/register for runtime 4.1.3
    • select for translation 4.1.2
    • verify 2.3.3
  • JDBC interoperability
    • connection contexts and connections 8.6.1
    • iterators and result sets 8.6.2
  • JDBC vs. SQLJ, sample application 3.5
  • jdblinemap option (sqlj -jdblinemap) 9.2.4
  • JDeveloper
  • JDK
    • supported versions 2.1.3
  • JNDI
    • name of default data source 8.1.8
    • use for data sources, connections 8.1.8
  • J prefix (sqlj -J-x) 9.3.1

K

L

  • language support (globalization support) 10.4.1
  • linemap option (sqlj -linemap) 9.2.4
  • line-mapping
    • SQLJ source to class file 9.2.4
    • SQLJ source to class for jdb 9.2.4
  • loadjava
    • compatibility options, SQLJ 9.1.1
  • LOBs
    • as iterator columns 6.3.2
    • as stored function results 6.3.2
    • FETCH INTO LOB host variables 6.3.2
    • SELECT INTO LOB host variables 6.3.2
    • support (oracle.sql and DBMS_LOB) 6.3.2
  • locale
  • log option (AuditorInstaller) A.6.4.2

M

  • message pipe, compiler 9.4.1
  • meta bind expressions (dynamic SQL) 8.7.1
  • method support for objects 7.2.2
  • middle-tier considerations 4.11
  • multithreading
    • in SQLJ, overview 8.3
    • relation to execution contexts 8.2.5
    • sample application 8.3

N

  • named iterators
  • name of compiler 9.4.1
  • name of Java VM 9.4.1
  • naming requirements and restrictions
  • native2ascii for encoding 10.4.4
  • NcharAsciiStream class (globalization support) 10.4.3
  • NCHAR class (globalization support) 10.4.3
  • NcharUnicodeStream class (globalization support) 10.4.3
  • NCLOB class (globalization support) 10.4.3
  • nested iterators 7.5.5
  • nested tables
  • non-repeatable reads 8.5.3
  • n option (sqlj -n) (echo without execution) 9.2.1
  • NString class 10.4.3
  • NString class (globalization support) 10.4.3
  • null-handling
    • examples 4.3.2
    • wrapper classes for null-handling 4.3.1

O

  • object references
    • selecting into iterators 7.4.1
    • strongly typed in SQLJ 7.4
    • updating in SQLJ 7.4.4
    • weak types, restrictions 7.7.2
    • weak types, support 7.7.1
  • objects
    • about custom Java classes 7.2
    • creating object types 7.3
    • data types 7.1.4
    • fundamentals 7.1.2
    • inserting in SQLJ 7.4.3
    • method support 7.2.2
    • ORAData specifications 7.2.1
    • overview of object support 7.1.1
    • selecting into iterators 7.4.1
    • serializing (overview) 7.6
    • serializing RAW and BLOB columns 7.6.1
    • serializing with custom Java class 7.6.2
    • SQLData specifications 7.2.1
    • strongly typed in SQLJ 7.4
    • updating a reference in SQLJ 7.4.4
    • updating in SQLJ 7.4.2
    • weak types, restrictions 7.7.2
    • weak types, support 7.7.1
  • OCI driver (JDBC) 4.1.1
  • offline checking
    • default checker, Oracle checkers 9.3.3
    • specifying checker 9.3.3
  • offline option (sqlj -offline) 9.3.3
  • offline parsing
  • online checking
    • caching results 9.3.3
    • default checker, Oracle checkers 9.3.3
    • enabling, setting user schema 9.2.3
    • registering drivers 9.2.3
    • setting default URL prefix 9.2.3
    • setting password 9.2.3
    • setting URL 9.2.3
    • specifying checker 9.3.3
    • vs. offline parsing 9.3.3
  • online option (sqlj -online) 9.3.3
  • opaque types 7.8
  • optcols option (Oracle customizer) A.3.6.4
  • optcols option (SQLJ -optcols) 9.2.6
  • optimizer, SQL 11.1
  • options (translator)
    • command line only 9.2.1
    • flags for special processing 9.3.2
    • for connections 9.2.3
    • for customization 9.4.2
    • for javac compatibility 9.1.1
    • for loadjava compatibility 9.1.1
    • for output files and directories 9.2.2
    • for reporting and line-mapping 9.2.4
    • for semantics-checking, offline parsing 9.3.3
    • for VM and compiler 9.4.1
    • help 9.2.1
    • order of precedence 9.1.5
    • overview 9.1.1
    • prefixes for passing options 9.3.1
    • summary list 9.1.1
    • support for alternative environments 9.4
  • options for customizer harness
  • options for Oracle customizer A.3.6
  • optparamdefaults option (Oracle customizer) A.3.6.6
  • optparamdefaults option (SQLJ -optparamdefaults) 9.2.6
  • optparams option (Oracle customizer) A.3.6.5
  • optparams option (SQLJ -optparams) 9.2.6
  • oracle.sql package 6.3.1
  • OracleChecker default checker 9.3.3
  • Oracle class
    • close() method parameters 4.2.4
    • connect() method 4.2.4
    • for DefaultContext instances 4.2.4
    • getConnection() method 4.2.4
  • Oracle customizer
  • Oracle extensions
    • overview 3.3
    • performance extensions 11.1
    • summary of features used A.3.6.10
    • type extensions 6.3
  • Oracle optimizer 11.1
  • Oracle-specific code generation
    • advantages and disadvantages 4.7.4
    • coding considerations, limitations 4.7.2
    • environment requirements 4.7.1
    • introduction 4.7, 4.9
    • translator/customizer usage changes 4.7.3
  • Oracle system identifiers (SIDs) in connect strings, deprecated 2.3.1
  • ORAData
  • output directory
    • for generated .class and .ser 9.2.2
    • for generated .java 9.2.2
  • output file and directory options (translator) 9.2.2
  • output file for compiler 9.4.1
  • output from translator 3.4.2
  • output pipe, compiler messages 9.4.1
  • Overview of SQLJ 3.1

P

  • parameter definitions (sizes)
    • general information 11.1.5
    • Oracle customizer optparamdefaults option A.3.6.6
    • Oracle customizer optparams option A.3.6.5
    • SQLJ -optparamdefaults option 9.2.6
    • SQLJ -optparams option 9.2.6
  • parse option (sqlj -parse) 9.3.3
  • passes, two-pass compiling 9.4.1
  • passes option (sqlj -passes) 9.4.1
  • passing options to other executables 9.3.1
  • password option (customizer harness) A.3.3.2
  • password option for checking (sqlj) 9.2.3
  • path and classpath 2.2.3
  • performance enhancements 11.1
  • performance monitoring, DMS support 11.3
  • phantom reads 8.5.3
  • pipe, compiler output messages 9.4.1
  • PL/SQL
  • plan baselines 8.9
    • command-line options 8.9.2
    • generated Java file 8.9.5
    • generated log file 8.9.4
    • generated SQL file 8.9.3
    • property file options 8.9.2
  • positional iterators
  • positioned delete 6.3.3
  • positioned update 6.3.3
  • P prefix (sqlj -P-x) 9.3.1
  • prefetching rows 11.1.1
  • prefixes
    • to pass options to customizer 9.3.1
    • to pass options to Java compiler 9.3.1
    • to pass options to Java VM 9.3.1
  • prefix option (AuditorInstaller) A.6.4.3
  • print option (customizer harness) A.3.4.2
  • procedure calls, stored 5.7.1
  • profile customization (see customization) 10.1.5
  • profile-keys 4.8.5.2
  • profile-keys class 4.8.4, 10.1.3
  • profile option (sqlj -profile) 9.3.2
  • profiles
  • properties, Java, getProperty() 10.4.4
  • properties files, SQLJ DMS 11.3.3
  • properties files (translator)
  • props option (sqlj -props) 9.2.1
  • public class name / source name check 9.4.1

R

  • READ COMMITTED transactions 8.5.3
  • READ ONLY transactions 8.5.2
  • READ UNCOMMITTED transactions 8.5.3
  • READ WRITE transactions 8.5.2
  • RECORD type (PL/SQL) 6.1.3
  • REF CURSOR
  • registering column types/sizes 11.1.4
  • registering parameter sizes 11.1.5
  • register JDBC drivers
  • REPEATABLE READ transactions 8.5.3
  • reporting options (translator) 9.2.4
  • requirements, environment 2.1.2
  • result expressions
  • result set iterators (strongly typed)
  • result set iterators (weakly typed)
  • ResultSetIterator type 8.4.4
  • result sets
    • as host variables 5.5.6
    • as iterator columns 5.5.7
    • as stored function returns 5.7.3
    • commit/rollback effect 4.5.6
    • converting from iterators 8.6.2
    • converting to iterators 8.6.2
  • returnability (cursor states, WITH clause) 5.1.5.3
  • rollback
    • effect on iterators and result sets 4.5.6
    • manual 4.5.5
    • with savepoint 4.5.7
  • ROWID
    • as stored function results 6.3.3
    • FETCH INTO ROWID host variable 6.3.3
    • SELECT INTO ROWID host variable 6.3.3
    • support 6.3.3
  • row prefetching 11.1.1
  • runtime
    • categories of errors 10.3.2
    • debugging output (AuditorInstaller) A.6.3
    • functionality 10.3
    • functionality of profiles A.2.5
    • generated calls to runtime 10.1.3
    • globalization support 10.4
    • JDBC driver selection and registration 4.1.3
    • overview 3.2.2, 4.8.2
    • packages 10.3.1
    • set up connection 2.3.1
    • steps in runtime processing 3.4.3
    • test 2.3.4

S

  • sample applications
    • JDBC vs. SQLJ 3.5
    • multiple connection contexts 8.1.4
    • multiple-row query (named iterator) 4.6
    • multithreading 8.3
    • single-row query (SELECT INTO) 4.6
  • sample classes
    • custom Java class (BetterDate) 7.2.6
    • SerializableDatum class 7.6.4
  • savepoints
  • scrollable iterators
    • declaring 8.4.5
    • scrollable named iterators 8.4.5
    • scrollable positional iterators 8.4.5
    • sensitivity 8.4.5
    • the scrollable interface 8.4.5
  • ScrollableResultSetIterator type 8.4.5
  • SELECT INTO statements
  • semantics-checking
    • caching online results 9.3.3
    • default checker, Oracle checkers 9.3.3
    • enabling online, setting user schema 9.2.3
    • invoking SQLCheckerCustomizer A.5.1
    • of profiles, via customizer harness A.3.4.3
    • options 9.3.3
    • registering drivers 9.2.3
    • setting default URL prefix 9.2.3
    • setting password 9.2.3
    • setting URL 9.2.3
    • specifying offline checker 9.3.3
    • specifying online checker 9.3.3
    • SQLCheckerCustomizer options A.5.2
    • steps involved 10.1.2
  • ser2class option (sqlj -ser2class) 9.3.2
  • SERIALIZABLE transactions 8.5.3
  • serialized objects
    • as host variables 7.6.3
    • in iterator columns 7.6.3
    • overview 7.6
    • SerializableDatum class (sample) 7.6.4
    • through custom Java class 7.6.2
    • to RAW and BLOB columns 7.6.1
  • ser profiles (.ser)
  • server-side internal driver (JDBC) 4.1.1
  • server-side Thin driver (JDBC) 4.1.1
  • SET (assignment) statements 5.6
  • setFormOfUse method 10.4.3
  • SET TRANSACTION syntax 8.5.1
  • setup of SQLJ, testing 2.3
  • 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 9.3.2
  • source file line-mapping
  • source files encoding option 9.2.2
  • source name / public class name check 9.4.1
  • SQLCheckerCustomizer
    • for semantics-checking of profiles A.5
    • invoking A.5.1
    • options A.5.2
  • SQLData
  • SQLException subclasses, using 4.4.3
  • SQLJ_OPTIONS environment variable 9.1.4
  • SqljConnBean for simple connection 8.1.10
  • SqljConnCacheBean for connection caching 8.1.10
  • sqljutl package 2.2.4
  • SQLJ vs. JDBC, sample application 3.5
  • SQL optimizer 11.1
  • SQL replacement code (dynamic SQL) 8.7.1
  • SQL states (for errors) 4.4.2
  • statement caching 11.1.2
  • static SQL, defined 3.1
  • status messages
    • for customization A.2.4
    • for translation 10.2.2
    • translator, enabling/disabling 9.2.4
  • status option (sqlj -status) 9.2.4
  • stmtcache option (Oracle customizer) A.3.6.9
  • stored function calls 5.7.2
  • stored outlines 8.8
    • configuration files 8.8
    • generation parameters 8.9.1
    • options 8.8
  • stored procedure calls 5.7.1
  • streams
    • as function return values 6.2.8
    • as output parameters 6.2.8
    • classes and methods 6.2.6
    • examples 6.2.7
    • general use in SQLJ 6.2.1
    • precautions 6.2.4
    • retrieving data 6.2.5
    • sending data to database 6.2.3
    • supporting classes 6.2
  • strongly typed collections 7.5
  • strongly typed custom Java classes 7.1.1
  • strongly typed objects and references 7.4
  • subclassing iterator classes 8.4.3
  • summary option (Oracle customizer) A.3.6.10
  • Sun JDK
    • supported versions 2.1.3
  • support for global transactions 8.1.11
  • support for pluggable databases 8.1.12
  • synchronization of execution contexts 8.2.3
  • syntax
    • translator command line 9.1.2
    • translator properties files 9.1.3
  • system identifiers (SIDs) in connect strings, deprecated 2.3.1

T

  • TABLE syntax (nested tables) 7.5.1, 7.5.4
  • TABLE type (PL/SQL) 6.1.3
  • Thin driver (JDBC) 4.1.1
  • transactions
    • access mode settings 8.5.2
    • advanced transaction control 8.5
    • automatic commit vs. manual commit 4.5.2
    • basic transaction control 4.5
    • isolation level settings 8.5.3
    • JDBC Connection methods 8.5.4
    • manual commit and rollback 4.5.5
    • modifying auto-commit 4.5.4
    • overview 4.5.1
    • savepoints for rollbacks 4.5.7
    • specifying auto-commit 4.5.3
  • translator
    • basic translation steps 3.4.1
    • code generation 10.1.3
    • compilation 10.1.4
    • customization 10.1.5
    • error, warning, info messages 10.2.1
    • exit codes 10.2.3
    • globalization support 10.4
    • input and output 3.4.2
    • internal operations 10.1
    • Java and SQLJ code-parsing, syntax-checking 10.1.1
    • overview 3.2.1, 4.8.2
    • SQL semantics-checking and offline parsing 10.1.2
    • status messages 10.2.2
    • support for alternative environments 9.4
    • test 2.3.4
  • type extensions 6.3
  • type resolution, expand search 9.3.2
  • types supported

U

  • uninstall option (AuditorInstaller) A.6.4.6
  • update batching
    • batchable and compatible statements 11.1.3
    • batching incompatible statements 11.1.3
    • batch limit 11.1.3
    • canceling a batch 11.1.3
    • cautions 11.1.3
    • enabling and disabling 11.1.3
    • error conditions during execution 11.1.3
    • explicit and implicit batch execution 11.1.3
    • overview 11.1.3
    • update counts 11.1.3
    • using implicit execution contexts 11.1.3
    • with respect to recursive call-ins 11.1.3
  • URL, database
    • default prefix for online checking 9.2.3
    • SIDs deprecated 2.3.1
    • use of database service names 2.3.1
  • url option (customizer harness) A.3.3.3
  • url option for checking (sqlj -url) 9.2.3
  • user-defined types 7.3
  • user option (customizer harness) A.3.3.1
  • user option for checking (sqlj -user) 9.2.3

V

  • VALUES syntax for stored functions 5.7.2
  • VARRAYs
    • inserting a row 7.5.7
    • selecting into host expression 7.5.6
    • VARRAY types 7.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) 9.2.1
  • VM
  • vm option (sqlj -vm) 9.4.1

W

  • warning messages, translator 10.2.1
  • warnings, translator, enabling/disabling 9.2.4
  • warn option (SQLCheckerCustomizer) A.5.2.2
  • warn option (sqlj -warn) 9.2.4
  • weakly typed custom Java classes 7.1.1
  • weakly typed iterators 8.4.4
  • weak object/collection types
  • WHERE CURRENT OF 6.3.3
  • WHERE CURRENT OF clause 6.3.3
  • Windows, SQLJ development in 3.7.3
  • WITH clause syntax 5.1.5
  • wrapper classes for null-handling 4.3.1