Index

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

---

A

access control

connection attributes, 2.2.2

for connections, 2.2.6

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 (not supported), 2.3.4

asynchronous detection, automatic client failover, 2.7.3

asynchronous updates, JMS/XLA, 3.5

autocommit mode, 2.3.9.1

automatic client failover

asynchronous detection, 2.7.3

overview, features, 2.7.1

synchronous detection, 2.7.2

---

B

batching SQL statements, 5.1.2

binding parameters

array binds (not supported), 2.3.4

duplicate parameters in PL/SQL, 2.3.4.4

duplicate parameters in SQL, 2.3.4.3

how to bind, 2.3.4.1

OUT and IN OUT, 2.3.4.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

cache groups, cache instances affected, 2.4.3.2

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

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.2

opening and closing direct driver connection, 2.2.5

TimesTenXADataSource, JTA, 4.3.2

to TimesTen, 2.2

to XLA, 3.3

user name and passwords, 2.2.3

XAConnection, JTA, 4.3.2

XAResource and Connection, JTA, 4.3.3

connection attributes

first connection attributes, 2.2.2

general connection attributes, 2.2.2

setting programmatically, 2.2.2

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 driver connection, opening and closing, 2.2.5

disconnecting, from TimesTen, 2.2.4

distributed transaction processing--see JTA

DML returning, 2.3.6

driver (JDBC), loading, 2.2.1

DriverManager class, using, 2.2.5

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.2

flags, XLA, 6.1.2

---

G

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

general connection attributes, 2.2.2

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

IN OUT 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.2

Java 5 JAR file, 1.2

Java 6

JAR file, 1.2

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, 2.2.1

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

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 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, 2.2.1

---

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

---

O

ObservableConnection, 2.1.4

ObservableConnectionDS, 2.1.4

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

Oracle Instant Client, 1.2

orai18n.jar version, JMS/XLA, 3.2

OUT parameters, 2.3.4.2

---

P

package imports, JDBC, 2.1.1

packages, required, JTA, 4.3.1

parallel replication, setup and JDBC support, 2.4.4

ParameterMetaData interface support, 2.1.2

parameters

binding, 2.3.4.1

duplicate parameters in PL/SQL, 2.3.4.4

duplicate parameters in SQL, 2.3.4.3

OUT and IN OUT, 2.3.4.2

passthrough, set level with ttOptSetFlag, 2.4.3.1

passwords for connection, 2.2.3

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

Java application tuning, 5.1

JMS/XLA application tuning, 5.2

prepared statement pooling, 5.1.1

ttXlaAcknowledge, 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.2

synchronous updates, JMS/XLA, 3.5

synonyms, 2.3.8

---

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

TimesTenCallableStatement interface, 2.1.5, 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

ttXlaAcknowledge, and performance, 5.2.2

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

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.2

user name for connection, 2.2.3

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