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