Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Symbols
- $, $, 14-9
- %, %, 8-55, 21-13
- &, &, 21-13
- +, +, 21-16
- _, _, 21-13
A
- absolute positioning in result sets, absolute positioning in result sets, 11-2
- absolute() method (result set), absolute() method (result set), 11-14
- acceptChanges() method, acceptChanges() method, A-13
- ACID properties, ACID properties, 17-2
- addBatch() method, addBatch() method, 12-11
- addConnectionEventListener() method (connection cache), addConnectionEventListener() method (connection cache), 14-22
- addRowSetListener() method, addRowSetListener() method, A-6
- afterLast() method (result sets), afterLast() method (result sets), 11-14
- ANO (Oracle Advanced Security), ANO (Oracle Advanced Security), 18-9
- ANSI Web site, ANSI Web site, xxvii, 8-53
- APPLET HTML tag, APPLET HTML tag, 18-25
- applets
- connecting to a database, connecting to a database, 18-16
- deploying in an HTML page, deploying in an HTML page, 18-25
- packaging, packaging, 18-24
- for JDK 1.2.x or 1.1.x browser, for JDK 1.2.x or 1.1.x browser, 18-24
- packaging and deploying, packaging and deploying, 1-13
- signed applets
- browser security, browser security, 18-21
- object-signing certificate, object-signing certificate, 18-21
- using signed applets, using signed applets, 18-20
- using with firewalls, using with firewalls, 18-21
- working with, working with, 18-16
- ARCHIVE, parameter for APPLET tag, ARCHIVE, parameter for APPLET tag, 18-26
- ARRAY
- class, class, 5-12
- descriptors, descriptors, 5-12
- objects, creating, objects, creating, 5-12, 10-12
- array descriptor
- creating, creating, 10-22
- ArrayDescriptor object, ArrayDescriptor object, 10-11, 10-22
- creating, creating, 10-12
- deserialization, deserialization, 10-15
- get methods, get methods, 10-14
- serialization, serialization, 10-15
- setConnection() method, setConnection() method, 10-15
- arrays
- defined, defined, 10-2
- example program, example program, 20-35
- getting, getting, 10-20
- named, named, 10-2
- passing to callable statement, passing to callable statement, 10-23
- retrieving from a result set, retrieving from a result set, 10-16
- retrieving partial arrays, retrieving partial arrays, 10-19
- using type maps, using type maps, 10-25
- working with, working with, 10-2
- ASO (Oracle Advanced Security), ASO (Oracle Advanced Security), 18-9
- authentication (security), authentication (security), 18-10
- AUTHENTICATION_LEVEL parameter, AUTHENTICATION_LEVEL parameter, 18-19
- auto-commit mode
- disabling, disabling, 19-6
- result set behavior, result set behavior, 19-6
B
- batch updates--see update batching
- batch value
- checking value, checking value, 12-7
- connection batch value, setting, connection batch value, setting, 12-5
- connection vs. statement value, connection vs. statement value, 12-4
- default value, default value, 12-5
- overriding value, overriding value, 12-7
- statement batch value, setting, statement batch value, setting, 12-6
- BatchUpdateException, BatchUpdateException, 12-16
- beforeFirst() method, beforeFirst() method, A-10
- beforeFirst() method (result sets), beforeFirst() method (result sets), 11-13
- begin method, begin method, 17-3, 17-16, 17-19
- BFILE
- accessing data, accessing data, 7-25
- class, class, 5-12
- creating and populating columns, creating and populating columns, 7-23
- defined, defined, 3-28
- example program, example program, 20-40
- introduction, introduction, 7-2
- locators, locators, 7-20
- getting from a result set, getting from a result set, 7-20
- getting from callable statement, getting from callable statement, 7-21
- passing to callable statements, passing to callable statements, 7-21
- passing to prepared statements, passing to prepared statements, 7-21
- manipulating data, manipulating data, 7-25
- reading data, reading data, 7-22
- BFILE locator, selecting, BFILE locator, selecting, 5-13
- BigDecimal mapping (for attributes), BigDecimal mapping (for attributes), 8-47
- bindds command, bindds command, 14-9, 17-14, 17-25
- example, example, 14-11
- options, options, 14-10
- bindut command, bindut command, 17-12, 17-17, 17-24
- BLOB, BLOB, 7-5
- class, class, 5-12
- creating and populating, creating and populating, 7-10
- creating columns, creating columns, 7-11
- getting locators, getting locators, 7-3
- introduction, introduction, 7-2
- locators
- getting from result set, getting from result set, 7-4
- selecting, selecting, 5-13
- manipulating data, manipulating data, 7-12
- populating columns, populating columns, 7-11
- reading data, reading data, 7-6, 7-8
- writing data, writing data, 7-9
- Boolean parameters, restrictions, Boolean parameters, restrictions, 19-9
- branch qualifier (distributed transactions), branch qualifier (distributed transactions), 15-13
C
- cache schemes (connection cache), cache schemes (connection cache), 14-27
- CachedRowSet, CachedRowSet, A-9
- caching, client-side
- custom use for scrollable result sets, custom use for scrollable result sets, 11-6
- Oracle use for scrollable result sets, Oracle use for scrollable result sets, 11-5
- callable statement
- getting a BFILE locator, getting a BFILE locator, 7-21
- getting LOB locators, getting LOB locators, 7-4
- passing BFILE locator, passing BFILE locator, 7-21
- passing LOB locators, passing LOB locators, 7-5
- using getOracleObject() method, using getOracleObject() method, 6-5
- cancelRowUpdates() method (result set), cancelRowUpdates() method (result set), 11-20
- casting return values, casting return values, 6-10
- catalog arguments (DatabaseMetaData), catalog arguments (DatabaseMetaData), 21-17
- CHAR class
- conversions with KPRB driver, conversions with KPRB driver, 18-34
- CHAR columns
- NLS size restrictions, Thin, NLS size restrictions, Thin, 18-6
- space padding, space padding, 19-8
- using setFixedCHAR() to match in WHERE, using setFixedCHAR() to match in WHERE, 6-17
- character sets, character sets, 5-32
- conversions with KPRB driver, conversions with KPRB driver, 18-34
- checksums
- code example, code example, 18-14
- setting parameters in Java, setting parameters in Java, 18-14
- support by OCI drivers, support by OCI drivers, 18-12
- support by Thin driver, support by Thin driver, 18-13
- Class.forName method, Class.forName method, 3-3
- CLASSPATH, specifying, CLASSPATH, specifying, 2-6
- clearBatch() method, clearBatch() method, 12-14
- clearDefines() method, clearDefines() method, 12-24
- clearMetaData parameter, clearMetaData parameter, 13-6, 16-11
- client installation, client installation, 1-12
- CLOB
- class, class, 5-12
- creating and populating, creating and populating, 7-10
- creating columns, creating columns, 7-11
- introduction, introduction, 7-2
- locators, locators, 7-3
- getting from result set, getting from result set, 7-4
- passing to callable statements, passing to callable statements, 7-5
- passing to prepared statement, passing to prepared statement, 7-5
- locators, selecting, locators, selecting, 5-13
- manipulating data, manipulating data, 7-12
- populating columns, populating columns, 7-11
- reading data, reading data, 7-6, 7-9
- writing data, writing data, 7-9
- close(), close(), 13-5
- close() method, close() method, 5-19, 5-20, 5-21, 19-8
- for caching statements, for caching statements, 13-7, 13-9
- for OracleConnectionCache interface, for OracleConnectionCache interface, 14-24
- closeFile() method, closeFile() method, 7-26
- closePooledConnection() method, closePooledConnection() method, 14-24
- closeWithKey(), closeWithKey(), 13-5
- closeWithKey() method, closeWithKey() method, 13-10
- CMAN.ORA file, creating, CMAN.ORA file, creating, 18-19
- CODE, parameter for APPLET tag, CODE, parameter for APPLET tag, 18-25
- CODEBASE, parameter for APPLET tag, CODEBASE, parameter for APPLET tag, 18-25
- collections
- defined, defined, 10-2
- collections (nested tables and arrays), collections (nested tables and arrays), 10-11
- column types
- defining, defining, 12-23
- redefining, redefining, 12-20
- commit a distributed transaction branch, commit a distributed transaction branch, 15-12
- commit changes to database, commit changes to database, 3-13
- commit method, commit method, 17-3, 17-4, 17-16, 17-19
- Common Object Request Broker Architecture (CORBA), Common Object Request Broker Architecture (CORBA), 1-17
- CONCUR_READ_ONLY result sets, CONCUR_READ_ONLY result sets, 11-9
- CONCUR_UPDATABLE result sets, CONCUR_UPDATABLE result sets, 11-9
- concurrency types in result sets, concurrency types in result sets, 11-4
- connect string
- for KPRB driver, for KPRB driver, 18-29
- for the Oracle8 Connection Manager, for the Oracle8 Connection Manager, 18-19
- connection
- closing, closing, 3-14
- from KPRB driver, from KPRB driver, 1-15
- opening, opening, 3-3
- opening for JDBC OCI driver, opening for JDBC OCI driver, 3-9
- opening for JDBC Thin driver, opening for JDBC Thin driver, 3-10
- Properties object, Properties object, 3-6
- connection caching
- adding connection event listener, adding connection event listener, 14-22
- basics, accessing the cache, basics, accessing the cache, 14-19
- basics, closing connections, basics, closing connections, 14-20
- basics, opening connections, basics, opening connections, 14-19
- basics, setting up a cache, basics, setting up a cache, 14-18
- cache instance getConnection() method, cache instance getConnection() method, 14-19
- connection events, connection events, 14-20
- creating connection event listener, creating connection event listener, 14-22
- implementation scenarios, implementation scenarios, 14-20
- OracleConnectionCache interface, OracleConnectionCache interface, 14-24
- OracleConnectionCacheImpl class, OracleConnectionCacheImpl class, 14-25
- OracleConnectionEventListener class, OracleConnectionEventListener class, 14-29
- overview, overview, 14-18
- preliminary steps, preliminary steps, 14-21
- removing connection event listener, removing connection event listener, 14-23
- steps in closing a connection, steps in closing a connection, 14-23
- steps in opening a connection, steps in opening a connection, 14-21
- connection event listener, connection event listener, 14-22
- Connection Manager, Connection Manager, 1-12, 18-17, 18-18
- installing, installing, 18-18
- starting, starting, 18-19
- using multiple managers, using multiple managers, 18-20
- writing the connect string, writing the connect string, 18-19
- connection methods, JDBC 2.0 result sets, connection methods, JDBC 2.0 result sets, 11-32
- connection pooling
- concepts, concepts, 14-13
- creating data source and connecting, creating data source and connecting, 14-16
- introduction, introduction, 14-13
- Oracle data source implementation, Oracle data source implementation, 14-14
- pooled connections, pooled connections, 14-15
- sample application, sample application, 20-89
- standard data source interface, standard data source interface, 14-14
- connection properties
- database, database, 3-7
- defaultBatchValue, defaultBatchValue, 3-7
- defaultRowPrefetch, defaultRowPrefetch, 3-7
- includeSynonyms, includeSynonyms, 3-7
- internal_logon, internal_logon, 3-7
- sysdba, sysdba, 3-7
- sysoper, sysoper, 3-7
- password, password, 3-6
- put() method, put() method, 3-9
- remarksReporting, remarksReporting, 3-7
- user, user, 3-6
- connectionClosed() method (connection event listener), connectionClosed() method (connection event listener), 14-29
- connectionErrorOccurred() method (connection event listener), connectionErrorOccurred() method (connection event listener), 14-29
- connections
- read-only, read-only, 19-14
- constants for SQL types, constants for SQL types, 5-22
- CORBA, CORBA, 1-17
- CREATE DIRECTORY statement
- for BFILEs, for BFILEs, 7-23
- CREATE TABLE statement
- to create BFILE columns, to create BFILE columns, 7-23
- to create BLOB, CLOB columns, to create BLOB, CLOB columns, 7-11
- CREATE TYPE command, CREATE TYPE command, 8-53, 8-55, 8-63
- CREATE TYPE statement, CREATE TYPE statement, 8-29, 8-52
- create() method
- for ORADataFactory interface, for ORADataFactory interface, 8-21
- createDescriptor() method, createDescriptor() method, 8-5, 8-61, 10-14
- createStatement(), createStatement(), 13-5
- createStatement() method, createStatement() method, 5-18, 13-10
- createStatementWithKey(), createStatementWithKey(), 13-5
- createStatementWithKey() method, createStatementWithKey() method, 13-10, 13-11
- createTemporary() method, createTemporary() method, 7-18
- creationState() method, creationState() method, 13-7
- code example, code example, 13-7
- CursorName
- limitations, limitations, 21-16
- cursors, cursors, 19-8
- custom collection classes
- and JPublisher, and JPublisher, 10-27
- defined, defined, 10-2, 10-27
- custom Java classes, custom Java classes, 5-4
- creating, creating, 20-43, 20-47
- defined, defined, 8-2
- custom object classes
- creating, creating, 8-10
- defined, defined, 8-2
- custom reference classes
- and JPublisher, and JPublisher, 9-10
- defined, defined, 9-2, 9-10
D
- data conversions, data conversions, 6-2
- LONG, LONG, 3-20
- LONG RAW, LONG RAW, 3-20
- data sources
- creating and connecting (with JNDI), creating and connecting (with JNDI), 14-8
- creating and connecting (without JNDI), creating and connecting (without JNDI), 14-7
- logging and tracing, logging and tracing, 14-11
- Oracle implementation, Oracle implementation, 14-3
- PrintWriter, PrintWriter, 14-11
- properties, properties, 14-4
- sample application (with JNDI), sample application (with JNDI), 20-85
- sample application (without JNDI), sample application (without JNDI), 20-86
- standard interface, standard interface, 14-3
- data streaming
- avoiding, avoiding, 3-24
- example program, example program, 20-18
- database
- connecting
- from an applet, from an applet, 18-16
- via multiple Connection Managers, via multiple Connection Managers, 18-20
- with server-side internal driver, with server-side internal driver, 18-27
- connection testing, connection testing, 2-8
- database connection
- connection property, connection property, 3-7
- database meta data methods, JDBC 2.0 result sets, database meta data methods, JDBC 2.0 result sets, 11-35
- database URL
- including userid and password, including userid and password, 3-5
- database URL, specifying, database URL, specifying, 3-5
- DatabaseMetaData calls, DatabaseMetaData calls, 21-17
- DatabaseMetaData class, DatabaseMetaData class, 21-12
- entry points for applets, entry points for applets, 18-24
- DataSource object
- binding in namespace, binding in namespace, 17-14, 17-18
- create dynamically, create dynamically, 17-25
- getConnection method, getConnection method, 17-6
- datatype classes, datatype classes, 5-7
- datatype mappings, datatype mappings, 3-16
- datatypes
- Java, Java, 3-16
- Java native, Java native, 3-16
- JDBC, JDBC, 3-16
- Oracle SQL, Oracle SQL, 3-16
- DATE class, DATE class, 5-13
- DBMS_LOB package, DBMS_LOB package, 7-6
- debugging JDBC programs, debugging JDBC programs, 19-11
- DEFAULT_CHARSET character set value, DEFAULT_CHARSET character set value, 5-32
- defaultBatchValue connection property, defaultBatchValue connection property, 3-7
- defaultConnection() method, defaultConnection() method, 18-27
- defaultRowPrefetch connection property, defaultRowPrefetch connection property, 3-7
- defineColumnType() method, defineColumnType() method, 3-24, 5-19, 12-24
- DELETE in a result set, DELETE in a result set, 11-18
- deleteRow() method (result set), deleteRow() method (result set), 11-18
- deletesAreDetected() method (database meta data), deletesAreDetected() method (database meta data), 11-29
- deserialization
- ArrayDescriptor object, ArrayDescriptor object, 10-15
- creating a StructDescriptor object, creating a StructDescriptor object, 8-6
- creating an ArrayDescriptor object, creating an ArrayDescriptor object, 10-15
- definition of, definition of, 8-6, 10-15
- StructDescriptor object, StructDescriptor object, 8-6
- distributed transaction ID component, distributed transaction ID component, 15-13
- distributed transactions
- branch qualifier, branch qualifier, 15-13
- check for same resource manager, check for same resource manager, 15-13
- commit a transaction branch, commit a transaction branch, 15-12
- components and scenarios, components and scenarios, 15-2
- concepts, concepts, 15-3
- distributed transaction ID component, distributed transaction ID component, 15-13
- end a transaction branch, end a transaction branch, 15-10
- example of implementation, example of implementation, 15-18
- global transaction identifier, global transaction identifier, 15-13
- ID format identifier, ID format identifier, 15-13
- introduction, introduction, 15-2
- Oracle XA connection implementation, Oracle XA connection implementation, 15-7
- Oracle XA data source implementation, Oracle XA data source implementation, 15-6
- Oracle XA ID implementation, Oracle XA ID implementation, 15-13
- Oracle XA optimizations, Oracle XA optimizations, 15-17
- Oracle XA resource implementation, Oracle XA resource implementation, 15-8
- prepare a transaction branch, prepare a transaction branch, 15-11
- roll back a transaction branch, roll back a transaction branch, 15-12
- sample application (suspend/resume), sample application (suspend/resume), 20-105
- sample application (two-phase commit), sample application (two-phase commit), 20-1, 20-109
- start a transaction branch, start a transaction branch, 15-10
- transaction branch ID component, transaction branch ID component, 15-13
- XA connection interface, XA connection interface, 15-7
- XA data source interface, XA data source interface, 15-6
- XA error handling, XA error handling, 15-16
- XA exception classes, XA exception classes, 15-15
- XA ID interface, XA ID interface, 15-13
- XA resource functionality, XA resource functionality, 15-9
- XA resource interface, XA resource interface, 15-8
- DriverManager class, DriverManager class, 3-3
- getConnection method, getConnection method, 17-6
- driverType, driverType, 14-5
- dynamic SQL, dynamic SQL, 1-2
- DYNAMIC_SCHEME (connection cache), DYNAMIC_SCHEME (connection cache), 14-28
E
- EJB, EJB, A-13
- encryption
- code example, code example, 18-14
- overview, overview, 18-11
- setting parameters in Java, setting parameters in Java, 18-14
- support by OCI drivers, support by OCI drivers, 18-12
- support by Thin driver, support by Thin driver, 18-13
- end a distributed transaction branch, end a distributed transaction branch, 15-10
- Enterprise Java Beans (EJB), Enterprise Java Beans (EJB), A-13
- environment variables
- specifying, specifying, 2-6
- errors
- general JDBC message structure, general JDBC message structure, B-2
- general JDBC messages, listed, general JDBC messages, listed, B-3
- processing exceptions, processing exceptions, 3-33
- TTC messages, listed, TTC messages, listed, B-14
- exceptions
- printing stack trace, printing stack trace, 3-34
- retrieving error code, retrieving error code, 3-33
- retrieving message, retrieving message, 3-33
- retrieving SQL state, retrieving SQL state, 3-33
- execute() method, execute() method, A-16
- executeBatch() method, executeBatch() method, 12-13
- executeQuery() method, executeQuery() method, 5-19
- executeUpdate() method, executeUpdate() method, 12-9
- explicit statement caching, explicit statement caching, 13-2, 20-82
- definition of, definition of, 13-4
- null data, null data, 13-11
- extensions to JDBC, Oracle, extensions to JDBC, Oracle, 5-1, 6-1, 8-1, 9-1, 10-1, 12-1
- external changes (result set)
- defined, defined, 11-27
- seeing, seeing, 11-28
- visibility vs. detection, visibility vs. detection, 11-29
- external file
- defined, defined, 3-28
- EXTERNAL NAME clause, EXTERNAL NAME clause, 8-55
F
- fetch direction in result sets, fetch direction in result sets, 11-17
- fetch size, result sets, fetch size, result sets, 11-24
- finalizer methods, finalizer methods, 19-8
- firewalls
- configuring for applets, configuring for applets, 18-22
- connect string, connect string, 18-23
- described, described, 18-21
- required rule list items, required rule list items, 18-22
- using with applets, using with applets, 1-13, 18-21
- first() method (result sets), first() method (result sets), 11-14
- FIXED_RETURN_NULL_SCHEME (connection cache), FIXED_RETURN_NULL_SCHEME (connection cache), 14-28
- FIXED_WAIT_SCHEME (connection cache), FIXED_WAIT_SCHEME (connection cache), 14-28
- floating-point compliance, floating-point compliance, 21-17
- format identifier, transaction ID, format identifier, transaction ID, 15-13
- forward-only result sets, forward-only result sets, 11-3
- freeTemporary() method, freeTemporary() method, 7-18
- function call syntax, SQL92 syntax, function call syntax, SQL92 syntax, 21-14
G
- getActiveSize() method (connection cache), getActiveSize() method (connection cache), 14-28
- getARRAY() method, getARRAY() method, 10-16
- getArray() method, getArray() method, 10-6, 10-10, 10-16
- using type maps, using type maps, 10-18
- getArrayType() method, getArrayType() method, 10-14
- getAsciiOutputStream() method, getAsciiOutputStream() method, 7-15
- for writing CLOB data, for writing CLOB data, 7-7
- getAsciiStream() method, getAsciiStream() method, 7-15
- for reading CLOB data, for reading CLOB data, 7-7
- getAttributes() method, getAttributes() method, 8-3
- used by Structs, used by Structs, 8-15
- getAutoBuffering() method
- of the oracle.sql.ARRAY class, of the oracle.sql.ARRAY class, 10-9
- of the oracle.sql.STRUCT class, of the oracle.sql.STRUCT class, 8-9
- getBaseName() method, getBaseName() method, 10-14
- getBaseType() method, getBaseType() method, 10-6, 10-14, 10-20
- getBaseTypeName() method, getBaseTypeName() method, 9-4, 10-6
- getBinaryOutputStream() method, getBinaryOutputStream() method, 7-14
- for writing BLOB data, for writing BLOB data, 7-7
- getBinaryStream() method, getBinaryStream() method, 3-22, 7-14, 7-26
- for reading BFILE data, for reading BFILE data, 7-22
- for reading BLOB data, for reading BLOB data, 7-6
- getBufferSize() method, getBufferSize() method, 7-14, 7-15
- getBytes() method, getBytes() method, 3-23, 5-10, 7-14, 7-26
- getCacheSize() method (connection cache), getCacheSize() method (connection cache), 14-28
- getCharacterOutputStream() method, getCharacterOutputStream() method, 7-15
- for writing CLOB data, for writing CLOB data, 7-7
- getCharacterStream() method, getCharacterStream() method, 7-15
- for reading CLOB data, for reading CLOB data, 7-7
- getChars() method, getChars() method, 7-15
- getChunkSize() method, getChunkSize() method, 7-14, 7-16
- getColumnCount() method, getColumnCount() method, 6-19
- getColumnName() method, getColumnName() method, 6-19
- getColumns() method, getColumns() method, 12-26
- getColumnType() method, getColumnType() method, 6-19
- getColumnTypeName() method, getColumnTypeName() method, 6-19
- getConcurrency() method (result set), getConcurrency() method (result set), 11-12
- getConnection() method, getConnection() method, 3-4, 10-15, 16-11, 18-27
- getCursor() method, getCursor() method, 5-35, 5-36
- getCursorName() method
- limitations, limitations, 21-16
- getDefaultExecuteBatch() method, getDefaultExecuteBatch() method, 5-18, 12-7
- getDefaultRowPrefetch() method, getDefaultRowPrefetch() method, 5-18, 12-21
- getDescriptor() method, getDescriptor() method, 8-4, 10-6
- getDirAlias() method, getDirAlias() method, 7-25, 7-27
- getErrorCode() method (SQLException), getErrorCode() method (SQLException), 3-33
- getExecuteBatch() method, getExecuteBatch() method, 5-20, 12-6, 12-7
- getFetchSize() method, getFetchSize() method, 11-24
- getJavaSQLConnection() method, getJavaSQLConnection() method, 8-4, 10-6
- getJavaSqlConnection() method, getJavaSqlConnection() method, 5-25
- getLanguage() method, getLanguage() method, 8-62
- getMaxLength() method, getMaxLength() method, 10-14
- getMessage() method (SQLException), getMessage() method (SQLException), 3-33
- getMetaData() method, getMetaData() method, 8-62
- getName() method, getName() method, 7-25, 7-27
- getNumericFunctions() method, getNumericFunctions() method, 21-12
- getObject() method
- casting return values, casting return values, 6-10
- for object references, for object references, 9-6
- for ORAData objects, for ORAData objects, 8-22
- for SQLInput streams, for SQLInput streams, 8-16
- for SQLOutput streams, for SQLOutput streams, 8-17
- for Struct objects, for Struct objects, 8-7
- return types, return types, 6-4, 6-6
- to get BFILE locators, to get BFILE locators, 7-20
- to get Oracle objects, to get Oracle objects, 8-8
- used with ORAData interface, used with ORAData interface, 8-24
- getOracleArray() method, getOracleArray() method, 10-6, 10-16, 10-19
- getOracleAttributes() method, getOracleAttributes() method, 8-4, 8-8
- getOracleObject() method, getOracleObject() method, 5-20, 5-22
- casting return values, casting return values, 6-10
- return types, return types, 6-4, 6-6
- using in callable statement, using in callable statement, 6-5
- using in result set, using in result set, 6-5
- getOraclePlsqlIndexTable() method, getOraclePlsqlIndexTable() method, 16-22, 16-25, 16-26
- argument
- int paramIndex, int paramIndex, 16-26
- code example, code example, 16-27
- getORAData() method, getORAData() method, 8-22, 8-24
- getPassword() method, getPassword() method, 14-5
- getPlsqlIndexTable() method, getPlsqlIndexTable() method, 16-22, 16-25, 16-27
- arguments
- Class primitiveType, Class primitiveType, 16-28
- int paramIndex, int paramIndex, 16-27
- code example, code example, 16-26, 16-28
- getProcedureColumns() method, getProcedureColumns() method, 12-26
- getProcedures() method, getProcedures() method, 12-26
- getREF() method, getREF() method, 9-7
- getRemarksReporting() method, getRemarksReporting() method, 5-19
- getResultSet() method, getResultSet() method, 5-19, 10-6
- getRow() method (result set), getRow() method (result set), 11-15
- getRowPrefetch() method, getRowPrefetch() method, 5-19, 12-21
- getSQLState() method (SQLException), getSQLState() method (SQLException), 3-33
- getSQLTypeName() method, getSQLTypeName() method, 8-3, 10-6, 10-20
- getStatus method, getStatus method, 17-5
- getStmtCacheSize() method
- code example, code example, 13-7
- getString() method, getString() method, 5-32
- to get ROWIDs, to get ROWIDs, 5-33
- getStringFunctions() method, getStringFunctions() method, 21-12
- getStringWithReplacement() method, getStringWithReplacement() method, 5-32
- getSTRUCT() method, getSTRUCT() method, 8-7
- getSubString() method, getSubString() method, 7-16
- for reading CLOB data, for reading CLOB data, 7-7
- getSystemFunctions() method, getSystemFunctions() method, 21-12
- getTimeDateFunctions() method, getTimeDateFunctions() method, 21-12
- getTransactionIsolation() method, getTransactionIsolation() method, 5-18, 19-14
- getType() method (result set), getType() method (result set), 11-12
- getTypeMap() method, getTypeMap() method, 5-18, 8-13
- getUpdateCounts() method (BatchUpdateException), getUpdateCounts() method (BatchUpdateException), 12-17
- getValue() method, getValue() method, 9-5
- for object references, for object references, 9-6
- getXXX() methods
- casting return values, casting return values, 6-10
- for specific datatypes, for specific datatypes, 6-7
- Oracle extended properties, Oracle extended properties, 14-6
- global transaction identifier (distributed transactions), global transaction identifier (distributed transactions), 15-13
- global transactions, global transactions, 15-2
H
- HEIGHT, parameter for APPLET tag, HEIGHT, parameter for APPLET tag, 18-25
- HeteroRM XA, HeteroRM XA, 16-19
- HeuristicMixedException, HeuristicMixedException, 17-4
- HeuristicRollbackException, HeuristicRollbackException, 17-4
- HTML tags, to deploy applets, HTML tags, to deploy applets, 18-25
- HTTP, HTTP, 1-17
- http
- //www.ansi.org/, //www.ansi.org/, 8-53
- HTTP protocol, HTTP protocol, 1-7
- Hypertext Transfer Protocol (HTTP), Hypertext Transfer Protocol (HTTP), 1-17
I
- IDE, IDE, A-4
- IEEE 754 floating-point compliance, IEEE 754 floating-point compliance, 21-17
- IIOP, IIOP, 1-17
- IllegalStateException, IllegalStateException, 17-4
- implicit statement caching, implicit statement caching, 13-2
- code example, code example, 20-79
- concept graphic, concept graphic, 13-3
- definition of, definition of, 13-2
- Least Recently Used (LRU) scheme, Least Recently Used (LRU) scheme, 13-4
- IN OUT parameter mode, IN OUT parameter mode, 16-24
- code example, code example, 20-11
- IN parameter mode, IN parameter mode, 16-22
- code example, code example, 20-11
- includeSynonyms connection property, includeSynonyms connection property, 3-7
- INSERT in a result set, INSERT in a result set, 11-21
- INSERT INTO statement
- for creating BFILE columns, for creating BFILE columns, 7-24
- insertRow() method (result set), insertRow() method (result set), 11-22
- insertsAreDetected() method (database meta data), insertsAreDetected() method (database meta data), 11-29
- installation
- client, client, 1-12
- directories and files, directories and files, 2-5
- verifying on the client, verifying on the client, 2-5
- integrity
- code example, code example, 18-14
- overview, overview, 18-11
- setting parameters in Java, setting parameters in Java, 18-14
- support by OCI drivers, support by OCI drivers, 18-12
- support by Thin driver, support by Thin driver, 18-13
- internal changes (result set)
- defined, defined, 11-27
- seeing, seeing, 11-27
- internal_logon connection property, internal_logon connection property, 3-7
- sysdba, sysdba, 3-7
- sysoper, sysoper, 3-7
- Internet Inter-ORB Protocol (IIOP), Internet Inter-ORB Protocol (IIOP), 1-17
- isAfterLast() method (result set), isAfterLast() method (result set), 11-15
- isBeforeFirst() method (result set), isBeforeFirst() method (result set), 11-15
- isFileOpen() method, isFileOpen() method, 7-27
- isFirst() method (result set), isFirst() method (result set), 11-15
- isLast() method (result set), isLast() method (result set), 11-15
- isSameRM() (distributed transactions), isSameRM() (distributed transactions), 15-13
- isTemporary() method, isTemporary() method, 7-18
J
- Java
- compiling and running, compiling and running, 2-7
- datatypes, datatypes, 3-16
- native datatypes, native datatypes, 3-16
- stored procedures, stored procedures, 3-32
- stream data, stream data, 3-19
- Java Naming and Directory Interface (JNDI), Java Naming and Directory Interface (JNDI), 14-2
- Java Sockets, Java Sockets, 1-7
- Java virtual machine (JVM), Java virtual machine (JVM), 1-10, 18-27
- JavaBeans, JavaBeans, A-2
- java.math, Java math packages, java.math, Java math packages, 3-2
- JavaSoft, JavaSoft, A-2
- java.sql, JDBC packages, java.sql, JDBC packages, 3-2
- java.sql.SQLData, java.sql.SQLData, 8-53
- java.sql.SQLException() method, java.sql.SQLException() method, 3-33
- java.sql.Types class, java.sql.Types class, 12-24
- java.util.Dictionary class
- used by type maps, used by type maps, 8-12
- java.util.Map class, java.util.Map class, 10-19
- java.util.Properties, java.util.Properties, 16-7
- JDBC
- and IDEs, and IDEs, 1-17
- and Oracle Application Server, and Oracle Application Server, 1-17
- basic program, basic program, 3-2
- datatypes, datatypes, 3-16
- defined, defined, 1-2
- guidelines for using, guidelines for using, 1-4
- importing packages, importing packages, 3-2
- limitations of Oracle extensions, limitations of Oracle extensions, 21-16
- sample files, sample files, 2-7
- testing, testing, 2-8
- JDBC 2.0 support
- datatype support, datatype support, 4-3
- extended feature support, extended feature support, 4-5
- introduction, introduction, 4-2
- JDK 1.2.x vs. JDK 1.1.x, JDK 1.2.x vs. JDK 1.1.x, 4-3
- overview of features, overview of features, 4-7
- standard feature support, standard feature support, 4-4
- JDBC drivers
- and NLS, and NLS, 18-3
- applets, applets, 1-12
- applications, applications, 1-12
- choosing a driver for your needs, choosing a driver for your needs, 1-10
- common features, common features, 1-6
- common problems, common problems, 19-8
- compatibilities, compatibilities, 2-2
- determining driver version, determining driver version, 2-8
- introduction, introduction, 1-5
- registering, registering, 3-3
- requirements, requirements, 2-2
- restrictions, restrictions, 19-9
- SQL92 syntax, SQL92 syntax, 21-10
- JDBC mapping (for attributes), JDBC mapping (for attributes), 8-46
- JdbcCheckup program, JdbcCheckup program, 2-8
- JDBCSpy, JDBCSpy, 19-13
- JDBCTest, JDBCTest, 19-13
- JDeveloper, JDeveloper, 1-17
- Jdeveloper, Jdeveloper, A-4
- JDK
- migration from 1.1.x to 1.2.x, migration from 1.1.x to 1.2.x, 4-5
- versions supported, versions supported, 1-16
- JNDI
- looking up data source, looking up data source, 14-11
- overview of Oracle support, overview of Oracle support, 14-2
- registering data source, registering data source, 14-9
- JPublisher, JPublisher, 5-4, 8-25, 8-45
- JPublisher utility, JPublisher utility, 5-4, 8-10
- creating custom collection classes, creating custom collection classes, 10-27
- creating custom Java classes, creating custom Java classes, 8-45
- creating custom reference classes, creating custom reference classes, 9-10
- SQL type categories and mapping options, SQL type categories and mapping options, 8-46
- type mapping modes and settings, type mapping modes and settings, 8-46
- type mappings, type mappings, 8-45
- JTA
- client-side demarcation, client-side demarcation, 17-3, 17-15
- enlisting resources, enlisting resources, 17-5
- limitations, limitations, 17-8
- nested transactions, nested transactions, 17-8
- overview, overview, 17-2
- specification web site, specification web site, 17-1
- two-phase commit, two-phase commit, 17-21
- overview, overview, 17-7
- JVM, JVM, 1-10, 18-27
K
- KPRB driver
- connection string for, connection string for, 18-29
- described, described, 1-10, 18-27
- NLS considerations, NLS considerations, 18-4
- relation to the SQL engine, relation to the SQL engine, 18-27
- session context, session context, 18-31
- testing, testing, 18-31
- transaction context, transaction context, 18-31
L
- last() method (result set), last() method (result set), 11-14
- LD_LIBRARY_PATH variable, specifying, LD_LIBRARY_PATH variable, specifying, 2-7
- Least Recently Used (LRU) scheme, Least Recently Used (LRU) scheme, 13-4, 16-8
- length() method, length() method, 7-14, 7-16, 7-27, 10-6
- libheteroxa9_g.so Solaris shared library, libheteroxa9_g.so Solaris shared library, 16-19
- libheteroxa9.so Solaris shared library, libheteroxa9.so Solaris shared library, 16-19
- LIKE escape characters, SQL92 syntax, LIKE escape characters, SQL92 syntax, 21-13
- limitations on setBytes() and setString(), use of streams to avoid, limitations on setBytes() and setString(), use of streams to avoid, 3-30
- loadjava tool, loadjava tool, 8-55
- LOB
- defined, defined, 3-27
- introduction, introduction, 7-2
- locators, locators, 7-2
- reading data, reading data, 7-6
- LOB locators
- getting from callable statements, getting from callable statements, 7-4
- passing, passing, 7-5
- LOBs
- empty, empty, 7-17
- example program, example program, 20-25
- locators
- getting for BFILEs, getting for BFILEs, 7-20
- getting for BLOBs, getting for BLOBs, 7-3
- getting for CLOBs, getting for CLOBs, 7-3
- LOB, LOB, 7-2
- passing to callable statements, passing to callable statements, 7-5
- passing to prepared statement, passing to prepared statement, 7-5
- logging with a data source, logging with a data source, 14-11
- logical connection instance, logical connection instance, 14-13
- LONG
- data conversions, data conversions, 3-20
- LONG RAW
- data conversions, data conversions, 3-20
- LRU scheme, LRU scheme, 13-4, 16-8
M
- make() method, make() method, 5-31
- memory leaks, memory leaks, 19-8
- migration from JDK 1.1.x to 1.2.x, migration from JDK 1.1.x to 1.2.x, 4-5
- moveToCurrentRow() method (result set), moveToCurrentRow() method (result set), 11-21
- moveToInsertRow() method (result set), moveToInsertRow() method (result set), 11-21
- mutable arrays, mutable arrays, 10-27
N
- named arrays, named arrays, 10-2
- defined, defined, 10-11
- Native Method Interface, Native Method Interface, 1-16
- nativeXA, nativeXA, 14-6, 16-19
- NC, NC, A-13
- Network Computer (NC), Network Computer (NC), A-13
- network events, trapping, network events, trapping, 19-11
- next() method, next() method, A-10
- next() method (result set), next() method (result set), 11-15
- NLS
- and JDBC drivers, and JDBC drivers, 18-3
- conversions, conversions, 18-3
- for JDBC OCI drivers, for JDBC OCI drivers, 18-3
- for JDBC Thin drivers, for JDBC Thin drivers, 18-4
- for KPRB driver, for KPRB driver, 18-4
- Java methods that employ, Java methods that employ, 18-2
- Thin driver CHAR/VARCHAR2 size restrictions, Thin driver CHAR/VARCHAR2 size restrictions, 18-6
- using, using, 18-2
- NLS_LANG environment variable, NLS_LANG environment variable, 18-3
- NMI (Native Method Interface), NMI (Native Method Interface), 1-16
- NotSupportedException, NotSupportedException, 17-4
- NULL data
- converting, converting, 6-2
- null data
- explicit statement caching, explicit statement caching, 13-11
- NUMBER class, NUMBER class, 5-13
O
- OAS, OAS, 1-17
- object references
- accessing object values, accessing object values, 9-7, 9-9
- described, described, 9-2
- passing to prepared statements, passing to prepared statements, 9-8
- retrieving, retrieving, 9-6
- retrieving from callable statement, retrieving from callable statement, 9-7
- updating object values, updating object values, 9-7, 9-9
- object-JDBC mapping (for attributes), object-JDBC mapping (for attributes), 8-46
- OCI driver
- applications, applications, 1-12
- described, described, 1-8
- NLS considerations, NLS considerations, 18-3
- ODBCSpy, ODBCSpy, 19-13
- ODBCTest, ODBCTest, 19-13
- openFile() method, openFile() method, 7-26
- optimization, performance, optimization, performance, 19-6
- Oracle Advanced Security, Oracle Advanced Security, 1-12
- support by JDBC, support by JDBC, 18-9
- support by OCI drivers, support by OCI drivers, 18-9
- support by Thin driver, support by Thin driver, 18-10
- Oracle Application Server, Oracle Application Server, 1-17
- Oracle Application Server (OAS), Oracle Application Server (OAS), 1-17
- Oracle datatypes
- using, using, 6-1
- Oracle extensions
- datatype support, datatype support, 5-3
- limitations, limitations, 21-16
- catalog arguments to DatabaseMetaData calls, catalog arguments to DatabaseMetaData calls, 21-17
- CursorName, CursorName, 21-16
- IEEE 754 floating-point compliance, IEEE 754 floating-point compliance, 21-17
- PL/SQL TABLE, BOOLEAN, RECORD types, PL/SQL TABLE, BOOLEAN, RECORD types, 21-16
- read-only connection, read-only connection, 19-14
- SQL92 outer join escapes, SQL92 outer join escapes, 21-16
- SQLWarning class, SQLWarning class, 21-17
- object support, object support, 5-4
- packages, packages, 5-2
- result sets, result sets, 6-3
- schema naming support, schema naming support, 5-5
- statements, statements, 6-3
- support under 8.0.x/7.3.x drivers, support under 8.0.x/7.3.x drivers, 5-36
- to JDBC, to JDBC, 5-1, 6-1, 8-1, 9-1, 10-1, 12-1
- Oracle mapping (for attributes), Oracle mapping (for attributes), 8-46
- Oracle Net
- name-value pair, name-value pair, 3-4
- protocol, protocol, 1-7
- Oracle objects
- and JDBC, and JDBC, 8-2
- converting with ORAData interface, converting with ORAData interface, 8-21
- converting with SQLData interface, converting with SQLData interface, 8-15
- getting with getObject() method, getting with getObject() method, 8-8
- Java classes which support, Java classes which support, 8-3
- mapping to custom object classes, mapping to custom object classes, 8-10
- reading data by using SQLData interface, reading data by using SQLData interface, 8-17
- working with, working with, 8-2
- writing data by using SQLData interface, writing data by using SQLData interface, 8-20
- Oracle SQL datatypes, Oracle SQL datatypes, 3-16
- Oracle8 Connection Manager, Oracle8 Connection Manager, 18-17
- OracleCallableStatement interface, OracleCallableStatement interface, 5-20
- getOraclePlsqlIndexTable() method, getOraclePlsqlIndexTable() method, 16-22
- getPlsqlIndexTable() method, getPlsqlIndexTable() method, 16-22
- getTIMESTAMP(), getTIMESTAMP(), 5-14
- getTIMESTAMPLTZ(), getTIMESTAMPLTZ(), 5-14
- getTIMESTAMPTZ(), getTIMESTAMPTZ(), 5-14
- getXXX() methods, getXXX() methods, 6-7
- registerIndexTableOutParameter() method, registerIndexTableOutParameter() method, 16-22, 16-24
- registerOutParameter() method, registerOutParameter() method, 6-13
- setPlsqlIndexTable() method, setPlsqlIndexTable() method, 16-22
- OracleCallableStatement object, OracleCallableStatement object, 13-3, 13-4
- OracleConnection class, OracleConnection class, 5-18
- OracleConnection interface, OracleConnection interface, 16-4
- OracleConnection object, OracleConnection object, 13-2
- OracleConnectionCache interface, OracleConnectionCache interface, 14-24
- close() method, close() method, 14-24
- closePooledConnection() method, closePooledConnection() method, 14-24
- reusePooledConnection() method, reusePooledConnection() method, 14-24
- OracleConnectionCacheImpl class, OracleConnectionCacheImpl class, 14-25, 14-27
- getActiveSize() method, getActiveSize() method, 14-28
- getCacheSize() method, getCacheSize() method, 14-28
- instantiating and setting properties, instantiating and setting properties, 14-25
- schemes for new pooled connections, schemes for new pooled connections, 14-27
- setCacheScheme() method, setCacheScheme() method, 14-28
- setConnectionPoolDataSource() method, setConnectionPoolDataSource() method, 14-26
- setMaxLimit() method
- setMaxLimit() method (connection cache), setMaxLimit() method (connection cache), 14-27
- setMinLimit() method
- setMinLimit() method (connection cache), setMinLimit() method (connection cache), 14-27
- setting maximum pooled connections, setting maximum pooled connections, 14-26
- setting minimum pooled connections, setting minimum pooled connections, 14-27
- OracleConnectionCacheImpl interface, OracleConnectionCacheImpl interface, 16-4
- OracleConnectionEventListener
- connectionClosed() method, connectionClosed() method, 14-29
- OracleConnectionEventListener class, OracleConnectionEventListener class, 14-29
- connectionErrorOccurred() method, connectionErrorOccurred() method, 14-29
- instantiating, instantiating, 14-29
- setDataSource() method, setDataSource() method, 14-29
- OracleConnectionPoolDataSouorce class, OracleConnectionPoolDataSouorce class, 14-14
- OracleDatabaseMetaData class, OracleDatabaseMetaData class, 21-12
- and applets, and applets, 18-24
- OracleDataSource class, OracleDataSource class, 14-3, 16-4
- OracleDriver class, OracleDriver class, 5-17
- defaultConnection method, defaultConnection method, 17-6
- oracle.jdbc. package, oracle.jdbc. package, 5-16
- oracle.jdbc., Oracle JDBC extensions, oracle.jdbc., Oracle JDBC extensions, 3-3
- oracle.jdbc2 package, described, oracle.jdbc2 package, described, 5-26
- oracle.jdbc2.Struct class, oracle.jdbc2.Struct class, 5-10
- getAttributes() method, getAttributes() method, 8-3
- getSQLTypeName() method, getSQLTypeName() method, 8-3
- oracle.jdbc.OracleCallableStatement interface, oracle.jdbc.OracleCallableStatement interface, 5-20
- close() method, close() method, 5-21
- getOracleObject() method, getOracleObject() method, 5-20
- getXXX() methods, getXXX() methods, 5-21, 5-22
- registerOutParameter() method, registerOutParameter() method, 5-21
- setNull() method, setNull() method, 5-21
- setOracleObject() methods, setOracleObject() methods, 5-21
- setXXX() methods, setXXX() methods, 5-21
- oracle.jdbc.OracleConnection interface, oracle.jdbc.OracleConnection interface, 5-18
- createStatement() method, createStatement() method, 5-18
- getDefaultExecuteBatch() method, getDefaultExecuteBatch() method, 5-18
- getDefaultRowPrefetch() method, getDefaultRowPrefetch() method, 5-18
- getRemarksReporting() method, getRemarksReporting() method, 5-19
- getTransactionIsolation() method, getTransactionIsolation() method, 5-18, 19-14
- getTypeMap() method, getTypeMap() method, 5-18
- prepareCall() method, prepareCall() method, 5-18
- prepareStatement() method, prepareStatement() method, 5-18
- setDefaultExecuteBatch() method, setDefaultExecuteBatch() method, 5-18
- setDefaultRowPrefetch() method, setDefaultRowPrefetch() method, 5-19
- setRemarksReporting() method, setRemarksReporting() method, 5-19
- setTransactionIsolation() method, setTransactionIsolation() method, 5-18, 19-14
- setTypeMap() method, setTypeMap() method, 5-18
- oracle.jdbc.OracleDriver class, oracle.jdbc.OracleDriver class, 5-17
- oracle.jdbc.OraclePreparedStatement interface, oracle.jdbc.OraclePreparedStatement interface, 5-19
- close() method, close() method, 5-20
- getExecuteBatch() method, getExecuteBatch() method, 5-20
- setExecuteBatch() method, setExecuteBatch() method, 5-20
- setNull() method, setNull() method, 5-20
- setOracleObject() method, setOracleObject() method, 5-20
- setORAData() method, setORAData() method, 5-20
- setXXX() methods, setXXX() methods, 5-20
- oracle.jdbc.OracleResultSet interface, oracle.jdbc.OracleResultSet interface, 5-21
- getOracleObject() method, getOracleObject() method, 5-22
- oracle.jdbc.OracleResultSetMetaData interface, oracle.jdbc.OracleResultSetMetaData interface, 5-22, 6-19
- getColumnCount() method, getColumnCount() method, 6-19
- getColumnName() method, getColumnName() method, 6-19
- getColumnType() method, getColumnType() method, 6-19
- getColumnTypeName() method, getColumnTypeName() method, 6-19
- using, using, 6-19
- oracle.jdbc.OracleSql class, oracle.jdbc.OracleSql class, 21-14
- oracle.jdbc.OracleStatement interface, oracle.jdbc.OracleStatement interface, 5-19
- close() method, close() method, 5-19
- defineColumnType(), defineColumnType(), 5-19
- executeQuery() method, executeQuery() method, 5-19
- getResultSet() method, getResultSet() method, 5-19
- getRowPrefetch() method, getRowPrefetch() method, 5-19
- setRowPrefetch() method, setRowPrefetch() method, 5-19
- oracle.jdbc.OracleTypes class, oracle.jdbc.OracleTypes class, 5-22, 12-24
- oracle.jdbc.pool package, oracle.jdbc.pool package, 14-16, 16-5
- oracle.jdbc.StructMetaData, oracle.jdbc.StructMetaData, 8-62
- oracle.jdbc.StructMetaData interface, oracle.jdbc.StructMetaData interface, 8-61
- oracle.jdbc.xa package and subpackages, oracle.jdbc.xa package and subpackages, 15-5
- OracleJTADataSource class, OracleJTADataSource class, 17-25
- OracleOCIConnection class, OracleOCIConnection class, 16-4
- OracleOCIConnectionPool class, OracleOCIConnectionPool class, 16-2, 16-4
- OracleOCIFailover interface, OracleOCIFailover interface, 16-6
- OraclePooledConnection class, OraclePooledConnection class, 14-15, 14-16, 16-2
- OraclePooledConnection method
- definitions, definitions, 14-16
- OraclePooledConnection object, OraclePooledConnection object, 13-2
- OraclePreparedStatement interface, OraclePreparedStatement interface, 5-19
- getOraclePlsqlIndexTable() method, getOraclePlsqlIndexTable() method, 16-22
- getPlsqlIndexTable() method, getPlsqlIndexTable() method, 16-22
- registerIndexTableOutParameter() method, registerIndexTableOutParameter() method, 16-22
- setPlsqlIndexTable() method, setPlsqlIndexTable() method, 16-22
- setTIMESTAMP(), setTIMESTAMP(), 5-14
- setTIMESTAMPLTZ(), setTIMESTAMPLTZ(), 5-14
- setTIMESTAMPTZ(), setTIMESTAMPTZ(), 5-14
- OraclePreparedStatement object, OraclePreparedStatement object, 13-3, 13-4
- OracleResultSet interface, OracleResultSet interface, 5-21
- getXXX() methods, getXXX() methods, 6-7
- OracleResultSetCache interface, OracleResultSetCache interface, 11-6
- OracleResultSetMetaData interface, OracleResultSetMetaData interface, 5-22
- OracleServerDriver class
- defaultConnection() method, defaultConnection() method, 18-28
- oracle.sql datatype classes, oracle.sql datatype classes, 5-7
- oracle.sql package
- data conversions, data conversions, 6-2
- described, described, 5-7
- oracle.sql.ARRAY class, oracle.sql.ARRAY class, 10-2
- and nested tables, and nested tables, 5-12
- and VARRAYs, and VARRAYs, 5-12
- createDescriptor() method, createDescriptor() method, 10-14
- getArray() method, getArray() method, 10-6
- getArrayType() method, getArrayType() method, 10-14
- getAutoBuffering() method, getAutoBuffering() method, 10-9
- getBaseType() method, getBaseType() method, 10-6
- getBaseTypeName() method, getBaseTypeName() method, 10-6
- getDescriptor() method, getDescriptor() method, 10-6
- getJavaSQLConnection() method, getJavaSQLConnection() method, 10-6, 10-15
- getMaxLength() method, getMaxLength() method, 10-14
- getOracleArray() method, getOracleArray() method, 10-6
- getResultSet() method, getResultSet() method, 10-6
- getSQLTypeName() method, getSQLTypeName() method, 10-6
- length() method, length() method, 10-6
- methods for Java primitive types, methods for Java primitive types, 10-8
- setAutoBuffering() method, setAutoBuffering() method, 10-9
- setAutoIndexing() method, setAutoIndexing() method, 10-10
- oracle.sql.ArrayDescriptor class
- getBaseName() method, getBaseName() method, 10-14
- getBaseType() method, getBaseType() method, 10-14
- oracle.sql.BFILE class, oracle.sql.BFILE class, 5-12
- closeFile() method, closeFile() method, 7-26
- getBinaryStream() method, getBinaryStream() method, 7-26
- getBytes() method, getBytes() method, 7-26
- getDirAlias() method, getDirAlias() method, 7-27
- getName() method, getName() method, 7-27
- isFileOpen() method, isFileOpen() method, 7-27
- length() method, length() method, 7-27
- openFile() method, openFile() method, 7-26
- position() method, position() method, 7-27
- oracle.sql.BLOB class, oracle.sql.BLOB class, 5-12
- getBinaryOutputStream() method, getBinaryOutputStream() method, 7-14
- getBinaryStream() method, getBinaryStream() method, 7-14
- getBufferSize() method, getBufferSize() method, 7-14
- getBytes() method, getBytes() method, 7-14
- getChunkSize() method, getChunkSize() method, 7-14
- length() method, length() method, 7-14
- position() method, position() method, 7-14
- putBytes() method, putBytes() method, 7-14
- oracle.sql.CHAR class, oracle.sql.CHAR class, 18-34
- getString() method, getString() method, 5-32
- getStringWithReplacement() method, getStringWithReplacement() method, 5-32
- toString() method, toString() method, 5-32
- oracle.sql.CharacterSet class, oracle.sql.CharacterSet class, 5-30
- oracle.sql.CLOB class, oracle.sql.CLOB class, 5-12
- getAsciiOutputStream() method, getAsciiOutputStream() method, 7-15
- getAsciiStream() method, getAsciiStream() method, 7-15
- getBufferSize() method, getBufferSize() method, 7-15
- getCharacterOutputStream() method, getCharacterOutputStream() method, 7-15
- getCharacterStream() method, getCharacterStream() method, 7-15
- getChars() method, getChars() method, 7-15
- getChunkSize() method, getChunkSize() method, 7-16
- getSubString() method, getSubString() method, 7-16
- length() method, length() method, 7-16
- position() method, position() method, 7-16
- putChars() method, putChars() method, 7-16
- putString() method, putString() method, 7-16
- supported character sets, supported character sets, 7-13
- oracle.sql.datatypes
- support, support, 5-9
- oracle.sql.DATE class, oracle.sql.DATE class, 5-13
- oracle.sql.Datum array, oracle.sql.Datum array, 16-26
- oracle.sql.Datum class, described, oracle.sql.Datum class, described, 5-7
- oracle.sql.NUMBER class, oracle.sql.NUMBER class, 5-13
- oracle.sql.ORAData, oracle.sql.ORAData, 8-53
- oracle.sql.ORAData interface, oracle.sql.ORAData interface, 8-21
- oracle.sql.ORADataFactory, oracle.sql.ORADataFactory, 8-53
- oracle.sql.ORADataFactory interface, oracle.sql.ORADataFactory interface, 8-21
- OracleSql.parse() method, OracleSql.parse() method, 21-14
- oracle.sql.RAW class, oracle.sql.RAW class, 5-13
- oracle.sql.REF class, oracle.sql.REF class, 5-11, 9-2
- getBaseTypeName() method, getBaseTypeName() method, 9-4
- getValue() method, getValue() method, 9-5
- setValue() method, setValue() method, 9-5
- oracle.sql.ROWID class, oracle.sql.ROWID class, 5-10, 5-15, 5-33
- oracle.sql.STRUCT class, oracle.sql.STRUCT class, 5-10, 8-4
- getAutoBuffering() method, getAutoBuffering() method, 8-9
- getDescriptor() method, getDescriptor() method, 8-4
- getJavaSQLConnection() method, getJavaSQLConnection() method, 8-4
- getOracleAttributes() method, getOracleAttributes() method, 8-4
- setAutoBuffering() method, setAutoBuffering() method, 8-9
- toJDBC() method, toJDBC() method, 8-4
- oracle.sql.StructDescriptor class, oracle.sql.StructDescriptor class, 8-61
- createDescriptor() method, createDescriptor() method, 8-5
- OracleStatement interface, OracleStatement interface, 5-19
- OracleTypes class, OracleTypes class, 5-22
- OracleTypes class for typecodes, OracleTypes class for typecodes, 5-22
- OracleTypes.CURSOR variable, OracleTypes.CURSOR variable, 5-36
- OracleXAConnection class, OracleXAConnection class, 15-7
- OracleXADataSource class, OracleXADataSource class, 15-6
- OracleXAResource class, OracleXAResource class, 15-8, 15-9
- OracleXid class, OracleXid class, 15-13
- ORAData interface, ORAData interface, 5-4
- additional uses, additional uses, 8-26
- advantages, advantages, 8-11
- example program, example program, 20-47
- Oracle object types, Oracle object types, 8-1
- reading data, reading data, 8-23
- writing data, writing data, 8-25
- othersDeletesAreVisible() method (database meta data), othersDeletesAreVisible() method (database meta data), 11-28
- othersInsertsAreVisible() method (database meta data), othersInsertsAreVisible() method (database meta data), 11-28
- othersUpdatesAreVisible() method (database meta data), othersUpdatesAreVisible() method (database meta data), 11-28
- OUT parameter mode, OUT parameter mode, 16-24, 16-25
- code example, code example, 20-11
- outer joins, SQL92 syntax, outer joins, SQL92 syntax, 21-13
- ownDeletesAreVisible() method (database meta deta), ownDeletesAreVisible() method (database meta deta), 11-27
- ownInsertsAreVisible() method (database meta data), ownInsertsAreVisible() method (database meta data), 11-28
- ownUpdatesAreVisible() method (database meta data), ownUpdatesAreVisible() method (database meta data), 11-27
P
- parameter modes
- IN, IN, 16-22
- code example, code example, 20-11
- IN OUT, IN OUT, 16-24
- code example, code example, 20-11
- OUT, OUT, 16-24, 16-25
- code example, code example, 20-11
- password connection property, password connection property, 3-6
- password, specifying, password, specifying, 3-5
- PATH variable, specifying, PATH variable, specifying, 2-7
- PDA, PDA, A-13
- performance enhancements, standard vs. Oracle, performance enhancements, standard vs. Oracle, 4-5
- performance extensions
- defining column types, defining column types, 12-23
- prefetching rows, prefetching rows, 12-20
- TABLE_REMARKS reporting, TABLE_REMARKS reporting, 12-26
- performance optimization, performance optimization, 19-6
- Personal Digital Assistant (PDA), Personal Digital Assistant (PDA), A-13
- PL/SQL
- IN parameter, IN parameter, 8-59
- OUT parameters, OUT parameters, 8-60
- restrictions, restrictions, 19-9
- space padding, space padding, 19-8
- stored procedures, stored procedures, 3-31
- PL/SQL index-by tables
- mapping, mapping, 16-25
- scalar datatypes, scalar datatypes, 16-21
- PL/SQL types
- corresponding JDBC types, corresponding JDBC types, 16-21
- limitations, limitations, 21-16
- PoolConfig() method, PoolConfig() method, 16-7
- pooled connections
- Oracle implementation, Oracle implementation, 14-15
- standard interface, standard interface, 14-15
- populate() method, populate() method, A-10
- position() method, position() method, 7-14, 7-16, 7-27
- positioning in result sets, positioning in result sets, 11-2
- prefetching rows, prefetching rows, 12-20
- suggested default, suggested default, 12-23
- prepare a distributed transaction branch, prepare a distributed transaction branch, 15-11
- prepareCall(), prepareCall(), 13-5
- prepareCall() method, prepareCall() method, 5-18, 13-8, 13-9, 13-10
- prepareCallWithKey(), prepareCallWithKey(), 13-5
- prepareCallWithKey() method, prepareCallWithKey() method, 13-10, 13-11
- prepared statement
- passing BFILE locator, passing BFILE locator, 7-21
- passing LOB locators, passing LOB locators, 7-5
- using setObject() method, using setObject() method, 6-12
- using setOracleObject() method, using setOracleObject() method, 6-12
- PreparedStatement object
- creating, creating, 3-12
- prepareStatement(), prepareStatement(), 13-5
- prepareStatement() method, prepareStatement() method, 5-18, 13-8, 13-9, 13-10
- code example, code example, 13-8
- prepareStatementWithKey(), prepareStatementWithKey(), 13-5
- prepareStatementWithKey() method, prepareStatementWithKey() method, 13-10, 13-11
- previous() method (result set), previous() method (result set), 11-15
- printStackTrace() method (SQLException), printStackTrace() method (SQLException), 3-34
- PrintWriter for a data source, PrintWriter for a data source, 14-11
- put() method
- for Properties object, for Properties object, 3-9
- for type maps, for type maps, 8-13
- putBytes() method, putBytes() method, 7-14
- putChars() method, putChars() method, 7-16
- putString() method, putString() method, 7-16
Q
- query, executing, query, executing, 3-11
R
- RAW class, RAW class, 5-13
- RDBMS, RDBMS, 1-7
- read-only result set concurrency type, read-only result set concurrency type, 11-4
- readSQL() method, readSQL() method, 8-15, 8-16, 8-54, 8-61
- implementing, implementing, 8-16
- REF class, REF class, 5-11
- REF CURSORs, REF CURSORs, 5-35
- example program, example program, 20-38
- materialized as result set objects, materialized as result set objects, 5-35
- refetching rows into a result set, refetching rows into a result set, 11-26, 11-29
- refreshRow() method (result set), refreshRow() method (result set), 11-26
- registerDriver() method, registerDriver() method, 5-17
- registerIndexTableOutParameter() method, registerIndexTableOutParameter() method, 16-22, 16-24
- arguments
- int elemMaxLen, int elemMaxLen, 16-24
- int elemSqlType, int elemSqlType, 16-24
- int maxLen, int maxLen, 16-24
- int paramIndex, int paramIndex, 16-24
- code example, code example, 16-25
- registering Oracle JDBC drivers, class for, registering Oracle JDBC drivers, class for, 5-17
- registerOutParameter() method, registerOutParameter() method, 5-21, 6-13, 8-61
- Relational Database Management System (RDBMS), Relational Database Management System (RDBMS), 1-7
- relative positioning in result sets, relative positioning in result sets, 11-2
- relative() method (result set), relative() method (result set), 11-14
- remarksReporting connection property, remarksReporting connection property, 3-7
- remarksReporting flag, remarksReporting flag, 12-20
- Remote Method Invocation (RMI), Remote Method Invocation (RMI), A-12
- removeConnectionEventListener method (connection cache), removeConnectionEventListener method (connection cache), 14-23
- resource managers, resource managers, 15-3
- result set
- auto-commit mode, auto-commit mode, 19-6
- getting BFILE locators, getting BFILE locators, 7-20
- getting LOB locators, getting LOB locators, 7-4
- metadata, metadata, 5-22
- Oracle extensions, Oracle extensions, 6-3
- using getOracleObject() method, using getOracleObject() method, 6-5
- result set enhancemennts
- positioning result sets, positioning result sets, 11-13
- result set enhancements
- concurrency types, concurrency types, 11-4
- downgrade rules, downgrade rules, 11-11
- fetch size, fetch size, 11-24
- limitations, limitations, 11-10
- Oracle scrollability requirements, Oracle scrollability requirements, 11-5
- Oracle updatability requirements, Oracle updatability requirements, 11-5
- positioning, positioning, 11-2
- processing result sets, processing result sets, 11-16
- refetching rows, refetching rows, 11-26, 11-29
- result set types, result set types, 11-3
- scrollability, scrollability, 11-2
- seeing external changes, seeing external changes, 11-28
- seeing internal changes, seeing internal changes, 11-27
- sensitivity to database changes, sensitivity to database changes, 11-2
- specifying scrollability, updatability, specifying scrollability, updatability, 11-8
- summary of methods, summary of methods, 11-32
- summary of visibility of changes, summary of visibility of changes, 11-30
- updatability, updatability, 11-4
- updating result sets, updating result sets, 11-18
- visibility vs. detection of external changes, visibility vs. detection of external changes, 11-29
- result set fetch size, result set fetch size, 11-24
- result set methods, JDBC 2.0, result set methods, JDBC 2.0, 11-32
- result set object
- closing, closing, 3-12
- result set types for scrollability and sensitivity, result set types for scrollability and sensitivity, 11-3
- result set, processing, result set, processing, 3-11
- ResultSet class, ResultSet class, 3-11
- ResultSet() method, ResultSet() method, 10-10
- ResultSetMetaData class, ResultSetMetaData class, 8-62
- return types
- for getXXX() methods, for getXXX() methods, 6-7
- getObject() method, getObject() method, 6-6
- getOracleObject() method, getOracleObject() method, 6-6
- return values
- casting, casting, 6-10
- reusePooledConnection() method, reusePooledConnection() method, 14-24
- RMI, RMI, A-12
- roll back a distributed transaction branch, roll back a distributed transaction branch, 15-12
- roll back changes to database, roll back changes to database, 3-13
- rollback method, rollback method, 17-3, 17-4, 17-16, 17-19
- RollbackException, RollbackException, 17-4
- row prefetching, row prefetching, 12-20
- and data streams, and data streams, 3-30
- ROWID class, ROWID class, 5-15
- CursorName methods, CursorName methods, 21-16
- defined, defined, 5-33
- ROWID, use for result set updates, ROWID, use for result set updates, 11-5
S
- scalar functions, SQL92 syntax, scalar functions, SQL92 syntax, 21-12
- schema naming conventions, schema naming conventions, 5-5
- scrollability in result sets, scrollability in result sets, 11-2
- scrollable result sets
- creating, creating, 11-8
- fetch direction, fetch direction, 11-17
- implementation of scroll-sensitivity, implementation of scroll-sensitivity, 11-30
- positioning, positioning, 11-13
- processing backward/forward, processing backward/forward, 11-16
- refetching rows, refetching rows, 11-26, 11-29
- scroll-insensitive result sets, scroll-insensitive result sets, 11-3
- scroll-sensitive result sets, scroll-sensitive result sets, 11-3
- seeing external changes, seeing external changes, 11-28
- visibility vs. detection of external changes, visibility vs. detection of external changes, 11-29
- scroll-sensitive result sets
- limitations, limitations, 11-10
- security
- authentication, authentication, 18-10
- encryption, encryption, 18-11
- integrity, integrity, 18-11
- Oracle Advanced Security support, Oracle Advanced Security support, 18-9
- overview, overview, 18-9
- SecurityException, SecurityException, 17-4
- SELECT statement
- to retrieve object references, to retrieve object references, 9-6
- to select LOB locator, to select LOB locator, 7-12
- sendBatch() method, sendBatch() method, 12-7, 12-9
- sensitivity in result sets to database changes, sensitivity in result sets to database changes, 11-2
- serialization
- ArrayDescriptor object, ArrayDescriptor object, 10-15
- definition of, definition of, 8-6, 10-15
- StructDescriptor object, StructDescriptor object, 8-6
- server-side internal driver
- connection to database, connection to database, 18-27
- server-side Thin driver, described, server-side Thin driver, described, 1-9
- sess_sh tool, sess_sh tool, 14-9
- session context, session context, 1-15
- for KPRB driver, for KPRB driver, 18-31
- setAsciiStream() method, setAsciiStream() method, 6-16
- setAutoBuffering() method
- of the oracle.sql.ARRAY class, of the oracle.sql.ARRAY class, 10-9
- of the oracle.sql.STRUCT class, of the oracle.sql.STRUCT class, 8-9
- setAutoCommit() method, setAutoCommit() method, 19-6
- setAutoIndexing() method, setAutoIndexing() method, 10-10
- direction parameter values
- ARRAY.ACCESS_FORWARD, ARRAY.ACCESS_FORWARD, 10-10
- ARRAY.ACCESS_REVERSE, ARRAY.ACCESS_REVERSE, 10-10
- ARRAY.ACCESS_UNKNOWN, ARRAY.ACCESS_UNKNOWN, 10-10
- setBFILE() method, setBFILE() method, 7-21
- setBinaryStream() method, setBinaryStream() method, 6-16
- setBLOB() method, setBLOB() method, 7-5
- setBlob() method, JDK 1.1.x, setBlob() method, JDK 1.1.x, 7-5
- setBlob() method, JDK 1.2.x, setBlob() method, JDK 1.2.x, 7-5
- setBytes() limitations, using streams to avoid, setBytes() limitations, using streams to avoid, 3-30
- setCacheScheme() method (connection cache), setCacheScheme() method (connection cache), 14-28
- setCharacterStream() method, setCharacterStream() method, 6-16
- setCLOB() method, setCLOB() method, 7-5
- setClob() method, 1.1.x, setClob() method, 1.1.x, 7-5
- setClob() method, JDK 1.2.x, setClob() method, JDK 1.2.x, 7-5
- setConnection() method
- ArrayDescriptor object, ArrayDescriptor object, 10-15
- StructDescriptor object, StructDescriptor object, 8-6
- setConnectionPoolDataSource method (connection cache), setConnectionPoolDataSource method (connection cache), 14-26
- setCursorName() method, setCursorName() method, 21-16
- setDataSource() method (connection event listener), setDataSource() method (connection event listener), 14-29
- setDate() method, setDate() method, 6-16
- setDefaultExecuteBatch() method, setDefaultExecuteBatch() method, 5-18, 12-5
- setDefaultRowPrefetch() method, setDefaultRowPrefetch() method, 5-19, 12-21
- setDisableStmtCaching() method, setDisableStmtCaching() method, 13-8
- setEscapeProcessing() method, setEscapeProcessing() method, 21-10
- setExecuteBatch() method, setExecuteBatch() method, 5-20, 12-6
- setFetchSize() method, setFetchSize() method, 11-24
- setFixedCHAR() method, setFixedCHAR() method, 6-17
- setFormOfUse() method, setFormOfUse() method, 5-28
- setMaxFieldSize() method, setMaxFieldSize() method, 12-25, 19-8
- setNull() method, setNull() method, 5-20, 5-21, 6-13
- setObejct() method, setObejct() method, 6-11
- setObject() method
- for BFILES, for BFILES, 7-21
- for BLOBs and CLOBs, for BLOBs and CLOBs, 7-5
- for object references, for object references, 9-8
- for ORAData objects, for ORAData objects, 8-23
- for STRUCT objects, for STRUCT objects, 8-8
- to write object data, to write object data, 8-26
- using in prepared statements, using in prepared statements, 6-12
- setOracleObject() method, setOracleObject() method, 5-20, 5-21, 6-11
- for BFILES, for BFILES, 7-21
- for BLOBs and CLOBs, for BLOBs and CLOBs, 7-5
- using in prepared statements, using in prepared statements, 6-12
- setORAData() method, setORAData() method, 5-20, 8-22, 8-26
- setPlsqlIndexTable() method, setPlsqlIndexTable() method, 16-22
- arguments
- int curLen, int curLen, 16-23
- int elemMaxLen, int elemMaxLen, 16-23
- int elemSqlType, int elemSqlType, 16-23
- int maxLen, int maxLen, 16-22
- int paramIndex, int paramIndex, 16-22, 16-25
- Object arrayData, Object arrayData, 16-22
- code example, code example, 16-23
- setPoolConfig() method, setPoolConfig() method, 16-7
- setREF() method, setREF() method, 9-8
- setRemarksReporting() method, setRemarksReporting() method, 5-19, 12-27
- setResultSetCache() method, setResultSetCache() method, 11-6
- setRollbackOnly method, setRollbackOnly method, 17-5
- setRowPrefetch() method, setRowPrefetch() method, 5-19, 12-21
- setStmtCacheSize() method, setStmtCacheSize() method, 13-6, 16-11
- code example, code example, 13-7
- setString() limitations, using streams to avoid, setString() limitations, using streams to avoid, 3-30
- setString() method
- to bind ROWIDs, to bind ROWIDs, 5-33
- setTime() method, setTime() method, 6-16
- setTimestamp() method, setTimestamp() method, 6-17
- setTransactionIsolation() method, setTransactionIsolation() method, 5-18, 19-14
- setTransactionTimeout method, setTransactionTimeout method, 17-5
- setTypeMap() method, setTypeMap() method, 5-18
- setUnicodeStream() method, setUnicodeStream() method, 6-16
- setValue() method, setValue() method, 9-5
- setXXX() methods
- Oracle extended properties, Oracle extended properties, 14-6
- setXXX() methods, for empty LOBs, setXXX() methods, for empty LOBs, 7-17
- setXXX() methods, for specific datatypes, setXXX() methods, for specific datatypes, 6-12
- signed applets, signed applets, 1-12
- Solaris
- shared libraries
- libheteroxa9_g.so, libheteroxa9_g.so, 16-19
- libheteroxa9.so, libheteroxa9.so, 16-19
- SQL
- data converting to Java datatypes, data converting to Java datatypes, 6-2
- primitive types, primitive types, 5-7
- structured types, structured types, 5-7
- types, constants for, types, constants for, 5-22
- SQL engine
- relation to the KPRB driver, relation to the KPRB driver, 18-27
- SQL syntax (Oracle), SQL syntax (Oracle), 21-10
- SQL*Plus, SQL*Plus, 8-55, 8-56, 8-59
- SQL92 syntax, SQL92 syntax, 21-10
- function call syntax, function call syntax, 21-14
- LIKE escape characters, LIKE escape characters, 21-13
- outer joins, outer joins, 21-13
- scalar functions, scalar functions, 21-12
- time and date literals, time and date literals, 21-10
- translating to SQL example, translating to SQL example, 21-14
- SQLData interface, SQLData interface, 5-4
- advantages, advantages, 8-11
- described, described, 8-15
- example program, example program, 20-43
- Oracle implementation, Oracle implementation, 5-26
- Oracle object types, Oracle object types, 8-1
- reading data from Oracle objects, reading data from Oracle objects, 8-17
- using with type map, using with type map, 8-15
- writing data from Oracle objects, writing data from Oracle objects, 8-20
- SQLInput interface, SQLInput interface, 8-15
- described, described, 8-16
- SQLInput streams, SQLInput streams, 8-16
- SQLJ
- advantages over JDBC, advantages over JDBC, 1-3
- guidelines for using, guidelines for using, 1-4
- SQLJ object type, SQLJ object type, 8-52
- SQLNET.ORA
- parameters for tracing, parameters for tracing, 19-11
- SQLOutput interface, SQLOutput interface, 8-15
- described, described, 8-16
- SQLOutput streams, SQLOutput streams, 8-17
- SQLWarning class, limitations, SQLWarning class, limitations, 21-17
- start a distributed transaction branch, start a distributed transaction branch, 15-10
- statement caching
- explicit, explicit, 13-2
- code example, code example, 20-82
- definition of, definition of, 13-4
- null data, null data, 13-11
- implicit, implicit, 13-2
- code example, code example, 20-79
- concept graphic, concept graphic, 13-3
- definition of, definition of, 13-2
- Least Recently Used (LRU) scheme, Least Recently Used (LRU) scheme, 13-4
- statement methods, JDBC 2.0 result sets, statement methods, JDBC 2.0 result sets, 11-35
- Statement object
- closing, closing, 3-12
- creating, creating, 3-11
- statements
- Oracle extensions, Oracle extensions, 6-3
- static SQL, static SQL, 1-2
- stored procedures
- Java, Java, 3-32
- PL/SQL, PL/SQL, 3-31
- stream data, stream data, 3-19, 7-6
- CHAR columns, CHAR columns, 3-24
- closing, closing, 3-28
- example, example, 3-21
- external files, external files, 3-27
- LOBs, LOBs, 3-27
- LONG columns, LONG columns, 3-19
- LONG RAW columns, LONG RAW columns, 3-19
- multiple columns, multiple columns, 3-25
- precautions, precautions, 3-28
- RAW columns, RAW columns, 3-24
- row prefetching, row prefetching, 3-30
- UPDATE/COMMIT statements, UPDATE/COMMIT statements, 7-8
- use to avoid setBytes() and setString() limitations, use to avoid setBytes() and setString() limitations, 3-30
- VARCHAR columns, VARCHAR columns, 3-24
- stream data column
- bypassing, bypassing, 3-26
- STRUCT class, STRUCT class, 5-10
- STRUCT descriptor, STRUCT descriptor, 8-4, 8-5
- STRUCT object, STRUCT object, 5-10
- attributes, attributes, 5-10
- creating, creating, 8-4, 8-5
- embedded object, embedded object, 8-7
- nested objects, nested objects, 5-11
- retrieving, retrieving, 8-7
- retrieving attributes as oracle.sql types, retrieving attributes as oracle.sql types, 8-8
- StructDescriptor object
- creating, creating, 8-5
- deserialization, deserialization, 8-6
- get methods, get methods, 8-5
- serialization, serialization, 8-6
- setConnection() method, setConnection() method, 8-6
- StructMetaData interface, StructMetaData interface, 8-62
- SystemException, SystemException, 17-4
T
- TABLE_REMARKS columns, TABLE_REMARKS columns, 12-20
- TABLE_REMARKS reporting
- restrictions on, restrictions on, 12-26
- TAF, definition of, TAF, definition of, 16-16
- TCP/IP protocol, TCP/IP protocol, 1-7, 3-10
- Thin driver
- applets, applets, 1-12, 18-16
- applications, applications, 1-12
- CHAR/VARCHAR2 NLS size restrictions, CHAR/VARCHAR2 NLS size restrictions, 18-6
- described, described, 1-7
- NLS considerations, NLS considerations, 18-4
- server-side, described, server-side, described, 1-9
- time and date literals, SQL92 syntax, time and date literals, SQL92 syntax, 21-10
- tnsEntry, tnsEntry, 14-5, 16-19
- TNSNAMES entries, TNSNAMES entries, 3-4
- toDatum() method, toDatum() method, 8-54
- applied to ORAData objects, applied to ORAData objects, 8-11
- applied to ORADate objects, applied to ORADate objects, 8-21
- called by setORAData() method, called by setORAData() method, 8-26
- toJDBC() method, toJDBC() method, 8-4
- toJdbc() method, toJdbc() method, 5-10
- toString() method, toString() method, 5-32
- trace facility, trace facility, 19-11
- trace parameters
- client-side, client-side, 19-11
- server-side, server-side, 19-12
- tracing with a data source, tracing with a data source, 14-11
- transaction
- client-side demarcation, client-side demarcation, 17-3, 17-15
- demarcation, demarcation, 17-3
- enlisting resources, enlisting resources, 17-5
- limitations, limitations, 17-8
- two-phase commit, two-phase commit, 17-7, 17-21
- transaction branch, transaction branch, 15-2
- transaction branch ID component, transaction branch ID component, 15-13
- Transaction class, Transaction class, 17-3
- transaction context, transaction context, 1-15
- for KPRB driver, for KPRB driver, 18-31
- transaction IDs (distributed transactions), transaction IDs (distributed transactions), 15-5
- transaction managers, transaction managers, 15-2
- TransactionManager class, TransactionManager class, 17-3
- transactions
- global, global, 17-3
- overview, overview, 17-2
- Transparent Application Failover (TAF), definition of, Transparent Application Failover (TAF), definition of, 16-16
- TTC error messages, listed, TTC error messages, listed, B-14
- TTC protocol, TTC protocol, 1-7, 1-8
- two-phase commit, two-phase commit, 17-21
- type map, type map, 5-4, 6-4
- adding entries, adding entries, 8-13
- and STRUCTs, and STRUCTs, 8-15
- creating a new map, creating a new map, 8-14
- used with arrays, used with arrays, 10-18
- used with SQLData interface, used with SQLData interface, 8-15
- using with arrays, using with arrays, 10-25
- type map (SQL to Java), type map (SQL to Java), 8-10
- type mapping
- BigDecimal mapping, BigDecimal mapping, 8-47
- JDBC mapping, JDBC mapping, 8-46
- object JDBC mapping, object JDBC mapping, 8-46
- Oracle mapping, Oracle mapping, 8-46
- type mappings
- JPublisher options, JPublisher options, 8-45
- type maps
- relationship to database connection, relationship to database connection, 18-29
- TYPE_FORWARD_ONLY result sets, TYPE_FORWARD_ONLY result sets, 11-8
- TYPE_SCROLL_INSENSITIVE result sets, TYPE_SCROLL_INSENSITIVE result sets, 11-8
- TYPE_SCROLL_SENSITIVE result sets, TYPE_SCROLL_SENSITIVE result sets, 11-8
- typecodes, Oracle extensions, typecodes, Oracle extensions, 5-22
U
- unicode data, unicode data, 5-28
- UNIX, UNIX, 14-9
- updatability in result sets, updatability in result sets, 11-4
- updatable result set concurrency type, updatable result set concurrency type, 11-4
- updatable result sets
- creating, creating, 11-8
- DELETE operations, DELETE operations, 11-18
- INSERT operations, INSERT operations, 11-21
- limitations, limitations, 11-10
- refetching rows, refetching rows, 11-26, 11-29
- seeing internal changes, seeing internal changes, 11-27
- update conflicts, update conflicts, 11-23
- UPDATE operations, UPDATE operations, 11-19
- update batching
- overview, Oracle vs. standard model, overview, Oracle vs. standard model, 12-2
- overview, statements supported, overview, statements supported, 12-3
- update batching (Oracle model)
- batch value, checking, batch value, checking, 12-7
- batch value, overriding, batch value, overriding, 12-7
- committing changes, committing changes, 12-8
- connection batch value, setting, connection batch value, setting, 12-5
- connection vs. statement batch value, connection vs. statement batch value, 12-4
- default batch value, default batch value, 12-5
- disable auto-commit, disable auto-commit, 12-4
- example, example, 12-9
- limitations and characteristics, limitations and characteristics, 12-5
- overview, overview, 12-4
- statement batch value, setting, statement batch value, setting, 12-6
- stream types not allowed, stream types not allowed, 12-5
- update counts, update counts, 12-9
- update batching (standard model)
- adding to batch, adding to batch, 12-11
- clearing the batch, clearing the batch, 12-14
- committing changes, committing changes, 12-14
- error handling, error handling, 12-16
- example, example, 12-15
- executing the batch, executing the batch, 12-13
- intermixing batched and non-batched, intermixing batched and non-batched, 12-17
- overview, overview, 12-10
- sample application, sample application, 20-69
- stream types not allowed, stream types not allowed, 12-11
- update counts, update counts, 12-15
- update counts upon error, update counts upon error, 12-17
- update conflicts in result sets, update conflicts in result sets, 11-23
- update counts
- Oracle update batching, Oracle update batching, 12-9
- standard update batching, standard update batching, 12-15
- upon error (standard batching), upon error (standard batching), 12-17
- UPDATE in a result set, UPDATE in a result set, 11-19
- updateRow() method (result set), updateRow() method (result set), 11-20
- updatesAreDetected() method (database meta data), updatesAreDetected() method (database meta data), 11-29
- updateXXX() methods (result set), updateXXX() methods (result set), 11-19, 11-21
- updateXXX() methods for empty LOBs, updateXXX() methods for empty LOBs, 7-17
- updating result sets, updating result sets, 11-18
- url, url, 14-6
- user connection property, user connection property, 3-6
- userid, specifying, userid, specifying, 3-5
- UserTransaction
- bind in namespace, bind in namespace, 17-12
- UserTransaction interface, UserTransaction interface, 17-3
- begin method, begin method, 17-3
- commit method, commit method, 17-4
- getStatus method, getStatus method, 17-5
- rollback method, rollback method, 17-4
- setRollbackOnly method, setRollbackOnly method, 17-5
- setTransactionTimeout method, setTransactionTimeout method, 17-5
- UserTransaction object
- begin method, begin method, 17-3, 17-16, 17-19
- binding in namespace, binding in namespace, 17-18
- commit method, commit method, 17-3, 17-16, 17-19
- rollback method, rollback method, 17-3, 17-16, 17-19
- using, using, 18-18
V
- VARCHAR2 columns, VARCHAR2 columns, 19-8
- NLS size restrictions, Thin, NLS size restrictions, Thin, 18-6
- varrays
- example program, example program, 20-35
W
- WIDTH, parameter for APPLET tag, WIDTH, parameter for APPLET tag, 18-25
- window, scroll-sensitive result sets, window, scroll-sensitive result sets, 11-30
- writeSQL() method, writeSQL() method, 8-15, 8-17, 8-54, 8-61
- implementing, implementing, 8-16
X
- XA
- connection implementation, connection implementation, 15-7
- connections (definition), connections (definition), 15-4
- data source implementation, data source implementation, 15-6
- data sources (definition), data sources (definition), 15-3
- definition, definition, 15-2
- error handling, error handling, 15-16
- example of implementation, example of implementation, 15-18
- exception classes, exception classes, 15-15
- Oracle optimizations, Oracle optimizations, 15-17
- Oracle transaction ID implementation, Oracle transaction ID implementation, 15-13
- resource implementation, resource implementation, 15-8
- resources (definition), resources (definition), 15-4
- sample application (suspend/resume), sample application (suspend/resume), 20-105
- sample application (two-phase commit), sample application (two-phase commit), 20-1, 20-109
- transaction ID interface, transaction ID interface, 15-13
- XAException, XAException, 15-13
- Xids, Xids, 15-13