Oracle® SQL Developer

1 Changes in this release

This section lists changes between releases:

• Changes for Release 19.1 from Release 18.2

• Changes for Release 18.2 from Release 4.1

• Changes for Release 4.1 from Release 4.0

• Changes for Release 4.0 from Release 3.1

2 Supported TimesTen releases and platforms

SQL Developer 19.1 is available on 64-bit Microsoft Windows, Linux systems, and macOS. SQL Developer 19.1 supports Oracle TimesTen In-Memory Database 11.2.2.8.0 and later, TimesTen Application-Tier Database Cache 11.2.2.8.0 and later, and TimesTen In-Memory Database 18.1, and can be used to connect to a TimesTen database that resides on any platform that is supported by the TimesTen software.

In a client/server environment, if you connect to the TimesTen server with an older release of the TimesTen client, then new features added to the newer release of the server are not supported.

SQL Developer 19.1 requires Oracle Java Development Kit (JDK) 8.

3 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 19.1 on Windows to manage a grid or database from TimesTen Scaleout, install a TimesTen Client (version 11.2.2.8.0 or higher) and set your environment variables with the ttenv script. By default, the ttenv script sets the CLASSPATH environment variable to:

  installation_dir\lib\ttjdbc5.jar;
  

  However, using ttjdbc5.jar with Oracle Java Development Kit (JDK) 8 causes the Java Virtual Machine to crash. Depending on the available.jar file, set your CLASSPATH environment variable to use either installation_dir\lib\ttjdbc7.jar; or installation_dir\lib\ttjdbc8.jar;.

• 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 INDEX statement, 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 ttBulkCp utility, set the format for DATE and TIMESTAMP data using the following instructions:

  1. Select Tools, then select Preferences.

  2. In the Preferences dialog box click the + to the left of the Database node to expand the node.

  3. Select NLS.

  4. In the Date Format field, specify RRRR-MM-DD

  5. In the Timestamp Format field, specify DD-MON-RRRR HH24:MI:SSXFF

  To export data from a table in a format that the ttBulkCp utility 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 DATE and TIMESTAMP data 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.

4 Documentation Accessibility

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.