Go to main content
1/15
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
What's New
New features in Release 18.1.1.2.0
New features in Release 18.1.1.1.0
1
C Development Environment
Setting the environment for development
Linking options
Considerations for linking without an ODBC driver manager
Considerations for linking with an ODBC driver manager
Compiling and linking applications
Compiling and linking applications on Windows
Compiling and linking applications on Linux or UNIX
TimesTen Quick Start and sample applications
2
Working with TimesTen Databases in ODBC
Managing TimesTen database connections
SQLConnect, SQLDriverConnect, SQLAllocConnect, SQLDisconnect functions
Connecting to and disconnecting from a database
Setting connection attributes programmatically
Using a default DSN
Managing TimesTen data
TimesTen include files
SQL statement execution within C applications
SQLExecDirect and SQLExecute functions
Executing a SQL statement
Preparing and executing queries and working with cursors
TimesTen deferred prepare
Prefetching multiple rows of data
Optimizing query performance
Binding parameters and executing statements
SQLBindParameter function
Determination of parameter type assignments and type conversions
Binding input parameters
Binding output parameters
Binding input/output parameters
Binding duplicate parameters in SQL statements
Binding duplicate parameters in PL/SQL
Considerations for floating point data
Using SQL_WCHAR and SQL_WVARCHAR with a driver manager
Working with REF CURSORs
Working with DML returning (RETURNING INTO clause)
Working with rowids
Working with LOBs
About LOBs
Differences between TimesTen LOBs and Oracle Database LOBs
LOB programming interfaces
Using the LOB simple data interface in ODBC
Using the LOB piecewise data interface in ODBC
Passthrough LOBs in ODBC
Making and committing changes to the database
Using additional TimesTen data management features
Using CALL to execute procedures and functions
Setting a timeout or threshold for executing SQL statements
Setting a timeout duration for SQL statements
Setting a threshold duration for SQL statements
Features for use with TimesTen Cache
Setting temporary passthrough level with the ttOptSetFlag built-in procedure
Determining passthrough status
Managing cache groups
Setting globalization options
TT_NLS_SORT
TT_NLS_LENGTH_SEMANTICS
TT_NLS_NCHAR_CONV_EXCP
Features for use with replication
Handling Errors
Checking for errors
Error and warning levels
Fatal errors
Non-fatal errors
Warnings
Abnormal termination
Recovering after fatal errors
Retrying after transient errors (ODBC)
Using automatic client failover in your application
Functionality of automatic client failover
Configuration of automatic client failover
Failover callback functions
Application action in the event of failover
Application steps for failover
Failover delay and retry settings
Client routing API for TimesTen Scaleout
Creating a grid map and distribution
Setting the distribution key values
Getting the element location given a set of key values
Get the element IDs
Get the replica set ID
Supported data types
Restrictions
Failure modes
3
TimesTen Support for OCI
Overview of OCI
Overview of TimesTen OCI support
OCI in TimesTen
Globalization support
Character sets
Additional globalization features
TimesTen restrictions and differences
Oracle Database features not supported
Additional TimesTen OCI restrictions
Additional TimesTen OCI differences
The ttSrcScan utility
Getting started with TimesTen OCI
Environment variables for TimesTen OCI
Compiling and linking OCI applications
Connecting to a TimesTen database from OCI
Using the tnsnames naming method to connect
Using an easy connect string to connect
Configuring whether to use tnsnames.ora or easy connect
OCI error handling
OCI error reporting
Transient errors (OCI)
Signal handling and diagnostic framework considerations
Use of additional features with TimesTen OCI
TimesTen deferred prepare
Parameter binding features in TimesTen OCI
Duplicate parameter bindings in TimesTen OCI
Associative array bindings in TimesTen OCI
TimesTen Cache with TimesTen OCI
Specifying the Oracle Database password in OCI for TimesTen Cache
Determining the number of cache groups affected by an action
LOBs in TimesTen OCI
LOB locators in OCI
Temporary LOBs in OCI
Differences between TimesTen LOBs and Oracle Database LOBs in OCI
Using the LOB simple data interface in OCI
Using the LOB locator interface in OCI
OCI client-side buffering
LOB prefetching in OCI
Passthrough LOBs in OCI
Use of PL/SQL in OCI to call a TimesTen built-in procedure
TimesTen OCI support reference
Supported OCI calls
Supported handles and attributes
Supported descriptors
Supported OCI-defined constants
Supported parameter attributes
4
TimesTen Support for Pro*C/C++
Overview of the Oracle Pro*C/C++ Precompiler
Overview of TimesTen support for Pro*C/C++
TimesTen OCI support
Embedded SQL support and restrictions
Semantic checking restrictions
Embedded PL/SQL restrictions
Transaction restrictions
Connection restrictions
Summary of unsupported or restricted executable commands and clauses
The ttSrcScan utility
Getting started with TimesTen Pro*C/C++
Environment and configuration for TimesTen Pro*C/C++
Building a Pro*C/C++ application
Connecting to a TimesTen database from Pro*C/C++
Connection syntax and parameters
Using tnsnames or easy connect
Specifying the Oracle Database password in Pro*C/C++ for TimesTen Cache
Error reporting and handling
Additional features of TimesTen Pro*C/C++
Associative array bindings in TimesTen Pro*C/C++
LOBs in TimesTen Pro*C/C++
Using the LOB simple data interface in Pro*C/C++
Using the LOB locator interface in Pro*C/C++
TimesTen Pro*C/C++ Precompiler options
Precompiler option support
Setting precompiler options
5
XLA and TimesTen Event Management
XLA concepts
XLA basics
How XLA reads records from the transaction log
About XLA and materialized views
About XLA bookmarks
Creating or reusing a bookmark
How bookmarks work
Replicated bookmarks
XLA bookmarks and transaction log holds
About XLA data types
Access control impact on XLA
XLA limitations
XLA sample application
Writing an XLA event-handler application
Obtaining a database connection handle
Initializing XLA and obtaining an XLA handle
Specifying which tables to monitor for updates
Retrieving update records from the transaction log
Inspecting record headers and locating row addresses
Inspecting column data
Obtaining column descriptions
Reading fixed-length column data
Reading NOT INLINE variable-length column data
Null-terminating returned strings
Converting complex data types
Detecting null values
Putting it all together: a PrintColValues() function
Handling XLA errors
Dropping a table that has an XLA bookmark
Deleting bookmarks
Terminating an XLA application
Using XLA as a replication mechanism
Checking table compatibility between databases
Checking table and column descriptions
Checking table and column versions
Replicating updates between databases
Handling timeout and deadlock errors
Checking for update conflicts
Replicating updates to a non-TimesTen database
Other XLA features
Changing the location of a bookmark
Passing application context
6
Distributed Transaction Processing: XA
Overview of XA
X/Open DTP model
Two-phase commit
Using XA in TimesTen
TimesTen database requirements for XA
Global transaction recovery in TimesTen
Considerations in using standard XA functions with TimesTen
xa_open()
xa_close()
Transaction id (XID) parameter
TimesTen tt_xa_context function to obtain ODBC handle from XA connection
Considerations in calling ODBC functions over XA connections in TimesTen
Autocommit
Local transaction COMMIT and ROLLBACK
Closing open cursors
XA resource manager switch
xa_switch_t
tt_xa_switch
XA error handling in TimesTen
XA support through the Windows ODBC driver manager
Issues to consider
Linking to the TimesTen ODBC XA driver manager extension library
Configuring Tuxedo to use TimesTen XA
Update the $TUXDIR/udataobj/RM file
Build the Tuxedo transaction manager server
Update the GROUPS section in the UBBCONFIG file
Compile the servers
7
ODBC Application Tuning
Bypass driver manager if appropriate
Using arrays of parameters for batch execution
Avoid excessive binds
Avoid SQLGetData
Avoid data type conversions
Bulk fetch rows of TimesTen data
Optimize queries
8
TimesTen Utility API
ttBackup
ttDestroyDataStore
ttDestroyDataStoreForce
ttRamGrace
ttRamLoad
ttRamPolicy
ttRamUnload
ttRepDuplicateEx
ttRestore
ttUtilAllocEnv
ttUtilFreeEnv
ttUtilGetError
ttUtilGetErrorCount
ttXactIdRollback
9
XLA Reference
About XLA functions
About return codes
About parameter types (input, output, input/output)
About results output by functions
About required privileges
Summary of XLA functions by category
XLA core functions
XLA data type conversion functions
XLA replication functions
XLA function reference
ttXlaAcknowledge
ttXlaClose
ttXlaConvertCharType
ttXlaDateToODBCCType
ttXlaDecimalToCString
ttXlaDeleteBookmark
ttXlaError
ttXlaErrorRestart
ttXlaGetColumnInfo
ttXlaGetLSN
ttXlaGetTableInfo
ttXlaGetVersion
ttXlaNextUpdate
ttXlaNextUpdateWait
ttXlaNumberToBigInt
ttXlaNumberToCString
ttXlaNumberToDouble
ttXlaNumberToInt
ttXlaNumberToSmallInt
ttXlaNumberToTinyInt
ttXlaNumberToUInt
ttXlaOraDateToODBCTimeStamp
ttXlaOraTimeStampToODBCTimeStamp
ttXlaPersistOpen
ttXlaRowidToCString
ttXlaSetLSN
ttXlaSetVersion
ttXlaTableByName
ttXlaTableStatus
ttXlaTableVersionVerify
ttXlaTimeToODBCCType
ttXlaTimeStampToODBCCType
ttXlaVersionColumnInfo
ttXlaVersionCompare
ttXlaVersionTableInfo
XLA replication function reference
ttXlaApply
ttXlaCommit
ttXlaGenerateSQL
ttXlaLookup
ttXlaRollback
ttXlaTableCheck
C data structures used by XLA
ttXlaNodeHdr_t
ttXlaUpdateDesc_t
Special update data formats
Locating the row data following a ttXlaUpdateDesc_t header
ttXlaVersion_t
ttXlaTblDesc_t
ttXlaTblVerDesc_t
ttXlaColDesc_t
tt_LSN_t
tt_XlaLsn_t
10
TimesTen ODBC Support
TimesTen ODBC 3.5 support
Using ODBC 3.5 with TimesTen
Client/server cross-release restrictions with ODBC 3.5
ODBC 3.5 new and replacement function support
ODBC 3.5 data type support notes
Environment attribute support for ODBC 3.5
Attribute support for ODBC 3.5 SQLSetConnectAttr and SQLGetConnectAttr
Attribute support for ODBC 3.5 SQLSetStmtAttr and SQLGetStmtAttr
TimesTen field identifiers for ODBC 3.5 SQLColAttribute
Information type support for ODBC 3.5 SQLGetInfo
TimesTen SQL keywords for ODBC 3.5
TimesTen ODBC 2.5 support
Using ODBC 2.5 with TimesTen
ODBC 2.5 function support
Option support for ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption
Option support for ODBC 2.5 SQLSetStmtOption and SQLGetStmtOption
Column descriptor support for ODBC 2.5 SQLColAttributes
Information type support for ODBC 2.5 SQLGetInfo
TimesTen SQL keywords for ODBC 2.5
ODBC API incompatibilities with previous versions of TimesTen
ODBC 3.5 function signatures that have changed
ODBC 2.5 function signatures that have changed
ODBC data types that have changed
Index
Scripting on this page enhances content navigation, but does not change the content in any way.