Contents

Title and Copyright Information

Preface

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

What's New

• New Features for Release 11.2.1

1 Configuring the Java Development Environment

• Installing TimesTen and the JDK
• Setting the Java environment variables
• About the TimesTen Java demos

2 Working with TimesTen Data Stores

• 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 in the javax.sql package
  • TimesTen JDBC extensions
  • Additional TimesTen classes and interfaces
• Connecting to a TimesTen data store
  • Load the TimesTen driver
  • Create a connection URL for the data store and specify connection attributes
  • Connect to the data store
  • Disconnect from the data store
  • 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
  • Preparing SQL statements and setting input parameters
  • Binding duplicate parameters
    • Binding duplicate parameters in SQL statements
    • Binding duplicate parameters in PL/SQL
  • Putting it all together: preparing and executing SQL statements
  • Calling TimesTen built-in procedures
  • Working with OUT and IN OUT parameters
  • Working with DML returning (RETURNING INTO clause)
  • Working with PL/SQL REF CURSORs
  • Working with rowids
  • Fetching multiple rows of data
  • Setting a timeout or threshold for executing SQL statements
    • Setting a timeout value for SQL statements
    • Setting a threshold value for SQL statements
  • Escape syntax in SQL functions
  • Managing cache groups
  • Committing changes
    • Setting autocommit
    • Manually committing or rolling back changes
    • Using COMMIT and ROLLBACK SQL statements
• Managing multiple threads
• 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 data store
  • TargetDataStore error recovery

4 Distributed Transaction Processing: JTA

• Overview of JTA
  • X/Open DTP model
  • Two-phase commit
• Using JTA in TimesTen
  • TimesTen data store 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
  • Using prepared statement pooling
  • Using 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
  • 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