Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  R  S  T  U  W  X  

A

  • AC 1
  • Accessing PL/SQL Associative Arrays 1
  • ANYDATA 1
  • ANYTYPE 1
  • applets
    • connecting to a database 1
    • deploying in an HTML page 1
    • packaging 1
    • signed applets
      • browser security 1
      • object-signing certificate 1
    • using signed applets 1
    • using with firewalls 1
  • application continuity
    • configuring Oracle database 1
    • configuring Oracle JDBC 1
    • delaying the reconnection 1
    • disabling replay 1
    • identifying request boundaries 1
    • logical transaction identifier 1
    • registering a connection callback 1
    • retaining mutable values 1
    • transaction guard 1
  • ARRAY
    • objects, creating 1
  • arrays
    • defined 1
    • getting 1
    • named 1
    • passing to callable statement 1
    • retrieving from a result set 1
    • retrieving partial arrays 1
    • using type maps 1
    • working with 1
  • at-most-once execution 1
  • authentication (security) 1
  • auto-commit 1
  • auto-commit mode
    • disabling 1
    • result set behavior 1

B

  • batch jobs, authenticating users in 1
  • batch updates--see update batching 1
  • BFILE
    • class 1
    • defined 1
  • BFILE locator, selecting 1
  • BLOB
    • class 1
    • locators
      • selecting 1
  • branch qualifier (distributed transactions) 1

C

  • CachedRowSet 1
  • caching, client-side
    • Oracle use for scrollable result sets 1
  • callable statement
    • using getOracleObject() method 1
  • cancelling
    • SQL statements 1
  • casting return values 1
  • catalog arguments (DatabaseMetaData) 1
  • character sets 1
  • CHAR columns
    • using setFixedCHAR() to match in WHERE 1
  • checksums
    • code example 1
    • setting parameters in Java 1
    • support by OCI drivers 1
    • support by Thin driver 1
  • CLOB
    • class 1
    • locators, selecting 1
  • close() method 1
  • close method 1
  • collections
    • defined 1
  • collections (nested tables and arrays) 1
  • column types
    • defining 1
    • redefining 1
  • commit a distributed transaction branch 1
  • commit changes to database 1
  • CONNECT / feature 1
  • connection
    • closing 1
    • opening 1
  • Connection Manager
    • installing 1
    • starting 1
    • using 1
    • using multiple managers 1
    • writing the connection string 1
  • connection properties
    • put() method 1
  • connections
    • read-only 1
  • connection string
    • Connection Manager 1
  • constants for SQL types 1
  • CursorName
    • limitations 1
  • cursors 1
  • custom collection classes
    • defined 1
  • custom Java classes
    • defined 1
  • custom object classes
    • creating 1
    • defined 1
  • custom reference classes
    • defined 1

D

  • database
    • connecting
      • from an applet 1
      • via multiple Connection Managers 1
      • with server-side internal driver 1
    • connection testing 1
  • DatabaseMetaData calls 1
  • Database Resident Connection Pooling
    • APIs 1
    • DRCP 1
    • enabling
      • client side 1
      • server side 1
    • sharing across multiple connections 1
    • tagging 1
  • database specifiers 1
  • database URL
    • including userid and password 1
  • database URL, specifying 1
  • database URLs
    • and database specifiers 1
  • data conversions
    • LONG 1
    • LONG RAW 1
  • datasources
    • and JNDI 1
  • data sources
    • creating and connecting (with JNDI) 1
    • creating and connecting (without JNDI) 1
    • Oracle implementation 1
    • properties 1
    • standard interface 1
  • data streaming
    • avoiding 1
  • data type mappings 1
  • data types
    • Java 1
    • Java native 1
    • JDBC 1
    • Oracle SQL 1
  • DATE class 1
  • DBOP tag 1
  • debugging JDBC programs 1
  • defaultConnection() method 1
  • detachServerConnection 1
  • distributed transaction ID component 1
  • distributed transactions
    • branch qualifier 1
    • check for same resource manager 1
    • commit a transaction branch 1
    • components and scenarios 1
    • concepts 1
    • distributed transaction ID component 1
    • end a transaction branch 1
    • example of implementation 1
    • forget 1
    • global transaction identifier 1
    • ID format identifier 1
    • obtain the list of transaction brances during recovery 1
    • Oracle XA connection implementation 1
    • Oracle XA data source implementation 1
    • Oracle XA ID implementation 1
    • Oracle XA optimizations 1
    • Oracle XA resource implementation 1
    • overview 1
    • prepare a transaction branch 1
    • roll back a transaction branch 1
    • start a transaction branch 1
    • transaction branch ID component 1
    • XA connection interface 1
    • XA data source interface 1
    • XA error handling 1
    • XA exception classes 1
    • XA ID interface 1
    • XA resource functionality 1
    • XA resource interface 1
  • DML Returning
    • example 1
    • limitations 1
    • Oracle-specific APIs 1
    • running statements 1
  • Double.NaN
    • restrictions on use 1
  • DRCP 1

E

  • encryption
    • code example 1
    • overview 1
    • setting parameters in Java 1
    • support by OCI drivers 1
    • support by Thin driver 1
  • end a distributed transaction branch 1
  • Enterprise Java Beans (EJB) 1
  • environment variables
    • specifying 1
  • errors
    • general JDBC messages, listed 1
    • general JDBC message structure 1
    • processing exceptions 1
    • TTC messages, listed 1
  • explicit Statement caching
    • definition of 1
  • extensions to JDBC, Oracle 1 , 2 , 3 , 4 , 5 , 6
  • external changes (result set)
    • defined 1
    • visibility vs. detection 1
  • external file
    • defined 1

F

  • fetch direction in result sets 1
  • fetch size, result sets 1
  • FilteredRowSet 1
  • finalizer methods 1
  • firewalls
    • configuring for applets 1
    • connection string 1
    • described 1
    • required rule list items 1
    • using with applets 1
  • Firewalls, using with JDBC 1
  • Float.NaN
    • restrictions on use 1
  • floating-point compliance 1
  • format identifier, transaction ID 1
  • function call syntax, JDBC escape syntax 1

G

  • getBinaryStream() method 1
  • getBytes() method 1
  • getColumns 1
  • getConnection() method 1
  • getCursorName() method
    • limitations 1
  • getLogicalTransactionId method 1
  • getMoreResultSet(int) 1
  • getObject() method
    • for ORAData objects 1
    • return types 1
  • getOracleObject() method
    • return types 1 , 2
    • using in callable statement 1
    • using in result set 1
  • getStatementCacheSize() method
    • code example 1
  • getXXX() methods
    • casting return values 1
    • for specific data types 1
  • globalization
    • using 1
  • global transaction identifier (distributed transactions) 1
  • global transactions 1

H

  • HTML tags, to deploy applets 1

I

  • IEEE 754 floating-point compliance 1
  • implicit Statement caching
    • definition of 1
    • Least Recently Used (LRU) algorithm 1
  • installation
    • directories and files 1
    • verifying on the client 1
  • Instant Client feature 1
  • integrity
    • code example 1
    • overview 1
    • setting parameters in Java 1
    • support by OCI drivers 1
    • support by Thin driver 1
  • internal changes (result set)
    • defined 1
  • isColumnInvisible 1
  • isSameRM() (distributed transactions) 1

J

  • Java
    • compiling and running 1
    • data types 1
    • native data types 1
    • stored procedures 1
    • stream data 1
  • java.sql.Connection interface
    • close method 1
  • java.sql.Statement interface
    • close method 1
  • java.util.Properties 1
  • Java Naming and Directory Interface (JNDI) 1
  • Java Sockets 1
  • Java Virtual Machine (JVM) 1
  • JDBC
    • and IDEs 1
    • basic program 1
    • data types 1
    • defined 1
    • importing packages 1
    • limitations of Oracle extensions 1
    • sample files 1
    • testing 1
    • version support 1
  • JDBC 2.0 support
    • data type support 1
    • extended feature support 1
    • introduction 1
    • JDK 1.2.x vs. JDK 1.1.x 1
    • standard feature support 1
  • JdbcCheckup program 1
  • JDBC drivers
    • applets 1
    • choosing a driver for your needs 1
    • common problems 1
    • determining driver version 1
    • introduction 1
    • JDBC escape syntax 1
  • JDBC escape syntax
    • function call syntax 1
    • LIKE escape characters 1
    • outer joins 1
    • scalar functions 1
    • time and date literals 1
    • translating to SQL example 1
  • JDBCRowSet 1
  • JDBCSpy 1
  • JDBCTest 1
  • JDeveloper 1
  • JDK
    • versions supported 1
  • JNDI
    • and datasources 1
    • looking up data source 1
    • overview of Oracle support 1
    • registering data source 1
  • JoinRowSet 1
  • JVM 1

K

  • KPRB driver
    • overview 1
    • relation to the SQL engine 1
    • session context 1
    • testing 1
    • transaction context 1
    • URL for 1

L

  • Least Recently Used (LRU) algorithm 1 , 2
  • LIKE escape characters, JDBC escape syntax 1
  • limitations on setBytes() and setString(), use of streams to avoid 1
  • LOB
    • defined 1
  • logical transaction identifier
    • LTXID 1
  • LONG
    • data conversions 1
  • LONG RAW
    • data conversions 1
  • LRU algorithm 1
  • LTXID 1

M

  • memory leaks 1
  • monitoring database operations
    • DBOP 1
    • setClientInfo 1

N

  • named arrays
    • defined 1
  • nativeXA 1
  • network events, trapping 1
  • NLS. See globalization 1
  • NULL
    • testing for 1
  • NUMBER class 1

O

  • object references
    • accessing object values 1 , 2
    • described 1
    • passing to prepared statements 1
    • retrieving 1
    • retrieving from callable statement 1
    • updating object values 1 , 2
  • OCI driver
    • described 1
  • ODBCSpy 1
  • ODBCTest 1
  • optimization, performance 1
  • oracle.jdbc., Oracle JDBC extensions 1
  • oracle.jdbc.LogicalTransactionIdEventListener interface 1
  • oracle.jdbc.OracleCallableStatement interface 1
  • oracle.jdbc.OracleConnection interface 1
  • oracle.jdbc.OraclePreparedStatement interface 1
  • oracle.jdbc.OracleResultSet interface 1
  • oracle.jdbc.OracleResultSetMetaData interface 1
  • oracle.jdbc.OracleSql class 1
  • oracle.jdbc.OracleStatement interface 1
  • oracle.jdbc.OracleTypes class 1
  • oracle.jdbc.xa package and subpackages 1
  • oracle.sql.ARRAY class
    • methods for Java primitive types 1
  • oracle.sql.BFILE class 1
  • oracle.sql.BLOB class 1
  • oracle.sql.CLOB class 1
  • oracle.sql.data types
    • support 1
  • oracle.sql.DATE class 1
  • oracle.sql.NUMBER class 1
  • oracle.sql.RAW class 1
  • oracle.sql.STRUCT class 1
  • Oracle Advanced Security
    • support by JDBC 1
  • OracleCallableStatement interface 1
  • OracleCallableStatement object 1
  • OracleConnection class 1
  • Oracle Connection Manager 1
  • OracleData interface
    • advantages 1
  • OracleDataSource class 1
  • Oracle data types
    • using 1
  • Oracle extensions
    • data type support 1
    • limitations
      • catalog arguments to DatabaseMetaData calls 1
      • CursorName 1
      • IEEE 754 floating-point compliance 1
      • JDBC outer join escapes 1
      • read-only connection 1
      • SQLWarning class 1
    • object support 1
    • result sets 1
    • statements 1
    • to JDBC 1 , 2 , 3 , 4 , 5 , 6
  • Oracle objects
    • and JDBC 1
    • Java classes which support 1
    • mapping to custom object classes 1
    • reading data by using SQLData interface 1
    • working with 1
    • writing data by using SQLData interface 1
  • OraclePreparedStatement interface 1
  • OraclePreparedStatement object 1
  • OracleResultSet interface 1
  • OracleResultSetMetaData interface 1
  • Oracle SQL data types 1
  • OracleStatement interface 1
  • OracleTypes class 1
  • OracleXAConnection class 1
  • OracleXADataSource class 1
  • OracleXAResource class 1
  • OracleXid class 1
  • ORAData interface
    • additional uses 1
    • reading data 1
    • writing data 1
  • orai18n.jar file 1
  • outer joins, JDBC escape syntax 1

P

  • password, specifying 1
  • PDA 1
  • performance enhancements, standard vs. Oracle 1
  • performance extensions
    • defining column types 1
  • performance optimization 1
  • Personal Digital Assistant (PDA) 1
  • PL/SQL
    • stored procedures 1
  • PL/SQL Associative Arrays
    • mapping 1
  • prefetching rows
    • suggested default 1
  • prepare a distributed transaction branch 1
  • put() method
    • for Properties object 1

R

  • RAW class 1
  • recover (distributed transactions) 1
  • REF CURSORs 1
  • refetching rows into a result set 1
  • registerConnectionInitializationCallback 1
  • registerIndexTableOutParameter() method
    • arguments
      • int paramIndex 1
  • Remote Method Invocation (RMI) 1
  • resource managers 1
  • result set
    • auto-commit mode 1
    • metadata 1
    • Oracle extensions 1
    • using getOracleObject() method 1
  • result set, processing 1
  • result set enhancements
    • downgrade rules 1
    • fetch size 1
    • limitations 1
    • Oracle scrollability requirements 1
    • Oracle updatability requirements 1
    • refetching rows 1
    • summary of visibility of changes 1
    • visibility vs. detection of external changes 1
  • result set fetch size 1
  • Result Set Holdability 1
  • result set object
    • closing 1
  • Retrieval of Auto-Generated Keys 1
  • return types
    • for getXXX() methods 1
    • getObject() method 1
    • getOracleObject() method 1
  • return values
    • casting 1
  • RMI 1
  • roll back a distributed transaction branch 1
  • roll back changes to database 1
  • ROWID, use for result set updates 1
  • ROWID class
    • defined 1
  • row prefetching
    • and data streams 1
  • RowSet
    • events and event listeners 1
    • overview 1
    • properties 1
    • traversing 1

S

  • savepoints
    • transaction 1
  • scalar functions, JDBC escape syntax 1
  • SCAN
    • backward compatibility 1
    • configuring the database 1
    • connection load balancing 1
    • maximum availability architecture environment 1
    • Oracle connection manager 1
    • overview 1
    • version 1
  • Schema Naming 1
  • scripts, authenticating users in 1
  • scrollable result sets
    • fetch direction 1
    • implementation of scroll-sensitivity 1
    • refetching rows 1
    • visibility vs. detection of external changes 1
  • scroll-sensitive result sets
    • limitations 1
  • security
    • authentication 1
    • encryption 1
    • integrity 1
    • Oracle Advanced Security support 1
  • server-side internal driver
    • connection to database 1
  • server-side Thin driver, overview 1
  • session context
    • for KPRB driver 1
  • setBytes() limitations, using streams to avoid 1
  • setCursorName() method 1
  • setDisableStmtCaching() method 1
  • setEscapeProcessing() method 1
  • setFixedCHAR() method 1
  • setNull() 1
  • setObejct() method 1
  • setObject() method
    • for STRUCT objects 1
  • setOracleObject() method 1
  • setString() limitations, using streams to avoid 1
  • setXXX() methods, for specific data types 1
  • signed applets 1
  • Solaris
    • shared libraries 1
  • specifiers
    • database 1
  • SQL
    • data converting to Java data types 1
    • types, constants for 1
  • SQLData interface
    • advantages 1
    • reading data from Oracle objects 1
    • writing data from Oracle objects 1
  • SQL engine
    • relation to the KPRB driver 1
  • SQL syntax (Oracle) 1
  • SQLWarning class, limitations 1
  • start a distributed transaction branch 1
  • statement.cancel() 1
  • Statement caching
    • explicit
      • definition of 1
    • implicit
      • definition of 1
      • Least Recently Used (LRU) algorithm 1
  • Statement object
    • closing 1
  • statements
    • Oracle extensions 1
  • stopping
    • statement execution 1
  • stored procedures
    • Java 1
    • PL/SQL 1
  • stream data
    • CHAR columns 1
    • closing 1
    • example 1
    • external files 1
    • LOBs 1
    • LONG columns 1
    • LONG RAW columns 1
    • multiple columns 1
    • precautions 1
    • RAW columns 1
    • row prefetching 1
    • use to avoid setBytes() and setString() limitations 1
    • VARCHAR columns 1
  • stream data column
    • bypassing 1
  • STRUCT class 1
  • STRUCT object
    • retrieving 1
    • retrieving attributes as oracle.sql types 1
  • SYS.ANYDATA 1
  • SYS.ANYTYPE 1

T

  • TAF, definition of 1
  • TCP/IP protocol 1
  • testing
    • for NULL values 1
  • Thin driver
    • applets 1
    • overview 1
    • server-side, overview 1
  • time and date literals, JDBC escape syntax 1
  • trace facility 1
  • trace parameters
    • client-side 1
    • server-side 1
  • transaction branch 1
  • transaction branch ID component 1
  • transaction context
    • for KPRB driver 1
  • transaction guard
    • at-most-once execution 1
    • logical transaction identifier 1
  • transaction IDs (distributed transactions) 1
  • transaction managers 1
  • transactions
    • switching between local and global 1
  • transaction savepoints
  • Transparent Application Failover (TAF), definition of 1
  • TTC error messages, listed 1
  • type map
    • adding entries 1
    • and STRUCTs 1
    • creating a new map 1
    • used with arrays 1
    • using with arrays 1
  • type map (SQL to Java) 1
  • type maps
    • relationship to database connection 1

U

  • unicode data 1
  • unregisterConnectionInitializationCallback method 1
  • updatable result sets
    • limitations 1
    • refetching rows 1
    • update conflicts 1
  • update batching (standard model)
    • adding to batch 1
    • clearing the batch 1
    • committing changes 1
    • error handling 1
    • example 1
    • executing the batch 1
    • intermixing batched and non-batched 1
    • overview 1
    • update counts 1
    • update counts upon error 1
  • update conflicts in result sets 1
  • update counts
    • standard update batching 1
    • upon error (standard batching) 1
  • URLs
    • for KPRB driver 1
  • userid, specifying 1

W

  • WebRowSet 1
  • window, scroll-sensitive result sets 1

X

  • XA
    • connection implementation 1
    • connections (definition) 1
    • data source implementation 1
    • data sources (definition) 1
    • definition 1
    • error handling 1
    • example of implementation 1
    • exception classes 1
    • Oracle optimizations 1
    • Oracle transaction ID implementation 1
    • resource implementation 1
    • resources (definition) 1
    • transaction ID interface 1