What's New

This section summarizes the new features and functionality of Oracle TimesTen In-Memory Database Release 11.2.1 that are documented in this guide, providing links into the guide for more information.

New features in Release 11.2.1.7.0

• CALL for PL/SQL procedures and functions

  TimesTen now supports CALL syntax from any of its programming interfaces to call PL/SQL procedures and functions (in addition to CALL syntax to call TimesTen built-in procedures, which was already supported).

  See "Using CALL to execute procedures and functions".

New features in Release 11.2.1.6.0

• User-specified parallel replication

  For applications that have very predictable transactional dependencies and do not require the commit order on the replica database to be the same as that on the originating database, TimesTen supports parallel replication. This feature allows replication of multiple user-specified tracks of transactions in parallel.

  See "Setting up user-specified parallel replication".

New features in Release 11.2.1.4.0

• Support for Java 6

  See "Setting the environment for Java development" regarding the class path.

• Additional rowid support (for use with Java 6)

  While rowids have been supported throughout the 11.2.1 release cycle as noted below, the 11.2.1.4.0 release adds support for the java.sql.RowId interface and Types.ROWID type.

  See "Working with rowids".

• Synonyms

  TimesTen supports private and public synonyms (aliases) for database objects such as tables, views, sequences, and PL/SQL objects. See "Working with synonyms".

New features in Release 11.2.1.1.0

• Quick Start demos

  This release includes an optional Quick Start feature with introductory information and some new or reworked demo applications. Note that the demos have mostly the same names as in earlier releases, but in a different location.

  See "About the TimesTen Java demos" and install_dir/quickstart.html in your installation.

• Access control

  Perhaps the most significant overall change to previous functionality in this release is access control. TimesTen has new features to control database access with object-level resolution for database objects such as tables, views, materialized views, and sequences. This also affects access to certain TimesTen built-in procedures, utilities, and database and connection attributes.

  See "Considering TimesTen features for access control". For general information, see "Managing Access Control" in Oracle TimesTen In-Memory Database Operations Guide.

• Output parameters

  TimesTen now supports OUT and IN OUT parameters for your database operations.

  See "Working with OUT and IN OUT parameters".

• Duplicate parameters

  TimesTen now supports either of two modes for binding duplicate parameters in a SQL statement. Use the DuplicateBindMode general connection attribute to choose between Oracle mode and traditional TimesTen mode.

  See "Binding duplicate parameters in SQL statements".

• REF CURSORs

  REF CURSOR is a PL/SQL concept, where a REF CURSOR is a handle to a cursor over a SQL result set and can be passed between PL/SQL and an application.

  See "Working with REF CURSORs".

• Automatic client failover

  Automatic client failover, used in High Availability scenarios when failure of a TimesTen node results in failover (transfer) to an alternate node, automatically reconnects applications to the new node. TimesTen provides features that allow applications to be alerted when this happens, so they can take any appropriate action.

  See "JDBC support for automatic client failover".

• DML returning (RETURNING INTO clause)

  You can use a RETURNING INTO clause, referred to as DML returning, with an INSERT, UPDATE, or DELETE statement to return specified items from a row that was affected by the action.

  See "Working with DML returning (RETURNING INTO clause)".

• Rowids

  Each row in a TimesTen database table has a unique identifier known as its rowid. TimesTen now supports Oracle-style rowids. An application can retrieve the rowid of a row from the ROWID pseudocolumn.

  See "Working with rowids".

• Execution time threshold for SQL statements

  You can configure TimesTen to write a warning to the support log and throw an SNMP trap when the execution of a SQL statement exceeds a specified time duration, in seconds. This feature was added in a 7.0.x maintenance release but not documented in this manual. Note that this feature is similar to but differs from the previously existing timeout value for SQL statements.

  See "Setting a timeout or threshold for executing SQL statements".

• JMS/XLA replicated bookmarks

  If you are using an active standby pair replication scheme, you now have the option of using replicated bookmarks. For a replicated bookmark, operations on the bookmark are replicated to the standby database as appropriate. This allows more efficient recovery of your bookmark positions when failover occurs.

  See the section on replicated bookmarks under "XLA bookmarks".

• Indication of XLA updates due to cascading deletes or aging

  TimesTen indicates if an XLA update was generated as part of a cascading delete or aging operation through new XLA flags.

  See "XLA flags".