Oracle SQL Developer Release 1.5 (1.5.0.53.38) - Release Notes

Date: 23 April 2008

Contents

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

1.  Before you Start

  1. Oracle SQL Developer 1.5 is available for Windows (XP and Vista (including 64bit)), Linux or the Mac.
  2. The SQL Developer 1.5 release is shipped with JDK1.5.0_06. You can use the embedded JDK or connect to a JDK you have installed. The minimum JDK you should use is 1.5.0_06. If you use JDK1.6 (JDK6.0), the minimum you should use is JDK1.6 Update 3. SQL Developer does not work with JDK 1.6 Update 1 and 2.
  3. Migrating from Previous releases
    1. To migrate your existing Release 1.2.1 connections, you should navigate to and select the <sqldev 1.2.1 home>\sqldeveloper\sqldeveloper\system folder. In the future these system folder files are stored in the \Documents and Settings\<your_user>\Application Data\SQL Developer
    2. In Oracle SQL Developer 1.5 your user-defined reports, SQL History and user-defined snippets files are located in the \Documents and Settings\<your_user>\Application Data\SQL Developer folder. These are also migrated.
    3. You can migrate from EA releases, in this case you should migrate from the \Documents and Settings\<your_user>\Application Data\SQL Developer folder. However migrating from EA releases will only migrate preferences, not your connections.(EA releases are unsupported releases)
  4. The JDBC drivers shipped are 11g R1. This means that users will no longer be able to connect to an Oracle 8.1.7 database.
  5. This release supports the Sybase 12 and Sybase 15 in addition to the current third party databases supported.
  6. Before you can use SQL Developer to connect to TimesTen:
    • Install the TimesTen 7.0.3 or later version of the server or client on the same machine as SQL Developer.
    • Make sure the CLASSPATH environment variable is pointing to the TimesTen JDBC driver (install_dir/lib/ttjdbc5.jar).
    • 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.
    • Read these more detailed release notes on TimesTen

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
  • The Times Ten is included in SQL Developer 1.5. You will not see the Times Ten Connection Node unless you have Times Ten installed and configured.(see TimesTen section below)
  • To add a SQL*Plus menu to your context menus, main toolbar or menu bar, using the External Tools option. For Windows:
    • Select the menu Tools ->External Tools
    • Click New... and enter the following values:
    • Program executable: cmd.exe
    • Arguments: /K start cmd /k D:\oracle\Administrator\product\11.1.0\db_1\BIN\sqlplus.exe where D:... is where your SQL*Plus is installed. i.e. this could be c:\instantclient\sqlplus.exe
      Note: In this case you are not passing any parameters to the string.

      To pass in username the string should include ${sqldev.dbuser}@${sqldev.conn} @${file.name}
      e.g. /K start cmd /k D:\oracle\Administrator\product\11.1.0\db_1\BIN\sqlplus.exe ${sqldev.dbuser}@${sqldev.conn} @${file.name}

  • Please review current certification status for platform and database certification queries.

  • TimesTen In-Memory Database support includes support for Oracle In-Memory Database Cache and TimesTen In-Memory Database Release 7.0.3 and later.


3. Known Issues

General

  • Extended Search dockable does not remember its last location
  • Print data tab of table: entire data not printed
  • Functions not displaying return type
  • Performance in query builder when dragging first table onto page is poor

Connections

  • Advanced Security Options for thin JDBC drivers are not supported

Create or Modify Objects

  • Loading jar file issues
  • Type body has run/debug toolbar button
  • Copy schema throws error for table with complex types defined in secondary schema

PL/SQL

  • Refresh or reconnecting to a user after privilege change does not update user

Migration

  • Unable to migrate tables with large number of rows for online migration for MySQL (> 5,000,000 rows)

Export/Import

  • Cursor data exported to html does not render properly

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.
  • 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 when the Data tab is being viewed. 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 is fixed in 7.0.5 and later version 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. They 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 exact object match. The workaound is to use = instead of LIKE when defining the filter.

 

4. Hints and Tips

This is not a list of new features, but a few pointers that might be useful.

  • The SQL History is a dockable window in SQL Developer 1.5. You’ll find it at the lower portion of your screen. You can undock and drag the window to a location of your choice. For example, you can move and relocate it with the minimize snippets window.
  • The keyboard shortcut for the SQL History is ctrl (up or down)
  • To create a shared worksheet, use the SQL Worksheet button in the toolbar or the context menu (keystroke ctrl+shift+W). Assuming a connection is called “HR”, these shared worksheets are numbered as following HR~1, HR~2 etc.
  • To create a new, unshared worksheet, use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet. The unshared worksheets are labeled as follows: HR_ _1
  • You can drag and drop Insert or Select or Update or Delete statements onto the worksheet. There is a preference to make this choice set by:
    Tools -> Preferences: Database -> Worksheet Parameters
    The default is the current 1.2.1 behavior.
  • Please note the new SQL Formatter options available
    Tools -> Preferences: Database -> SQL Formatter
  • You can use force the use of the OCI/Thick driver using a preference
    Tools -> Preferences: Database ->Advanced Preferences
  • You can create code templates in the Preferences dialog.
    Tools -> Preferences: Database -> SQL Editor Code Templates
  • To use code editor templates you have created (in the preferences) use the keyboard shortcut ctrl-shift-T
  • You can choose to close all worksheets and all reports on disconnect. These are preferences.
  • Open a xxx.trc (tkprof) file in Oracle SQL Developer to see the formatted view of the file.
  • You can add connections to folders. Right click and add connection to existing folder or new folder. Folders are not migrated.
  • You can run DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects.
  • Code Templates are now shareable : <user>/Application Data/Sql Developer/CodeTemplate.xml

5. New Features in Oracle SQL Developer 1.5

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

Feature Area Feature
SQL Worksheet Updated code insight. Allows users to use code completion for a greater number of object types
  Replaced SQL Formatting. See SQL Formatter preferences to control white space, tabs, comma placement, case, new line etc.
  Code Templates for frequently used code. Create these in Preferences, then through key stroke, in Code Editors and SQL Worksheet, import code template . ctrl+shift+T)
  Code Templates are shareable : <user>/Application Data/Sql Developer/CodeTemplate.xml
  Flashback. For 10g and 11g, you can use flashback on your data. See the Flashback tab on Tables.
  Keystroke to change case. (This is also available on a context menu.) Keystroke case is ctrl-quote
  Refactor code, see context menu on SQL Worksheet or Code Editors
  Separate unshared worksheet for connections for long running queries. Use the keystroke ctrl+shift+N. This will create a separate, unshared worksheet. The unshared worksheets are labeled as follows: HR_ _1
  SQL History stores commands form F5 and F9 keystrokes. i.e Execute script or Execute statement. Note if you run @filename, this is what is stored in the History, not every command from the file .Keystroke ctrl-up and ctrl-down adds and scrolls through previously executed commands in the SQL Worksheet.
  Drag and Drop from Navigator to Worksheet for Insert, Update, Delete, Join and Select statements. Set preference.
 

Data Grid on tables retains Sort.

  Data Grid filter retains drop list of previous filter options
Navigator

View Queues and Queue tables

  Load and view Java
  Extended Search dialog in addition to DB Object search. This allows for searching for objects in code, such as parameters, declaration and usage.
  Create table from xls spreadsheet import.
  Run Manage Database report (right-click for context menu on any connection with privileges, such as SYS or SYSTEM)
  Run Manage Database report ( as SYS) to shut down and rest rat database
  Generate DB Doc (right-click for context menu on connections) for all objects in a schema. Open the generated index.html file in a browser to review objects.
Schema Copy

To copy contents of one schema to another

  Choices include drop objects, truncate and copy
  Preview report of actions to be executed
  Log report of results
Schema Diff

Compare and create SQL Difference statement between 2 schemas

  Select objects to compare
  Report of objects to be compared
  List of differences and SQL Code to be executed
  Run script output to SQL Worksheet to be executed against connection of choice.
Export Wizard Export of DDL and Data updated to a wizard
  Includes object grants
  Select data for export
  Include drop commands
  Choice of dependent or independent objects
  View report of export to be run
  Export script opened in SQL Worksheet to run against user of choice
Import Import from XLS and create new table
  Import from CSV
Tip of the Day If you have any tips, submit them on the SQL Exchange or Forum for inclusion in the product.
Connections Force the OCI/thick driver connection, using a preference
  Support for LDAP and Authenticated Enterprise users
  Proxy user connections
  OS Authentication
  Add connections to folders
Tuning Open *.trc file in SQL Developer for a formatted trace file.
Preferences Support for a startup file such as login.sql. Add file choice to preferences.
Reports Monitor Sessions report is also on the main Tools menu
  Manage Database report on the context menu of the connection in the navigator
  Revised Migration reports
  Add reports with gauges
 

ASH and AWR reports

PL/SQL Hierarchical Profiler
Third Party Databases Includes Sybase 12 and Sybase 15 migration support
  Times Ten extension integrated into SQL Developer
Version Control Support for CVS and Subversion
Files An additional node for browsing the file system is available. File extensions associated with SQL Developer can be opened from the File Browser
Migration Quick Migrate is now a wizard.
TimesTen

Both direct-linked and client/server connections to TimesTen In-Memory database and In-Memory Database Cache

  Connections to databases with Access Control enabled as well as databases without Access Control enabled
  Connection Navigator support for selected database objects
  View, sort, search and edit data in existing tables, including cache and replication tables in the data grid
  Export of data from Oracle and TimesTen tables in TTBULCKCP text file format.