Skip Headers
Oracle® TimesTen In-Memory Database TTClasses Guide
11g Release 2 (11.2.2)

E21640-07
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  L  M  N  O  P  Q  R  S  T  U  W  X 

A

access control
connections, 2.4.3
CREATE SESSION privilege to connect, 2.4.3.2
in XLA, 2.7.3
TimesTen features, 2.3
acknowledging XLA updates
ackUpdates method, 3.3.1.3.1
at transaction boundaries, 2.7.2
without transaction boundaries, 2.7.1
ackUpdates method (XLA), 3.3.1.3.1
add method (add table handler to XLA table list), 3.3.4.3.1
AddConnectionToPool method, 3.1.4.3.1
AIX, linking considerations, 1.2.1
autocommit, 3.1.3.3.10

B

batch operations
bind parameter, 3.1.5.5.2
execute, 3.1.5.5.3
prepare, 3.1.5.5.4
size of batch, 3.1.5.5.1
TTCmd methods, 3.1.5.5
batchSize method, 3.1.5.5.1
bind variable--see binding parameters
binding parameters
duplicate parameters in SQL, 2.5.1.4
input parameters, 2.5.1.1
length of bound value, setting (batch), 3.1.5.5.5
length of bound value, setting (non-batch), 3.1.5.3.23
null value, setting (batch), 3.1.5.5.6
null value, setting (non-batch), 3.1.5.3.24
output and input/output parameters, 2.5.1.3
registering parameters, 2.5.1.2
registerParam method, 3.1.5.3.19
set parameter value (batch), 3.1.5.5.2
set parameter value (non-batch), 3.1.5.3.22
BindParameter method (bind parameter, batch), 3.1.5.5.2
bookmark
acquire location, 3.3.1.3.6
delete, 3.3.1.3.3
return to location, 3.3.1.3.7

C

catalog
catalog class (metadata information, tables), 3.2.1
column class (metadata information, column), 3.2.3
fetch catalog data, 3.2.1.2.1
index class (metadata information, index), 3.2.4
special column class (metadata information, special column), 3.2.5
system catalog classes, 3.2
table class (metadata information, single table), 3.2.2
client/server, deferred prepare, 3.1.5.3.17
Close method (close result set), 3.1.5.3.1
column class, catalog, 3.2.3
column, number of columns, return, 3.2.2.2.3
columnPrec method (XLA row viewer), 3.3.2.3.1
columnScale method (XLA row viewer), 3.3.2.3.2
Commit method, 3.1.3.3.1
compiler macros
64-bit TimesTen, 1.1.3.4
C++ streams, 1.1.3.2
gcc, 1.1.3.5
throw C++ exceptions, 1.1.3.1
TT_64BIT, 1.1.3.4
TTC_USE_STRINGSTREAM, 1.1.3.2.1
TTDEBUG, 1.1.3.3
TTEXCEPT, 1.1.3.1
USE_OLD_CPP_STREAMS, 1.1.3.2.3
compiling
applications, 1.2
applications on UNIX, 1.2.1
applications on Windows, 1.2.2
TTClasses on UNIX, 1.1.1.2
TTClasses on Windows, 1.1.2.2
UNIX compilation options for TTClasses, 1.1.1.3
Windows compilation options for TTClasses, 1.1.2.3
Connect method
description, 3.1.3.3.2
example, 2.2
XLA, 3.3.1.3.2
connection
access control, 2.4.3
autocommit, 3.1.3.3.10
confirm connection, 3.1.3.3.7
connect (XLA), 3.3.1.3.2
Connect method example, 2.2
connecting, 3.1.3.3.2
connecting and disconnecting, 2.4.2
connection class definition, 2.2
connection pools, 3.1.4
context value, 3.1.3.3.6
CREATE SESSION privilege, 2.4.3.2
disconnect (XLA), 3.3.1.3.4
Disconnect method example, 2.2
disconnecting, 3.1.3.3.3
managing connections, 2.4
ODBC connection handle, 3.1.3.3.5
privilege for XLA connections, 2.4.3.3
TTConnection class, 3.1.3
validity check, 3.1.2.4.1
XLA, privilege for connections, 2.4.3.3
connection pool
adding connection to pool, 3.1.4.3.1
connecting all connections in pool, 3.1.4.3.2
disconnecting all connections in pool, 3.1.4.3.3
getting a connection from pool, 3.1.4.3.5
returning a connection to pool, 3.1.4.3.4
status information, 3.1.4.3.6
TTConnectionPool class, 3.1.4
CREATE SESSION privilege, 2.4.3.2

D

data source names (DSNs), 2.4.1
debugging
debug libraries, shared and static (UNIX), 1.1.1.3
generating information, 1.1.3.3
shared debug library (UNIX), 1.1.1.3
static debug library (UNIX), 1.1.1.3
deferred prepare, client/server, 3.1.5.3.17
del method (delete table handler from XLA table list), 3.3.4.3.2
delete TTClasses libraries and object files
UNIX, 1.1.1.3
Windows, 1.1.2.3
deleteBookmarkAndDisconnect method, 3.3.1.3.3
demos for TTClasses, 1.3
disableLogging method, 3.1.1.3.1
DisableTracking method (XLA table handler), 3.3.3.4.1
Disconnect method
description, 3.1.3.3.3
XLA, 3.3.1.3.4
DisconnectAll method, 3.1.4.3.3
DO_NOT_THROW flag (TTStatus), suppress exceptions, 3.1.2.1
driver manager
restrictions, 1.2.3
shared optimized library for driver manager (Windows), 1.1.2.3
Drop method (drop prepared statement), 3.1.5.3.2
DSNs (data source names), 2.4.1
duplicate parameter binding, 2.5.1.4
DuplicateBindMode general connection attribute, 2.5.1.4
DurableCommit method, 3.1.3.3.4

E

EnableTracking method (XLA table handler), 3.3.3.4.2
environment handle, ODBC, 3.1.1.3.4
environment variables
UNIX, 1.1.1.1
Windows, 1.1.2.1
error reporting
print error to stream, 3.1.2.4.2
suppress exceptions, DO_NOT_THROW flag, 3.1.2.1
try/catch with TTStatus, 3.1.2.1
TTError class, 3.1.2.2.1
TTStatus class, 3.1.2
TTWarning class, 3.1.2.2.2
Execute method (execute statement), 3.1.5.3.3
ExecuteBatch method, 3.1.5.5.3
ExecuteImmediate method (instead of Prepare and Execute), 3.1.5.3.4

F

fetch result set row, 3.1.5.3.5
fetchCatalogData method, 3.2.1.2.1
FetchNext method (fetch result set row), 3.1.5.3.5
fetchUpdatesWait method (XLA), 3.3.1.3.5
freeConnection method, 3.1.4.3.4

G

gcc, using to compile TTClasses, 1.1.3.5
generateSQL method (XLA table handler), 3.3.3.4.3
Get method (column value, XLA row viewer), 3.3.2.3.3
getBookmarkIndex method (XLA), 3.3.1.3.6
getCollation method (index), 3.2.4.2.1
getColName method (XLA column), 3.3.6.3.1
getColNumber method (XLA table), 3.3.5.3.1
getColumn method
catalog, column, 3.2.2.2.1
description, 3.1.5.3.6
metadata, XLA row viewer, 3.3.2.3.4
getColumnLength method, 3.1.5.3.7
getColumnName method
catalog, column, 3.2.3.2.1
description, 3.1.5.4.1
index, 3.2.4.2.2
getColumnName method (special column), 3.2.5.3.1
getColumnNullability method, 3.1.5.4.2
getColumnNullable method, 3.1.5.3.8
getColumnPrecision method, 3.1.5.4.3
getColumnScale method, 3.1.5.4.4
getColumnType method, 3.1.5.4.5
getDataType method
column, 3.2.3.2.2
special column, 3.2.5.3.2
getHdbc method, 3.1.3.3.5
getIndex method, 3.2.2.2.2
getIndexName method, 3.2.4.2.3
getIndexOwner method, 3.2.4.2.4
getLength method
column, 3.2.3.2.3
special column, 3.2.5.3.3
getMaxRows method, 3.1.5.3.10
getNCols method (number of columns, XLA table), 3.3.5.3.2
getNColumns method, 3.1.5.4.6
getNextColumn method, 3.1.5.3.11
getNextColumnNullable method, 3.1.5.3.12
getNParameters method, 3.1.5.4.7
getNullable method (column), 3.2.3.2.4
getNumColumns method
index, 3.2.4.2.5
table, 3.2.2.2.3
getNumIndexes method, 3.2.2.2.4
getNumSpecialColumns method, 3.2.2.2.5
getNumSysTables method, 3.2.1.2.2
getNumTables method, 3.2.1.2.3
getNumUserTables method, 3.2.1.2.4
getOwnerName method (XLA table), 3.3.5.3.3
getParam method, 3.1.5.3.13
getParamNullability method, 3.1.5.4.8
getParamPrecision method, 3.1.5.4.9
getParamScale method, 3.1.5.4.10
getParamType method, 3.1.5.4.11
getPrecision method
column, 3.2.3.2.5
special column, 3.2.5.3.4
XLA column, 3.3.6.3.2
getQueryThreshold method, 3.1.5.3.14
getRadix method, column, 3.2.3.2.6
getRowCount method, 3.1.5.3.15
getScale method
column, 3.2.3.2.7
special column, 3.2.5.3.5
XLA column, 3.3.6.3.3
getSize method (XLA column), 3.3.6.3.4
getSpecialColumn method, 3.2.2.2.6
getStats method, 3.1.4.3.6
getSysColNum method (XLA column), 3.3.6.3.5
getTable method, 3.2.1.2.5
getTableIndex method, 3.2.1.2.6
getTableName method
catalog, table, 3.2.2.2.7
index, 3.2.4.2.6
XLA table, 3.3.5.3.4
getTableOwner method, 3.2.2.2.8
getTableType method, 3.2.2.2.9
GetTTContext method, 3.1.3.3.6
getType method
index, 3.2.4.2.7
XLA column, 3.3.6.3.6
getTypeName method
column, 3.2.3.2.8
special column, 3.2.5.3.6
getUserColNum method (XLA column), 3.3.6.3.7
getUserTable method, 3.2.1.2.7

H

HandleChange method
XLA table handler, 3.3.3.4.4
XLA table list, 3.3.4.3.3
HandleDelete method (XLA table handler), 3.3.3.4.5
HandleInsert method (XLA table handler), 3.3.3.4.6
HandleUpdate method (XLA table handler), 3.3.3.4.7
HDBC (connection) handle, ODBC, 3.1.3.3.5
HENV (environment) handle, ODBC, 3.1.1.3.4
HSTMT (statement) handle, ODBC, 3.1.5, 3.1.5.3.9

I

index class, catalog, 3.2.4
index, number of indexes, return, 3.2.2.2.4
input parameters, 2.5.1.1
I/O streams, C++ flag settings, 1.1.3.2
isBeingExecuted method, 3.1.5.4.12
isColumnNull method, 3.1.5.3.16
isColumnTTTimestamp method (XLA row viewer), 3.3.2.3.5
isConnected method, 3.1.3.3.7
isConnectionInvalid method, 3.1.2.4.1
isNull method (column, XLA row viewer), 3.3.2.3.6
isNullable method (XLA column), 3.3.6.3.8
isolation level
Read Committed, 3.1.3.3.11
Serializable, 3.1.3.3.12
isPKColumn method (primary key, XLA column), 3.3.6.3.9
isSystemTable method, 3.2.2.2.10
isTTTimestamp method (XLA column), 3.3.6.3.10
isUnique method (index), 3.2.4.2.8
isUpdated method (XLA column), 3.3.6.3.11
isUserTable method, 3.2.2.2.11

L

linking applications
AIX considerations, 1.2.1
on UNIX, 1.2.1
on Windows, 1.2.2
references to related information, 1.2
Solaris considerations, 1.2.1
LOBs
TimesTen support, 2.5.4
XLA support, 2.7
lock timeout interval, 3.1.3.3.13
logging
disable, 3.1.1.3.1
levels, 3.1.1.3.2
logging information, where to send, 3.1.1.3.3
TTGlobal class, 3.1.1
using, 2.6

M

macros--see compiler macros
make
clean, delete TTClasses libraries and object files (UNIX), 1.1.1.3
clean, delete TTClasses libraries and object files (Windows), 1.1.2.3
debug libraries (UNIX), 1.1.1.3
optimized libraries (UNIX), 1.1.1.3
optimized libraries, direct and client/server (Windows), 1.1.2.3
optimized library, client/server (Windows), 1.1.2.3
shared debug library (UNIX), 1.1.1.3
shared optimized library (UNIX), 1.1.1.3
shared optimized library for driver manager (Windows), 1.1.2.3
static debug library (UNIX), 1.1.1.3
static optimized library (UNIX), 1.1.1.3
metadata
column, 3.2.3
index, 3.2.4
number of system tables, 3.2.1.2.2
number of tables, 3.2.1.2.3
number of user tables, 3.2.1.2.4
special column, 3.2.5
table, single, 3.2.2
tables, 3.2.1
multithreaded applications, 3.1.4

N

name of table, return, 3.2.2.2.7
numUpdatedCols method (XLA row viewer), 3.3.2.3.7

O

ODBC
HDBC (connection) handle, 3.1.3.3.5
HENV (environment) handle, 3.1.1.3.4
HSTMT (statement) handle, 3.1.5, 3.1.5.3.9
optimized library
client/server (Windows), 1.1.2.3
direct and client/server (Windows), 1.1.2.3
for driver manager (Windows), 1.1.2.3
shared (UNIX), 1.1.1.3
shared and static (UNIX), 1.1.1.3
static (UNIX), 1.1.1.3
ostream method, 3.1.2.4.2
OUT and IN OUT parameters
getting output values, 3.1.5.3.13
registering, 2.5.1.2
output and input/output parameters
binding, 2.5.1.3
owner of table, return, 3.2.2.2.8

P

parameter binding--see binding parameters
prefetch, 3.1.3.3.15
Prepare method (prepare statement), 3.1.5.3.17
PrepareBatch method, 3.1.5.5.4
printColumn method, 3.1.5.3.18

Q

query--see result set
Quick Start demos for TTClasses, 1.3

R

REF CURSORs
getParam method for REF CURSORs, 3.1.5.3.13
using, 2.5.2
registerParam method, 2.5.1.2, 3.1.5.3.19
RePrepare method (after invalidation), 3.1.5.3.20
result set
close, 3.1.5.3.1
fetch a column of current row, 3.1.5.3.6
fetch next column of current row, 3.1.5.3.11
fetch row, 3.1.5.3.5
maximum rows, 3.1.5.3.21
print value of a column of current row, 3.1.5.3.18
Rollback method, 3.1.3.3.8
rowids, ROWID type, 2.5.3

S

SetAutoCommitOff method, 3.1.3.3.9
SetAutoCommitOn method, 3.1.3.3.10
setBookmarkIndex method (XLA), 3.3.1.3.7
SetIsoReadCommitted method, 3.1.3.3.11
SetIsoSerializable method, 3.1.3.3.12
SetLockWait method, 3.1.3.3.13
setLogLevel method, 3.1.1.3.2
setLogStream method, 3.1.1.3.3
setMaxRows method, 3.1.5.3.21
setParam method (bind parameter, non-batch), 3.1.5.3.22
setParamLength method
batch operations, 3.1.5.5.5
non-batch operations, 3.1.5.3.23
setParamNull method
batch operations, 3.1.5.5.6
non-batch operations, 3.1.5.3.24
SetPrefetchCloseOff method, 3.1.3.3.14
SetPrefetchCloseOn method, 3.1.3.3.15
SetPrefetchCount method, 3.1.3.3.16
setQueryThreshold method, 3.1.5.3.25
setQueryTimeout method, 3.1.5.3.26
setTuple method (XLA row viewer), 3.3.2.3.8
shared debug library (UNIX), 1.1.1.3
shared optimized library (UNIX), 1.1.1.3
size of batch, 3.1.5.5.1
Solaris, linking considerations, 1.2.1
special column class, catalog, 3.2.5
SQL statements
drop, 3.1.5.3.2
execute, 3.1.5.3.3
execute immediate (instead of prepare and execute), 3.1.5.3.4
execution, confirm, 3.1.5.4.12
number of rows affected, 3.1.5.3.15
prepare, 3.1.5.3.17
reprepare (after invalidation), 3.1.5.3.20
timeouts and thresholds, 2.5.5
TTCmd class, 3.1.5
sqlhenv method, 3.1.1.3.4
statement handle, ODBC, 3.1.5, 3.1.5.3.9
statements--see SQL statements
static debug library (UNIX), 1.1.1.3
static optimized library (UNIX), 1.1.1.3
streams, C++ flag settings, 1.1.3.2
system catalog--see catalog

T

table class, catalog, 3.2.2
threshold, SQL statements, 2.5.5
throwError method, 3.1.2.4.3
timeout, SQL statements, 2.5.5
transaction
acknowledge XLA updates at transaction boundaries, 2.7.2
acknowledge XLA updates without transaction boundaries, 2.7.1
autocommit, 3.1.3.3.10
committing, 3.1.3.3.1
durable commit, 3.1.3.3.4
isolation level, Read Commited, 3.1.3.3.11
isolation level, Serializable, 3.1.3.3.12
log API, overview, 2.7
rolling back, 3.1.3.3.8
TT_64BIT compiler macro, 1.1.3.4
TTC_USE_STRINGSTREAM compiler macro, 1.1.3.2.1
TTCatalog class (metadata information, tables), 3.2.1
TTCatalogColumn class
metadata information, column, 3.2.3
return a TTCatalogColumn object, 3.2.2.2.1
TTCatalogIndex class
metadata information, index, 3.2.4
return a TTCatalogIndex object, 3.2.2.2.2
TTCatalogSpecialColumn class
metadata information, special column, 3.2.5
return a TTCatalogSpecialColumn object, 3.2.2.2.6
TTCatalogTable class
metadata information, single table, 3.2.2
return a TTCatalogTable object, 3.2.1.2.5
TTCmd class (SQL statement)
batch operations, 3.1.5.5
general use, 3.1.5.3
introduction and overview, 3.1.5
non-batch operations, 3.1.5.3
object properties, obtaining, 3.1.5.4
overview, using, 2.2
TTConnection class
description, 3.1.3
overview, using, 2.2
TTConnectionPool class
description, 3.1.4
overview, using, 2.2
TTDEBUG compiler macro, 1.1.3.3
TTError class, 3.1.2.2.1
TTEXCEPT compiler macro, 1.1.3.1
TTGlobal class (logging), 3.1.1
TTStatus class (error reporting), 3.1.2
TTWarning class, 3.1.2.2.2
TTXlaColumn class, 3.3.6
TTXlaPersistConnection class, 3.3.1
TTXlaRowViewer class, 3.3.2
TTXlaTable class, 3.3.5
TTXlaTableHandler class, 3.3.3
TTXlaTableList class, 3.3.4

U

UNIX
compilation options for TTClasses, 1.1.1.3
compiling and linking applications, 1.2.1
compiling TTClasses, 1.1.1.2
environment variables, 1.1.1.1
installing TTClasses library, 1.1.1.4
updatedCol method (XLA row viewer), 3.3.2.3.9
USE_OLD_CPP_STREAMS compiler macro, 1.1.3.2.3

W

Windows
compilation options for TTClasses, 1.1.2.3
compiling and linking applications, 1.2.2
compiling TTClasses, 1.1.2.2
environment variables, 1.1.2.1

X

XLA
access control, 2.7.3
ackUpdates method, acknowledge updates, 3.3.1.3.1
bookmark location, acquire, 3.3.1.3.6
bookmark location, return, 3.3.1.3.7
classes, 2.7
classes to use XLA, 3.3
column class, 3.3.6
connect, 3.3.1.3.2
connection, create, 3.3.1
connections, privilege, 2.4.3.3
delete bookmark, 3.3.1.3.3
disconnect, 3.3.1.3.4
fetch records, 3.3.1.3.5
LOB support, 2.7
privilege for connections, 2.4.3.3
row viewer class, 3.3.2
table class, 3.3.5
table handler class, 3.3.3
table list class, 3.3.4
updates, acknowledging at transaction boundaries, 2.7.2
updates, acknowledging without transaction boundaries, 2.7.1