This document provides late-breaking information (as well as information that is not yet part of the formal documentation) on Oracle SQL Developer regarding the management and use of Oracle TimesTen In-Memory Database.
This is release 21.2 of SQL Developer. For the release notes of SQL Developer 21.2, see Oracle SQL Developer 21.2 Release Notes.
This is release 22.1 of TimesTen. For the release notes of TimesTen 22.1, see Oracle TimesTen In-Memory Database Release Notes.
We strongly recommend that users of earlier versions upgrade to these releases.
SQL Developer documentation is available on the SQL Developer documentation website.
TimesTen documentation is available on the TimesTen documentation website.
In particular, Oracle TimesTen In-Memory Database SQL Developer Support User's Guide may be of interest.
Supported Platforms and TimesTen Releases
SQL Developer 21.2 is available on:
- macOS (64-bit)
- Microsoft Windows (64-bit)
SQL Developer 21.2 supports:
- TimesTen Classic Release 22.214.171.124.0 or higher
- TimesTen Scaleout Release 126.96.36.199.0 or higher
SQL Developer 21.2 can be used to connect to a TimesTen database that resides on any platform that is supported by TimesTen. If you connect to a TimesTen server of an older release than the TimesTen client used for the connection, any new features added to TimesTen since the release of the TimesTen server are not supported.
Required Java Versions
SQL Developer 21.2 requires Oracle Java Development Kit (JDK) 8 or 11, with a minimum version of 1.8 update 121.
Changes in the Release
This section describes new features, enhancements, and other changes to SQL Developer to support TimesTen in this and previous releases.
Changes in Release 21.2
A problem is fixed where the SQL tab in the table view failed to show the
CREATE TABLEstatement for the table if the connection type was client/server.
There are new features. See New Features in Release 21.2.
New Features in Release 21.2
Features supported in TimesTen Scaleout Release 22.1 or higher:
You can create a grid in TimesTen Scaleout with a K-safety level up to 5.
Changes in Release 20.4
There are new features. See New Features in Release 20.4.
New Features in Release 20.4
Features supported in TimesTen Release 188.8.131.52.0 or higher:
You can create, edit, or drop password management profiles for database users in TimesTen databases. See Working with profiles in the Oracle TimesTen In-Memory Database SQL Developer Support User's Guide.
The Create User and Edit User dialogs are enabled to:
Assign an existing profile to the user.
Lock the user account.
Expire the password.
You can reset the password of the database user used for the TimesTen connection. See Reset password of connected user in the Oracle TimesTen In-Memory Database SQL Developer Support User's Guide.
Changes in Release 20.2
This release replaces all text instances of TimesTen Grid with TimesTen Scaleout in the user interface.
Changes in Release 19.1
- There are new features. See New Features in Release 19.1.
New Features in Release 19.1
Features supported in TimesTen Scaleout Release 184.108.40.206.0 or higher:
For stop or unload database operations, you can opt to force all user connections to disconnect if the initial attempt to terminate such connections fails.
Features supported in TimesTen Scaleout Release 220.127.116.11.0 or higher:
The Connection Details dialog now displays information on the element, host, instance, connection name, process ID, and type of connection for the selected connection. It also displays additional information on client/server or proxy connections.
Changes in Release 18.2
- There are new features. See New Features in Release 18.2.
New Features in Release 18.2
Features supported in TimesTen Release 18.1 or higher:
- You can use SQL Developer to work with TimesTen Scaleout databases. For more information, see Working with TimesTen Scaleout in the Oracle TimesTen In-Memory Database SQL Developer Support User's Guide.
Known Problems and Limitations
When you use some Java 8 versions on Linux, the pie chart in the table distribution tab cannot be seen. The drop-down list for the pie chart and the bar chart may look distorted. As a workaround, select the bar chart to visualize the data.
To use SQL Developer 21.2 on Windows to manage a grid or database from TimesTen Scaleout, install a TimesTen client (version 18.104.22.168.0 or higher) and set your environment variables with the
ttenvscript. By default, the
ttenvscript sets the
CLASSPATHenvironment variable to:
ttjdbc5.jarwith Oracle Java Development Kit (JDK) 8 causes the Java Virtual Machine to crash. Depending on the available
.jarfile, set your
CLASSPATHenvironment variable to use either
If you do not select Autocommit, then TimesTen SQL operations within the Connections navigator are not always automatically committed. You must issue an explicit commit by either selecting Commit or by issuing the commit command in SQL Worksheet. If TimesTen encounters errors in your transaction, you must explicitly roll back the transaction by either selecting Rollback or by issuing the rollback command in SQL Worksheet.
If Autocommit is selected, then TimesTen SQL operations within the Connections navigator are automatically committed. A transaction in the SQL Worksheet is also automatically committed if there are no open tables in the transaction. If there are open tables, then the transaction in the worksheet is not automatically committed and you must issue an explicit commit by either selecting Commit or by issuing the commit command in SQL Worksheet.
To enable Autocommit, select Tools, then select Preferences. In the Preferences dialog box, click the + to the left of the Database node to expand the node and select Advanced.
Setting the passthrough level to a value other than 0 can affect the SQL operations in the Connections navigator. Make sure this setting is reset to 0 when switching from issuing passthrough operations in SQL Worksheet back to the Connections navigator.
You can also create an unshared worksheet which uses a separate database connection from the Connections navigator so that a particular passthrough level setting applies only to that worksheet. From a shared worksheet, click the Unshared SQL Worksheet icon or press Ctrl + Shift + N to create an unshared worksheet.
If you click the + to the left of the Indexes node to view the list of indexes and then click the name of the index with the characteristics you want to view, you cannot view the index's DDL statement, because the SQL tab is missing. To view the
CREATE INDEXstatement, from the index's underlying table or materialized view, click the SQL tab.
TimesTen error 2963 (
Inconsistent datatypes: (NUMBER,CHAR) are not compatible in expression) is returned when you attempt to specify a numeric value filter on a numeric column. To specify a filter value for a numeric column, click the + to the left of the Tables node to view the list of tables, and then click the name of a table that contains a numeric column. In the Data tab of the table, click the name of a numeric column. In the Filter field, enter a numeric value and press the Enter key.
Before you export data from a table in a format that is compatible with the TimesTen
ttBulkCputility, set the format for
TIMESTAMPdata using the following instructions:
- Select Tools, then select Preferences.
- In the Preferences dialog box click the + to the left of the Database node to expand the node.
- Select NLS.
- In the Date Format field, specify
- In the Timestamp Format field, specify
To export data from a table in a format that the
ttBulkCputility recognizes, right-click the name of the table and select Unload. After you select Unload, step 1 (Source/Destination) of the Unload Wizard appears. In the Format drop-down menu, select ttbulkcp. After you complete step 1, click the Next button to advance to step 2 (Specify Data) of the Unload Wizard. After you complete step 2, click the Next button to advance to step 3 (Unload Summary). Click the Finish button to complete the data export operation.
You can change the
TIMESTAMPdata format back to their original settings after the data has been exported.
The hierarchical profile and debugging of PL/SQL procedures and functions in a TimesTen database are not supported.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle TimesTen In-Memory Database SQL Developer Support Release Notes, Release 21.2
Copyright © 2008, 2022, Oracle and/or its affiliates.