New Features:

Database Explorer

• Object type bodies are only shown if they actually exist (previously an empty body was displayed).
• All database objects can be displayed in separate Detail Browsers when opened using the keystroke CTRL+CR.

Detail Browser

• When displaying the source code of stored procedures, views, triggers and all SQL scripts the background of the current line is coloured like in the editor to show which line the cursor is currently on.
• A new icon was added to the toolbar to enable jumping straight to the referenced database object when displaying synonyms.

Editors

• A new menu item Copy SQL as Java Snippet was added to the context menus of SQL Worksheet and Stored Procedure Editor. The function turns a sql statement in a java-code-snippet. There are different formats available. The function can be called via the key stroke Alt+C.

korrigierte Fehler:

• When saving object types the view in the Database Explorer did not update automatically.
• When executing select statements in SQL Worksheet not all result columns are populated if the column name is ambiguous.
• When displaying trigger source code in the Detail Browser the when clause is not displayed.
• Detail Browser throws an exeception when displaying data from EXTERNAL TABLES. Changing the data is not possible.

New Features:

Detail Browser

• Outline View of the Detail Browser now shows the complete outline of a trigger.

Errors corrected:

• In the PL/SQL Editor there were runtime exceptions for objects types with constructors.
• Under certain circumstances a StringIndexOutOfBoundsException occurred when viewing an invalid trigger in the Detail Browser.
• The package body icon was not always updated correctly in the Database Explorer and the PL/SQL Editor.

New Features:

General

• Similar to the shortcut Ctrl+Shift+R for opening any resource, there is now a shortcut for opening database objects, namely Ctrl+Shift+D:
  • The selection list shows all database objects of the currently visible schemas.
  • The selection can be limited via prefixes and wildcards.
  • Stored Procedures, Triggers and Views are opened in the PL/SQL-Editor, if:
    • there is source code for the object,
    • the object is part of the default schema of the connection,
    • the option for direct editing of database objects has been activated.

    Otherwise the object will be opened using the detail browser.

• The menu items for Open Declaration and Quick Outline in the Navigate menu have been rearranged and are hidden if not active. This is to avoid confusion with menu items of the same name in the Java-Editor.

Detail Browser

• The units BYTE or CHAR are shown in addition to the length of char data types when displaying table and view columns.

Errors corrected:

• SQL statements were not stored in the SQL history if the History View had not been activated previously.
• The history displayed in SQL History View could not be sorted correctly by execution count.

New Features:

General

• Extended search:
  • Preceeded by a backslash the characters * and ? can be searched now.
  • Search can be limited using the name of database objects.

Detail Browser

• Extension of the Select Columns Dialog in Datasheet:
  • Size of the dialog can be changed.
  • Added two buttons for selecting and de-selecting all columns.
• Added option "Use DBMS_METADATA.GETDDL" to the Script Tab tab for tables and clusters. If the option is activated the script is generated using the DBMS_METADATA package. The resulting script contains all information supported by the package. This option is not available in Oracle 8 and excludes several other options.

Errors corrected:

• The search only scanned the body of a view, not it's column list resulting in incorrect areas in the editor being marked.
• Under certain circumstances SWT exceptions where thrown when closing jOra.
• When exectuting SQL statements in SQL Worksheet the use of comments in the code caused ORA-900 errors in some circumstances.
• Logins to a Oracle 8 databases cause NULLPointerExceptions.
• Empty result sets of SQL statements caused SWT exceptions.

New Features:

General

• jOra now supports object type CLUSTER
  • new category Cluster added to Database Explorer
  • detail information of clusters is shown in the Detail Browser
  • detail information of a table links directly to used clusters
• Source code for all stored procedures can be searched now. Added new tab to Eclipse search. Search supports wildcards and can be limited by database objects and schema.

Detail Browser

• the tabs for Uses and Used By were completely reworked::
  • improved run times
  • display of the correct icons for db objects
  • correct filter for the list of visible schemas applied (objects from schemas not in the list are hidden).
• All stored procedures and triggers can be stored from the Source tab directly to file.

Errors corrected:

• On systems with regional setting 'turkish' (probably in some other locales too) the names of database objects are converted to lower case letters incorrectly.
• Menu 'Copy' in result sets of sql statements not working.

New Features:

Database Explorer

• The Database Explorer can be configured to display either the Database-Objects of just the current schema or of all schemas. Use the Database-Explorer's View-Menu to change the configuration.
• Schema-Triggers are now included in the Trigger List.

Detail Browser/SQL Worksheet

• The Data Sheet view on tables and views now supports the SYS.XMLTYPE datatype. XML-data can be both viewed and edited. In the SQL Worksheet view XML-data can only be viewed when the data can be transformed using XMLType.getClobVal() to create a CLOB or using XMLType.getStringVal() to create a string
• An editor has been introduced to allow data types CLOB and XMLTYPE to be viewed and edited. The editor is opened using a double-click on the cell or by selecting the cell and pressing RETURN.
• When exporting data from the SQL Worksheet, whereas previously only the entire contents of the result table could be exported, now an area can be selected to be exported. In addition the order of the columns in the table can now be changed.
• On exporting the data the order of the columns is taken into account.
• Data displayed in the Outline View is (with the exception of stored procedures) sorted alphabetically.
• The Detail Browser displays the "wrapped code" for Stored Procedures without Source Code.

Editors

• The PL/Doc of Intrinsic Functions is displayed when the mouse hovers over such a function. If the cursor is placed over the name of an Intrinsic function then the PL/Doc is displayed in the PL/Doc View.
• The Code Completion for DML-commands was improved and extended to include suggestions for level, rownum, sqlcode and sqlerrm.
• The editors now have a Quick Outline View, accessed using Ctrl+O, allowing fast navigation in the source code.

Other

• The column datatype and column comment of tables and views is displayed in the PL/Doc.

Errors corrected:

• Occasional SWT-Exceptions occured in the Connections View when closing views.
• When constraints were deactivated came the message "Keyword missing" and the constraint was not deactivated.
• Errors came when using code completion whilst editing Stored Procedures and SQL-Files if the editor was not connected to the database.
• No entries appeared in the Outline View on declaring Subtypes (UNDER subtype).

New Features:

Editors

• SQL Worksheet and SQL Script Editor support the Outline View
• More than one stored procedure (e.g. package spec and body) can now be held in a single file using the Stored Procedure Editor.
• Compile errors previously only displayed in the Detail Browser are now directly visible in the Source Code.

Fixed:

• NullPointerExceptions and StringIndexOutOfBoundsExceptions were thrown whilst working with more than one statement in the Stored Procedure Editor.

New Features:

General

• Performance improved when editing large stored procedures.
• Performance improved updating the UI when entering a filter in Database Explorer.

Fixed:

• NullPointerException in Outline View and SQL History View fixed.
• A NullPointerException was thrown on exiting when the contents of a Stored Procedure Editor was not saved.

New Features:

Detail Browser

• In Data-Sheet of Tables and Views - data can now be exported in CSV-format using the context menu. The export can be made to either the clipboard or a file.
• Whilst editing stored procedures and triggers, compile errors are now displayed on the right and left borders of the editor.
• Constraint activation / deactivation is now asynchronous.
• Execution of ANALYZE Index is now asynchronous.

SQL Worksheet

• The result of an SQL-query can be exported as a CSV using the data view's context menu.

Code Completion

• Code completion now works when formulating SQL-queries with joins given in the SQL-standard form.

General

• SQL-commands saved in history entries can now be added to SQL-editors using drag-and-drop.
• A dialog with the most important options was added for ANALYZE Table and ANALYZE Index.

Fixed:

• Login to a database was not possible with a user name containing special or lowercase characters. In these cases the user name should be placed between quotes.
• Renaming of database objects did not work with names containing special or lowercase characters.
• The Detail Browser's display update no longer flickers and has improved performance.
• When an index was selected in the outline of the Detail Browser, the index was marked but not displayed correctly in the detail view.
• Code completion did not function correctly when comments were used within DML-instructions.

New Features:

SQL and PL/SQL Files

• Each PL/SQL resource has its own file extension now:
  • Package - *.pks
  • Package Body - *.pkb
  • Function - *.fnc
  • Procedure - *.prc
  • Trigger - *.trg
  • View - *.vw
• The old file extension *.pls is not used any more. If an encoding was configured for a file type it must configured once more in the preferences.
• The file extensions can be configured in the preferences. In the FAQs you find a detailed description of how to configure the file extensions.
• In the context menu of the Package Explorer Views and the Navigator Views underneath the menu entry New shortcuts to create new PL/SQL resources were added. If they are not visible the jOra perspective must be reseted. This function can be accessed also by File->New->Others.
• The file extension .sql was moved in the Content-Types from the entry "Text" into the entry "PL/SQL and SQL files". If an encoding was defined for SQL-Scripts it must be configured once more.

PL/Doc

• The new view PL/Doc View was added to view PL/Doc.
• If you click in the PL/SQL or SQL source code on a database object its documentation is shown in the PL/Doc View.
• PL/Doc is also shown:
  • In the suggestions of the code completion.
  • in the info view, if the cursor remains on a database element in the SQL or PL/SQL source code.
• In the FAQs you can find a detailed description of how to use PL/Doc.

SQL and PL/SQL Editor

• Enhancements of the code completion:
  • Code completion also works in DML statements now. The column names of the used tables are listed as well now.
  • In functions and procedures of packages the PL/Doc is also shown.
  • For overridden functions/procedures for each variant a suggestion is offered.
• If you open a file with an editor the eclipse functions:
  • Add Bookmark
  • Add Task
  • und Set Encoding
  are available in the edit menu. For editors working directly with a datsbase object this functions are not available.
• In the edit menu and in the context menu of the editors the new function "Toggle Comment" was added. With this function single or all selected rows can be commented out or in.
• Hyperlinks can also be opened using the key F3 now.
• In both editors the currenct connection is shown above the toolbar.
• When opening a file with the PL/SQL Editor, the included stored procedure can also be saved in the database and compiled using Ctrl+Enter now.
• When indenting automatically the Eclipse preference "Insert spaces for tabs" is used. Depending on the setting for the indenting tabs or spaces are used.
• If the mouse pointer delays on a database object in a little window additional information to the database object are shown.
  • for tables and views the schema and the comment
  • for columns the appropriate table, the data type and the comment
  • for methods and functions the schema, the parameter list and the type of the return value
  • for all others the type and the schema if available
  The info window can also be opened using the key F2. It receives the focus than. Its size can be changed now.

Detail Browser

• Detail Browser and Outline View are synchronized now: If you select an element in the Detail Browser it is also selected in the Outline View. The other way around this works as well.

Preferences

• In the template configuration new templates were added. They are used to added new PL/SQL resources. This templates can be configured.
• In the project settings a default connection can be set. It is used when SQL- and PL/SQL-Files are opened in this project. The configuration of the project settings is described in the FAQs.
• The new option "Allow direct editing for stored procedures, views and triggers" configures, whether database objects can be loaded directly from the database into a Stored Procedure Editor and edited so. By default this function is deactivated.

  If a version control is used for the database sources, the directly editing of database objects is usually not wished. The function should be deactived in this case.

Corrected Bugs:

• If a stored procedure or a trigger was changed and saved into the database in the Detail Browser still the old source code was shown. A refresh in the Detail Browser did not update the view.
• In the source code view of the Detail Browsers Ctrl/C did not work always.
• For databases using multi byte character sets verwenden (e.g. AL32UTF8) the length of VARCHAR fields was not shown correctly.
• With an opened Oracle Parameters View without having access rights for the used table error messages were shown, which had to be confirmed.
• In the dialogs to add a new index and a new synonym in the list to select a schema all schemas were shown. Now only the ones defined in the schema filter are shown.
• If the owner of a trigger and the owner of the associated table were not the same the attributes of the trigger could not be changed in the Detail Browser.
• In the source code of the trigger the wrong owner was shown, if the owner of the trigger differed from the one of the current schema.
• Using the code completion for the functions last_day, new_time and next_day the current date was inserted as the first parameter automatically.
• When closing the last editor view the Connections View was not update.
• When displaying the data of an Index Organized Table (IOT) in the Detail Browser an error message was always shown. This does not happen any more as the data of a IOT can not be change further in Detail Browser.
• In the detail browser comments of views could not be saved.
• The outline did not display some entries correctly, if a CREATE command was not at the beginning of the source code.

New Features:

Connections View

• In the context menu of the connection exists a new function to filter the schemas of the connection. The settings are saved.
• Proxy Users are supported now. The user name is provided in the form proxy_user[proxied_user] as in SQL Plus.

Database Explorer

• The handling of synonyms was completely reworked:
  • The UI divides public and private synonyms.
  • The performance of accessing synonyms got much better.
  • synonyms can be deleted now.
  • synonyms to database objects not supported by jOra are displayed as well.

Detail Browser

• In the "Uses"- and "Used By" tab the database objects are sorted by name now.
• All SQL and PL/SQL displays use the option to show line numbers (Window->Preferences->General->Editors->Text Editors->Show line numbers).
• The displaying of synonyms was reworked:
  • In the Info tab all attributes of the synonym are displayed.
  • In the tool bar of the Info tab exists a new function to show the database object the synonym references.
  • In the Script tab the CREATE command is displayed.

Preferences

• For each PL/SQL and SQL files a new own content type was defined. So the encodings of this files can be set (see Window->Preferences->General->Content Types).

Corrected Bugs:

• The displaying of the read rows in the status line was not always correct.
• With Oracle 10g a StackOverflowException occurred when displaying synonyms.
• NullPointerExceptions occurred when closing Eclipse.
• "Uses" and "Used By" tabs had column widths of 0 pixels. So the display was empty.
• In the synonyms tab new defined synonyms were not displayed after a view update.
• No package body was showed after the filter was used in the Database Explorer.
• When renaming an index in the Detail Browser the UI was not updated.
• When renaming a row table in the Detail Browser the UI was not updated.

New Features:

SQL Editors and Viewers

• In all editors and when displaying SQL and PL/SQL the support of hyper links got better. Hyper links are created also for the table columns and procedures/functions inside a package body now.

Detail Browser

• When double clicking on a database object in the "Uses" and "Used By" tab opens its detail view.

Corrected Bugs:

• A NullPointerExceptions occurred, if in a schema the logged in user had no permissions for the table of a trigger.
• In Eclipse 3.3 the icons for invalid procedures and packages were displayed incorrect sometimes.

Corrected Bugs:

• In Eclipse 3.4 (Ganymede) occurred NullPointerExceptions in the Database Explorer, when synonyms or database objects with status INVALID were displayed.
• When navigating using the Outline View, the cursor position in all opened Stored Procedure Editors and Detail Browsers was changed.

New Features:

Connections View

• The last selected connection is selected again in the Connections View when starting.

Database Explorer

• A new category to show all triggers was added. In addition to the triggers at tables and views the one for database events are listed as well. The Detail Browser was also extended and shows the triggers' details.
• In the category "synonyms" synonyms for Java classes and synonyms for synonyms are shown now, too.

Preferences

• New standard templates were added to the preferences. Eventually a "Restore Defaults" in the Preference Page must be performed once after getting the update.

Navigation History

• The Detail Browser adds all displayed database objects into the Navigation History of Eclipse now. So using the tool bar buttons "Back" and "Forward" one can comfortably navigate to the last displayed database objects.
• The SQL Explorer displays all database objects of the Navigation History in bold. So in the SQL Explorer you can easily see which database objects were used last.

SQL Editor and SQL Worksheet

• After executing any SQL command in the status line the execution time is displayed. For INSERT, UPDATE or DELETE the number of the inserted, changed or removed data rows is displayed. For SELECT the execution time is displayed. After all data rows were read and displayed, the number of the read rows and the time to do this is displayed as well.

Miscellaneous

• The Outline View was added to the jOra perspective. To activate it after the update the perspective must be reseted (click with the right mouse button on the icon of the perspective).

Corrected Bugs:

• Sorting a date column by clicking the column's header did not work. The results were shown display unordered.
• When editing RAW columns the error message "ORA-01465: ..." was displayed, if the HEX values were separated by spaces.
• If the SQL commands were separated by more the one empty line in the SQL Worksheet the following SQL commands could not be executed.
• If in the SQL Worksheet a SELECT with a join to several tables with identical column names was executed only the values of one table were displayed.
• If the first row was empty in the SQL Worksheet or SQL Editor and the first SQL command should be executed a BadLocationException occurred.
• When trying to create a book mark for a Package Body, by mistake a book mark for the package was created instead.
• After deleting a book mark, the display was not updated.
• Sometimes "widget is disposed" errors occurred when Eclipse was terminated.

New Features:

Database Explorer

• A new category to display all DATABASE LINKs was added. The Detail Browser was extended accordingly and displays the details of the database links now.
• Categories can be shown and faded individually. The corresponding menu item is located in the menu of the view (e.g. see Feature-Description).

Stored Procedure Editor (Outline)

• In the Outline View the list of parameters of procedures and functions can be displayed.
• The list of procedures and functions in the Outline View can be sorted by its names.

Oracle Parameters View

• Now the version info is better displayed by the view PRODUCT_COMPONENT_VERSION instead of V$VERSION before.

Detail Browser

Corrected errors:

• When editing data in the Data Sheet "Widget is disposed" messages were written in the Eclipse log.
• In the Detail Browser for SQL scripts of TEMPORARY TABLEs for indices a storage clause was displayed.
• In the data sheet of the Detail Browser OutOfMemoryExceptions occurred, if the content of large tables was displayed without specifying a row limit. The exception does not occur any more. The row count is limited according to available RAM.
• In the code completion database objects were listed twice, if a synonym was defined for it.

New Features:

Detail Browser

• The Detail Browser supports the Outline View when showing the following database objects:
  • TABLE
  • VIEW
  • PROCEDURE
  • FUNCTION
  • PACKAGE
  • PACKAGE BODY

Database Explorer

• The new category "Invalid Objects" was added. It shows all Stored Procedures, Triggers and Views with status INVALID. With a button in the toolbar all selected database objects can be compiled.

SQL Worksheet and SQL Script Editor

• A new function was added in the toolbar to display the EXPLAIN PLAN of SQL statement. The short cut ALT+CR was assigned to this function. The explained statement is the one under the cursor. If a part of a SQL statement is selected only the explain plan of the selected part is created.
• For the execution of SQL statements the handling of the selected area was changed. Following rules apply:
  • Single statements are separated by empty lines (as before).
  • If nothing is selected the SQL statement under the cursor is executed.
  • If a part of a SQL statement is selected the selection is assumed as a SQL statement and executed. So sub selects can be executed separately.
  • If the selection includes several statements all SQL statements included (even partly) are executed (as before).

Miscellaneous

• The login dialog was enhanced. Connections to a Oracle Real Application Cluster are possible now. To use this new feature in the connection dialog has the option Use custom JDBC connect string. If this option is activated alternative to host, port and SID the complete JDBC connect string can be provided.
• The data type INTERVAL DAY TO SECOND is supported now.

Corrected Bugs:

• For database objects with a dollar sign in the name the code completion did not work.
• In certain circumstances a NullPointerException occurred in de.tl.jora.views.PartAdapter.hook(PartAdapter.java:34) when closing Eclipse.
• In the Data Sheet a date could not be inserted. The error message "Input is not a legal date" was shown always.
• When adding new data records in the Data Sheet exceptions occurred when the new data record was identical to an existing one (all fields with equal content).
• If a stored procedure was closed with a slash and a line break an additional slash was appended when saving it. Because of this the procedure was invalid and could not be compiled.
• The code completion of a stored procedure without parameters left out the opening brace.

New Features:

PL/SQL Editor New!

• The editor is used to edit stored procedures, triggers and views. By default it is associated with the file extension "pls". With this editor it is possible to manage stored procedures, triggers and views in Eclipse projects.
• The editor provides the same functions as the Stored Procedure Editor.
• After opening the PL/SQL Editors the editor is not connected to a connection. The connection must be chosen in the toolbar first.

Code Completion

• Enhancement of code completion in all editors:
  • For all intrinsic functions templates were defined. Place holders were included for all their mandatory parameters.
  • The parameters of stored procedures are filled as place holders as well.
• In the preferences own templates can be defined. They are shown in the code completion selection menu.
• If the selection menu contains only one entry and if the entry is user defined it is inserted immediately into the source code.

Detail Browser

Database Explorer

• The object filter applies just only for database objects for the current category. The filter is saved per category.

Corrected Bugs:

• If in the SQL history was only one grouping line selected and if afterwards in the toolbar the actions "Copy To Clipboard" or "Hide Unpinned Entries" were called exceptions occurred.
• In the columns tab of the detail browser the function "Rename Column" was also for Oracle 8 active.
• In the connections view the actions in the context menu were always active.

New Features:

Connections View

• In the Toolbar an action to group connections by SID was added. The state of the action is saved.

Oracle Parameters View

• Some information was added to the view:
  • Version infos (V$_VERSION)
  • Database settings (V$_DATABASE)
  • NLS parameters (NLS_DATABASE_PARAMETERS, NLS_INSTANCE_PARAMETERS, NLS_SESSION_PARAMETERS)
• The display uses always the active connection now. It is no longer necessary to select a connection explicitly.

Corrected Bugs

• The names of connections were not saved.
• When opening the Outline View, for already opened Stored Procedure Editors no outline was shown.
• When saving Stored Procedures, for uppercase SQL commands no compiler errors were shown.
• If everything was written uppercase the automatic indention did not work in the Stored Procedure Editor and in the SQL Worksheet.
• Syntax coloring in the SQL Script Editor works only with file extension "sql".
• The SQL History doesn't work.

New Features:

Database Explorer New!

• The Database Explorer shows all database objects in one view. It replaces the present Object List Views for tables, views, procedures, sequences and synonyms.
• The design of the synonym list was completely reworked. All public synonyms and all SYS/SYSTEM synonyms can be hidden. These adjustments are saved.
• Bookmarks can be managed separately for all connections. They are shown as separate category in the Database Explorer.
• Performing truncate table must be confirmed.
• When editing stored procedures, only one editor per stored procedure is opened. If the editor for the chosen stored procedure already opened it gets the active editor.

SQL Script Editor New!

• With this editor SQL scripts can be edited. It is by default assigned with the file extension "sql". Hence SQL scripts can be managed in Eclipse projects.
• Its functions are almost the same as the ones of the SQL Worksheet.
• When opening SQL Script Editor it is not associated with a Connection. The connection must be chosen manually with the toolbar.

Detail Browser

Stored Procedure Editor

• If a stored procedure, a trigger or a view is loaded in the Stored Procedure Editor the source code is reloaded from the database.

SQL Worksheet

• In the table view of data the data type ROWID is correctly display.

Connections View

• In the Properties Dialog of a connection a display name can be defined. Everywhere the connection is shown the defined display name is displayed.

SQL History View

• The table columns widths adjust automatically to the width of the views.
• The SQL History View has two parts now. In the top part the present table is shown. In the bottom part the associated SQL statement is displayed nicely formatted.

Preferences

• A new function was added to enable or disable the confirmation question for a DROP statement and TRUNCATE TABLE.
• It is configurable which editors (Detail Browser and/or SQL Worksheet) are opened after connecting to the database.

Miscellaneous

• Columns of primary keys got in all displays an own icon.

Corrected Bugs:

• When connection to a database for some databases the session time zone could not be set. A login was not possible so.
• In the data sheet of the Detail Browser the error message "Illegal character" was shown, when the data of a table or a view with a name beginning with an underscore should be displayed.
• Several errors occured for names containing quotation marks.
• When opening the Outline View no outline was shown, if the Stored Procedure Editor was opened.
• In PlDoc comments the code completion of @ and HTML tags did not work.
• The SQL history was completely removed, if the maximum of 100 entries was reached.
• In the tooltip of the Detailbrowser also an internal ID was shown.
• In the Oracle Parameters View in the selection menu of the connection also an internal ID was shown.
• In the Oracle Parameters View the connection to a database connection could not be closed.
• The filter in the Object List Views (now Database Explorer) and in the SQL History did not work correctly, if special characters of regular expressions occured in the text.