Oracle SQL Developer Release 1.5.5 - Release Notes

Date: July 2009

Contents

About this release

  1. Before you Start
  2. Once you have started
  3. Known Issues
  4. Language and Translation Issues
  5. New Features in SQL Developer 1.5

About this release

Oracle SQL Developer 1.5.5 is the release that will be incorporated into Oracle Database 11gR2. This has minor updates to release 1.5.4 and no focus on new functionality. New features are included in Oracle SQL Developer 2.1, scheduled for release in FY2010.

NOTE: The SQL Worksheet is being rewritten for SQL Developer 2.1. As such many existing bugs and requests for the SQL Worksheet have been noted and should be addressed in the next release of SQL Developer, not in SQL Developer 1.5.5.

1.  Before you Start

2. Once you have Started

  • You are supported by Oracle Support under your current database Support license. Log SQL Developer bugs and issues using Metalink for the product Oracle SQL Developer.
  • You can discuss issues on the Oracle SQL Developer forum
    • Be sure to use clear subject lines to initiate a thread
    • Try to avoid using old, unrelated threads for a new issue.
  • There is a list of bugs fixed. You can also contact Oracle Support to request bugs are published.
  • Known issues in this release are listed below. This is not a complete list of known bugs, but some of the main issues that might impact you.
  • Features not yet supported in this release can be added to the Feature Requests section on the Oracle SQL Developer Exchange
  • Please review current certification status for platform and database certification queries.
  • TimesTen is included in SQL Developer 1.5.5. You will not see the TimesTen Connection node unless you have TimesTen installed and configured (see TimesTen section above).
  • Support for TimesTen In-Memory Database includes support for Oracle In-Memory Database Cache and TimesTen In-Memory Database Release 7.0.3 and later.
  • If you did not migrate your connections from a previous release, you can import them afterwards. Invoke the earlier release of SQL Developer, export the required connections and import them in the new release.
  • Expired password: When a password expires, an error message is raised to alter the user. To reset the password, right-click the connection and select Reset Password.

3. Known Issues

This list is not exhaustive, but consists of the higher priority issues trapped and reported. To find out the status of a bug or to log additional bugs, please contact Oracle Support through Metalink.

General

  • Doc Help window pops up when other dialogs invoked
  • Error when dropping directories called after 'c:\'
  • Format changes -- to /* -- instead of /* -- */
  • JDK 1.6 update 10 does not work with windows look and feel
  • NLS preferences override the login trigger and session parameters
  • Performance in query builder when dragging first table onto page is poor
  • Print data tab of table: entire data not printed
  • Retrieving the content of an xml document using pseudo column object_value

Browsing

  • Cannot browse the xmltype table in 9i db when created in sql worksheet
  • Cannot display xmltype data stored in al32utf8 db character set
  • Java : drop class resulting in error, class not dropped
  • Popup describe: explicit schema name ignored when checking synonyms
  • Privileges > grant - no priv listed for public under "available privileges"

Formatter

  • Compare and merge; ignore white spaces has no effect
  • Many keywords not recognized in formatter
  • Option to preserve blank lines between commands
  • Preference > sql formatter > other > input sql has line breaks inside tokens

Connections

  • Advanced connections aren't encrypted (Use thick/OCI driver)
  • Advanced Security Options for thin JDBC drivers are not supported
  • MAC: connect button not displayed in the new/select database connection dialog
  • Users in expired(grace) status not notified when connecting

Create or Modify Objects

  • Database difference utility finds false differences
  • Database copy wizard shows duplicate record errors for existing PK and unique indexes
  • Path for create directory in the directories node is incorrect
  • Users with permission select any dictionary cannot view trigger details
  • View dialog: SQL syntax is valid, however the query is invalid

SQL Worksheet and Data

  • Accept default option does not work in worksheet - SQL*Plus
  • File -> print on data grid, truncates header row
  • F9 bind variables should be able to be in double quotes and have spaces
  • NLS justification of middle eastern languages not appropriate when edit data
  • NLS settings are not used for binary_float/binary_double
  • MAC query builder to select all cols for a table, tick mark is not displayed.
  • Select* (no gap) incorrect syntax does not show error for F9 (enter statement)
  • Set serveroutput on fails in glogin.sql auto run script
  • Sort setting can't be changed if there is a failure
  • Special characters displayed as open square in results screen
  • to_timestamp_tz not showing correct results
  • Update date in data grid, resets time details for date format without timestamp

PL/SQL

  • Bind variable declared with variable command have case sensitive names
  • No way to terminate an executing pl/sql procedure once started
  • Opening file in plsqlnode incorrectly displays a default connection
  • Refresh or reconnecting to a user after privilege change does not update user
  • Remote debug: does not default connection, can't find source

Export/Import

  • Cursor data exported to html does not render properly
  • Wrong encoding for exported ttbulkcp file

Migrate

  • Access: Data move incorrectly handles boolean value 'true'
  • Access: View referencing alias inline
  • Access view translation not handling parameter values correctly
  • Browsing SQL Server 2000 indexes panel does not work
  • Cannot sort a row of size 8096, greater than the max
  • Create view conversion missing alias clause
  • Data move fails for multibyte database name
  • Delete statement with column alias cannot be parsed
  • Default value for date needs to be converted
  • Duplicate column name error reported on translated ms access query
  • Multi-segmented unique indexes turn to non-unique in the captured model
  • Not equals ! = with a space between the bang and equals is not recognized
  • Sybase: Older join syntax in triggers fail to convert
  • On delete cascade is lost during migration
  • Procedure arguments need to match variable names in case.
  • SQL Server 2000 browse data (and data grid) do not display datetime values
  • SQL Server default "for" triggers should be converted to after trigger
  • SQL Server - data move fails with characters included & and '
  • Sybase trigger: inserted sub condition not converted
  • Triggers deleted gets removed or replaced by dual and pl/sql code incomplete
  • Unable to translate query with wildcard as identifier
  • Update join clause not translated correctly
  • Update statement with assignments not converted correctly

Preferences

  • Create a preference for setting TNS location or setting TNS path
  • NLS preferences override the login trigger and session parameters
  • Objectviewer parameters: Uncheck 'show schema', comments has schema name in - Base bug on database
  • Preferences>accelerators, add one and remove, it will lose key assignment
  • Reassigning cut copy paste to the standard key combination, does not work
  • SQL Developer seems to "lose" some key assignments now and then - have to reset defaults

Version Control

  • SVN check out: error message is needed if destination does not exist
  • Versioning > cvs ; new files not being displayed in the cvs connection

TimesTen

  • Commit and rollback behavior for TimesTen DDL and DML operations: Unlike the Oracle database, TimesTen does not implicitly commit DDL transactions. The user must explicitly commit the transactions by clicking the Commit button on the SQL Worksheet.
  • Enabling PassThrough can affect the SQL operations in the Connections navigator. Make sure this setting is reset to 0 when switching from PassThrough operations in the SQL Worksheet back to the Connections navigator.
  • DDL operations fail with when the Data tab is being viewed. Ensure that the data tab is not viewing the same table that you are performing 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 statements will be blocked and may eventually time out because of this. The lock is released as soon as the focus of the Data tab is switched to another table. This is fixed in 7.0.5 and later release of the TimesTen In-Memory Database.
  • EXPORT DATA > insert generates Oracle-compatible SQL INSERT statements, depending on the underlying data type and the difference in support of literals. These may not be compatible with the TimesTen database.
  • EXPORT DATA > ttbulkcp generates an error when the action is performed inside the Data tab. Select this option from the Connections navigator.
  • The LIKE filter does not find an exact object match. The workaround is to use = instead of LIKE when defining the filter.
4. Language and Translation Issues
  • There are a number of strings that did not get translated in this our first translation release. The untranslated strings have not been itemized.

5. New Features in Oracle SQL Developer 1.5

For a comprehensive list of features please review the SQL Developer 1.5 Feature List