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

A

absolute positioning in result sets, 17.1.1.1

absolute() method (result set), 17.3.1.1.5

acceptChanges() method, 18.6

accumulateBatchResult connection property, 4.1.2.3

addBatch() method, 22.1.3.2

addRowSetListener() method, 18.4

afterLast() method (result sets), 17.3.1.1.2

ANO (Oracle Advanced Security), 23.1

APPLET HTML tag, 23.2.5.1

applets

connecting to a database, 23.2.1

deploying in an HTML page, 23.2.5

packaging, 23.2.4, 23.2.4

packaging and deploying, 1.3.1.3

signed applets

browser security, 23.2.2.2

object-signing certificate, 23.2.2.2

using signed applets, 23.2.2.2

using with firewalls, 23.2.3

working with, 23.2

ARCHIVE, parameter for APPLET tag, 23.2.5.3

ARRAY

class, 10.3.1.5

descriptors, 10.3.1.5

objects, creating, 10.3.1.5, 16.4.1.1

array descriptor

creating, 16.4.3.1

ArrayDescriptor object, 16.4.1.1, 16.4.3.1

creating, 16.4.1.1

deserialization, 16.4.1.4, 16.4.1.4

get methods, 16.4.1.3

serialization, 16.4.1.4

setConnection() method, 16.4.1.4

arrays

defined, 16.1

getting, 16.4.2.6

named, 16.1

passing to callable statement, 16.4.3.2

retrieving from a result set, 16.4.2.1

retrieving partial arrays, 16.4.2.5

using type maps, 16.5

working with, 16.1

ASO (Oracle Advanced Security), 23.1

authentication (security), 23.1.2

AUTHENTICATION_LEVEL parameter, 23.2.2.1.1

auto-commit mode

disabling, 26.2.1

result set behavior, 26.2.1

B

batch updates--see update batching

batch value

checking value, 22.1.2.4

connection batch value, setting, 22.1.2.2

connection vs. statement value, 22.1.2

default value, 22.1.2.1

overriding value, 22.1.2.5

statement batch value, setting, 22.1.2.3

BatchUpdateException, 22.1.3.7

beforeFirst() method, 18.6

beforeFirst() method (result sets), 17.3.1.1.1

BFILE

accessing data, 14.6.4

class, 10.3.1.6

creating and populating columns, 14.6.3

defined, 4.4.4.2

introduction, 14.1

locators, 14.6.1.1

getting from a result set, 14.6.1.1.1

getting from callable statement, 14.6.1.1.2

passing to callable statements, 14.6.1.2

passing to prepared statements, 14.6.1.2

manipulating data, 14.6.4

reading data, 14.6.2

BFILE locator, selecting, 10.3.1.6

BigDecimal mapping (for attributes), 13.5.2.2

BLOB, 14.2.1.2.1, 14.2.1.2.2

class, 10.3.1.6

creating and populating, 14.2.3

creating columns, 14.2.3.1

getting locators, 14.2.1.1

interface changes, 5.6

introduction, 14.1

locators

getting from result set, 14.2.1.1.1

selecting, 10.3.1.6

manipulating data, 14.2.4

populating columns, 14.2.3.2

reading data, 14.2.2, 14.2.2.1

writing data, 14.2.2.3

BLOBs

size limit with PL/SQL prodcedures, 14.2.1.2

Boolean parameters, restrictions, 26.3.3

branch qualifier (distributed transactions), 9.2.5

C

CachedRowSet, 18.6

caching, client-side

custom use for scrollable result sets, 17.1.2.3

Oracle use for scrollable result sets, 17.1.2.1

callable statement

getting a BFILE locator, 14.6.1.1.2

getting LOB locators, 14.2.1.1.2

passing BFILE locator, 14.6.1.2

passing LOB locators, 14.2.1.2.2

using getOracleObject() method, 11.3.2.2

cancelRowUpdates() method (result set), 17.4.2

casting return values, 11.3.5

catalog arguments (DatabaseMetaData), 24.4.5

CHAR class

conversions with KPRB driver, 23.3.6

CHAR columns

space padding, 26.3.1

using setFixedCHAR() to match in WHERE, 11.3.7.4

character sets, 10.4.3.3

conversions with KPRB driver, 23.3.6

checksums

code example, 23.1.3.3.1

setting parameters in Java, 23.1.3.3

support by OCI drivers, 23.1.3.1

support by Thin driver, 23.1.3.2

CLASSPATH, specifying, 2.2.2

clearBatch() method, 22.1.3.5

clearClientIdentifier() method, 10.3.2.1.1

clearDefines() method, 22.2.2

CLOB

class, 10.3.1.6

creating and populating, 14.2.3

creating columns, 14.2.3.1

interface changes, 5.6

introduction, 14.1

locators, 14.2.1.1

getting from result set, 14.2.1.1.1

passing to callable statements, 14.2.1.2.2

passing to prepared statement, 14.2.1.2.1

locators, selecting, 10.3.1.6

manipulating data, 14.2.4

populating columns, 14.2.3.2

reading data, 14.2.2, 14.2.2.2

writing data, 14.2.2.4

close(), 6.1.3

close() method, 10.3.2.2, 10.3.2.3, 10.3.2.4, 26.3.2

for caching statements, 6.2.3, 6.2.4.3

closeFile() method, 14.6.5

closeWithKey(), 6.1.3

closeWithKey() method, 6.2.5, 6.2.5.2

CMAN.ORA file, creating, 23.2.2.1.1

CODE, parameter for APPLET tag, 23.2.5.1

CODEBASE, parameter for APPLET tag, 23.2.5.2

collections

defined, 16.1

collections (nested tables and arrays), 16.4.1.1

column types

defining, 22.2.2

redefining, 22.2

commit a distributed transaction branch, 9.2.4.4

commit changes to database, 4.1.8

compatibility

forward and backward, 1.5.1.1

CONCUR_READ_ONLY result sets, 17.2.1

CONCUR_UPDATABLE result sets, 17.2.1

concurrency types in result sets, 17.1.1.4

connect string

Connection Manager, 23.2.2.1.2

connection

closing, 4.1.9

from KPRB driver, 1.4.2

opening, 4.1.2

opening for JDBC Thin driver, 3.2.1.2

Connection Manager, 23.2.1

installing, 23.2.2.1.1

starting, 23.2.2.1.1

using, 23.2.2.1

using multiple managers, 23.2.2.1.3

writing the connect string, 23.2.2.1.2

connection methods, JDBC 2.0 result sets, 17.8.1

connection properties

database, 4.1.2.3

defaultBatchValue, 4.1.2.3

defaultRowPrefetch, 4.1.2.3

includeSynonyms, 4.1.2.3

internal_logon, 4.1.2.3

sysdba, 4.1.2.4

sysoper, 4.1.2.4

password, 4.1.2.3

put() method, 4.1.2.7.1

remarksReporting, 4.1.2.3

user, 4.1.2.3

connections

read-only, 26.5

constants for SQL types, 10.3.2.7

CREATE DIRECTORY statement

for BFILEs, 14.6.3.1

CREATE TABLE statement

to create BFILE columns, 14.6.3.1

to create BLOB, CLOB columns, 14.2.3

CREATE TYPE statement, 13.4.1

create() method

for ORADataFactory interface, 13.3.6.1

createDescriptor() method, 13.2.2.1, 16.4.1.3

createStatement(), 6.1.3

createStatement() method, 6.2.5.1, 10.3.2.1.1

createTemporary() method, 14.4

creationState() method, 6.2.2

code example, 6.2.2

CursorName

limitations, 24.4.1

cursors, 26.3.2

custom collection classes

and JPublisher, 16.6

defined, 16.1.1, 16.6

custom Java classes, 10.2.2

defined, 13.1

custom object classes

creating, 13.3

defined, 13.1

custom reference classes

and JPublisher, 15.5

defined, 15.1, 15.5

D

data conversions, 11.1

LONG, 4.4.1.2

LONG RAW, 4.4.1.1

data sources

creating and connecting (with JNDI), 3.1.4

creating and connecting (without JNDI), 3.1.3

logging and tracing, 3.1.5

Oracle implementation, 3.1.2.1

PrintWriter, 3.1.5

properties, 3.1.2.2

standard interface, 3.1.2.1

data streaming

avoiding, 4.4.1.4

database

connecting

from an applet, 23.2.1

via multiple Connection Managers, 23.2.2.1.3

with server-side internal driver, 23.3.1

connection testing, 2.2.5

database connection

connection property, 4.1.2.3

database meta data methods, JDBC 2.0 result sets, 17.8.4

database specifiers, 3.2

database URL

including userid and password, 4.1.2.2

database URL, specifying, 4.1.2.1

database URLs

and database specifiers, 3.2

DatabaseMetaData calls, 24.4.5

DatabaseMetaData class, 24.3.3

entry points for applets, 23.2.4

datasources, 3.1

and JNDI, 3.1.4

datatype classes, 10.3.1.1

datatype mappings, 4.3

datatypes

Java, 4.3

Java native, 4.3

JDBC, 4.3

Oracle SQL, 4.3

DATE class, 10.3.1.7

debugging JDBC programs, 26.4

DEFAULT_CHARSET character set value, 10.4.3.2

defaultBatchValue connection property, 4.1.2.3

defaultConnection() method, 23.3.1

defaultExecuteBatch connection property, 4.1.2.3

defaultNchar connection property, 4.1.2.3

defaultRowPrefetch connection property, 4.1.2.3

defineColumnType() method, 4.4.1.4, 10.3.2.2, 22.2.2

DELETE in a result set, 17.4.1

deleteRow() method (result set), 17.4.1

deletesAreDetected() method (database meta data), 17.7.3

deserialization

ArrayDescriptor object, 16.4.1.4

creating a StructDescriptor object, 13.2.2.3

creating an ArrayDescriptor object, 16.4.1.4

definition of, 13.2.2.3, 16.4.1.4

StructDescriptor object, 13.2.2.3

disableDefineColumnType connection property, 4.1.2.3

disabling

escape processing, 4.1.2.3

distributed transaction ID component, 9.2.5

distributed transactions

branch qualifier, 9.2.5

check for same resource manager, 9.2.4.8

commit a transaction branch, 9.2.4.4

components and scenarios, 9.1.1

concepts, 9.1.2

distributed transaction ID component, 9.2.5

end a transaction branch, 9.2.4.2

example of implementation, 9.4

global transaction identifier, 9.2.5

ID format identifier, 9.2.5

introduction, 9.1

Oracle XA connection implementation, 9.2.2

Oracle XA data source implementation, 9.2.1

Oracle XA ID implementation, 9.2.5

Oracle XA optimizations, 9.3.4

Oracle XA resource implementation, 9.2.3

prepare a transaction branch, 9.2.4.3

roll back a transaction branch, 9.2.4.5

start a transaction branch, 9.2.4.1

transaction branch ID component, 9.2.5

XA connection interface, 9.2.2

XA data source interface, 9.2.1

XA error handling, 9.3.3

XA exception classes, 9.3.1

XA ID interface, 9.2.5

XA resource functionality, 9.2.4

XA resource interface, 9.2.3

DMS

and end-to-end matrics, 21.1

DMSName connection property, 4.1.2.3

DMSType connection property, 4.1.2.3

Double.NaN

restrictions on use, 10.3.1.7

driverType, 3.1.2.2

E

encryption

code example, 23.1.3.3.1

overview, 23.1.3

setting parameters in Java, 23.1.3.3

support by OCI drivers, 23.1.3.1

support by Thin driver, 23.1.3.2

end a distributed transaction branch, 9.2.4.2

end-to-end matrics

and DMS, 21.1

end-to-end metrics, 21

Enterprise Java Beans (EJB), 18.6

environment variables

specifying, 2.2.2

errors

general JDBC message structure, A.1

general JDBC messages, listed, A.2

processing exceptions, 4.6

TTC messages, listed, A.4

escape processing

disabling, 4.1.2.3

exceptions

printing stack trace, 4.6.2

retrieving error code, 4.6.1

retrieving message, 4.6.1

retrieving SQL state, 4.6.1

execute() method, 18.7

executeBatch() method, 22.1.3.3

executeQuery() method, 10.3.2.2

executeUpdate() method, 22.1.2.7

explicit statement caching

definition of, 6.1.3

null data, 6.2.5.3

extensions to JDBC, Oracle, 10, 11, 13, 15, 16, 22

external changes (result set)

defined, 17.7

seeing, 17.7.2

visibility vs. detection, 17.7.3

external file

defined, 4.4.4.2

F

failover

fast connection, 8

fast connection failover, 8

prerequisites, 8.2.1

fetch direction in result sets, 17.3.2.2

fetch size, result sets, 17.5

finalizer methods, 26.3.2

firewalls

configuring for applets, 23.2.3.1

connect string, 23.2.3.2

described, 23.2.3

required rule list items, 23.2.3.1

using with applets, 1.3.1.2, 23.2.3

first() method (result sets), 17.3.1.1.3

fixedString connection property, 4.1.2.3

floating-point compliance, 24.4.4

Float.NaN

restrictions on use, 10.3.1.7

format identifier, transaction ID, 9.2.5

forward-only result sets, 17.1.1.2

freeTemporary() method, 14.4, 14.4

function call syntax, SQL92 syntax, 24.3.6

G

getARRAY() method, 16.4.2.1

getArray() method, 16.2.2.2, 16.3.3, 16.4.2.2

using type maps, 16.4.2.4

getArrayType() method, 16.4.1.3

getAsciiStream() method, 14.2.5.2, 14.2.5.2

for reading CLOB data, 14.2.2

getAttributes() method

used by Structs, 13.3.3.3

getAutoBuffering() method

of the oracle.sql.ARRAY class, 16.3.2

of the oracle.sql.STRUCT class, 13.2.5

getBaseName() method, 16.4.1.3

getBaseType() method, 16.2.2.2, 16.4.1.3, 16.4.2.6

getBaseTypeName() method, 15.2.2, 16.2.2.2

getBinaryStream() method, 4.4.1.3.1, 14.6.5

for reading BFILE data, 14.6.2

for reading BLOB data, 14.2.2

getBufferSize() method, 14.2.5.1, 14.2.5.2

getBytes() method, 4.4.1.3.2, 10.3.1.2, 14.2.5.1, 14.6.5

getCallWithKey(), 6.1.3

getCallWithKey() method, 6.2.5.3, 6.2.5.3

getCharacterStream() method, 14.2.5.2, 14.2.5.2

for reading CLOB data, 14.2.2

getChars() method, 14.2.5.2

getChunkSize() method, 14.2.5.1, 14.2.5.2

getColumnCount() method, 11.4

getColumnName() method, 11.4

getColumns() method, 22.2.3

getColumnType() method, 11.4

getColumnTypeName() method, 11.4

getConcurrency() method (result set), 17.2.2.3

getConnection() method, 16.4.1.3, 19.1.5, 23.3.1

getCursor() method, 10.5.2, 10.5.2.1

getCursorName() method

limitations, 24.4.1

getDefaultExecuteBatch() method, 10.3.2.1.1, 22.1.2.4

getDefaultRowPrefetch() method, 10.3.2.1.1, 22.2.1.1

getDescriptor() method, 13.2.1.2, 16.2.2.2

getDirAlias() method, 14.6.4, 14.6.5

getErrorCode() method (SQLException), 4.6.1

getExecuteBatch() method, 10.3.2.3, 22.1.2.3, 22.1.2.4

getFetchSize() method, 17.5.1

getJavaSQLConnection() method, 13.2.1.2, 16.2.2.2

getJavaSqlConnection() method, 10.3.2.8

getMaxLength() method, 16.4.1.3

getMessage() method (SQLException), 4.6.1

getName() method, 14.6.4, 14.6.5

getNumericFunctions() method, 24.3.3

getObject() method

casting return values, 11.3.5

for object references, 15.3.1

for ORAData objects, 13.3.6.2

for SQLInput streams, 13.3.4.2

for SQLOutput streams, 13.3.4.2

for Struct objects, 13.2.3.1

return types, 11.3.1, 11.3.3

to get BFILE locators, 14.6.1.1

to get Oracle objects, 13.2.3.2

used with ORAData interface, 13.3.7.1

getOracleArray() method, 16.2.2.2, 16.4.2.2, 16.4.2.6

getOracleAttributes() method, 13.2.1.2, 13.2.3.3

getOracleObject() method, 10.3.2.4, 10.3.2.5

casting return values, 11.3.5

return types, 11.3.2, 11.3.3

using in callable statement, 11.3.2.2

using in result set, 11.3.2.1

getOraclePlsqlIndexTable() method, 19.4.1, 19.4.3.2, 19.4.3.2.2

argument

int paramIndex, 19.4.3.2.2

code example, 19.4.3.2.2

getORAData() method, 13.3.6.2, 13.3.7.1

getPassword() method, 3.1.2.2

getPlsqlIndexTable() method, 19.4.1, 19.4.3.2, 19.4.3.2, 19.4.3.2.1, 19.4.3.2.3

arguments

Class primitiveType, 19.4.3.2.3

int paramIndex, 19.4.3.2.3

code example, 19.4.3.2.1, 19.4.3.2.3

getProcedureColumns() method, 22.2.3

getProcedures() method, 22.2.3

getREF() method, 15.3.1

getResultSet() method, 10.3.2.2, 16.2.2.2

getRow() method (result set), 17.3.1.2

getRowPrefetch() method, 10.3.2.2, 22.2.1.1

getSQLState() method (SQLException), 4.6.1

getSQLTypeName() method, 13.2.1.1, 16.2.2.2, 16.4.2.6

getStatementCacheSize() method

code example, 6.2.1.2

getStatementWithKey(), 6.1.3

getStatementWithKey() method, 6.2.5.3, 6.2.5.3

getString() method, 10.4.3.3

to get ROWIDs, 10.5.1

getStringFunctions() method, 24.3.3

getStringWithReplacement() method, 10.4.3.3

getSTRUCT() method, 13.2.3.1

getSubString() method, 14.2.5.2

for reading CLOB data, 14.2.2

getSystemFunctions() method, 24.3.3

getTimeDateFunctions() method, 24.3.3

getTransactionIsolation() method, 10.3.2.1.1, 26.5

getType() method (result set), 17.2.2.3

getTypeMap() method, 10.3.2.1.1, 13.3.3.1

getUpdateCounts() method (BatchUpdateException), 22.1.3.7

getValue() method, 15.2.2

for object references, 15.3.1

getXXX() methods

casting return values, 11.3.5

for specific datatypes, 11.3.4

Oracle extended properties, 3.1.2.2

global transaction identifier (distributed transactions), 9.2.5

global transactions, 9.1

globalization, 12

Java methods that employ, 12.3

using, 12

H

HEIGHT, parameter for APPLET tag, 23.2.5.1

HTML tags, to deploy applets, 23.2.5

HTTP protocol, 1.2.2

I

IEEE 754 floating-point compliance, 24.4.4

implicit statement caching

definition of, 6.1.2

Least Recently Used (LRU) scheme, 6.1.2

IN OUT parameter mode, 19.4.3

IN parameter mode, 19.4.2

includeSynonyms connection property, 4.1.2.3

INSERT in a result set, 17.4.3

INSERT INTO statement

for creating BFILE columns, 14.6.3.2

insertRow() method (result set), 17.4.3

insertsAreDetected() method (database meta data), 17.7.3

installation

directories and files, 2.2.1

verifying on the client, 2.2

Instant Client feature, 20.1

integrity

code example, 23.1.3.3.1

overview, 23.1.3

setting parameters in Java, 23.1.3.3

support by OCI drivers, 23.1.3.1

support by Thin driver, 23.1.3.2

internal changes (result set)

defined, 17.7

seeing, 17.7.1

internal_logon connection property, 4.1.2.3

sysdba, 4.1.2.4

sysoper, 4.1.2.4

isAfterLast() method (result set), 17.3.1.2

isBeforeFirst() method (result set), 17.3.1.2

isFileOpen() method, 14.6.5

isFirst() method (result set), 17.3.1.2

isLast() method (result set), 17.3.1.2

isSameRM() (distributed transactions), 9.2.4.8

isTemporary() method, 14.4, 14.4

J

Java

compiling and running, 2.2.3

datatypes, 4.3

native datatypes, 4.3

stored procedures, 4.5.2

stream data, 4.4

Java Naming and Directory Interface (JNDI), 3.1.1

Java Sockets, 1.2.2

Java virtual machine (JVM), 1.2.5, 23.3

JavaBeans, 18.1

java.math, Java math packages, 4.1.1

JavaSoft, 18.1

java.sql, JDBC packages, 4.1.1

java.sql.SQLException() method, 4.6

java.sql.Struct class

getSQLTypeName() method, 13.2.1.1

java.sql.Types class, 22.2.2

java.util.Map class, 16.4.2.5

java.util.Properties, 19.1.3.3

JDBC

and IDEs, 1.5.3

basic program, 4.1

datatypes, 4.3

defined, 1.1

importing packages, 4.1.1

limitations of Oracle extensions, 24.4

sample files, 2.2.3

testing, 2.2.5

version compatibility, 1.5.1.1

version support, 5

JDBC 2.0 support

datatype support, 5.2.1

extended feature support, 5.2.3

introduction, 5.1

JDK 1.2.x vs. JDK 1.1.x, 5.2, 5.3

overview of features, 5.4

standard feature support, 5.2.2

JDBC drivers

applets, 1.3.1.1

choosing a driver for your needs, 1.2.6

common features, 1.2.1

common problems, 26.3

determining driver version, 2.2.4

introduction, 1.2

restrictions, 26.3.3

SQL92 syntax, 24.3

JDBC mapping (for attributes), 13.5.2.2

JdbcCheckup program, 2.2.5

JDBCSpy, 26.4.2

JDBCTest, 26.4.2

JDeveloper, 1.5.3

Jdeveloper, 18.2

JDK

migration from 1.1.x to 1.2.x, 5.2.5

versions supported, 1.5.1

JNDI

and datasources, 3.1.4

looking up data source, 3.1.4.3

overview of Oracle support, 3.1.1

registering data source, 3.1.4.2

JPublisher, 13.3.7.2, 13.5.1

JPublisher utility, 13.3

creating custom collection classes, 16.6

creating custom Java classes, 13.5

creating custom reference classes, 15.5

SQL type categories and mapping options, 13.5.2.1

type mapping modes and settings, 13.5.2.2

type mappings, 13.5.2

JVM, 1.2.5, 23.3

K

KPRB driver

described, 1.2.5

relation to the SQL engine, 23.3

session context, 23.3.3

testing, 23.3.4

transaction context, 23.3.3

URL for, 23.3.1.2

L

last() method (result set), 17.3.1.1.4

LD_LIBRARY_PATH variable, specifying, 2.2.2.1

LDAP

and SSL, 3.2.1

Least Recently Used (LRU) scheme, 6.1.2, 19.1.3.4

length() method, 14.2.5.1, 14.2.5.2, 14.6.5, 16.2.2.2

libheteroxa10.so Solaris shared library, 19.3.1

libheteroxa9_g.so Solaris shared library, 19.3.1

libheteroxa9.so Solaris shared library, 19.3.1

LIKE escape characters, SQL92 syntax, 24.3.4

limitations on setBytes() and setString(), use of streams to avoid, 4.4.6.2

LOB

defined, 4.4.4

introduction, 14.1

locators, 14.1

reading data, 14.2.2

LOB locators

getting from callable statements, 14.2.1.1.2

passing, 14.2.1.2

LOBs

empty, 14.2.5.3

new interface methods, 5.6

locators

getting for BFILEs, 14.6.1.1

getting for BLOBs, 14.2.1.1

getting for CLOBs, 14.2.1.1

LOB, 14.1

passing to callable statements, 14.2.1.2.2

passing to prepared statement, 14.2.1.2.1

logging with a data source, 3.1.5

LONG

data conversions, 4.4.1.2

LONG RAW

data conversions, 4.4.1.1

LRU scheme, 6.1.2, 19.1.3.4

M

make() method, 10.4.3.2

memory leaks, 26.3.2

metrics

end-to-end, 21

migration from JDK 1.1.x to 1.2.x, 5.2.5

moveToCurrentRow() method (result set), 17.4.3

moveToInsertRow() method (result set), 17.4.3

mutable arrays, 16.6

N

named arrays, 16.1

defined, 16.4.1.1

nativeXA, 3.1.2.2, 19.3

NC, 18.6

Network Computer (NC), 18.6

network events, trapping, 26.4.1

next() method, 18.6

next() method (result set), 17.3.2

NLS. See globalization

NLS_LANG variable

desupported, 12

NULL

testing for, 11.1.3

NULL data

converting, 11.1.2

null data

explicit statement caching, 6.2.5.3

NullPointerException

thrown when converting Double.NaN and Float.NaN, 10.3.1.7

NUMBER class, 10.3.1.7

O

object references

accessing object values, 15.3.1, 15.4, 15.4

described, 15.1

passing to prepared statements, 15.3.3

retrieving, 15.3.1

retrieving from callable statement, 15.3.2

updating object values, 15.3.1, 15.4, 15.4

object-JDBC mapping (for attributes), 13.5.2.2

OCI driver

described, 1.2.3

ODBCSpy, 26.4.2

ODBCTest, 26.4.2

ONS

configuring, 8.2.2

ons.config file, 8.2.2.1, 8.2.2.1, 8.2.2.3

openFile() method, 14.6.5

optimization, performance, 26.2

Oracle Advanced Security

support by JDBC, 23.1.1

support by OCI drivers, 23.1.1.1

support by Thin driver, 23.1.1.2

Oracle Connection Manager, 1.3.1.1, 23.2.1

Oracle datatypes

using, 11

Oracle extensions

datatype support, 10.2.1

limitations, 24.4

catalog arguments to DatabaseMetaData calls, 24.4.5

CursorName, 24.4.1

IEEE 754 floating-point compliance, 24.4.4

PL/SQL TABLE, BOOLEAN, RECORD types, 24.4.3

read-only connection, 26.5

SQL92 outer join escapes, 24.4.2

SQLWarning class, 24.4.6

object support, 10.2.2

packages, 10.1

result sets, 11.2

schema naming support, 10.2.3

statements, 11.2

to JDBC, 10, 11, 13, 15, 16, 22

Oracle JPublisher, 10.2.2

generated classes, 13.4.2.3

Oracle mapping (for attributes), 13.5.2.2

Oracle Net

protocol, 1.2.2

Oracle Notification Service. See ONS

Oracle objects

and JDBC, 13.1

converting with ORAData interface, 13.3.6

converting with SQLData interface, 13.3.4

getting with getObject() method, 13.2.3.2

Java classes which support, 13.2

mapping to custom object classes, 13.3

reading data by using SQLData interface, 13.3.5.1

working with, 13.1

writing data by using SQLData interface, 13.3.5.4

Oracle SQL datatypes, 4.3

OracleCallableStatement interface, 10.3.2.4

getOraclePlsqlIndexTable() method, 19.4.1

getPlsqlIndexTable() method, 19.4.1

getTIMESTAMP(), 10.3.1.8, 10.3.1.8

getTIMESTAMPLTZ(), 10.3.1.8

getTIMESTAMPTZ(), 10.3.1.8

getXXX() methods, 11.3.4

registerIndexTableOutParameter() method, 19.4.1, 19.4.3.1

registerOutParameter() method, 11.3.7

setPlsqlIndexTable() method, 19.4.1, 19.4.2

OracleCallableStatement object, 6.1.2, 6.1.2

OracleConnection class, 10.3.2.1

OracleConnection interface, 19.1.3

OracleConnection object, 6.1.1

OracleDatabaseMetaData class, 24.3.3

and applets, 23.2.4

OracleDataSource class, 3.1.2.1, 19.1.3, 19.1.3

oracle.jdbc. package, 10.3.2

oracle.jdbc., Oracle JDBC extensions, 4.1.1

oracle.jdbc.J2EE13Compliant connection property, 4.1.2.3

oracle.jdbc.ocinativelibrary connection property, 4.1.2.3

oracle.jdbc.OracleCallableStatement interface, 10.3.2.4

close() method, 10.3.2.4

getOracleObject() method, 10.3.2.4

getXXX() methods, 10.3.2.4, 10.3.2.5

registerOutParameter() method, 10.3.2.4

setNull() method, 10.3.2.4

setOracleObject() methods, 10.3.2.4

setXXX() methods, 10.3.2.4

oracle.jdbc.OracleConnection interface, 10.3.2.1

clearClientIdentifier() method, 10.3.2.1.1

createStatement() method, 10.3.2.1.1

getDefaultExecuteBatch() method, 10.3.2.1.1

getDefaultRowPrefetch() method, 10.3.2.1.1

getTransactionIsolation() method, 10.3.2.1.1, 26.5

getTypeMap() method, 10.3.2.1.1

prepareCall() method, 10.3.2.1.1

prepareStatement() method, 10.3.2.1.1

setClientIdentifier() method, 10.3.2.1.1

setDefaultExecuteBatch() method, 10.3.2.1.1

setDefaultRowPrefetch() method, 10.3.2.1.1

setTransactionIsolation() method, 10.3.2.1.1, 26.5

setTypeMap() method, 10.3.2.1.1

oracle.jdbc.OraclePreparedStatement interface, 10.3.2.3

close() method, 10.3.2.3

getExecuteBatch() method, 10.3.2.3

setExecuteBatch() method, 10.3.2.3

setNull() method, 10.3.2.3

setOracleObject() method, 10.3.2.3

setORAData() method, 10.3.2.3

setXXX() methods, 10.3.2.3

oracle.jdbc.OracleResultSet, 11.2

oracle.jdbc.OracleResultSet interface, 10.3.2.5

getOracleObject() method, 10.3.2.5

oracle.jdbc.OracleResultSetMetaData interface, 10.3.2.6, 11.4

getColumnCount() method, 11.4

getColumnName() method, 11.4

getColumnType() method, 11.4

getColumnTypeName() method, 11.4

using, 11.4

oracle.jdbc.OracleSql class, 24.3.7

oracle.jdbc.OracleStatement interface, 10.3.2.2

close() method, 10.3.2.2

defineColumnType(), 10.3.2.2

executeQuery() method, 10.3.2.2

getResultSet() method, 10.3.2.2

getRowPrefetch() method, 10.3.2.2

setRowPrefetch() method, 10.3.2.2

oracle.jdbc.OracleTypes class, 10.3.2.7, 22.2.2

oracle.jdbc.pool package, 19.1.3.1

oracle.jdbc.TcpNoDelay connection property, 4.1.2.3

oracle.jdbc.xa package and subpackages, 9.1.4

OracleOCIConnection class, 19.1.3

OracleOCIConnectionPool class, 19.1, 19.1.3

OraclePooledConnection object, 6.1.1

OraclePreparedStatement interface, 10.3.2.3

getOraclePlsqlIndexTable() method, 19.4.1

getPlsqlIndexTable() method, 19.4.1

registerIndexTableOutParameter() method, 19.4.1

setPlsqlIndexTable() method, 19.4.1, 19.4.2

setTIMESTAMP(), 10.3.1.8

setTIMESTAMPLTZ(), 10.3.1.8

setTIMESTAMPTZ(), 10.3.1.8

OraclePreparedStatement object, 6.1.2, 6.1.2

OracleResultSet interface, 10.3.2.5

getXXX() methods, 11.3.4

OracleResultSetCache interface, 17.1.2.3

OracleResultSetMetaData interface, 10.3.2.6

OracleServerDriver class

defaultConnection() method, 23.3.1.1

oracle.sql datatype classes, 10.3.1.1

oracle.sql package

data conversions, 11.1

described, 10.3.1

oracle.sql.ARRAY class, 16.1.1

and nested tables, 10.3.1.5

and VARRAYs, 10.3.1.5

createDescriptor() method, 16.4.1.3

getArray() method, 16.2.2.2

getArrayType() method, 16.4.1.3

getAutoBuffering() method, 16.3.2

getBaseType() method, 16.2.2.2

getBaseTypeName() method, 16.2.2.2

getDescriptor() method, 16.2.2.2

getJavaSQLConnection() method, 16.2.2.2, 16.4.1.3

getMaxLength() method, 16.4.1.3

getOracleArray() method, 16.2.2.2

getResultSet() method, 16.2.2.2

getSQLTypeName() method, 16.2.2.2

length() method, 16.2.2.2

methods for Java primitive types, 16.3.1

setAutoBuffering() method, 16.3.2

setAutoIndexing() method, 16.3.3, 16.3.3

oracle.sql.ArrayDescriptor class

getBaseName() method, 16.4.1.3

getBaseType() method, 16.4.1.3

oracle.sql.BFILE class, 10.3.1.6

closeFile() method, 14.6.5

getBinaryStream() method, 14.6.5

getBytes() method, 14.6.5

getDirAlias() method, 14.6.5

getName() method, 14.6.5

isFileOpen() method, 14.6.5

length() method, 14.6.5

openFile() method, 14.6.5

position() method, 14.6.5

oracle.sql.BLOB class, 10.3.1.6

getBufferSize() method, 14.2.5.1

getBytes() method, 14.2.5.1

getChunkSize() method, 14.2.5.1

length() method, 14.2.5.1

position() method, 14.2.5.1

putBytes() method, 14.2.5.1

setBinaryStream() method, 14.2.5.1

oracle.sql.CHAR class, 23.3.6

getString() method, 10.4.3.3

getStringWithReplacement() method, 10.4.3.3

toString() method, 10.4.3.3

oracle.sql.CharacterSet class, 10.4.3.1

oracle.sql.CLOB class, 10.3.1.6

getAsciiStream() method, 14.2.5.2

getBufferSize() method, 14.2.5.2

getCharacterStream() method, 14.2.5.2

getChars() method, 14.2.5.2

getChunkSize() method, 14.2.5.2

getSubString() method, 14.2.5.2

length() method, 14.2.5.2

position() method, 14.2.5.2

putChars() method, 14.2.5.2

setAsciiStream() method, 14.2.5.2

setCharacterStream() method, 14.2.5.2

setString() method, 14.2.5.2

supported character sets, 14.2.5

oracle.sql.datatypes

support, 10.3.1.2

oracle.sql.DATE class, 10.3.1.7

oracle.sql.Datum array, 19.4.3.2.2

oracle.sql.Datum class, described, 10.3.1

oracle.sql.NUMBER class, 10.3.1.7

oracle.sql.ORAData interface, 13.3.6

oracle.sql.ORADataFactory interface, 13.3.6

OracleSql.parse() method, 24.3.7

oracle.sql.RAW class, 10.3.1.7

oracle.sql.REF class, 10.3.1.4, 15.1

getBaseTypeName() method, 15.2.2

getValue() method, 15.2.2

setValue() method, 15.2.2

oracle.sql.ROWID class, 10.3.1.2, 10.3.1.9, 10.5.1

oracle.sql.STRUCT class, 10.3.1.3, 13.2.1.2

getAutoBuffering() method, 13.2.5

getDescriptor() method, 13.2.1.2

getJavaSQLConnection() method, 13.2.1.2

getOracleAttributes() method, 13.2.1.2

setAutoBuffering() method, 13.2.5

toJDBC() method, 13.2.1.2, 13.2.1.2

oracle.sql.StructDescriptor class

createDescriptor() method, 13.2.2.1

OracleStatement interface, 10.3.2.2

OracleTypes class, 10.3.2.7

OracleTypes class for typecodes, 10.3.2.7

OracleTypes.CURSOR variable, 10.5.2.1

OracleXAConnection class, 9.2.2

OracleXADataSource class, 9.2.1

OracleXAResource class, 9.2.3, 9.2.4

OracleXid class, 9.2.5

ORAData interface, 10.2.2

additional uses, 13.3.8

advantages, 13.3.1

Oracle object types, 13

reading data, 13.3.7.1

writing data, 13.3.7.2

orai18n.jar file, 12.1

othersDeletesAreVisible() method (database meta data), 17.7.2

othersInsertsAreVisible() method (database meta data), 17.7.2

othersUpdatesAreVisible() method (database meta data), 17.7.2

OUT parameter mode, 19.4.3, 19.4.3.1, 19.4.3.2

outer joins, SQL92 syntax, 24.3.5

ownDeletesAreVisible() method (database meta deta), 17.7.1

ownInsertsAreVisible() method (database meta data), 17.7.1

ownUpdatesAreVisible() method (database meta data), 17.7.1

P

parameter modes

IN, 19.4.2

IN OUT, 19.4.3

OUT, 19.4.3, 19.4.3.1, 19.4.3.2

password connection property, 4.1.2.3

password, specifying, 4.1.2.1

PATH variable, specifying, 2.2.2.1

PDA, 18.6

performance enhancements, standard vs. Oracle, 5.2.4

performance extensions

defining column types, 22.2.2

prefetching rows, 22.2.1

TABLE_REMARKS reporting, 22.2.3

performance optimization, 26.2

Personal Digital Assistant (PDA), 18.6

PL/SQL

limit on BLOB size, 14.2.1.2

restrictions, 26.3.3

space padding, 26.3.1

stored procedures, 4.5.1

PL/SQL index-by tables

mapping, 19.4.3.2

scalar datatypes, 19.4.1

PL/SQL types

corresponding JDBC types, 19.4.1

limitations, 24.4.3

PoolConfig() method, 19.1.3.3

populate() method, 18.6

position() method, 14.2.5.1, 14.2.5.2, 14.6.5

positioning in result sets, 17.1.1.1

prefetching rows, 22.2, 22.2.1

suggested default, 22.2.1.2

prepare a distributed transaction branch, 9.2.4.3

prepareCall(), 6.1.3

prepareCall() method, 6.2.4.1, 6.2.4.4, 6.2.4.4, 6.2.5.1, 10.3.2.1.1

prepared statement

passing BFILE locator, 14.6.1.2

passing LOB locators, 14.2.1.2.1

using setObject() method, 11.3.6.1

using setOracleObject() method, 11.3.6.1

PreparedStatement object

creating, 4.1.7

prepareStatement(), 6.1.3

prepareStatement() method, 6.2.4.1, 6.2.4.4, 6.2.4.4, 6.2.5.1, 10.3.2.1.1

code example, 6.2.4.2

previous() method (result set), 17.3.2

printStackTrace() method (SQLException), 4.6.2

PrintWriter for a data source, 3.1.5

processEscapes

connection property, 4.1.2.3

put() method

for Properties object, 4.1.2.7.1

for type maps, 13.3.3, 13.3.3.1

putBytes() method, 14.2.5.1

putChars() method, 14.2.5.2

Q

query, executing, 4.1.4

R

racgons, 8.2.2.3

RAW class, 10.3.1.7

RDBMS, 1.2.2

read-only result set concurrency type, 17.1.1.4

readSQL() method, 13.3.4, 13.3.4.2

implementing, 13.3.4.2

REF class, 10.3.1.4

REF CURSORs, 10.5.2

materialized as result set objects, 10.5.2

refetching rows into a result set, 17.6, 17.7.3

refreshRow() method (result set), 17.6

registerIndexTableOutParameter() method, 19.4.1, 19.4.3.1

arguments

int elemMaxLen, 19.4.3.1

int elemSqlType, 19.4.3.1

int maxLen, 19.4.3.1

int paramIndex, 19.4.3.1

code example, 19.4.3.1

registerOutParameter() method, 10.3.2.4, 11.3.7

Relational Database Management System (RDBMS), 1.2.2

relative positioning in result sets, 17.1.1.1

relative() method (result set), 17.3.1.1.6

remarksReporting connection property, 4.1.2.3, 4.1.2.3

remarksReporting flag, 22.2

Remote Method Invocation (RMI), 18.6

resource managers, 9.1.1

restrictGetTables connection property, 4.1.2.3

result set

auto-commit mode, 26.2.1

getting BFILE locators, 14.6.1.1.1

getting LOB locators, 14.2.1.1.1

metadata, 10.3.2.6

Oracle extensions, 11.2

using getOracleObject() method, 11.3.2.1

result set enhancemennts

positioning result sets, 17.3.1

result set enhancements

concurrency types, 17.1.1.4

downgrade rules, 17.2.2.2

fetch size, 17.5

limitations, 17.2.2.1

Oracle scrollability requirements, 17.1.2.1

Oracle updatability requirements, 17.1.2.2

positioning, 17.1.1.1

processing result sets, 17.3.2.1

refetching rows, 17.6, 17.7.3

result set types, 17.1.1.2

scrollability, 17.1.1.1

seeing external changes, 17.7.2

seeing internal changes, 17.7.1

sensitivity to database changes, 17.1.1.1

specifying scrollability, updatability, 17.2.1

summary of methods, 17.8

summary of visibility of changes, 17.7.4

updatability, 17.1.1.3

updating result sets, 17.4

visibility vs. detection of external changes, 17.7.3

result set fetch size, 17.5

result set methods, JDBC 2.0, 17.8.2

result set object

closing, 4.1.6

result set types for scrollability and sensitivity, 17.1.1.2

result set, processing, 4.1.5

ResultSet class, 4.1.4

ResultSet() method, 16.3.3

return types

for getXXX() methods, 11.3.4.1

getObject() method, 11.3.3

getOracleObject() method, 11.3.3

return values

casting, 11.3.5

RMI, 18.6

roll back a distributed transaction branch, 9.2.4.5

roll back changes to database, 4.1.8

row prefetching, 22.2.1

and data streams, 4.4.6.3

ROWID class, 10.3.1.9

CursorName methods, 24.4.1

defined, 10.5.1

ROWID, use for result set updates, 17.1.2.2

S

savepoints

transaction, 5.5

scalar functions, SQL92 syntax, 24.3.3

schema naming conventions, 10.2.3

scrollability in result sets, 17.1.1.1

scrollable result sets

creating, 17.2.1

fetch direction, 17.3.2.2

implementation of scroll-sensitivity, 17.7.5

positioning, 17.3.1

processing backward/forward, 17.3.2.1

refetching rows, 17.6, 17.7.3

scroll-insensitive result sets, 17.1.1.2

scroll-sensitive result sets, 17.1.1.2

seeing external changes, 17.7.2

visibility vs. detection of external changes, 17.7.3

scroll-sensitive result sets

limitations, 17.2.2.1

security

authentication, 23.1.2

encryption, 23.1.3

integrity, 23.1.3

Oracle Advanced Security support, 23.1.1

overview, 23.1

SELECT statement

to retrieve object references, 15.3.1

to select LOB locator, 14.2.4

sendBatch() method, 22.1.2.5, 22.1.2.7

sensitivity in result sets to database changes, 17.1.1.1

serialization

ArrayDescriptor object, 16.4.1.4

definition of, 13.2.2.3, 16.4.1.4

StructDescriptor object, 13.2.2.3

server connection property, 4.1.2.3

server-side internal driver

connection to database, 23.3.1

server-side Thin driver, described, 1.2.4

session context, 1.4.1

for KPRB driver, 23.3.3

setAsciiStream() method, 11.3.7.3

for writing CLOB data, 14.2.2

setAutoBuffering() method

of the oracle.sql.ARRAY class, 16.3.2

of the oracle.sql.STRUCT class, 13.2.5

setAutoCommit() method, 26.2.1

setAutoIndexing() method, 16.3.3, 16.3.3, 16.3.3, 16.3.3

direction parameter values

ARRAY.ACCESS_FORWARD, 16.3.3

ARRAY.ACCESS_REVERSE, 16.3.3

ARRAY.ACCESS_UNKNOWN, 16.3.3

setBFILE() method, 14.6.1.2

setBinaryStream() method, 11.3.7.3, 14.2.5.1

for writing BLOB data, 14.2.2

setBLOB() method, 14.2.1.2

setBlob() method, JDK 1.2.x, 14.2.1.2

setBytes() limitations, using streams to avoid, 4.4.6.2

setCharacterStream() method, 11.3.7.3

for writing CLOB data, 14.2.2

setClientIdentifier() method, 10.3.2.1.1

setCLOB() method, 14.2.1.2

setClob() method, JDK 1.2.x, 14.2.1.2

setConnection() method

ArrayDescriptor object, 16.4.1.4

StructDescriptor object, 13.2.2.3

setCursorName() method, 24.4.1

setDate() method, 11.3.7.3

setDefaultExecuteBatch() method, 10.3.2.1.1, 22.1.2.2

setDefaultRowPrefetch() method, 10.3.2.1.1, 22.2.1.1

setDisableStatementCaching() method, 6.2.4.2

setEscapeProcessing() method, 24.3.1

setExecuteBatch() method, 10.3.2.3, 22.1.2.3

setFetchSize() method, 17.5.1

setFixedCHAR() method, 11.3.7.4

setFormOfUse() method, 10.4.2

setMaxFieldSize() method, 22.2.2

setNull(), 11.1.3

setNull() method, 10.3.2.3, 10.3.2.4, 11.3.7

setObejct() method, 11.3.6

setObject() method

for BFILES, 14.6.1.2

for CustomDatum objects, 13.3.6.2

for object references, 15.3.3

for STRUCT objects, 13.2.4

to write object data, 13.3.7.2

using in prepared statements, 11.3.6.1

setOracleObject() method, 10.3.2.3, 10.3.2.4, 11.3.6

for BFILES, 14.6.1.2

for BLOBs and CLOBs, 14.2.1.2

using in prepared statements, 11.3.6.1

setORAData() method, 10.3.2.3, 13.3.6.2, 13.3.7.2

setPlsqlIndexTable() method, 19.4.1, 19.4.2

arguments

int curLen, 19.4.2

int elemMaxLen, 19.4.2

int elemSqlType, 19.4.2

int maxLen, 19.4.2

int paramIndex, 19.4.2, 19.4.3.2.1

Object arrayData, 19.4.2

code example, 19.4.2

setPoolConfig() method, 19.1.3.3

setREF() method, 15.3.3

setRemarksReporting() method, 22.2.3

setResultSetCache() method, 17.1.2.3

setRowPrefetch() method, 10.3.2.2, 22.2.1.1

setString() limitations, using streams to avoid, 4.4.6.2

setString() method, 14.2.5.2

to bind ROWIDs, 10.5.1

setTime() method, 11.3.7.3

setTimestamp() method, 11.3.7.3

setTransactionIsolation() method, 10.3.2.1.1, 26.5

setTypeMap() method, 10.3.2.1.1

setUnicodeStream() method, 11.3.7.3

setValue() method, 15.2.2

setXXX() methods

Oracle extended properties, 3.1.2.2

setXXX() methods, for empty LOBs, 14.2.5.3

setXXX() methods, for specific datatypes, 11.3.7

signed applets, 1.3.1.1

Solaris

shared libraries

libheteroxa10_g.so, 19.3.1

libheteroxa9.so, 19.3.1

specifiers

database, 3.2

SQL

data converting to Java datatypes, 11.1

types, constants for, 10.3.2.7

SQL engine

relation to the KPRB driver, 23.3

SQL syntax (Oracle), 24.3.1

SQL92 syntax, 24.3

function call syntax, 24.3.6

LIKE escape characters, 24.3.4

outer joins, 24.3.5

scalar functions, 24.3.3

time and date literals, 24.3.2

translating to SQL example, 24.3.7

SQLData interface, 10.2.2

advantages, 13.3.1

described, 13.3.4

Oracle object types, 13

reading data from Oracle objects, 13.3.5.1

using with type map, 13.3.4

writing data from Oracle objects, 13.3.5.4

SQLInput interface, 13.3.4

described, 13.3.4.1

SQLInput streams, 13.3.4.2

SQLNET.ORA

parameters for tracing, 26.4.1

SQLOutput interface, 13.3.4

described, 13.3.4.1

SQLOutput streams, 13.3.4.2

SQLWarning class, limitations, 24.4.6

SSL

and LDAP, 3.2.1

start a distributed transaction branch, 9.2.4.1

statement caching

explicit

definition of, 6.1.3

null data, 6.2.5.3

implicit

definition of, 6.1.2

Least Recently Used (LRU) scheme, 6.1.2

statement methods, JDBC 2.0 result sets, 17.8.3

Statement object

closing, 4.1.6

creating, 4.1.3

statements

Oracle extensions, 11.2

stored procedures

Java, 4.5.2

PL/SQL, 4.5.1

stream data, 4.4, 14.2.2

CHAR columns, 4.4.2

closing, 4.4.5

example, 4.4.1.3

external files, 4.4.4

LOBs, 4.4.4

LONG columns, 4.4.1

LONG RAW columns, 4.4.1

multiple columns, 4.4.3

precautions, 4.4.6.1

RAW columns, 4.4.2

row prefetching, 4.4.6.3

UPDATE/COMMIT statements, 14.2.2

use to avoid setBytes() and setString() limitations, 4.4.6.2

VARCHAR columns, 4.4.2

stream data column

bypassing, 4.4.3.2

STRUCT class, 10.3.1.3

STRUCT descriptor, 13.2.2.1, 13.2.2.1, 13.2.2.1, 13.2.2.2

STRUCT object, 10.3.1.3

attributes, 10.3.1.3

creating, 13.2.2.1, 13.2.2.1

embedded object, 13.2.3

nested objects, 10.3.1.3

retrieving, 13.2.3

retrieving attributes as oracle.sql types, 13.2.3.3

StructDescriptor object

creating, 13.2.2.1

deserialization, 13.2.2.3, 13.2.2.3

get methods, 13.2.2.2

serialization, 13.2.2.3

setConnection() method, 13.2.2.3

T

TABLE_REMARKS columns, 22.2

TABLE_REMARKS reporting

restrictions on, 22.2.3

TAF, definition of, 19.2

TCP/IP protocol, 1.2.2, 3.2.1.1

testing

for NULL values, 11.1.3

Thin driver

applets, 23.2

applications, 1.3.1

described, 1.2.2

LDAP over SSL, 3.2.1

server-side, described, 1.2.4

time and date literals, SQL92 syntax, 24.3.2

tnsEntry, 3.1.2.2, 19.3

toDatum() method

applied to CustomDatum objects, 13.3.1, 13.3.6.1

called by setORAData() method, 13.3.7.2

toJDBC() method, 13.2.1.2, 13.2.1.2

toJdbc() method, 10.3.1.2

toString() method, 10.4.3.3

trace facility, 26.4.1

trace parameters

client-side, 26.4.1.1

server-side, 26.4.1.2

tracing with a data source, 3.1.5

transaction branch, 9.1

transaction branch ID component, 9.2.5

transaction context, 1.4.1

for KPRB driver, 23.3.3

transaction IDs (distributed transactions), 9.1.2

transaction managers, 9.1.1

transaction savepoints, 5.5

transactions

switching between local and global, 9.1.3

Transparent Application Failover (TAF), definition of, 19.2

TTC error messages, listed, A.4

TTC protocol, 1.2.2, 1.2.3

type map, 10.2.2, 11.3.1

adding entries, 13.3.3.1

and STRUCTs, 13.3.3.3

creating a new map, 13.3.3.2

used with arrays, 16.4.2.4

used with SQLData interface, 13.3.4

using with arrays, 16.5

type map (SQL to Java), 13.3

type mapping

BigDecimal mapping, 13.5.2.2

JDBC mapping, 13.5.2.2

object JDBC mapping, 13.5.2.2

Oracle mapping, 13.5.2.2

type mappings

JPublisher options, 13.5.2

type maps

relationship to database connection, 23.3.1.2

TYPE_FORWARD_ONLY result sets, 17.2.1

TYPE_SCROLL_INSENSITIVE result sets, 17.2.1

TYPE_SCROLL_SENSITIVE result sets, 17.2.1

typecodes, Oracle extensions, 10.3.2.7

U

unicode data, 10.4.2

updatability in result sets, 17.1.1.3

updatable result set concurrency type, 17.1.1.4

updatable result sets

creating, 17.2.1

DELETE operations, 17.4.1

INSERT operations, 17.4.3

limitations, 17.2.2.1

refetching rows, 17.6, 17.7.3

seeing internal changes, 17.7.1

update conflicts, 17.4.4

UPDATE operations, 17.4.2

update batching

overview, Oracle vs. standard model, 22.1.1.1

overview, statements supported, 22.1.1.2

update batching (Oracle model)

batch value, checking, 22.1.2.4

batch value, overriding, 22.1.2.5

committing changes, 22.1.2.6

connection batch value, setting, 22.1.2.2

connection vs. statement batch value, 22.1.2

default batch value, 22.1.2.1

disable auto-commit, 22.1.2

example, 22.1.2.7

limitations and characteristics, 22.1.2.1

overview, 22.1.2

statement batch value, setting, 22.1.2.3

stream types not allowed, 22.1.2.1

update counts, 22.1.2.7

update batching (standard model)

adding to batch, 22.1.3.2

clearing the batch, 22.1.3.5

committing changes, 22.1.3.4

error handling, 22.1.3.7

example, 22.1.3.6

executing the batch, 22.1.3.3

intermixing batched and non-batched, 22.1.3.8

overview, 22.1.3

stream types not allowed, 22.1.3.1

update counts, 22.1.3.6

update counts upon error, 22.1.3.7

update conflicts in result sets, 17.4.4

update counts

Oracle update batching, 22.1.2.7

standard update batching, 22.1.3.6

upon error (standard batching), 22.1.3.7

UPDATE in a result set, 17.4.2

updateRow() method (result set), 17.4.2

updatesAreDetected() method (database meta data), 17.7.3

updateXXX() methods (result set), 17.4.2, 17.4.3

updateXXX() methods for empty LOBs, 14.2.5.3

updating result sets, 17.4

url, 3.1.2.2

URLs

for KPRB driver, 23.3.1.2

useFetchSizeWithLongColumn connection property, 4.1.2.3

user connection property, 4.1.2.3

userid, specifying, 4.1.2.1

V

VARCHAR2 columns, 26.3.1

version

compatibility, 1.5.1.1

W

WIDTH, parameter for APPLET tag, 23.2.5.1

window, scroll-sensitive result sets, 17.7.5

writeSQL() method, 13.3.4, 13.3.4.2

implementing, 13.3.4.2

X

connection implementation, 9.2.2

connections (definition), 9.1.2

data source implementation, 9.2.1

data sources (definition), 9.1.2

definition, 9.1

error handling, 9.3.3

example of implementation, 9.4

exception classes, 9.3.1

Oracle optimizations, 9.3.4

Oracle transaction ID implementation, 9.2.5

resource implementation, 9.2.3

resources (definition), 9.1.2

transaction ID interface, 9.2.5

XAException, 9.2.4.7

Xids, 9.2.4.7