Skip Headers
Oracle® TimesTen In-Memory Database C Developer's Guide
11
g
Release 2 (11.2.2)
E21637-09
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
1/15
Contents
Title and Copyright Information
Preface
Audience
Related documents
Conventions
Documentation Accessibility
What's New
New features in Release 11.2.2.4.0
New features in Release 11.2.2.2.0
New features in Release 11.2.2.0.0
1
C Development Environment
Setting the environment for development
Linking options
Linking without an ODBC driver manager
Linking with an ODBC driver manager
Compiling and linking applications
Compiling and linking applications on Windows
Compiling and linking applications on UNIX
About the TimesTen C demos
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
Access control for connections
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
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
ODBC 3.0 data types
Considering TimesTen features for access control
Handling Errors
Checking for errors
Error and warning levels
Fatal errors
Non-fatal errors
Warnings
Abnormal termination
Recovering after fatal errors
Using automatic client failover in your application
Functionality of automatic client failover
Configuration of automatic client failover
Failover callback functions
3
TimesTen Support for OCI
Overview of OCI
Overview of TimesTen OCI support
OCI libraries and architecture
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
Connecting as an externally identified user in OCI
OCI error reporting
Signal handling and diagnostic framework considerations
OCI demo programs
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 SQL data types
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
Connecting as an externally identified user in Pro*C/C++
Error reporting and handling
Pro*C/C++ demo programs
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 demo
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
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 Functions and Options
Supported ODBC functions
Option support for ODBC connection and statement functions
Option support for SQLSetConnectOption and SQLGetConnectOption
Option support for SQLSetStmtOption and SQLGetStmtOption
Information type support for SQLGetInfo
Column descriptor support for SQLColAttributes
Index
Scripting on this page enhances content navigation, but does not change the content in any way.