Contents

• Features in This Release
• Installation Prerequisites
• Installing the TimesTen database extension
• Known Issues

Features in This Release

The Early Adopter Release of the SQL Developer TimesTen database extension provides the following features:

• The extension supports both direct-linked and client/server connections to TimesTen database
• The extension supports connections to databases with Access Control enabled as well as databases without Access Control enabled
• The connections navigator in SQL Developer supports the following database objects: Cache Groups, Replication Schemes, Tables, Views, Indexes, Sequences and Materialized Views.
• You can view the definitions and the properties including the SQL CREATE statements associated with the database objects from the connections navigator.
• The connections navigator supports creation and modification of Tables, Views, Indexes, Sequences and Materialized Views.
• Within the Data tab, you can view, sort, search and edit data in existing tables, including cache and replication tables.
• You can use the SQL Worksheet to enter and execute TimesTen SQL statements, call TimesTen built-in procedures and run SQL scripts.
• The following ttIsql commands are supported in the SQL Worksheet: desc, version and dssize.
• Data from Oracle and TimesTen tables can be exported in TTBULCKCP text file format.
• The extension supports the creation of TimesTen user-defined reports.
  

The TimesTen database extension runs on top of SQL Developer 1.2.1 Build 32.13. It supports Oracle TimesTen In-Memory Database Release 7.0.3 and later.

Installation Prerequisites

Before installing the SQL Developer TimesTen database extension:

1. Install SQL Developer 1.2.1 on either Windows or Linux.
2. Install the TimesTen 7.0.3 server or client on the same machine as SQL Developer.
3. Make sure the CLASSPATH environment variable is pointing to the TimesTen JDBC driver (install_dir/lib/ttjdbc5.jar).
4. On Linux, execute the shell script install_dir/bin/ttenv.sh or install_dir/bin/ttenv.csh to set up the correct TimesTen environment before launching SQL Developer.

Installing the TimesTen database extension

The TimesTen database extension is available through Check-for-Updates.

1. Start SQL Developer.
2. Select the Help > Check for Updates... menu option.
3. Click the checkbox to select and install the TimesTen database extension.
4. Close and restart SQL Developer. (Two restarts are needed).
   

Known Issues

• Commit and rollback behavior for TimesTen DDL and DML operations: Unlike the Oracle database, TimesTen does not implicitly commit DDL transactions. The transactions can be rolled back like DML statements.
  
  If the "Autocommit in SQLWorksheet" preference is checked, then the TimesTen SQL operations within the navigator are automatically committed. The transactions in the SQL Worksheet are also committed automatically if there are no active Data tabs. If there are active Data tabs, the transactions in the worksheet are not committed and the user must issue an explicit commit by either clicking the Commit button or by entering the Commit command into SQL Worksheet.
  
  When the "Autocommit in SQL Worksheet" preference is not checked, TimesTen SQL operations are not committed. This applies to both the SQL Worksheet and the DDL operations available within the connections navigator. The user must explicitly commit the transactions by clicking the Commit button on the SQL Worksheet.
  
  
• The SQL tab is not populated for databases with Access Control enabled. This issue affects non-instance administrator users only. The workaround is to include the UID and PWDCrypt in the DSN definition.
  
  
• Turning on Passthrough can affect the SQL operations in the connections navigator. Make sure this setting is reset to 0 when switching from passthrough operations in SQL Worksheet back to the connections navigator.
  
  
• DLL operations fail with 'TT0941: Execution of operation not possible - dependent object is in use' when the Data tab is being viewed. A SELECT cursor is opened when the records are being viewed in the Data tab. Certain DDL operations such as ALTER TABLE ADD column are not allowed in TimesTen when a select cursor is opened against the same table. The workaround is to ensure that the data tab is not viewing the same table as the table you need to perform DDL on.
  
  
• You cannot create tables when the SYS.TABLES system table is being viewed in SQL Developer. Viewing the content of SYS.TABLES in the Data tab causes a lock to be placed. All CREATE TABLE operations will time out because of this. The lock is released as soon as the focus of the Data tab is switched to another table.
  
  
• Viewing the legacy TimesTen DATE and TIMESTAMP data types (TT_DATE and TT_TIMESTAMP in Oracle type mode)in the Data tab is not supported. Errors will be generated.
  
  
• The Index menu option is not available for materialized views.
  
  
• The SQL tab is missing for Index. Use the SQL tab on the corresponding table to view the CREATE INDEX statement.
  
  
• EXPORT DATA > INSERT generates Oracle-compatible SQL INSERT statements, depending on the underlying data type and the difference in support of literals. They may not be compatible with the TimesTen database.
  
  
• EXPORT DATA > TTBULKCP generates an error when the action is performed inside the Data tab. The workaround is select this option from the connections navigator.
  
  
• The LIKE filter does not find exact object match. The workaound is to use = instead of LIKE when defining the filter.