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
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
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
Oracle password, for cache, 2.4.3
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