Index
A
B
- backup option (customizer harness) 1
- backward compatibility
- 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
- 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
- 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
- codegen option (SQLJ -codegen) 1
- code layers in profiles 1
- collections
- column definitions (types/sizes)
- command line (translator)
- commit
- compat(ibility) option (Oracle customizer) 1
- compilation
- compile option (sqlj -compile) 1
- compiler
- 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
- 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
- context expressions
- 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
- customizer option (customizer harness) 1
- customizers
- custom Java classes
D
- database connection, verify 1
- database URL
- data source support
- DBMS_LOB package 1
- debugging
- debug option (customizer harness) 1
- declarations
- default connection
- DefaultContext class
- 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
- dir option (sqlj -dir) 1
- dirty reads 1
- DMS support
- d option (sqlj -d) 1
- driver option (customizer harness) 1
- driver registration option (sqlj -driver) 1
- Dynamic Monitoring Service, SQLJ support 1
- dynamic SQL
- dynamic SQL support in SQLJ
E
- echoing command line without executing 1
- echo option, without execution 1
- encoding
- encoding option, source files (sqlj -encoding) 1
- environment assumptions and requirements 1
- environments--scenarios and limitations 1
- environment variable, translator options 1
- errors
- exceptions
- executable statements
- execution contexts
- exemplar schema 1
- exit codes, translator 1
- explain option (sqlj -explain) 1
- extending iterator classes 1
- extensions
H
I
- IDE SQLJ integration 1
- IMPLEMENTS clause
- 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
- 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
- JDBC 2.0
- JDBC connection methods (transactions) 1
- JDBC driver registration option (sqlj -driver) 1
- JDBC drivers
- JDBC interoperability
- JDBC vs. SQLJ, sample application 1
- jdblinemap option (sqlj -jdblinemap) 1
- JDeveloper
- JDK
- supported versions 1
- JNDI
- J prefix (sqlj -J-x) 1
L
N
- named iterators
- name of compiler 1
- name of Java VM 1
- naming requirements and restrictions
- 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
- non-repeatable reads 1
- n option (sqlj -n) (echo without execution) 1
- NString class 1
- NString class (globalization support) 1
- null-handling
O
- object references
- 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
- offline option (sqlj -offline) 1
- offline parsing
- online checking
- 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
- 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
- Oracle customizer
- Oracle extensions
- Oracle optimizer 1
- Oracle-specific code generation
- Oracle system identifiers (SIDs) in connect strings, deprecated 1
- ORAData
- output directory
- 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)
- 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
- plan baselines 1
- positional iterators
- positioned delete 1
- positioned update 1
- P prefix (sqlj -P-x) 1
- prefetching rows 1
- prefixes
- 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
- properties, Java, getProperty() 1
- properties files, SQLJ DMS 1
- properties files (translator)
- 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
- registering column types/sizes 1
- registering parameter sizes 1
- register JDBC drivers
- REPEATABLE READ transactions 1
- reporting options (translator) 1
- requirements, environment 1
- result expressions
- result set iterators (strongly typed)
- Overview 1
- result set iterators (weakly typed)
- ResultSetIterator type 1
- result sets
- returnability (cursor states, WITH clause) 1
- rollback
- ROWID
- row prefetching 1
- runtime
S
- sample applications
- sample classes
- savepoints
- scrollable iterators
- ScrollableResultSetIterator type 1
- SELECT INTO statements
- 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
- ser profiles (.ser)
- 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
- source files encoding option 1
- source name / public class name check 1
- SQLCheckerCustomizer
- 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
- status option (sqlj -status) 1
- stmtcache option (Oracle customizer) 1
- stored function calls 1
- stored outlines 1
- stored procedure calls 1
- streams
- 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
- 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
- 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
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
- 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
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
- WHERE CURRENT OF 1
- WHERE CURRENT OF clause 1
- Windows, SQLJ development in 1
- WITH clause syntax 1
- wrapper classes for null-handling 1