Skip Headers
Oracle® Database JDBC Developer's Guide
12c Release 1 (12.1)

E17657-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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

AC, 27
acceptChanges() method, 18.2
Accessing PL/SQL Associative Arrays, 4.2.6
addBatch() method, 21.1.3.2
addLogicalTransactionIdEventListener method, 26.2.2.1
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
application continuity, 27
configuring Oracle database, 27.2
configuring Oracle JDBC, 27.1
delaying the reconnection, 27.5
disabling replay, 27.7
identifying request boundaries, 27.3
logical transaction identifier, 26.1
registering a connection callback, 27.4
retaining mutable values, 27.6
transaction guard, 27
ARCHIVE, parameter for APPLET tag, 5.3.5.3
ARRAY
objects, creating, 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
at-most-once execution, 26.1
attachServerConnection, 23.5
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, 21.1.2.4
connection batch value, setting, 21.1.2.2
connection vs. statement value, 21.1.2
default value, 21.1.2.1
overriding value, 21.1.2.5
statement batch value, setting, 21.1.2.3
BatchUpdateException, 21.1.3.8
beforeFirst() method, 18.1.4
beginRequest method, 27.3
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
branch qualifier (distributed transactions), 30.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.4
casting return values, 11.4.5
catalog arguments (DatabaseMetaData), A.5.4
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, 21.1.3.6
clearDefines() method, 21.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, 21.2.3
redefining, 21.2
commit a distributed transaction branch, 30.2.4
commit changes to database, 2.3.8
CONNECT / feature, 9.9
connection
closing, 2.3.10
opening, 2.3.2
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.5.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 Resident Connection Pooling, 23.1
APIs, 23.5
DRCP, 23
enabling
client side, 23.2.2
server side, 23.2.1
sharing across multiple connections, 23.3
tagging, 23.4
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.5.4
DatabaseMetaData class, A.4.2
datasources, 8.1
and JNDI, 8.1.4
DATE class, 4.3.1
dbms_connection_pool.start_pool method, 23.2.1
dbms_connection_pool.stop_pool method, 23.2.1
DBOP tag, 3.4.1
debugging JDBC programs, E.2
DEFAULT_CHARSET character set value, 4.4.3
defaultConnection() method, 7.2
defineColumnType() method, 12.2.4, 21.2.3
detachServerConnection, 23.5
disableReplay method, 27.7.1
distributed transaction ID component, 30.2.5
distributed transactions
branch qualifier, 30.2.5
check for same resource manager, 30.2.4
commit a transaction branch, 30.2.4
components and scenarios, 30.1.1
concepts, 30.1.2
distributed transaction ID component, 30.2.5
end a transaction branch, 30.2.4
example of implementation, 30.4
forget, 30.2.4
global transaction identifier, 30.2.5
ID format identifier, 30.2.5
obtain the list of transaction brances during recovery, 30.2.4
Oracle XA connection implementation, 30.2.2
Oracle XA data source implementation, 30.2.1
Oracle XA ID implementation, 30.2.5
Oracle XA optimizations, 30.3.4
Oracle XA resource implementation, 30.2.3
overview, 30.1
prepare a transaction branch, 30.2.4
roll back a transaction branch, 30.2.4
start a transaction branch, 30.2.4
transaction branch ID component, 30.2.5
XA connection interface, 30.2.2
XA data source interface, 30.2.1
XA error handling, 30.3.3
XA exception classes, 30.3.1
XA ID interface, 30.2.5
XA resource functionality, 30.2.4
XA resource interface, 30.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
DRCP, 23.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, 30.2.4
endRequest method, 27.3
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, 21.1.3.3
executeUpdate() method, 21.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, 21
external changes (result set)
defined, 17.6
visibility vs. detection, 17.6.1
external file
defined, 12.4

F

FAILOVER_DELAY parameter, 27.5
FAILOVER_RETRIES parameter, 27.5
fast connection failover, Preface
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.5
floating-point compliance, A.5.3
Float.NaN
restrictions on use, 4.3.1
format identifier, transaction ID, 30.2.5
freeTemporary() method, 14.5, 14.5
function call syntax, JDBC escape syntax, A.4.5

G

GET_LTXID_OUTCOME procedure, 26.4
getArray() method, 16.3.3, 16.4.2.2
using type maps, 16.4.2.4
getARRAY() method, 16.4.2.1
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.4
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, 2.3.9
getColumns() method, 21.2.4
getConcurrency() method (result set), 17.2
getConnection() method, 7.2, 22.4
getCursor() method, 4.5.2, 4.5.2
getCursorName() method
limitations, A.5.1
getDefaultExecuteBatch() method, 21.1.2.4
getErrorCode() method (SQLException), 2.6
getExecuteBatch() method, 21.1.2.3, 21.1.2.4
getFetchSize() method, 17.4.1
getLogicalTransactionId method, 26.2.1
getMessage() method (SQLException), 2.6
getMoreResults, 2.5.3
getMoreResultSet(int), 2.5.3
getNumericFunctions() method, A.4.2
getObject method, 13.3.5
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.1
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.1
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
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, 21.2.4
getProcedures() method, 21.2.4
getResultSet, 2.5.3
getSQLState() method (SQLException), 2.6
getSQLTypeName() method, 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.4.2
getStringWithReplacement() method, 4.4.3
getSystemFunctions() method, A.4.2
getTimeDateFunctions() method, A.4.2
getTransactionIsolation() method, C.3
getType() method (result set), 17.2
getTypeMap() method, 13.3.3.1
getUpdateCounts() method (BatchUpdateException), 21.1.3.8
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), 30.2.5
global transactions, 30.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.5.3
implicit results, 2.5.3
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
invisible columns, 2.3.9
isColumnInvisible, 2.3.9
isDRCPEnabled, 23.5
isSameRM() (distributed transactions), 30.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
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.Types class, 21.2.3
java.util.Map class, 16.4.2.5
java.util.Properties, 22.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.5
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.1
common problems, E.1
determining driver version, 2.2.4
introduction, 1.1
JDBC escape syntax, A.4
JDBC escape syntax, A.4
function call syntax, A.4.5
LIKE escape characters, A.4.3
outer joins, A.4.4
scalar functions, A.4.2
time and date literals, A.4.1
translating to SQL example, A.4.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
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, 22.3
libheteroxa11.so shared library, 30.5.1
LIKE escape characters, JDBC escape syntax, A.4.3
limitations on setBytes() and setString(), use of streams to avoid, 12.7.2
LOB
defined, 12.4
logical transaction identifier
LTXID, 26.1
LONG
data conversions, 12.2.2
LONG RAW
data conversions, 12.2.1
LRU algorithm, 20.1.2
LTXID, 26.1

M

make() method, 4.4.3
memory leaks, E.1.2
monitoring database operations
DBOP, 3.4.1
setClientInfo, 3.4.1
mutable arrays, 16.6

N

named arrays, 16.1
defined, 16.4.1
nativeXA, 8.1.2, 30.5.1
needToPurgeStatementCache, 23.5
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
explicit Statement caching, 20.2.4
NULL data
converting, 11.2.2
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
ODBCSpy, E.2.2
ODBCTest, E.2.2
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.5
catalog arguments to DatabaseMetaData calls, A.5.4
CursorName, A.5.1
IEEE 754 floating-point compliance, A.5.3
JDBC outer join escapes, A.5.2
read-only connection, C.3
SQLWarning class, A.5.5
object support, 4.2.3
result sets, 11.3
statements, 11.3
to JDBC, 4, 11, 13, 15, 16, 21
Oracle JPublisher, 4.2.3
generated classes, 13.4.2.3
Oracle mapping (for attributes), 13.5.2
Oracle objects
and JDBC, 13.1
converting with OracleData interface, 13.3.5
getting with getObject() method, 13.2.1
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, 22.3
OracleConnection object, 20.1.1
OracleData interface
advantages, 13.3.1
OracleDatabaseMetaData class, A.4.2
OracleDataSource class, 8.1.2, 22.3, 22.3
oracle.jdbc. package, 4.5.5
oracle.jdbc., Oracle JDBC extensions, 2.3.1
oracle.jdbc.LogicalTransactionIdEventListener interface, 26.2.2
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.OracleData interface, 13.3.5
oracle.jdbc.OracleDataFactory interface, 13.3.5
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.4.6
oracle.jdbc.OracleStatement, 11.3
oracle.jdbc.OracleStatement interface, 4.5.5.2
oracle.jdbc.OracleTypes class, 4.5.5.7, 21.2.3
oracle.jdbc.pool package, 22.3
oracle.jdbc.replay.OracleDataSourceImpl data source, 27.1
oracle.jdbc.xa package and subpackages, 30.1.4
OracleOCIConnection class, 22.3
OracleOCIConnectionPool class, 22, 22.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
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
OracleSql.parse() method, A.4.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.4
setAutoBuffering() method, 13.2.4
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, 30.2.2
OracleXADataSource class, 30.2.1
OracleXAResource class, 30.2.3, 30.2.4
OracleXid class, 30.2.5
ORAData interface, 4.2.3
additional uses, 13.3.7
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.4.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, 21.2.3
TABLE_REMARKS reporting, 21.2.4
performance optimization, C.2
Personal Digital Assistant (PDA), 18.2
PL/SQL
stored procedures, 2.5.1
PL/SQL Associative Arrays, 4.7
mapping, 4.7.3
scalar data types, 4.7.1
PL/SQL types
corresponding JDBC types, 4.7.1
PoolConfig() method, 22.3
populate() method, 18.2
prefetching rows, 21.2
suggested default, 21.2.2
prepare a distributed transaction branch, 30.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), 30.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
registerConnectionInitializationCallback, 27.4.3.2
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, 21.2
Remote Method Invocation (RMI), 18.2
removeLogicalTransactionIdEventListener method, 26.2.2.2
REPLAY_INITIAITION_TIMEOUT parameter, 27.5
resource managers, 30.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, 30.2.4
roll back changes to database, 2.3.8
Row Count per Array DML, 21.1.3.4
row prefetching
and data streams, 12.7.3
ROWID class
CursorName methods, A.5.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, Preface

S

savepoints
transaction, 3.2.1
scalar functions, JDBC escape syntax, A.4.2
SCAN
backward compatibility, 29.2.2
configuring the database, 29.2
connection load balancing, 29.2.1
maximum availability architecture environment, 29.3
Oracle connection manager, 29.4
overview, 29.1
version, 29.2.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, 21.1.2.5, 21.1.2.7
server-side internal driver
connection to database, 7.2
server-side Thin driver, overview, 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.4
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.5.1
setDefaultExecuteBatch() method, 21.1.2.2
setDisableStmtCaching() method, 20.2.3
setEscapeProcessing() method, A.4
setExecuteBatch() method, 21.1.2.3
setFetchSize() method, 17.4.1
setFixedCHAR() method, 11.4.7.2
setMaxFieldSize() method, 21.2.3
setNull(), 11.2.3
setNull() method, 11.4.7
setObejct() method, 11.4.6
setObject method, 13.3.5
setObject() method
for CustomDatum objects, 13.3.5
for object references, 15.2.3
for STRUCT objects, 13.2.3
setOracleObject() method, 11.4.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, 22.3
setREF() method, 15.2.3
setRemarksReporting() method, 21.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, 30.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.4
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.5.5
SSL
and LDAP, 8.2
start a distributed transaction branch, 30.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.4
statements
Oracle extensions, 11.3
stopping
statement execution, E.1.4
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.1
retrieving, 13.2.1
retrieving attributes as oracle.sql types, 13.2.1
SYS.ANYDATA, 4.5.4
SYS.ANYTYPE, 4.5.4

T

TABLE_REMARKS columns, 21.2
TABLE_REMARKS reporting
restrictions on, 21.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
server-side, overview, 1.1
time and date literals, JDBC escape syntax, A.4.1
tnsEntry, 8.1.2, 30.5.1
toDatum() method
applied to CustomDatum objects, 13.3.5
toJdbc() method, 4.3.1
toJDBCObject method, 13.3.1
called by setObject method, 13.3.6
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, 30.1
transaction branch ID component, 30.2.5
transaction context
for KPRB driver, 7.3
transaction guard, 26.1, 27
at-most-once execution, 26.1
logical transaction identifier, 26.1
transaction IDs (distributed transactions), 30.1.2
transaction managers, 30.1.1
transaction savepoints, 3.2.1
transactions
switching between local and global, 30.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
unregisterConnectionInitializationCallback method, 27.4.3.3
updatable result sets
limitations, 17.2
refetching rows, 17.5
update conflicts, 17.3
update batching
overview, Oracle vs. standard model, 21.1.1
overview, statements supported, 21.1.1
update batching (Oracle model)
batch value, checking, 21.1.2.4
batch value, overriding, 21.1.2.5
committing changes, 21.1.2.6
connection batch value, setting, 21.1.2.2
connection vs. statement batch value, 21.1.2
default batch value, 21.1.2.1
disable auto-commit, 21.1.2
example, 21.1.2.7
limitations and characteristics, 21.1.2.1
overview, 21.1.2
statement batch value, setting, 21.1.2.3
update counts, 21.1.2.7
update batching (standard model)
adding to batch, 21.1.3.2
clearing the batch, 21.1.3.6
committing changes, 21.1.3.5
error handling, 21.1.3.8
example, 21.1.3.7
executing the batch, 21.1.3.3
intermixing batched and non-batched, 21.1.3.9
overview, 21.1.3
update counts, 21.1.3.7
update counts upon error, 21.1.3.8
update conflicts in result sets, 17.3
update counts
Oracle update batching, 21.1.2.7
standard update batching, 21.1.3.7
upon error (standard batching), 21.1.3.8
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

XA
connection implementation, 30.2.2
connections (definition), 30.1.2
data source implementation, 30.2.1
data sources (definition), 30.1.2
definition, 30.1
error handling, 30.3.3
example of implementation, 30.4
exception classes, 30.3.1
Oracle optimizations, 30.3.4
Oracle transaction ID implementation, 30.2.5
resource implementation, 30.2.3
resources (definition), 30.1.2
transaction ID interface, 30.2.5
XAException, 30.2.4
Xids, 30.2.4