Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility
• Technical support

What's New

• New features in Release 11.2.1.7.0
• New features in Release 11.2.1.6.0
• New features in Release 11.2.1.4.0
• New features in Release 11.2.1.1.0

1 Java Development Environment

• Installing TimesTen and the JDK
• Setting the environment for Java development
• Compiling Java applications
• About the TimesTen Java demos

2 Working with TimesTen Databases

• Key JDBC classes and interfaces
  • Package imports
  • Support for interfaces in the java.sql package
  • Support for classes in the java.sql package
  • Support for interfaces and classes in the javax.sql package
  • TimesTen JDBC extensions
  • Additional TimesTen classes and interfaces
• Managing TimesTen database connections
  • Load the TimesTen driver
  • Create a connection URL for the database and specify connection attributes
  • Connect to the database
  • Disconnect from the database
  • Opening and closing a direct driver connection
  • Access control for connections
• Managing TimesTen data
  • Executing simple SQL statements
  • Working with TimesTen result sets: hints and restrictions
  • Fetching multiple rows of data
  • Binding parameters and executing statements
    • Preparing SQL statements and setting input parameters
    • Working with OUT and IN OUT parameters
    • Binding duplicate parameters in SQL statements
    • Binding duplicate parameters in PL/SQL
  • Working with REF CURSORs
  • Working with DML returning (RETURNING INTO clause)
  • Working with rowids
  • Working with synonyms
  • Committing or rolling back changes to the database
    • Setting autocommit
    • Manually committing or rolling back changes
    • Using COMMIT and ROLLBACK SQL statements
  • Managing multiple threads
  • Java escape syntax and SQL functions
• 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 value for SQL statements
    • Setting a threshold value for SQL statements
  • Features for use with IMDB Cache
    • Setting temporary passthrough level with the ttOptSetFlag built-in procedure
    • Managing cache groups
  • Setting up user-specified parallel replication
• Considering TimesTen features for access control
• Handling errors
  • About fatal errors, non-fatal errors, and warnings
    • Handling fatal errors
    • Handling non-fatal errors
    • About warnings
  • Reporting errors and warnings
  • Catching and responding to specific errors
  • Rolling back failed transactions
• JDBC support for automatic client failover
  • Features and functionality of JDBC support for automatic client failover
    • General Client Failover Features
    • Client failover features for pooled connections
  • Synchronous detection of automatic client failover
  • Asynchronous detection of automatic client failover
    • Implement a client failover event listener
    • Register the client failover listener instance
    • Remove the client failover listener instance

3 Using JMS/XLA for Event Management

• JMS/XLA concepts
  • How XLA reads records from the transaction log
  • XLA and materialized views
  • XLA bookmarks
    • How bookmarks work
    • Replicated bookmarks
  • JMS/XLA configuration file and topics
  • XLA updates
  • XLA acknowledgment modes
    • Prefetching updates
    • Acknowledging updates
  • Access control impact on XLA
• JMS/XLA and Oracle GDK dependency
• Connecting to XLA
• Monitoring tables for updates
• Receiving and processing updates
• Terminating a JMS/XLA application
  • Closing the connection
  • Deleting bookmarks
  • Unsubscribing from a table
• Using JMS/XLA as a replication mechanism
  • Applying JMS/XLA messages to a target database
  • TargetDataStore error recovery

4 Distributed Transaction Processing: JTA

• Overview of JTA
  • X/Open DTP model
  • Two-phase commit
• Using JTA in TimesTen
  • TimesTen database requirements for XA
  • Global transaction recovery in TimesTen
  • XA error handling in TimesTen
• Using the JTA API
  • Required packages
  • Creating a TimesTen XAConnection object
  • Creating XAResource and Connection objects

5 Application Tuning

• Tuning Java applications
  • Use prepared statement pooling
  • Use arrays of parameters for batch execution
  • Bulk fetch rows of TimesTen data
  • Use the ResultSet method getString() sparingly
  • Avoid data type conversions
• Tuning JMS/XLA applications
  • Configure xlaPrefetch parameter
  • Reduce frequency of calls to ttXlaAcknowledge
  • Handling high event rates

6 JMS/XLA Reference

• JMS/XLA MapMessage contents
  • XLA update types
  • XLA flags
• DML event data formats
  • Table data
  • Row data
  • Context information
• DDL event data formats
  • CREATE_TABLE
  • DROP_TABLE
  • CREATE_INDEX
  • DROP_INDEX
  • ADD_COLUMNS
  • DROP_COLUMNS
  • CREATE_VIEW
  • DROP_VIEW
  • CREATE_SEQ
  • DROP_SEQ
  • CREATE_SYNONYM
  • DROP_SYNONYM
  • TRUNCATE
• Data type support
  • Data type mapping
  • Data types character set
• JMS classes for event handling
• JMS/XLA replication API
  • TargetDataStore interface
  • TargetDataStoreImpl class
• JMS message header fields

Index