Edit D:\app\Administrator\product\11.2.0\dbhome_1\sqldeveloper\relnotes

Edit D:\app\Administrator\product\11.2.0\dbhome_1\sqldeveloper\relnotes_v155.html

<TITLE>Oracle SQL Developer 1.5.4: Release Notes</TITLE>

<table width="100%" cellpadding="7" cellspacing="0" border="0" class="bodycopy">
 <tr> 
 <td> <img src="/technology/products/database/sql_developer/raptor_image.jpg" width="48" height="48" hspace="5" vspace="5" align=left> 
 
 Oracle SQL Developer Release 1.5.5 - Release 
 Notes 
 Date: July 2009 
 Contents
 <a href="#about" class="bodycopy">About this release</a>
 <ol>
 <li class="bodycopy"><a href="#sec1">Before you Start</a></li>
 <li class="bodycopy"><a href="#sec2">Once you have started</a></li>
 <li class="bodycopy"><a href="#sec3">Known Issues</a></li>
 <li><a href="#sec4">Language and Translation Issues</a></li>
 <li class="bodycopy"><a href="#sec5">New Features in SQL Developer 1.5</a></li>
 </ol></td>
 </tr>
 <tr> 
 <td><a name="about"></a>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.
 <a name="sec1" id="sec1"></a>1.&nbsp; Before 
 you Start
 <ul>
 <li>Platform Support 
 <ul>
 <li>Oracle SQL Developer 1.5.5 is available 
 for Windows XP , Vista (including 64bit) and Windows Server 2008, 
 Linux or Mac OS X. </li>
 </ul>
 </li>
 <li>JDK Support 
 <ul>
 <li>Oracle SQL Developer 1.5.5 release is shipped 
 with JDK 1.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.</li>
 <li> Windows Vista requires the JDK 1.6 as a minimum and is certified 
 for JDK 1.6, using the default Oracle Look and Feel. Some issues 
 have been reported when using the Windows look and feel.</li>
 <li> There are known issues with JDK 1.6 updates 10 and 12.</li>
 </ul>
 </li>
 <li>Installing or Upgrading 
 <ul>
 <li>The Check for Updates option to upgrade between releases of SQL 
 Developer is not supported. This utility is provided to install 
 third party extensions, this includes the third party drivers required 
 for migrations.</li>
 <li>All new releases of SQL Developer require a full installation. 
 Download and unzip the file into an empty folder. Ensure the &quot;Use 
 folder names&quot; checkbox is checked when unzipping the file.</li>
 </ul>
 </li>
 <li>Migrating previous releases 
 After you have installed the product you 
 are asked if you want to migrate from a previous release. This migrates 
 previously set preferences and connections created: 
 <ul>
 <li>To migrate your existing Release 1.2.1 
 connections, select Browse... on the dialog, navigate 
 to and select the &lt;sqldev 1.2.1 home&gt;\sqldeveloper\sqldeveloper\system 
 folder. In the future these system folder files are stored in the 
 \Documents and Settings\&lt;your_user&gt;\Application Data\SQL 
 Developer</li>
 <li> To migrate settings from SQL Developer 
 1.5.x, select Browse... on the dialog, navigate 
 to and select the \Documents and Settings\&lt;your_user&gt;\Application 
 Data\SQL Developer folder. </li>
 <li>If you are using Oracle SQL Developer 1.1.3 as part of the Oracle 
 Database 11gR1 installation, navigate to [ORACLE_HOME] \product\11.1.0\db_1\sqldeveloper\sqldeveloper\system 
 NOTE: If you install a release later than 1.1.3, this does not replace 
 the menu item in your Start Programs list. You can add your own 
 menu option here or a short cut on the desktop.</li>
 </ul>
 </li>
 <li>User Defined Reports, Snippets and 
 SQL History 
 <ul>
 <li>In Oracle SQL Developer 1.5.5 your user-defined 
 reports, SQL History and user-defined snippets files are located 
 in the \Documents and Settings\&lt;your_user&gt;\Application 
 Data\SQL Developer folder. These are also migrated.</li>
 </ul>
 </li>
 <li>Folders 
 <ul>
 <li>If you created folders in release 1.5.1, 1.5.3 or 1.5.4, these 
 are automatically included in the migration. If you choose not to 
 migrate your settings between release, then you can import your 
 old connections. This does not include folders. </li>
 </ul>
 </li>
 <li> JDBC Drivers 
 <ul>
 <li>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. </li>
 </ul>
 </li>
 <li>Debug Log Window 
 <ul>
 <li>This is now set off by default. If you want to see the SQL Developer 
 debug log window information by default, then include the line IncludeConfFile 
 sqldeveloper-debug.conf in the sqldeveloper.conf file. </li>
 <li>To start up the debug log window in the product while you are 
 working, enter &quot;setloglevel oracle.dbtools ALL&quot; in the 
 SQL Worksheet. This will stay on while you are working, but won't 
 reopen the log window if you stop and restart the product.</li>
 </ul>
 </li>
 <li>Translations 
 <ul>
 <li>The help text is not translated - this will remain in English</li>
 <li>The Tip of the Day is not translated - we hope to translate these 
 in the future</li>
 <li>There are a number of areas where the test has not been translated. 
 We have bugs logged for these and will address them in future releases. 
 The individual bugs have not been itemized in this document.</li>
 </ul>
 </li>
 <li>Third Party Databases </li>
 <ul>
 <li>This release supports the Sybase 12 and Sybase 
 15 in addition to the current third party databases supported. 
 <ul>
 <li>You will not see any third party tabs 
 in the connections dialog until you have installed the drivers.</li>
 <li>You can download and include the third-party 
 database drivers manually. See the <a href="http://www.oracle.com/technology/tech/migration/workbench/files/omwb_getstarted.html">existing 
 documentation</a> for that on OTN. Alternatively you can 
 use Check for Updates to setup these drivers.</li>
 <li>Do not use the latest MySQL driver 5.1. Use the 5.0.x 
 drivers for MySQL</li>
 </ul>
 </li>
 </ul>
 <li>TimesTen 
 <ul>
 <li>Before you can use SQL Developer to connect to TimesTen: 
 <ul>
 <li>Install TimesTen 7.0.3 or a later release of the server or 
 client on the same machine as SQL Developer.</li>
 <li> Make sure the CLASSPATH environment variable is pointing 
 to the TimesTen JDBC driver (TimesTen_install_dir/lib/ttjdbc5.jar).</li>
 <li> On Linux systems, execute the shell script TimesTen_install_dir/bin/ttenv.sh 
 or TimesTen_install_dir/bin/ttenv.csh to set up the TimesTen 
 environment before launching SQL Developer.</li>
 <li>Read <a href="http://www.oracle.com/technology/products/timesten/htdocs/doc/sqldev_154_relnotes.html">these 
 more detailed release notes</a> on TimesTen </li>
 </ul>
 </li>
 </ul>
 </li>
 </ul></td>
 </tr>
 <tr> 
 <td><a name="sec2"></a>2. Once you have Started
 <ul>
 <li class="bodycopy"> 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.</li>
 <li>You can discuss issues on the <a href="http://forums.oracle.com/forums/forum.jspa?forumID=260">Oracle 
 SQL Developer forum</a> 
 <ul>
 <li class="bodycopy"> Be sure to use clear subject lines to initiate 
 a thread</li>
 <li class="bodycopy">Try to avoid using old, unrelated threads for 
 a new issue.</li>
 </ul>
 </li>
 <li class="bodycopy">There is a <a href="http://www.oracle.com/technology/products/database/sql_developer/files/BugsFixed_v155.html">list 
 of bugs fixed</a>. You can also contact Oracle Support to request bugs 
 are published.</li>
 <li class="bodycopy"> 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.</li>
 <li class="bodycopy"> Features not yet supported in this release can be 
 added to the Feature Requests section on the <a href="http://sqldeveloper.oracle.com">Oracle 
 SQL Developer Exchange</a></li>
 <li class="bodycopy"> Please review current <a href="http://www.oracle.com/technology/products/database/sql_developer/files/certification.html">certification</a> 
 status for platform and database certification queries. 
 <li>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). 
 <li class="bodycopy"> 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.</li>
 <li class="bodycopy">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.</li>
 <li>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.</li>
 </ul></td>
 </tr>
 <tr> 
 <td> <a name="sec3" id="sec3"></a>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
 <ul>
 <li class="bodycopy">Doc Help window pops up when other dialogs invoked</li>
 <li> Error when dropping directories called after 'c:\'</li>
 <li> Format changes -- to /* -- instead of /* -- */</li>
 <li>JDK 1.6 update 10 does not work with windows look and feel</li>
 <li> NLS preferences override the login trigger and session parameters</li>
 <li> Performance in query builder when dragging first table onto page 
 is poor</li>
 <li> Print data tab of table: entire data not printed</li>
 <li> Retrieving the content of an xml document using pseudo column object_value</li>
 </ul>
 Browsing
 <ul>
 <li> Cannot browse the xmltype table in 9i db when created in sql worksheet</li>
 <li> Cannot display xmltype data stored in al32utf8 db character set</li>
 <li> Java : drop class resulting in error, class not dropped</li>
 <li> Popup describe: explicit schema name ignored when checking synonyms</li>
 <li> Privileges &gt; grant - no priv listed for public under &quot;available 
 privileges&quot;</li>
 </ul>
 Formatter
 <ul>
 <li>Compare and merge; ignore white spaces has no effect</li>
 <li> Many keywords not recognized in formatter</li>
 <li>Option to preserve blank lines between commands</li>
 <li>Preference &gt; sql formatter &gt; other &gt; input sql has line breaks 
 inside tokens</li>
 </ul>
 Connections
 <ul>
 <li>Advanced connections aren't encrypted (Use thick/OCI driver)</li>
 <li>Advanced Security Options for thin JDBC drivers are not supported 
 </li>
 <li>MAC: connect button not displayed in the new/select database connection 
 dialog</li>
 <li>Users in expired(grace) status not notified when connecting</li>
 </ul>
 Create or Modify Objects
 <ul>
 <li>Database difference utility finds false differences</li>
 <li>Database copy wizard shows duplicate record errors for existing PK 
 and unique indexes</li>
 <li>Path for create directory in the directories node is incorrect</li>
 <li>Users with permission select any dictionary cannot view trigger details</li>
 <li>View dialog: SQL syntax is valid, however the query is invalid</li>
 </ul>
 SQL Worksheet and Data
 <ul>
 <li>Accept default option does not work in worksheet - SQL*Plus</li>
 <li> File -&gt; print on data grid, truncates header row</li>
 <li>F9 bind variables should be able to be in double quotes and have spaces</li>
 <li> NLS justification of middle eastern languages not appropriate when 
 edit data</li>
 <li>NLS settings are not used for binary_float/binary_double</li>
 <li>MAC query builder to select all cols for a table, tick mark is not 
 displayed.</li>
 <li> Select* (no gap) incorrect syntax does not show error for F9 (enter 
 statement)</li>
 <li> Set serveroutput on fails in glogin.sql auto run script</li>
 <li> Sort setting can't be changed if there is a failure</li>
 <li> Special characters displayed as open square in results screen</li>
 <li> to_timestamp_tz not showing correct results</li>
 <li>Update date in data grid, resets time details for date format without 
 timestamp</li>
 </ul>
 PL/SQL
 <ul>
 <li>Bind variable declared with variable command have case sensitive names</li>
 <li>No way to terminate an executing pl/sql procedure once started</li>
 <li>Opening file in plsqlnode incorrectly displays a default connection</li>
 <li>Refresh or reconnecting to a user after privilege change does not 
 update user</li>
 <li>Remote debug: does not default connection, can't find source</li>
 </ul>
 Export/Import
 <ul>
 <li>Cursor data exported to html does not render properly</li>
 <li>Wrong encoding for exported ttbulkcp file</li>
 </ul>
 Migrate
 <ul>
 <li> Access: Data move incorrectly handles boolean value 'true'</li>
 <li> Access: View referencing alias inline</li>
 <li>Access view translation not handling parameter values correctly</li>
 <li> Browsing SQL Server 2000 indexes panel does not work</li>
 <li> Cannot sort a row of size 8096, greater than the max</li>
 <li>Create view conversion missing alias clause</li>
 <li>Data move fails for multibyte database name</li>
 <li>Delete statement with column alias cannot be parsed</li>
 <li> Default value for date needs to be converted</li>
 <li>Duplicate column name error reported on translated ms access query</li>
 <li>Multi-segmented unique indexes turn to non-unique in the captured 
 model</li>
 <li>Not equals ! = with a space between the bang and equals is not recognized</li>
 <li> Sybase: Older join syntax in triggers fail to convert</li>
 <li>On delete cascade is lost during migration</li>
 <li> Procedure arguments need to match variable names in case.</li>
 <li> SQL Server 2000 browse data (and data grid) do not display datetime 
 values</li>
 <li> SQL Server default &quot;for&quot; triggers should be converted to 
 after trigger</li>
 <li> SQL Server - data move fails with characters included &amp; and '</li>
 <li>Sybase trigger: inserted sub condition not converted</li>
 <li>Triggers deleted gets removed or replaced by dual and pl/sql code 
 incomplete</li>
 <li>Unable to translate query with wildcard as identifier</li>
 <li>Update join clause not translated correctly</li>
 <li>Update statement with assignments not converted correctly</li>
 </ul>
 Preferences
 <ul>
 <li>Create a preference for setting TNS location or setting TNS path</li>
 <li>NLS preferences override the login trigger and session parameters</li>
 <li>Objectviewer parameters: Uncheck 'show schema', comments has schema 
 name in - Base bug on database</li>
 <li>Preferences&gt;accelerators, add one and remove, it will lose key 
 assignment</li>
 <li>Reassigning cut copy paste to the standard key combination, does not 
 work</li>
 <li>SQL Developer seems to &quot;lose&quot; some key assignments now and 
 then - have to reset defaults</li>
 </ul>
 Version Control
 <ul>
 <li>SVN check out: error message is needed if destination does not exist</li>
 <li> Versioning &gt; cvs ; new files not being displayed in the cvs connection</li>
 </ul>
 TimesTen
 <ul>
 <li>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.</li>
 <li>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.</li>
 <li>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. </li>
 <li>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. 
 </li>
 <li>EXPORT DATA &gt; 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. 
 </li>
 <li>EXPORT DATA &gt; ttbulkcp generates an error when the action is performed 
 inside the Data tab. Select this option from the Connections navigator. 
 </li>
 <li>The LIKE filter does not find an exact object match. The workaround 
 is to use = instead of LIKE when defining the filter.</li>
 </ul></td>
 </tr>
 <tr> 
 <td><a name="sec4"></a> 4. Language and Translation 
 Issues <ul>
 <li> There are a number of strings that did not get translated in this 
 our first translation release. The untranslated strings have not been 
 itemized. 
 </li>
 </ul></td>
 </tr>
 <tr> 
 <td><a name="sec5" id="sec5"></a>5. New Features 
 in Oracle SQL Developer 1.5
 For a comprehensive list of features please review 
 the <a href="http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm">SQL 
 Developer 1.5 Feature List</a></td>
 </tr>
</table>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de