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.1 is available for Windows (XP and Vista (including 64bit)), Linux or the Mac.
2. The SQL Developer 1.5.1 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.1 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 Release 1.5, in this case you should migrate from the \Documents and Settings\<your_user>\Application Data\SQL Developer folder.
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.
   • You will not see any third party tabs in the connections dialog until you have installed the drivers.
   • You can download and include the third-party database drivers manually. See the existing documentation for that on OTN. Alternatively you can use Check for Updates to setup these drivers.
   • Do not use the latest MySQL driver 5.1. Use the 5.0.x drivers for MySQL.
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.1 You will not see the Times Ten Connection Node unless you have Times Ten installed and configured.(see TimesTen section below)
• 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

• 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
• update date in data grid, resets time details for date format without timestamp
• MAC: "view files" should filter mac hidden files on the mac
• bind variable declared with variable command have case sensitive names
• nls preferences override the login trigger and session parameters
• timing and status message are wiped out on saving sql file
• format changes -- to /* -- instead of /* -- */
• MAC: data tab's filter does not work well on mac
• Closing unshared worksheet prompts for save twice
• Unshared worksheet launch prompts inconsistently for password
• Deadlock from worksheet
• Search on access gives null at the start of local doc results

Formatter

• Many keywords not recognized in formatter
• Formatter does not right align set, and/or and breaks in strange places.
• Auto format to upper, lower mixed case on keywords
• Option to preserve blank lines between commands requested

Connections

• Advanced Security Options for thin JDBC drivers are not supported

Create or Modify Objects

• Loading jar file issues
• 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

Export/Import

• Cursor data exported to html does not render properly
• export-insert wrong after column reorder

Migrate

• Migrate from sql server - data move fails with characters included & and '
• ntext to nclob on non unicode database corrupt with chinese character
• Browsing sql server 2000 indexes panel does not work

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 workaround 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