Index

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

A

acceptChanges() method, 18.2

Accessing PL/SQL Index-by Tables, 4.2.6

addBatch() method, 23.1.3.2

ANYDATA, 4.5.4

ANYTYPE, 4.5.4

APPLET HTML tag, 5.3.5.1

applets

connecting to a database, 5.3.1

deploying in an HTML page, 5.3.5

packaging, 5.3.4, 5.3.4

signed applets

browser security, 5.3.2.2

object-signing certificate, 5.3.2.2

using signed applets, 5.3.2.2

using with firewalls, 5.3.3

ARCHIVE, parameter for APPLET tag, 5.3.5.3

ARRAY

class, 4.3.1

descriptors, 4.3.1

objects, creating, 4.3.1, 16.4.1

arrays

defined, 16.1

getting, 16.4.2.6

named, 16.1

passing to callable statement, 16.4.3

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

authentication (security), 9.2

auto-commit, 2.3.8

auto-commit mode

disabling, C.2.1

result set behavior, C.2.1

B

batch jobs, authenticating users in, 9.9

batch updates--see update batching

batch value

checking value, 23.1.2.4

connection batch value, setting, 23.1.2.2

connection vs. statement value, 23.1.2

default value, 23.1.2.1

overriding value, 23.1.2.5

statement batch value, setting, 23.1.2.3

BatchUpdateException, 23.1.3.7

beforeFirst() method, 18.1.4

BFILE

class, 4.3.1

defined, 12.4

BFILE locator, selecting, 4.3.1

BigDecimal mapping (for attributes), 13.5.2

BLOB

class, 4.3.1

locators

selecting, 4.3.1

Boolean parameters, restrictions, E.1.3

branch qualifier (distributed transactions), 29.2.5

C

CachedRowSet, 18.2

caching, client-side

Oracle use for scrollable result sets, 17.1

callable statement

using getOracleObject() method, 11.4.2

cancelling

SQL statements, E.1.5

casting return values, 11.4.5

catalog arguments (DatabaseMetaData), A.4.5

CHAR columns

using setFixedCHAR() to match in WHERE, 11.4.7.2

character sets, 4.4.3

checksums

code example, 9.5.3

setting parameters in Java, 9.5.3

support by OCI drivers, 9.5.1

support by Thin driver, 9.5.2

CLASSPATH environment variable, specifying, 2.2.2

clearBatch() method, 23.1.3.5

clearDefines() method, 23.2.3

CLOB

class, 4.3.1

locators, selecting, 4.3.1

close method, 20.3.2, 20.3.2

close(), 20.1.3

close() method, E.1.2

for caching statements, 20.2.2, 20.2.3

closeWithKey(), 20.1.3

closeWithKey() method, 20.2.4, 20.2.4

CMAN.ORA file, creating, 5.3.2.1

CODE, parameter for APPLET tag, 5.3.5.1

CODEBASE, parameter for APPLET tag, 5.3.5.2

collections

defined, 16.1

collections (nested tables and arrays), 16.4.1

column types

defining, 23.2.3

redefining, 23.2

commit a distributed transaction branch, 29.2.4

commit changes to database, 2.3.8

CONNECT / feature, 9.9

connection

closing, 2.3.9

opening, 2.3.2

connection attributes, 21.3

connection cache properties, 21.4

Connection Manager

installing, 5.3.2.1

starting, 5.3.2.1

using, 5.3.2.1

using multiple managers, 5.3.2.1

writing the connection string, 5.3.2.1

connection properties, 8.1.5

put() method, 8.1.9

connection string

Connection Manager, 5.3.2.1

connections

read-only, C.3

constants for SQL types, 4.5.5.7

CREATE TYPE statement, 13.4.1

create() method

for ORADataFactory interface, 13.3.5

createSQLXML

method to create an XML instance, 3.3.2

createStatement(), 20.1.3

createStatement() method, 20.2.4

createTemporary() method, 14.5

CursorName

limitations, A.4.1

cursors, E.1.2

custom collection classes

and JPublisher, 16.6

defined, 16.1.1, 16.6

custom Java classes, 4.2.3

defined, 13.1

custom object classes

creating, 13.3

defined, 13.1

custom reference classes

and JPublisher, 15.4

defined, 15.1, 15.4

D

data conversions, 11.2

LONG, 12.2.2

LONG RAW, 12.2.1

data sources

creating and connecting (with JNDI), 8.1.4

creating and connecting (without JNDI), 8.1.3

Oracle implementation, 8.1.2

properties, 8.1.2

standard interface, 8.1.2

data streaming

avoiding, 12.2.4

data type mappings, 11.1

data types

Java, 11.1

Java native, 11.1

JDBC, 11.1

Oracle SQL, 11.1

database

connecting

from an applet, 5.3.1

via multiple Connection Managers, 5.3.2.1

with server-side internal driver, 7.2

connection testing, 2.2.5

database specifiers, 8.2

database URL

including userid and password, 2.3.2

database URL, specifying, 2.3.2

database URLs

and database specifiers, 8.2

DatabaseMetaData calls, A.4.5

DatabaseMetaData class, A.3.2

datasources, 8.1

and JNDI, 8.1.4

DATE class, 4.3.1

DBMS_SERVICE.SERVICE_TIME, 22.2

DBMS_SERVICE.THROUGHPUT, 22.2

debugging JDBC programs, E.2

DEFAULT_CHARSET character set value, 4.4.3

defaultConnection() method, 7.2

defineColumnType() method, 12.2.4, 23.2.3

distributed transaction ID component, 29.2.5

distributed transactions

branch qualifier, 29.2.5

check for same resource manager, 29.2.4

commit a transaction branch, 29.2.4

components and scenarios, 29.1.1

concepts, 29.1.2

distributed transaction ID component, 29.2.5

end a transaction branch, 29.2.4

example of implementation, 29.4

forget, 29.2.4

global transaction identifier, 29.2.5

ID format identifier, 29.2.5

obtain the list of transaction brances during recovery, 29.2.4

Oracle XA connection implementation, 29.2.2

Oracle XA data source implementation, 29.2.1

Oracle XA ID implementation, 29.2.5

Oracle XA optimizations, 29.3.4

Oracle XA resource implementation, 29.2.3

overview, 29.1

prepare a transaction branch, 29.2.4

roll back a transaction branch, 29.2.4

start a transaction branch, 29.2.4

transaction branch ID component, 29.2.5

XA connection interface, 29.2.2

XA data source interface, 29.2.1

XA error handling, 29.3.3

XA exception classes, 29.3.1

XA ID interface, 29.2.5

XA resource functionality, 29.2.4

XA resource interface, 29.2.3

DML Returning, 4.2.5, 4.6

example, 4.6.3

limitations, 4.6.4

Oracle-specific APIs, 4.6.1

running statements, 4.6.2

Double.NaN

restrictions on use, 4.3.1

driverType, 8.1.2

E

encryption

code example, 9.5.3

overview, 9.5

setting parameters in Java, 9.5.3

support by OCI drivers, 9.5.1

support by Thin driver, 9.5.2

end a distributed transaction branch, 29.2.4

Enterprise Java Beans (EJB), 18.2

environment variables

specifying, 2.2.2

errors

general JDBC message structure, D.1

general JDBC messages, listed, D.2

processing exceptions, 2.6

TTC messages, listed, D.4

exceptions

retrieving error code, 2.6

retrieving message, 2.6

retrieving SQL state, 2.6

execute() method, 18.3

executeBatch() method, 23.1.3.3

executeUpdate() method, 23.1.2.7

explicit Statement caching

definition of, 20.1.3

null data, 20.2.4

extensions to JDBC, Oracle, 4, 11, 13, 15, 16, 23

external changes (result set)

defined, 17.6

visibility vs. detection, 17.6.1

external file

defined, 12.4

F

failover

fast connection, 27

Fast Connection Failover, 27

fast connection failover

prerequisites, 27.2.1

fetch direction in result sets, 17.4.2

fetch size, result sets, 17.4

FilteredRowSet, 18.5

finalizer methods, E.1.2

firewalls

configuring for applets, 5.3.3.1

connection string, 5.3.3.2

described, 5.3.3

required rule list items, 5.3.3.1

using with applets, 5.3.3

Firewalls, using with JDBC, E.1.6

floating-point compliance, A.4.4

Float.NaN

restrictions on use, 4.3.1

format identifier, transaction ID, 29.2.5

freeTemporary() method, 14.5, 14.5

function call syntax, JDBC escape syntax, A.3.5

G

getARRAY() method, 16.4.2.1

getArray() method, 16.3.3, 16.4.2.2

using type maps, 16.4.2.4

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

getBaseType() method, 16.4.2.6

getBinaryStream() method, 12.2.3

getBytes() method, 4.3.1, 12.2.3

getCallWithKey(), 20.1.3

getCallWithKey() method, 20.2.4, 20.2.4

getColumns() method, 23.2.4

getConcurrency() method (result set), 17.2

getConnection() method, 7.2, 24.4

getCursor() method, 4.5.2, 4.5.2

getCursorName() method

limitations, A.4.1

getDefaultExecuteBatch() method, 23.1.2.4

getErrorCode() method (SQLException), 2.6

getExecuteBatch() method, 23.1.2.3, 23.1.2.4

getFetchSize() method, 17.4.1

getJavaSqlConnection() method, 4.5.5.8

getMessage() method (SQLException), 2.6

getNumericFunctions() method, A.3.2

getObject() method

casting return values, 11.4.5

for object references, 15.2.1

for ORAData objects, 13.3.5

return types, 11.4.1, 11.4.3

to get Oracle objects, 13.2.2

used with ORAData interface, 13.3.6

getObjectReturnsXMLType

property to change the return type of the getObjectMethod, 3.3.2

getOracleArray() method, 16.4.2.2, 16.4.2.6

getOracleAttributes() method, 13.2.2

getOracleObject() method

casting return values, 11.4.5

return types, 11.4.2, 11.4.3

using in callable statement, 11.4.2

using in result set, 11.4.2

getOraclePlsqlIndexTable() method, 4.7.1, 4.7.3, 4.7.4

argument

int paramIndex, 4.7.4

code example, 4.7.4

getORAData() method, 13.3.5, 13.3.6

getPassword() method, 8.1.2

getPlsqlIndexTable() method, 4.7.1, 4.7.3, 4.7.3, 4.7.4, 4.7.4

arguments

Class primitiveType, 4.7.4

int paramIndex, 4.7.4

code example, 4.7.4, 4.7.4

getProcedureColumns() method, 23.2.4

getProcedures() method, 23.2.4

getSQLState() method (SQLException), 2.6

getSQLTypeName() method, 13.2.1, 16.4.2.6

getStatementCacheSize() method

code example, 20.2.1

getStatementWithKey(), 20.1.3

getStatementWithKey() method, 20.2.4, 20.2.4

getString() method, 4.4.3

to get ROWIDs, 4.5.1

getStringFunctions() method, A.3.2

getStringWithReplacement() method, 4.4.3

getSystemFunctions() method, A.3.2

getTimeDateFunctions() method, A.3.2

getTransactionIsolation() method, C.3

getType() method (result set), 17.2

getTypeMap() method, 13.3.3.1

getUpdateCounts() method (BatchUpdateException), 23.1.3.7

getValue() method

for object references, 15.2.1

getXXX() methods

casting return values, 11.4.5

for specific data types, 11.4.4

global transaction identifier (distributed transactions), 29.2.5

global transactions, 29.1

globalization, 19

using, 19

H

HEIGHT, parameter for APPLET tag, 5.3.5.1

HTML tags, to deploy applets, 5.3.5

I

IEEE 754 floating-point compliance, A.4.4

implicit connection cache, 21

example, 21.2.6

implicit Statement caching

definition of, 20.1.2

Least Recently Used (LRU) algorithm, 20.1.2

IN OUT parameter mode, 4.7.3

IN parameter mode, 4.7.2

installation

directories and files, 2.2.1

verifying on the client, 2.2

Instant Client feature, 6.5.1

integrity

code example, 9.5.3

overview, 9.5

setting parameters in Java, 9.5.3

support by OCI drivers, 9.5.1

support by Thin driver, 9.5.2

internal changes (result set)

defined, 17.6

isSameRM() (distributed transactions), 29.2.4

isTemporary() method, 14.5, 14.5

J

Java

compiling and running, 2.2.3

data types, 11.1

native data types, 11.1

stored procedures, 2.5.2

stream data, 12

Java Naming and Directory Interface (JNDI), 8.1.1

Java Sockets, 1.1.1

Java Virtual Machine (JVM), 7.1

java.math, Java math packages, 2.3.1

java.sql, JDBC packages, 2.3.1

java.sql.Connection interface

close method, 20.3.2

java.sql.SQLException() method, 2.6

java.sql.Statement interface

close method, 20.3.2

java.sql.Struct class

getSQLTypeName() method, 13.2.1

java.sql.Types class, 23.2.3

java.util.Map class, 16.4.2.5

java.util.Properties, 24.3

JDBC

and IDEs, 1.2.3

basic program, 2.3

data types, 11.1

defined, 1

importing packages, 2.3.1

limitations of Oracle extensions, A.4

sample files, 2.2.3

testing, 2.2.5

version support, 3

JDBC 2.0 support

data type support, 3.1.1

extended feature support, 3.1.3

introduction, 3.1

JDK 1.2.x vs. JDK 1.1.x, 3.1, 3.2

standard feature support, 3.1.2

JDBC drivers

applets, 5.3

choosing a driver for your needs, 1.1.2

common features, 1.1.1

common problems, E.1

determining driver version, 2.2.4

introduction, 1.1

JDBC escape syntax, A.3

restrictions, E.1.3

JDBC escape syntax, A.3

function call syntax, A.3.5

LIKE escape characters, A.3.3

outer joins, A.3.4

scalar functions, A.3.2

time and date literals, A.3.1

translating to SQL example, A.3.6

JDBC mapping (for attributes), 13.5.2

JdbcCheckup program, 2.2.5

JDBCRowSet, 18.3

JDBCSpy, E.2.2

JDBCTest, E.2.2

JDeveloper, 1.2.3

JDK

versions supported, 1.2.1

JNDI

and datasources, 8.1.4

looking up data source, 8.1.4

overview of Oracle support, 8.1.1

registering data source, 8.1.4

JoinRowSet, 18.6

JPublisher, 13.3.6, 13.5.1

JPublisher utility, 13.3

creating custom collection classes, 16.6

creating custom Java classes, 13.5

creating custom reference classes, 15.4

SQL type categories and mapping options, 13.5.2

type mapping modes and settings, 13.5.2

type mappings, 13.5.2

JVM, 7.1

K

KPRB driver

overview, 1.1.1

relation to the SQL engine, 7.1

session context, 7.3

testing, 7.4

transaction context, 7.3

URL for, 7.2

L

LD_LIBRARY_PATH environment variable, specifying, 2.2.2

LDAP

and SSL, 8.2

Least Recently Used (LRU) algorithm, 20.1.2, 24.3

libheteroxa11_g.so shared library, 29.5.1

libheteroxa11.so shared library, 29.5.1

LIKE escape characters, JDBC escape syntax, A.3.3

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

load balancing advisory, 22.1

LOB

defined, 12.4

LONG

data conversions, 12.2.2

LONG RAW

data conversions, 12.2.1

LRU algorithm, 20.1.2

M

make() method, 4.4.3

memory leaks, E.1.2

mutable arrays, 16.6

N

named arrays, 16.1

defined, 16.4.1

nativeXA, 8.1.2, 29.5.1

network events, trapping, E.2.1

next() method, 18.1.4

NLS. See globalization

NLS_LANG variable

desupported, 19

NULL

testing for, 11.2.3

NULL data

converting, 11.2.2

null data

explicit Statement caching, 20.2.4

NullPointerException

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

NUMBER class, 4.3.1

O

object references

accessing object values, 15.2.1, 15.3, 15.3

described, 15.1

passing to prepared statements, 15.2.3

retrieving, 15.2.1

retrieving from callable statement, 15.2.2

updating object values, 15.2.1, 15.3, 15.3

object-JDBC mapping (for attributes), 13.5.2

OCI driver

described, 1.1.1

ODBCSpy, E.2.2

ODBCTest, E.2.2

ONS

configuring, 27.2.2

ons.config file, B.2.1.1, B.2.1.1

optimization, performance, C.2

Oracle Advanced Security

support by JDBC, 9.1

support by OCI drivers, 9.1

support by Thin driver, 9.1

Oracle Connection Manager, 5.3.1

Oracle data types

using, 11

Oracle extensions, 4.2

data type support, 4.2.2

limitations, A.4

catalog arguments to DatabaseMetaData calls, A.4.5

CursorName, A.4.1

IEEE 754 floating-point compliance, A.4.4

JDBC outer join escapes, A.4.2

PL/SQL TABLE, BOOLEAN, RECORD types, A.4.3

read-only connection, C.3

SQLWarning class, A.4.6

object support, 4.2.3

result sets, 11.3

statements, 11.3

to JDBC, 4, 11, 13, 15, 16, 23

Oracle JPublisher, 4.2.3

generated classes, 13.4.2.3

Oracle mapping (for attributes), 13.5.2

Oracle Notification Service. See ONS

Oracle objects

and JDBC, 13.1

converting with ORAData interface, 13.3.5

getting with getObject() method, 13.2.2

Java classes which support, 13.2

mapping to custom object classes, 13.3

reading data by using SQLData interface, 13.3.4

working with, 13.1

writing data by using SQLData interface, 13.3.4

Oracle SQL data types, 11.1

OracleCallableStatement interface, 4.5.5.4

getOraclePlsqlIndexTable() method, 4.7.1

getPlsqlIndexTable() method, 4.7.1

getXXX() methods, 11.4.4

registerIndexTableOutParameter() method, 4.7.1, 4.7.3

registerOutParameter() method, 11.4.7

setPlsqlIndexTable() method, 4.7.1, 4.7.2

OracleCallableStatement object, 20.1.2, 20.1.2

OracleConnection class, 4.5.5.1

OracleConnection interface, 24.3

OracleConnection object, 20.1.1

OracleDatabaseMetaData class, A.3.2

OracleDataSource class, 8.1.2, 24.3, 24.3

oracle.jdbc. package, 4.5.5

oracle.jdbc., Oracle JDBC extensions, 2.3.1

oracle.jdbc.OracleCallableStatement interface, 4.5.5.4

oracle.jdbc.OracleConnection interface, 4.5.5.1

getTransactionIsolation() method, C.3

setTransactionIsolation() method, C.3

oracle.jdbc.OraclePreparedStatement interface, 4.5.5.3

oracle.jdbc.OracleResultSet, 11.3

oracle.jdbc.OracleResultSet interface, 4.5.5.5

oracle.jdbc.OracleResultSetMetaData interface, 4.5.5.6, 11.5

using, 11.5

oracle.jdbc.OracleSql class, A.3.6

oracle.jdbc.OracleStatement, 11.3

oracle.jdbc.OracleStatement interface, 4.5.5.2

oracle.jdbc.OracleTypes class, 4.5.5.7, 23.2.3

oracle.jdbc.pool package, 24.3

oracle.jdbc.xa package and subpackages, 29.1.4

OracleOCIConnection class, 24.3

OracleOCIConnectionPool class, 24, 24.3

OraclePreparedStatement interface, 4.5.5.3

getOraclePlsqlIndexTable() method, 4.7.1

getPlsqlIndexTable() method, 4.7.1

registerIndexTableOutParameter() method, 4.7.1

setPlsqlIndexTable() method, 4.7.1, 4.7.2

OraclePreparedStatement object, 20.1.2, 20.1.2

OracleResultSet interface, 4.5.5.5

getXXX() methods, 11.4.4

OracleResultSetMetaData interface, 4.5.5.6

OracleServerDriver class

defaultConnection() method, 7.2

oracle.sql package

data conversions, 11.2

described, 4.3.1

oracle.sql.ARRAY class, 16.1.1

and nested tables, 4.3.1

and VARRAYs, 4.3.1

getAutoBuffering() method, 16.3.2

methods for Java primitive types, 16.3.1

setAutoBuffering() method, 16.3.2

setAutoIndexing() method, 16.3.3, 16.3.3

oracle.sql.BFILE class, 4.3.1

oracle.sql.BLOB class, 4.3.1

oracle.sql.CHAR class

getString() method, 4.4.3

getStringWithReplacement() method, 4.4.3

toString() method, 4.4.3

oracle.sql.CharacterSet class, 4.4.3

oracle.sql.CLOB class, 4.3.1

oracle.sql.data types

support, 4.3.1

oracle.sql.DATE class, 4.3.1

oracle.sql.Datum array, 4.7.4

oracle.sql.Datum class, described, 4.3.1

oracle.sql.NUMBER class, 4.3.1

oracle.sql.ORAData interface, 13.3.5

oracle.sql.ORADataFactory interface, 13.3.5

OracleSql.parse() method, A.3.6

oracle.sql.RAW class, 4.3.1

oracle.sql.REF class, 4.3.1

oracle.sql.ROWID class, 4.5.1

oracle.sql.STRUCT class, 4.3.1

getAutoBuffering() method, 13.2.5

setAutoBuffering() method, 13.2.5

OracleStatement interface, 4.5.5.2

OracleTypes class, 4.5.5.7

OracleTypes class for typecodes, 4.5.5.7

OracleTypes.CURSOR variable, 4.5.2

OracleXAConnection class, 29.2.2

OracleXADataSource class, 29.2.1

OracleXAResource class, 29.2.3, 29.2.4

OracleXid class, 29.2.5

ORAData interface, 4.2.3

additional uses, 13.3.7

advantages, 13.3.1

Oracle object types, 13

reading data, 13.3.6

writing data, 13.3.6

orai18n.jar file, 19.1

OUT parameter mode, 4.7.3, 4.7.3, 4.7.3

outer joins, JDBC escape syntax, A.3.4

P

parameter modes

IN, 4.7.2

IN OUT, 4.7.3

OUT, 4.7.3, 4.7.3, 4.7.3

password, specifying, 2.3.2

PATH environment variable, specifying, 2.2.2

PDA, 18.2

performance enhancements, standard vs. Oracle, 3.1.4

performance extensions

defining column types, 23.2.3

TABLE_REMARKS reporting, 23.2.4

performance optimization, C.2

Personal Digital Assistant (PDA), 18.2

PL/SQL

restrictions, E.1.3

stored procedures, 2.5.1

PL/SQL index-by tables, 4.7

mapping, 4.7.3

scalar data types, 4.7.1

PL/SQL types

corresponding JDBC types, 4.7.1

limitations, A.4.3

PoolConfig() method, 24.3

populate() method, 18.2

prefetching rows, 23.2

suggested default, 23.2.2

prepare a distributed transaction branch, 29.2.4

prepareCall(), 20.1.3

prepareCall() method, 20.2.3, 20.2.3, 20.2.3, 20.2.4

PreparedStatement object

creating, 2.3.7

prepareStatement(), 20.1.3

prepareStatement() method, 20.2.3, 20.2.3, 20.2.3, 20.2.4

code example, 20.2.3

put() method

for Properties object, 8.1.9

for type maps, 13.3.3, 13.3.3.1

Q

query, executing, 2.3.4

R

RAW class, 4.3.1

recover (distributed transactions), 29.2.4

REF class, 4.3.1

REF CURSORs, 4.5.2

materialized as result set objects, 4.5.2

refetching rows into a result set, 17.5

refreshRow() method (result set), 17.5

registerIndexTableOutParameter() method, 4.7.1, 4.7.3

arguments

int elemMaxLen, 4.7.3

int elemSqlType, 4.7.3

int maxLen, 4.7.3

int paramIndex, 4.7.3

code example, 4.7.3

registerOutParameter() method, 11.4.7

remarksReporting flag, 23.2

Remote Method Invocation (RMI), 18.2

resource managers, 29.1.1

result set

auto-commit mode, C.2.1

metadata, 4.5.5.6

Oracle extensions, 11.3

using getOracleObject() method, 11.4.2

result set enhancements

downgrade rules, 17.2

fetch size, 17.4

limitations, 17.2

Oracle scrollability requirements, 17.1

Oracle updatability requirements, 17.1

refetching rows, 17.5

summary of visibility of changes, 17.6.2

visibility vs. detection of external changes, 17.6.1

result set fetch size, 17.4

Result Set Holdability, 3.2.4

result set object

closing, 2.3.6

result set, processing, 2.3.5

ResultSet class, 2.3.4

ResultSet() method, 16.3.3

Retrieval of Auto-Generated Keys, 3.2.2

return types

for getXXX() methods, 11.4.4.1

getObject() method, 11.4.3

getOracleObject() method, 11.4.3

return values

casting, 11.4.5

RMI, 18.2

roll back a distributed transaction branch, 29.2.4

roll back changes to database, 2.3.8

row prefetching

and data streams, 12.7.3

ROWID class

CursorName methods, A.4.1

defined, 4.5.1

ROWID, use for result set updates, 17.1

RowSet

events and event listeners, 18.1.2

overview, 18.1

properties, 18.1.1

traversing, 18.1.4

run-time connection load balancing, 22

enabling, 22.2

how it works, 22.1

load balancing advisory, 22.1

overview, 22.1

S

savepoints

transaction, 3.2.1

scalar functions, JDBC escape syntax, A.3.2

Schema Naming, 4.2.4

scripts, authenticating users in, 9.9

scrollable result sets

fetch direction, 17.4.2

implementation of scroll-sensitivity, 17.6.3

refetching rows, 17.5

visibility vs. detection of external changes, 17.6.1

scroll-sensitive result sets

limitations, 17.2

security

authentication, 9.2

encryption, 9.5

integrity, 9.5

Oracle Advanced Security support, 9.1

SELECT statement

to retrieve object references, 15.2.1

sendBatch() method, 23.1.2.5, 23.1.2.7

server-side internal driver

connection to database, 7.2

server-side Thin driver, overview, 1.1.1

session context

for KPRB driver, 7.3

setAutoBuffering() method

of the oracle.sql.ARRAY class, 16.3.2

of the oracle.sql.STRUCT class, 13.2.5

setAutoCommit() method, C.2.1

setAutoIndexing() method, 16.3.3, 16.3.3

setBytes() limitations, using streams to avoid, 12.7.2

setCursorName() method, A.4.1

setDefaultExecuteBatch() method, 23.1.2.2

setDisableStatementCaching() method, 20.2.3

setEscapeProcessing() method, A.3

setExecuteBatch() method, 23.1.2.3

setFetchSize() method, 17.4.1

setFixedCHAR() method, 11.4.7.2

setMaxFieldSize() method, 23.2.3

setNull(), 11.2.3

setNull() method, 11.4.7

setObejct() method, 11.4.6

setObject() method

for CustomDatum objects, 13.3.5

for object references, 15.2.3

for STRUCT objects, 13.2.4

to write object data, 13.3.6

setOracleObject() method, 11.4.6

setORAData() method, 13.3.5, 13.3.6

setPlsqlIndexTable() method, 4.7.1, 4.7.2

arguments

int curLen, 4.7.2

int elemMaxLen, 4.7.2

int elemSqlType, 4.7.2

int maxLen, 4.7.2

int paramIndex, 4.7.2, 4.7.4

Object arrayData, 4.7.2

code example, 4.7.2

setPoolConfig() method, 24.3

setREF() method, 15.2.3

setRemarksReporting() method, 23.2.4

setString() limitations, using streams to avoid, 12.7.2

setString() method

to bind ROWIDs, 4.5.1

setTransactionIsolation() method, C.3

setXXX() methods, for specific data types, 11.4.7

signed applets, 5.3.1

Solaris

shared libraries, 29.5.1

specifiers

database, 8.2

SQL

data converting to Java data types, 11.2

types, constants for, 4.5.5.7

SQL engine

relation to the KPRB driver, 7.1

SQL syntax (Oracle), A.3

SQLData interface, 4.2.3

advantages, 13.3.1

Oracle object types, 13

reading data from Oracle objects, 13.3.4

writing data from Oracle objects, 13.3.4

SQLNET.ORA

parameters for tracing, E.2.1

SQLWarning class, limitations, A.4.6

SSL

and LDAP, 8.2

start a distributed transaction branch, 29.2.4

Statement caching

explicit

definition of, 20.1.3

null data, 20.2.4

implicit

definition of, 20.1.2

Least Recently Used (LRU) algorithm, 20.1.2

Statement object

closing, 2.3.6

creating, 2.3.3

statement.cancel(), E.1.5

statements

Oracle extensions, 11.3

stopping

statement execution, E.1.5

stored procedures

Java, 2.5.2

PL/SQL, 2.5.1

stream data, 12

CHAR columns, 12.3

closing, 12.6

example, 12.2.3

external files, 12.4

LOBs, 12.4

LONG columns, 12.2

LONG RAW columns, 12.2

multiple columns, 12.5

precautions, 12.7.1

RAW columns, 12.3

row prefetching, 12.7.3

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

VARCHAR columns, 12.3

stream data column

bypassing, 12.5

STRUCT class, 4.3.1

STRUCT object

embedded object, 13.2.2

retrieving, 13.2.2

retrieving attributes as oracle.sql types, 13.2.2

SYS.ANYDATA, 4.5.4

SYS.ANYTYPE, 4.5.4

T

TABLE_REMARKS columns, 23.2

TABLE_REMARKS reporting

restrictions on, 23.2.4

TAF, definition of, 28.1

TCP/IP protocol, 8.2

testing

for NULL values, 11.2.3

Thin driver

applets, 5.3

LDAP over SSL, 8.2

overview, 1.1.1

server-side, overview, 1.1.1

time and date literals, JDBC escape syntax, A.3.1

tnsEntry, 8.1.2, 29.5.1

toDatum() method

applied to CustomDatum objects, 13.3.1, 13.3.5

called by setORAData() method, 13.3.6

toJdbc() method, 4.3.1

toString() method, 4.4.3

trace facility, E.2.1

trace parameters

client-side, E.2.1.1

server-side, E.2.1.2

transaction branch, 29.1

transaction branch ID component, 29.2.5

transaction context

for KPRB driver, 7.3

transaction IDs (distributed transactions), 29.1.2

transaction managers, 29.1.1

transaction savepoints, 3.2.1

transactions

switching between local and global, 29.1.3

Transparent Application Failover (TAF), definition of, 28.1

TTC error messages, listed, D.4

type map, 4.2.3, 11.4.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

using with arrays, 16.5

type map (SQL to Java), 13.3

type mapping

BigDecimal mapping, 13.5.2

JDBC mapping, 13.5.2

object JDBC mapping, 13.5.2

Oracle mapping, 13.5.2

type mappings

JPublisher options, 13.5.2

type maps

relationship to database connection, 7.2

typecodes, Oracle extensions, 4.5.5.7

U

unicode data, 4.4.2

updatable result sets

limitations, 17.2

refetching rows, 17.5

update conflicts, 17.3

update batching

overview, Oracle vs. standard model, 23.1.1

overview, statements supported, 23.1.1

update batching (Oracle model)

batch value, checking, 23.1.2.4

batch value, overriding, 23.1.2.5

committing changes, 23.1.2.6

connection batch value, setting, 23.1.2.2

connection vs. statement batch value, 23.1.2

default batch value, 23.1.2.1

disable auto-commit, 23.1.2

example, 23.1.2.7

limitations and characteristics, 23.1.2.1

overview, 23.1.2

statement batch value, setting, 23.1.2.3

stream types not allowed, 23.1.2.1

update counts, 23.1.2.7

update batching (standard model)

adding to batch, 23.1.3.2

clearing the batch, 23.1.3.5

committing changes, 23.1.3.4

error handling, 23.1.3.7

example, 23.1.3.6

executing the batch, 23.1.3.3

intermixing batched and non-batched, 23.1.3.8

overview, 23.1.3

update counts, 23.1.3.6

update counts upon error, 23.1.3.7

update conflicts in result sets, 17.3

update counts

Oracle update batching, 23.1.2.7

standard update batching, 23.1.3.6

upon error (standard batching), 23.1.3.7

url, 8.1.2

URLs

for KPRB driver, 7.2

userid, specifying, 2.3.2

W

WebRowSet, 18.4

WIDTH, parameter for APPLET tag, 5.3.5.1

window, scroll-sensitive result sets, 17.6.3

X

connection implementation, 29.2.2

connections (definition), 29.1.2

data source implementation, 29.2.1

data sources (definition), 29.1.2

definition, 29.1

error handling, 29.3.3

example of implementation, 29.4

exception classes, 29.3.1

Oracle optimizations, 29.3.4

Oracle transaction ID implementation, 29.2.5

resource implementation, 29.2.3

resources (definition), 29.1.2

transaction ID interface, 29.2.5

XAException, 29.2.4

Xids, 29.2.4