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 1
    • 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 1
    • 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 1
    • 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