Contents

• Features in This Release
• Prerequisites
• Known Issues

Features in This Release

SQL Developer 1.5 provides the following TimesTen In-Memory Database features:

• Supports both direct-linked and client/server connections to TimesTen In-Memory database and In-Memory Database Cache
• Supports connections to databases with Access Control enabled as well as databases without Access Control enabled
• The connections navigator 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.
  

It supports Oracle In-Memory Database Cache and TimesTen In-Memory Database Release 7.0.3 and later.

Prerequisites

Before you can use SQL Developer to connect to TimesTen:

1. Install the TimesTen 7.0.3 or later version of the server or client on the same machine as SQL Developer.
2. Make sure the CLASSPATH environment variable is pointing to the TimesTen JDBC driver (install_dir/lib/ttjdbc5.jar).
3. 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.

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.
  
  
• 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.
  
  
• DDL 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. This problem has been fixed in 7.0.5 and later version of the TimesTen In-Memory Database.
  
  
• 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 to 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.