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.
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).
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.
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.
Synonyms
TimesTen supports private and public synonyms (aliases) for database objects such as tables, views, sequences, and PL/SQL objects. See "Working with synonyms".
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.
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.
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.
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.
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.
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.
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".