Index

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

A

access control

connection attributes, 2.2.1

for connections, 2.2.5

impact in JMS/XLA, 3.1.7

overview of impact, 2.5

acknowledgments, JMS/XLA, 3.1.6

ADD_COLUMNS, JMS/XLA, 6.3.5

array binds--see associative array binding

associative array binding, 2.3.4.5

asynchronous detection, automatic client failover, 2.7.4

asynchronous updates, JMS/XLA, 3.5

autocommit mode, 2.3.9.1

automatic client failover

asynchronous detection, 2.7.4

configuration, 2.7.2

overview, features, 2.7.1

synchronous detection, 2.7.3

B

batching SQL statements, 5.1.2

bind variable--see binding parameters

binding parameters

associative arrays, 2.3.4.5

duplicate parameters in PL/SQL, 2.3.4.4

duplicate parameters in SQL, 2.3.4.3

how to bind, 2.3.4.1

output and input/output, 2.3.4.2

Blob interface support, 2.1.2

bookmarks--see XLA bookmarks

built-in procedures

calling TimesTen built-ins, 2.4.1

ttApplicationContext, 6.1.1

ttCkpt, 2.4.1

ttDataStoreStatus, 2.4.1

ttDurableCommit, 4.2.1

ttXlaBookMarkCreate, 3.5

ttXlaBookmarkDelete, 3.6.2

ttXlaSubscribe, 3.4

ttXlaUnsubscribe, 3.6.3

bulk fetch rows, 5.1.3

bulk insert, update, delete (batching), 5.1.2

C

cache

autorefresh cache groups and XLA, 3.1.8

cache groups, cache instances affected, 2.4.3.2

Oracle password, 2.4.3

set passthrough level, 2.4.3.1

CALL

PL/SQL procedures and functions, 2.4.1

TimesTen built-in procedures, 2.4.1

CallableStatement interface support, 2.1.2

catching errors, 2.6.3

character set for data types, JMS/XLA, 6.4.2

client failover--see automatic client failover

ClientFailoverEvent class, TimesTen, 2.1.6

ClientFailoverEventListener interface, TimesTen, 2.1.6

Clob interface support, 2.1.2

commit

autocommit mode, 2.3.9.1

commit() method, 2.3.9.2

committing changes, 2.3.9

manual commit, 2.3.9.2

SQL COMMIT statement, 2.3.9.3

configuration file, JMS/XLA, 3.1.4

connecting

connection URL, creating, 2.2.1

opening and closing direct connection, 2.2.4

TimesTenXADataSource, JTA, 4.3.2

to TimesTen, 2.2

to XLA, 3.3

user name and passwords, 2.2.2

XAConnection, JTA, 4.3.2

XAResource and Connection, JTA, 4.3.3

connection attributes

first connection attributes, 2.2.1

general connection attributes, 2.2.1

setting programmatically, 2.2.1

connection events, ConnectionEvent support, 2.1.4

Connection interface support, 2.1.2

connection pool, 2.1.4

ConnectionPoolDataSource interface support, 2.1.4

CREATE_INDEX, JMS/XLA, 6.3.3

CREATE_SEQ, JMS/XLA, 6.3.9

CREATE_SYNONYM, JMS/XLA, 6.3.11

CREATE_TABLE, JMS/XLA, 6.3.1

CREATE_VIEW, JMS/XLA, 6.3.7

cursors

closed upon commit, 2.3.9

REF CURSORs, 2.3.5

result set hints and restrictions, 2.3.2

D

data source, JTA, 4.3.2

data types

character set, JMS/XLA, 6.4.2

conversions and performance, 5.1.5

mapping, JMS/XLA, 6.4.1

DatabaseMetaData interface support, 2.1.2

DataSource interface support, 2.1.4

demo applications, Quick Start, 1.4

direct connection, opening and closing, 2.2.4

disconnecting, from TimesTen, 2.2.3

distributed transaction processing--see JTA

DML returning, 2.3.6

driver (JDBC), loading (Java 5), 2.2

DriverManager class, using, 2.2.4

DROP_COLUMNS, JMS/XLA, 6.3.6

DROP_INDEX, JMS/XLA, 6.3.4

DROP_SEQ, JMS/XLA, 6.3.10

DROP_SYNONYM, JMS/XLA, 6.3.12

DROP_TABLE, JMS/XLA, 6.3.2

DROP_VIEW, JMS/XLA, 6.3.8

dropping a table, JMS/XLA, requirements, 3.6.3

DuplicateBindMode general connection attribute, 2.3.4.3

Durable commits, with JTA, 4.2.1

E

environment variables, 1.2

errors

catching and responding, 2.6.3

error levels, 2.6.1

fatal errors, 2.6.1.1

handling, 2.6

non-fatal errors, 2.6.1.2

reporting, 2.6.2

rolling back failed transactions, 2.6.4

warnings, 2.6.1.3

XA/JTA error handling, 4.2.3

escape syntax in SQL functions, 2.3.11

event data formats, JMS/XLA

DDL events, 6.3

DML events, 6.2

event handling, JMS classes, 6.5

exceptions--see errors

executing SQL statements, 2.3.1, 2.3.4.1

extensions, JDBC, supported by TimesTen, 2.1.5

F

failover--see automatic client failover

fatal errors, handling, 2.6.1.1

fetching

multiple rows, 2.3.3

results, simple example, 2.3.1

first connection attributes, 2.2.1

flags, XLA, 6.1.2

G

GDK, JMS/XLA dependency, JMS/XLA, 3.2

general connection attributes, 2.2.1

getString() method, performance, 5.1.4

global transactions, recovery, JTA, 4.2.2

globalization, GDK dependency, JMS/XLA, 3.2

H

header fields, message, JMS/XLA, 6.7

I

IMDB Cache--see cache

input/output parameters, 2.3.4.2

installing TimesTen and JDK, 1.1

Instant Client, 1.2

J

JAR files for Java 5 and Java 6, 1.3

Java 5 JAR file, 1.3

Java 6

JAR file, 1.3

RowId interface support, 2.1.2, 2.3.7

ROWID type, 2.3.7

Java environment variables, 1.2

Java Transaction API--see JTA

java.sql

supported classes, 2.1.3

supported interfaces, 2.1.2

javax.sql, supported interfaces and classes, 2.1.4

JDBC driver, loading (Java 5), 2.2

JDBC support

additional TimesTen interfaces and classes, 2.1.6

java.sql supported classes, 2.1.3

java.sql supported interfaces, 2.1.2

key classes and interfaces, 2.1

package imports, 2.1.1

TimesTen extensions, 2.1.5

JDK, installing, 1.1

JMS/XLA

access control impact, 3.1.7

asynchronous updates, 3.5

bookmarks--see XLA bookmarks

character set for data types, 6.4.2

closing the connection, 3.6.1

concepts, 3.1

configuration file, 3.1.4

connecting to XLA, 3.3

data type mapping, 6.4.1

dropping a table, 3.6.3

event data formats, DDL, 6.3

event data formats, DML, 6.2

event handling, JMS classes, 6.5

flags, 6.1.2

GDK dependency, 3.2

high event rates, 5.2.3

LOB support, 3.4, 3.5

MapMessage contents, 6.1

MapMessage objects, XLA updates, 3.1.5

materialized views and XLA, 3.1.2

message header fields, 6.7

monitoring tables, 3.4

performance tuning, 5.2

receiving and processing updates, 3.5

replication API, 6.6

replication using JMS/XLA, 3.7

synchronous updates, 3.5

table subscriptions, verifying, 3.4

terminating a JMS/XLA application, 3.6

topics, 3.1.4

unsubscribe from a table, 3.6.3

update types, 6.1.1

XLA acknowledge and performance, 5.2.2

XLA acknowledgments, 3.1.6

XLA updates, 3.1.5

JTA

API, 4.3

durable commits, 4.2.1

error handling, XA, 4.2.3

global transactions, recover, 4.2.2

overview, 4.1

packages, required, 4.3.1

requirements, database, 4.2.1

resource manager, 4.1.1

TimesTenXADataSource, 4.3.2

transaction manager, 4.1.1

two-phase commit, 4.1.2

XAConnection, 4.3.2

XAResource, 4.3.3

X/Open DTP model, 4.1.1

L

loading JDBC driver (Java 5), 2.2

LOBs

JDBC, 2.3.8

JMS/XLA support, 3.4, 3.5

overview, 2.3.8

M

MapMessage

contents, 6.1

Map Message objects, XLA updates, 3.1.5

materialized views and XLA, 3.1.2

message header fields, JMS/XLA, 6.7

monitoring tables, JMS/XLA, 3.4

multithreaded environments, 2.3.10

N

NClob interface support, 2.1.2

O

ObservableConnection, 2.1.4

ObservableConnectionDS, 2.1.4

Oracle Globalization Development Kit, supported version, JMS/XLA, 3.2

Oracle Instant Client, 1.2

Oracle password, for cache, 2.4.3

orai18n.jar version, JMS/XLA, 3.2

output parameters, 2.3.4.2

P

package imports, JDBC, 2.1.1

packages, required, JTA, 4.3.1

parallel replication, user-defined, setup and JDBC support, 2.4.4

ParameterMetaData interface support, 2.1.2

parameters

associative arrays, 2.3.4.5

binding, 2.3.4.1

duplicate parameters in PL/SQL, 2.3.4.4

duplicate parameters in SQL, 2.3.4.3

output and input/output, 2.3.4.2

passthrough, set level with ttOptSetFlag, 2.4.3.1

passwords for connection, 2.2.2

performance

batch execution, 5.1.2

bulk fetch rows, 5.1.3

data type conversions, 5.1.5

getString() method, 5.1.4

high event rates, JMS/XLA, 5.2.3

JDBC application tuning, 5.1

JMS/XLA application tuning, 5.2

prepared statement pooling, 5.1.1

XLA acknowledge, 5.2.2

PL/SQL procedures and functions, calling, 2.4.1

pooled connections, client failover, 2.7.1.2

PooledConnection interface support, 2.1.4

pooling prepared statements, 5.1.1

prefetching

and performance, 5.2.1

fetching multiple rows, 2.3.3

xlaPrefetch parameter, 5.2.1

prepared statement

pooling, 5.1.1

sharing, 2.3.4.1

PreparedStatement interface support, 2.1.2

preparing SQL statements, 2.3.4.1, 2.3.4.1

privileges--see access control

Q

query threshold (or for any SQL), 2.4.2.2

query timeout (or for any SQL), 2.4.2.1

query, executing, 2.3.1

Quick Start demo applications and tutorials, 1.4

R

recovery, global transactions, JTA, 4.2.2

REF CURSORs, 2.3.5

replicated bookmarks, JMS/XLA, 3.1.3.2

replication

JMS/XLA replication API, 6.6

using JMS/XLA, 3.7

resource manager, JTA, 4.1.1

result sets, hints and restrictions, 2.3.2

ResultSet interface support, 2.1.2

ResultSetMetaData interface support, 2.1.2

RETURNING INTO clause, 2.3.6

rollback

rollback() method, 2.3.9.2

rolling back failed transactions, 2.6.4

SQL ROLLBACK, 2.3.9.3

rowids

RowId interface support, 2.1.2, 2.3.7

rowid support, 2.3.7

ROWID type, 2.3.7

S

security--see access control

Statement interface support, 2.1.2

statements

executing, 2.3.1, 2.3.4.1

preparing, 2.3.4.1, 2.3.4.1

subscriptions (JMS/XLA), table, verifying, 3.4

synchronous detection, automatic client failover, 2.7.3

synchronous updates, JMS/XLA, 3.5

T

table subscriptions (JMS/XLA), verifying, 3.4

target database

applying messages, 3.7.1

checking conflicts, 3.7.1

creating, 3.7.1

manual commit, 3.7.1

rollback, 3.7.1

TargetDataStore interface, JMS/XLA

error recovery, 3.7.2

methods, 6.6.1

TargetDataStoreImpl class, JMS/XLA, 6.6.2

terminating a JMS/XLA application, 3.6

threads, multithreaded environments, 2.3.10

threshold for SQL statements, 2.4.2.2

timeout for SQL statements, 2.4.2.1

TimesTenBlob interface, 2.1.5

TimesTenCallableStatement interface, 2.1.5, 2.1.5

TimesTenClob interface, 2.1.5

TimesTenConnection interface, 2.1.5, 2.1.5

TimesTenPreparedStatement interface, 2.1.5, 2.1.5

TimesTenStatement interface, 2.1.5, 2.1.5

TimesTenTypes interface, 2.1.6

TimesTenVendorCode interface, 2.1.6, 2.6.3

TimesTenXADataSource, JTA, 4.3.2

topics, JMS/XLA, 3.1.4

transaction manager, JTA, 4.1.1

TRUNCATE, JMS/XLA, 6.3.13

ttApplicationContext built-in procedure, 6.1.1

ttCkpt built-in procedure, 2.4.1

ttDataStoreStatus built-in procedure, 2.4.1

ttXlaBookmarkCreate built-in procedure, 3.5

ttXlaBookmarkDelete built-in procedure, 3.6.2

ttXlaSubscribe built-in procedure, 3.4

ttXlaUnsubscribe built-in procedure, 3.6.3

tuning

JDBC applications (performance), 5.1

JMS/XLA applications (performance), 5.2

two-phase commit, JTA, 4.1.2

U

unsubscribe from a table, JMS/XLA, 3.6.3

update types, XLA, 6.1.1

update, executing, 2.3.1

updates, receiving and processing, JMS/XLA, 3.5

URL for connection, 2.2.1

user name for connection, 2.2.2

UTF-16 character set for data types, JMS/XLA, 6.4.2

W

warnings, 2.6.1.3

X

XAConnection, JTA, 4.3.2

XADataSource interface support, 2.1.4

XAResource and Connection, JTA, 4.3.3

XA--see JTA

XLA bookmarks

deleting, 3.6.2

overview, 3.1.3

replicated bookmarks, 3.1.3.2

xlaPrefetch parameter, 5.2.1

XLA--see JMS/XLA

X/Open DTP model, 4.1.1