Index

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

A

access control
connection attributes, 2.2.1
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--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
cancel statement, 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

input/output parameters, 2.3.4.2
installing TimesTen and JDK, 1.1
Instant Client, 1.2
isDataStoreValid() method, 2.2.5

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
canceling, 2.1.2
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
TimesTen Cache--see cache
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

V

validity, database, checking, 2.2.5

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