|
From: <man...@us...> - 2010-08-21 18:21:20
|
Revision: 5831
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=5831&view=rev
Author: manningr
Date: 2010-08-21 18:21:11 +0000 (Sat, 21 Aug 2010)
Log Message:
-----------
Initial changes to convert from Ant build to Maven build
Added Paths:
-----------
trunk/sql12/doc/pom.xml
trunk/sql12/doc/src/
trunk/sql12/doc/src/main/
trunk/sql12/doc/src/main/resources/
trunk/sql12/doc/src/main/resources/changes.txt
trunk/sql12/doc/src/main/resources/images/
trunk/sql12/doc/src/main/resources/images/add_alias_1.png
trunk/sql12/doc/src/main/resources/images/add_exc.gif
trunk/sql12/doc/src/main/resources/images/alias_properties.png
trunk/sql12/doc/src/main/resources/images/alias_properties_button.png
trunk/sql12/doc/src/main/resources/images/alias_properties_dialog.png
trunk/sql12/doc/src/main/resources/images/alias_properties_dialog2.png
trunk/sql12/doc/src/main/resources/images/alias_properties_dialog3.png
trunk/sql12/doc/src/main/resources/images/alias_properties_dialog4.png
trunk/sql12/doc/src/main/resources/images/alias_properties_dialog5.png
trunk/sql12/doc/src/main/resources/images/alias_window_no_tree.png
trunk/sql12/doc/src/main/resources/images/alias_window_with_tree.png
trunk/sql12/doc/src/main/resources/images/aliases_tool_window_1.png
trunk/sql12/doc/src/main/resources/images/chg_driver_1.png
trunk/sql12/doc/src/main/resources/images/chg_driver_2.png
trunk/sql12/doc/src/main/resources/images/color-properties.png
trunk/sql12/doc/src/main/resources/images/connect_window.png
trunk/sql12/doc/src/main/resources/images/createresultwindow.gif
trunk/sql12/doc/src/main/resources/images/discovery.gif
trunk/sql12/doc/src/main/resources/images/drivers_tool_window_1.png
trunk/sql12/doc/src/main/resources/images/error_st_obj.gif
trunk/sql12/doc/src/main/resources/images/fonts_menus_demo.png
trunk/sql12/doc/src/main/resources/images/fonts_other_demo.png
trunk/sql12/doc/src/main/resources/images/fonts_static_text_demo.png
trunk/sql12/doc/src/main/resources/images/fonts_status_bar_demo.png
trunk/sql12/doc/src/main/resources/images/global_bookmarks.png
trunk/sql12/doc/src/main/resources/images/global_data_types_part1.png
trunk/sql12/doc/src/main/resources/images/global_data_types_part2.png
trunk/sql12/doc/src/main/resources/images/global_fonts.png
trunk/sql12/doc/src/main/resources/images/global_general.png
trunk/sql12/doc/src/main/resources/images/global_laf.png
trunk/sql12/doc/src/main/resources/images/global_proxy.png
trunk/sql12/doc/src/main/resources/images/global_sql.png
trunk/sql12/doc/src/main/resources/images/global_sqlscripts.png
trunk/sql12/doc/src/main/resources/images/history_arrow.png
trunk/sql12/doc/src/main/resources/images/history_dialog_icon.png
trunk/sql12/doc/src/main/resources/images/last_log_entry_dialog.png
trunk/sql12/doc/src/main/resources/images/log_messages_status.png
trunk/sql12/doc/src/main/resources/images/logo.jpg
trunk/sql12/doc/src/main/resources/images/logo_1.jpg
trunk/sql12/doc/src/main/resources/images/mdi_session_layout.png
trunk/sql12/doc/src/main/resources/images/ok_st_obj.gif
trunk/sql12/doc/src/main/resources/images/plugins_1.png
trunk/sql12/doc/src/main/resources/images/scrollable_tabs.png
trunk/sql12/doc/src/main/resources/images/session_1.png
trunk/sql12/doc/src/main/resources/images/session_2.png
trunk/sql12/doc/src/main/resources/images/session_background_color_example.png
trunk/sql12/doc/src/main/resources/images/session_props_general.png
trunk/sql12/doc/src/main/resources/images/session_props_objecttree.png
trunk/sql12/doc/src/main/resources/images/session_props_sql.png
trunk/sql12/doc/src/main/resources/images/sql_1.png
trunk/sql12/doc/src/main/resources/images/sql_2.png
trunk/sql12/doc/src/main/resources/images/sql_history_dialog.png
trunk/sql12/doc/src/main/resources/images/sql_history_list.png
trunk/sql12/doc/src/main/resources/images/stacked_tabs.png
trunk/sql12/doc/src/main/resources/images/tabbed_session_layout.png
trunk/sql12/doc/src/main/resources/images/toolspopup.jpg
trunk/sql12/doc/src/main/resources/images/update-dialog.png
trunk/sql12/doc/src/main/resources/images/update-settings.png
trunk/sql12/doc/src/main/resources/images/update_download_progress.png
trunk/sql12/doc/src/main/resources/images/update_summary.png
trunk/sql12/doc/src/main/resources/images/updates-menu.png
trunk/sql12/doc/src/main/resources/licences/
trunk/sql12/doc/src/main/resources/licences/dean_jones_icons_licence.txt
trunk/sql12/doc/src/main/resources/licences/eclipse-icons-licence.html
trunk/sql12/doc/src/main/resources/licences/eclipse-icons-licence.txt
trunk/sql12/doc/src/main/resources/licences/log4j-licence.txt
trunk/sql12/doc/src/main/resources/licences/nano_xml_licence.txt
trunk/sql12/doc/src/main/resources/licences/squirrel_licence.txt
trunk/sql12/doc/src/main/resources/licences/sun_icons_licence.txt
trunk/sql12/doc/src/main/resources/news.txt
trunk/sql12/doc/src/main/resources/plugins.html
trunk/sql12/doc/src/main/resources/quick_start.html
trunk/sql12/doc/src/main/resources/readme.html
trunk/sql12/doc/src/main/resources/readme.txt
trunk/sql12/doc/src/main/resources/style.css
trunk/sql12/doc/src/main/resources/welcome.html
Removed Paths:
-------------
trunk/sql12/doc/changes.txt
trunk/sql12/doc/images/add_alias_1.png
trunk/sql12/doc/images/add_exc.gif
trunk/sql12/doc/images/alias_properties.png
trunk/sql12/doc/images/alias_properties_button.png
trunk/sql12/doc/images/alias_properties_dialog.png
trunk/sql12/doc/images/alias_properties_dialog2.png
trunk/sql12/doc/images/alias_properties_dialog3.png
trunk/sql12/doc/images/alias_properties_dialog4.png
trunk/sql12/doc/images/alias_properties_dialog5.png
trunk/sql12/doc/images/alias_window_no_tree.png
trunk/sql12/doc/images/alias_window_with_tree.png
trunk/sql12/doc/images/aliases_tool_window_1.png
trunk/sql12/doc/images/chg_driver_1.png
trunk/sql12/doc/images/chg_driver_2.png
trunk/sql12/doc/images/color-properties.png
trunk/sql12/doc/images/connect_window.png
trunk/sql12/doc/images/createresultwindow.gif
trunk/sql12/doc/images/discovery.gif
trunk/sql12/doc/images/drivers_tool_window_1.png
trunk/sql12/doc/images/error_st_obj.gif
trunk/sql12/doc/images/fonts_menus_demo.png
trunk/sql12/doc/images/fonts_other_demo.png
trunk/sql12/doc/images/fonts_static_text_demo.png
trunk/sql12/doc/images/fonts_status_bar_demo.png
trunk/sql12/doc/images/global_bookmarks.png
trunk/sql12/doc/images/global_data_types_part1.png
trunk/sql12/doc/images/global_data_types_part2.png
trunk/sql12/doc/images/global_fonts.png
trunk/sql12/doc/images/global_general.png
trunk/sql12/doc/images/global_laf.png
trunk/sql12/doc/images/global_proxy.png
trunk/sql12/doc/images/global_sql.png
trunk/sql12/doc/images/global_sqlscripts.png
trunk/sql12/doc/images/history_arrow.png
trunk/sql12/doc/images/history_dialog_icon.png
trunk/sql12/doc/images/last_log_entry_dialog.png
trunk/sql12/doc/images/log_messages_status.png
trunk/sql12/doc/images/logo.jpg
trunk/sql12/doc/images/logo_1.jpg
trunk/sql12/doc/images/mdi_session_layout.png
trunk/sql12/doc/images/ok_st_obj.gif
trunk/sql12/doc/images/plugins_1.png
trunk/sql12/doc/images/scrollable_tabs.png
trunk/sql12/doc/images/session_1.png
trunk/sql12/doc/images/session_2.png
trunk/sql12/doc/images/session_background_color_example.png
trunk/sql12/doc/images/session_props_general.png
trunk/sql12/doc/images/session_props_objecttree.png
trunk/sql12/doc/images/session_props_sql.png
trunk/sql12/doc/images/sql_1.png
trunk/sql12/doc/images/sql_2.png
trunk/sql12/doc/images/sql_history_dialog.png
trunk/sql12/doc/images/sql_history_list.png
trunk/sql12/doc/images/stacked_tabs.png
trunk/sql12/doc/images/tabbed_session_layout.png
trunk/sql12/doc/images/toolspopup.jpg
trunk/sql12/doc/images/update-dialog.png
trunk/sql12/doc/images/update-settings.png
trunk/sql12/doc/images/update_download_progress.png
trunk/sql12/doc/images/update_summary.png
trunk/sql12/doc/images/updates-menu.png
trunk/sql12/doc/licences/dean_jones_icons_licence.txt
trunk/sql12/doc/licences/eclipse-icons-licence.html
trunk/sql12/doc/licences/eclipse-icons-licence.txt
trunk/sql12/doc/licences/log4j-licence.txt
trunk/sql12/doc/licences/nano_xml_licence.txt
trunk/sql12/doc/licences/squirrel_licence.txt
trunk/sql12/doc/licences/sun_icons_licence.txt
trunk/sql12/doc/news.txt
trunk/sql12/doc/plugins.html
trunk/sql12/doc/quick_start.html
trunk/sql12/doc/readme.html
trunk/sql12/doc/readme.txt
trunk/sql12/doc/style.css
trunk/sql12/doc/welcome.html
Property Changed:
----------------
trunk/sql12/doc/
Property changes on: trunk/sql12/doc
___________________________________________________________________
Added: svn:ignore
+ target
.settings
.project
.classpath
Deleted: trunk/sql12/doc/changes.txt
===================================================================
--- trunk/sql12/doc/changes.txt 2010-08-21 18:18:54 UTC (rev 5830)
+++ trunk/sql12/doc/changes.txt 2010-08-21 18:21:11 UTC (rev 5831)
@@ -1,2560 +0,0 @@
-SQuirreL SQL Client Change Log
-==============================
-
-Not yet released - available from SVN or in the latest snapshot:
-----------------------------------------------------------------
-
-Enhancements:
-
-Session Property: "Keep SQL result table layout on rerun SQL"
-If this option is checked the layout of the table of a SQL result is tried to be restored after rerunning the SQL.
-Note: You rerun a SQL when you click the running man button on the upper left of a SQL result.
-
-
-New way to view query results: There is an new tab inside a query result named "Overview".
-It might need some trying out to understand what it does.
-
-
-Incorporated patch which provides a node in the object tree called LOB which lists all LOBs, providing
-details about each (Thanks to Bogdan Cristian Paulon)
-
-Incorporated patch which provides a node under each table in the object tree that lists all of the
-constraints for that table. (Thanks to Bogdan Cristian Paulon)
-
-Bug-fixes:
-
-RSyntax: Turned off drag and drop inside the editor. It conflicted with our
-drag and drop feature for files and caused editor texts to vanish. See bug #3006515.
-
-RSyntax: When code reformatting was used on Windows, carriage return chars (\r) where inserted in the editor.
-These chars made keyboard arrow keys fail: If you stepped over an \r the key hit did nothing.
-
-
-2991971: RSyntax text editor ignores font settings
-2992443: Cannot use RSyntax or Netbeans editors
-2973045: Export to excel results in strange rounding; Thanks to Bogdan Cristian Paulon for the patch
-
-Parser could be triggered far to often which resulted in high CPU and memory load.
-This problem was caused by redundant carriage return chars (\r).
-
-Any redundant carriage return chars (\r) are removed from files.
-On Win Platforms carriage return line feeds (\r\n) are kept for new lines.
-
-3.1.1 (4/24/2010)
-================
-
-Enhancements:
-
-Code completion Plugin:
- - Users may choose to see column remarks in completion lists.
- See Menu File --> New Session Properties --> Code Completion --> Checkbox an bottom of panel
-
-Hibernate Plugin:
- - Results of HQL Queries can be displayed as objects
- - Hibernate logs can be seen in SQuirreL logs when Hibernate logging is configured for console output.
-
-
-Bug-Fixes:
-
-2991709: Quotes missing in squirrel-sql.bat
-2990527: nChar() is unknown field
-2982594 / 2988387: RSyntax editor crash
-When database errors occured while loading table columns, SQuirreL slowed down and produced a lot of log messages.
-2981691 / 2981694: squirrel-sql.bat fails on Windows 7 64 bit
-2980873: squirrel-sql.bat doesn't work out of box
-2978540: Identifiers starting with '_' where not handled as identifiers by the RSyntax lexer. This resulted in syntax coloring and completion problems.
-2974533: Informix: Method can be called only once. / ErrorCode: -79
-2965617: Fail to open session with RSyntax editor
-2963371: Splash on 3.1 - copyright (was not updated for 2010)
-
-
-
-3.1 (3/3/2010)
-================
-
-Enhancements:
-
-Updated Translations:
- - Korean (Thanks to Youngwoo Kim)
- - Chinese (Thanks to xpdz)
- - French (Thanks to Erwan DUROSELLE)
-
-Improved display of SQL result metadata
-
-Hibernate Plugin:
- The Classpath configuration now allows to move entries up or down.
-
-New plugin for Netezza NPS database server. This plugin allows for viewing source and details of Views,
-Stored Procedures, and synonyms. It also provides the ability to execute stored procedures in the SQL Editor.
-See Help for screenshots and more details.
-
-Aliases now have the ability to setup a keep-alive SQL statement and sleep time (in seconds) to prevent a
-connection from being disconnected while appearing to be idle. This is done using the new Connection tab
-on the Alias properties dialog.
-
-Derby Plugin:
- New tab to display the source code of Derby stored procedures
- Thanks to Glenn (bassnfool2) for the patch (Patch ID 2907220)
-
-XML Export:
- Tables in SQuirreL's GUI now allow to export data as XML (besides CSV and MS-Excel export)
- Thanks to mironsadziak for the patch (Patch ID 2905595)
-
-New editor component: RSyntaxTextArea by fifesoft.com.
- New features:
- - No long line problems
- - Enhanced search functions:
- shift F3: Find selected.
- F3: Repeat last find.
- control shift F3: Mark selected.
- escape: Unmark all.
- - Line numbers can be displayed
- - Current line can be highlighted
- Note: On MS-Windows systems the Java-VM parameter -Dsun.java2d.noddraw=true must be set in your SQUirreL
- start batch to prevent performance problems.
-
-
- - New Polish translation available (Thanks to Miron Sadziak)
-
-Better table header rendering for MAC OS
- Thanks for Brian Mauter's Patch (ID 2856103)
-
-Feature request 2826175:
- Number of rows read is now visible on message panel and results tab.
-
-Feature request 1656320:
- Background Color Configuration is now available via a new tab ("Color Properties") in Alias
- Properties dialog.
-
-MySQL Plugin
- Fixed object tree menu items:
- * Create database (on root node)
- * Drop database (on catalog nodes)
- * Rename (on table nodes)
-
-SQL Scripts Plugin:
- New checkbox 'Use double quotes (") for qualifying' in global scripting preferences.
-
-Feature Request #2818444: Oracle: Connecting as SYS not possible - now it is possible to add the necessary
-driver property to connect as SYS, or any other account that needs to connect as SYSDBA.
-
-Look & Feel Plugin
- - Better support for Nimbus: No horizontal scrollbars on pop up lists (e.g. code completion)
- - Removed choices for Metouia and OYOAHA as these are not supported for use in Java 6.
-
-Oracle Plugin
- - SQL*Loader control file generation.
- Adds a new right mouse menu item to tables in the object tree: "Generate SQL*Loader control file"
- Thanks to José David Moreno Juárez for the patch (Patch ID 2776344)
-
-About dialog now has a clickable link to our home page.
- - Thanks to Hashim Kubba for this patch (ID 2104309)
-
-Graph Plugin:
- - Show constraint name can be selected on each constraint separately. See right mouse menu on constraint
- line.
- - Allowed constraints to be created using drag and drop.
- To create such a non-DB constraint using drag and drop hold
- down the control key. Then right click the constraint to configure it.
-
-
-Bug-Fixes:
-
-SQuirreL was seen consuming a lot of memory and CPU.
- For details about the fix see comments in class ExitParserThreadRequestException
- See: http://squirrel-sql.cvs.sourceforge.net/viewvc/squirrel-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/parser/kernel/ExitParserThreadRequestException.java?view=log
-
-Loading and saving files on Windows produced multiple CR (carriage return) chars in files.
-When copy and paste was used on such files multiple empty lines were created.
-Note: The Windows standard editor Notepad shows multiple CR chars where they exist and allows to remove them.
- SQuirreL does not remove them automatically at any place.
-
-Moved focus to SQL Editor when it gets visible through previous Session / next Session navigation (Alt left/right)
-
-Fixed class not found exception in Oracle Plugin when setting Session Time Zone.
-Thanks to Neville Rowe
-
-
-2946165: preferences messages not translatable
-2946160: translation missing in refactoring
-2944128: remote not translatable
-2942351: Program doesn't launch
-2927576: NPE at Copy as SQL INSERT-VALUES
-2913463: Problems with system classpath with quotes
-2908407: MSSQL driver plugin example URL isn't correct
-2891190: block comment content produces error
-2879711: Fix for Excel date export concerning dates earlier than 1900-03-01.
- Thanks to mironsadziak for the patch (Patch ID 2905218)
-2853329: Ctrl-S overwrites existing file on 2nd try
-2819161: squirrel-sql.sh in plain zip had an errant apostrophe. Tested this fix on MacOS 10 and Ubuntu 9.04.
- Thanks to Jonathan James for vetting the anonymously submitted patch.
-2818117 ("Make Editable" uses column label instead of name)
- Thanks to Christian Gruenberg for the patch (Patch ID 2924887)
-2801011: Sybase (CREATE TABLE script generate decimal(15,2) instead of (15,4))
-2794860: Sybase (CREATE TABLE script generate numeric(15) instead (15,2))
-2754166: SQLScript plugin loses precision for Timestamp in H2
-2746982: Error occured in IPlugin.sessionEnded() for SQL Parametrisation
-2713952: Create table script (on Sybase): Always generate "datetime" type for "date" (and datetime)
-2657987: Session was closed even if session closing confirm dialog was not confirmed. Connection was not
- closed then.
-
-ArrayIndexOutOfBounds exception occured when more than one Alias was deleted form Alias tree
-
-Fixed startup error:
- java.lang.NullPointerException
- at ... .AliasFolderState.applyExpansionAndSelectionToNode(AliasFolderState.java:144)
-
-Error in Alias tree: Alias vanished or gave an error when dragged on itself.
-
-SQL Scripts Plugin:
- - Several scripting functions did not respect global scripting preferences about qualifying tables.
- - When generating insert scripts from a SQL statement the global
- preference "Qualify table names in generated scripts with the schema name" did not work.
- Thanks to Johann Geyer for the patch (Patch ID 2365193)
- - Generating data scripts may throw java.lang.StringIndexOutOfBoundsException when timestamps where scripted
- - Foreign key constraints with more than one column were not scripted correctly. (Only first column was
- included.)
-
-Schema caching:
- Removed problems with selective schema caching when the same table name
- exisits in two different schemas. E.g. column completion didn't word anymore.
-
-Stored Procedures that return a mix of update counts and results sets weren't displayed properly.
-
-
-3.0.1 (3/23/2009)
-================
-
-Enhancements:
-
- - New Korean translation available (Thanks to Youngwoo Kim)
-
-Bug-Fixes:
-
-2686268: OS X Look and Feel is Incorrect
-2645286: Quotes missing in squirrel-sql.sh (Thanks to mdykierek for the patch)
-2531193: Oracle create table script the "ON UPDATE" is wrong
-2644778: "Contents Tab SQL filter" and "Limit cell edit WHERE clause size" dialogs didn't work
-
-Other reported bug-fixes:
-
- - Fixed UI freeze issue which sometimes occurred when using software update feature.
-
- - Better support for PointBase 5.7
-
- - Fixed bug which caused NullPointerException in Refactoring when modifying column types
-
- - Fixed bug which occurred when generating FK SQL for DB2 where the update and delete action clause result
- in syntax error for certain standard constraint actions.
-
- - Fixed the case of the install directory (java -> Java) to match the case of the directory created by the
- installer.
-
- - NullPointerException occured when last tab was closed
-
- - Fixed several problems when Schemas where cached. For example, "Contents Tab SQL filter" and
- "Limit cell edit WHERE clause size" dialogs did not open.
-
- - Fixed a problem where when certain windows were closed (for example, the Session Properties window) the
- first tab was always selected
-
-3.0 (2/21/2009)
-==============
-
-Enhancements:
-
-Dataimport Plugin:
- * SuggestColumns: if columns in database and in the first line of the file
- are equal, they are matched for the import.
-
-Sybase Plugin:
- * New ExceptionFormatter for SQLWarnings: better viewing warnings while the parameter
- showplan is on (set showplan on)
-
-Look an Feel Plugin:
- * Made Nimbus look and feel available (needs at least JDK/JRE 1.6.0_10)
- * Made Metal look and feel with Ocean theme the default (used at first start up).
- * Added warning message that look and feels other than Metal may cause perfomance and/or functional problems
-
-
-Updated Italian translation (Ivo Neri), Chinese translation (xpdz), French translation (Erwan Duroselle)
-
-New user interface layout: Tabbed layout
-
-Hibernate Plugin:
- - Cleaned up details display in mapped objects tab: Now every tree node displays an appropriate details table.
- - Added hint to solve StackOverflowError caused by logging that may occur when connecting to a Hibernate configuration.
-
-Object tree search (Feature request 2004240):
- Above the Object tree is a text field and a find button.
- The search string has to be the exact simple (unqualified) name of an DB object or may contain placeholders ("%" or "_").
- The text field supports code completion.
- A filter button allows to apply the search string as Object tree filter.
-
-Object tree filtering:
- Multiple (comma separated) Object tree filters can be defined. Filter conditions can be excluding oder including.
- Better support for placeholders "%" and "_".
- See "Session Properties"/"New Session Properties" dialogs --> Tab "Object Tree".
-
-Graph Plugin:
- - Qualified table names can now be displayed. Use the right mouse menu on graph background.
-
-Edit Extras Plugin:
- - Improved handling and look of Escape date dialog.
-
-Graph Plugin:
- - New entries in table's popup menu: "Copy table name" and "Copy qualified table name".
- - Columns of all tables in a graph can now be ordered at once. Use the right mouse menu on graph background.
-
-New Plugin: Smarttools by Michael Romankiewicz
- - Searching for tables that do not have a primary key or unique index or index.
- - Searching for non nullable columns that contain null values. Some DBs e.g. Firebird can be tricked to have this inconsistency.
- - Changing values database wide according to specified criteria.
- For more information see the Plugin's help.
-
-
-New Plugin: Firebird Manager by Michael Romankiewicz
- - Storing and restoring Firebird DBs
- - Managing users and roles for the Firebird RDBMS
- For more information see the Plugin's help.
-
- - Aliases can be displayed as list or as tree.
-
- - A new preference for choosing Locales is available in Global Preferences -> General tab. This allows you to
- set your preferred locale, and if an optional translation is installed that corresponds with the preferred
- locale, then restart and the changes take effect.(No longer necessary to hand edit the start script)
-
- - Copy as "SQL WHERE" / "UPDATE-SET" / "INSERT-VALUES" statement function in tables
- Tables offer right mouse menu to copy WHERE, UPDATE-SET or INSERT-VALUES clauses of selected data to clip board.
- Works like the existing "Copy as SQL IN statement" function.
-
- - New Plugin: SQLReplace by Dieter Engelhardt
- This plugin replaces a set of variables before a statement is executed.
- The variables to replace can be defined at the Plugin's Global Preferences tab.
-
- - Added a preference option to allow the selection of items in lists to change while activating
- the popup menu on a single right-mouse button click. For example, without this, you need to
- select an object in the tree with a left mouse button click, then press the right mouse button
- to activate the popup menu.(See Global Preferences -> General -> Select On Right Mouse Click)
-
-Data Import Plugin: It now warns the user when importing data into an existing table, that it's current data
- will be truncated first.
-
-DBCopy Plugin:
- - Added support for mapping the DISTINCT source column type for copying data from PostgreSQL
-
-DB2 Plugin: Lars Heller provided a patch to add support for XML column types in SQuirreL via the
- DB2 Plugin (tested against DB2 v9.5 LUW)
-
-Oracle Plugin:
- - Added validity (VALID|INVALID) field to trigger details tab for triggers.
- - Allow the user to configure whether or not to show the syntax error offset in
- the SQL Editor. This feature creates a user-defined function called
- SQUIRREL_GET_ERROR_OFFSET, which can be disabled.
- - Added ability to recognize "create package" and "create package body" statements.
-
-PostgreSQL Plugin:
- - Added support for PostgreSQL(8.3.x) new XML type.
-
- Contributions from Daniel Regli and Yannick Winiger:
- - Menu: added a new "PostgreSQL" menu to the object tree and the session menu for
- PostgreSQL-specific functionalities.
- - Vacuum: added visual (dialog) support for the PostgreSQL-specific VACUUM statement for
- garbage-collecting a selection of tables or the whole database.
- - Explain: added an additional SQLResultExecuter to the sql panel that shows
- the query plan of executed statements.
-
-Refactoring Plugin:
- - Fixed bug which caused column comment alter statement to be generated even when no column column
- change was made.
-
- - Don't try to order the list of tables to be dropped (forcing FK info retrieval)
- when there is only one table being dropped.
-
- - Contributions from Daniel Regli and Yannick Winiger:
- Added new Refactorings (All new refactoring dialogs can now be closed with the ESCAPE key):
- - Rename Table
- - Add/Rename/Drop View
- - Add/Modify/Drop Sequence
- - Add/Drop Index
- - Add/Drop Foreign Key
- - Add/Drop Unique Constraint
- - Add Lookup Table
- - Add Auto Increment
- - Merge Column
- - Merge Table
-
- - Refactoring, scripting for Intersystems Cache DB:
- Made Refactoring and scripting functions available for the Intersystems Cache DB by activating its
- Hibernate dialect.
-
-Bug-Fixes:
-
-SQL Replace Plugin: Fixed a bug that caused patterns such as $P{startDate} to throw an exception.
-
-Add/Edit Alias window did not resize properly
-
-SQL Scripts Plugin: On some DBs (e.g. MySQL) "Store result of SQL in table"
- did not work for SQLs that returned a lot of rows.
-
-
-Graph Plugin: Table's right mouse menu "Add Parent tables" did add a parent more
- than once when more than one foreign key to the parent existed.
-
-Graph Plugin: Refresh didn't work for newly created constraints
-
-Fixed several bugs which made it impossible to work with SQLite.
-
-Fixed a bug which made it difficult to see text that was being edited in a table.
-
-2609090: Auto update fails if "empty" change list is validated
-
-2480365: Plugin loading fails when installdir has spaces
-
-2220792: SQLite: content not editable
-
-2184379: (SQuirrel client 2.6.6 fills up 52 gigs of log file space). Added a new log
-appender that is based on file size rather than time.
-
-2119937: Windows EOL chars (CRLF) are converted to Linux EOL (LF).
-
-2104422: Fixed some potential bugs (Thanks to Hashim Kubba)
-
-2102894: Missing Scale Placeholder in Sql server dialect. This causes script generation and dbcopy
-targeting MS-SQL server to produce decimal columns without the scale attribute (that is, decimal(7) instead
-of decimal(7,5))
-
-2092902: Focus remains on hidden session window for Alt-Arrow. Removed code which was a
-work-around for a bug in java 1.3, that has since been fixed and was actually producing a
-bug seen in java5 and java6, where the Alt-RightArrow key shortcut switched session windows
-into the foreground without giving them focus. Thanks goes to Johnathan James for the
-bug-fix.
-
-2091569: FAQ is missing its images
-
-2049336: Make Editable disappear from SQL/results tab
-
-2018512: DB2 timestamps still don't work when milliseconds are zero. Patch submitted by Daniel Stränger.
-
-2018018: (Bug in FormatSql function) Formatter now uses platform-specific EOL char sequence.
-
-2013346: export csv with option "carriage return + linefeed"
-
-1995728: Unable to switch database
-
-1958881: (Unable to see source of database views) Adjusted the query for view source to use
-underlying system tables instead of INFORMATION_SCHEMA.VIEWS, since this view cannot handle views
-that are greater than 4000 characters.
-
-1968807: Unsigned INT problem with IMPORT FILE functionality
-
-1968270: Displaying unsigned INT as signed INT in column
-
-1845987: PostgreSQL interval types are not displayed
-
-1840266: Create Table Script sets varchar columns to 8000
-
-1830649: Focus Loss
-
-1824534: Constraint created twice
-
-1902611: (Oracle) Don't fail on SQL-Plus "SET ..." commands in SQL script; Now, the Oracle plugin skips over
- them.
-
-1876352: (DB2) Incorrect TIMESTAMP in create data script (loss of precision - nanosecond component - also
- affected other databases.
-
-1861402: (Informix catalog switching doesn't work correctly)
- - Better catalog switching behavior for databases that support catalogs. Now if a connection is made
- without specifying the catalog, a place-holder
- catalog ("None") is inserted into the catalog drop-down menu and removed once a catalog is selected.
- - Fixed a race condition that caused the tree to be refreshed before data was refreshed from the database
- when the catalog was switched.
- - For Informix, setCatalog seems to have no effect, so now an explicit DATABASE <catalog name> command is
- issued.
-
-1848924: Sybase object browser contents not displayed
-
-1769599: fix for permission problem with Windows Vista. Now we create our temporary path file in a temporary
-location that the user should always be able to write to. Thanks to user aberdeen61 for contributing the
-fix.
-
-1596240: Fixed bug when displaying HSQLDB->Objects->Content, where contents are not shown and exceptions are
-thrown because tables are not being qualified with the schema name.
-
-1541325: (Derby) Connection doesn't close when ending session - thanks goes to Alex Pivovarov for the
- patch that fixed the issue.
-
-Bug-Fix for bug that caused Frontbase indexes not to be displayed in the indexes tab, for tables in the
-Object tree.
-
-Fixed identifier qualification in Progress - tested on OpenEdge 10.1C. Now only schema is pre-fixed to
-identifiers, instead of catalog and schema.
-
-Code Completion Plugin:
- - Made column completion available for databases/JDBC drivers that support catalogs and/or schemas
- but don't provide catalog or schemas in their column meta data. For example some versions of MySQL
- show this behavior.
-
-DBCopy Plugin:
- - Only attempt to order the tables being copied if there is more than one table in the copy set.
-
-Changing to another window using Alt + left/right arrow did not properly set focus.
-
-Hibernate Plugin:
- - Class names in completion list could change from fully qualified to simple
- while scrolling through the completion list.
- - Fixed identifier qualification in Progress - tested on OpenEdge 10.1C.
- Now only schema is pre-fixed to identifiers, instead of catalog and schema.
- When a statement like "from Kv k where k." was completed the fields for k. would come from
- any arbitrary mapped class which name started with Kv
-
-Refactoring Plugin: When generating DROP TABLE statements, Frontbase requires
-CASCADE or RESTRICT. Now we append CASCADE to the DROP TABLE statement.
-
-1830649: Focus Loss
-1820792: Sybase ASE - table not shown in object browser
-1821354: Changing default value of a column in Derby does nothing
-1820214: 2.5.1 DB aliases do not transfer properly to 2.6.1
-1820020: modified tables aren't sorted
-1815667: Create Table Script does not include column defaults
-
-Syntax Plugin: Fixed memory leak which caused sessions not to be garbage
-collected.
-
-Bug-fix for plugin unloading where unloading a session plugin did not prevent
-it from binding to new sessions.
-
-2.6.1 (10/24/2007)
-==============
-
-Bug-Fixes:
-
-1818446: Packaging problem in v2.6 on MacOS X
-1805954: Tables not in alpha order in Object view
-
-2.6 (10/20/2007)
-==============
-
-Enhancements:
-
-New Plugin (Hibernate)
- - allows to generate SQL statements from Hibernate HQL statements
- - shows object tree of mapped objects
- - HQL Code completion and syntax highlighting
- - Three ways to create a HibernateSessionFactory
- * Native way using "new Configuration().configure().buildSessionFactory();"
- * JPA way using "Persistence.createEntityManagerFactory("<persitence-unit name>");"
- * User defined way to by calling a user defined provider method.
- See help for further details.
-
-Improved speed at which large files are loaded into import popup for
-CLOB/VARCHAR cells.
-
-Added basic drag-n-drop to transfer a file from the desktop into an SQL Editor
-panel.
-
-
-New Plugin (SQL Parametrisation - Thorsten Mürell) allows you to put variables
- into your SQL statements.
-
-New Plugin (Data import - Thorsten Mürell) allows you to import arbitrary files
- into the database.
-
-DBCopy Plugin:
- - Copy thread will wait for the dialog record progress bar to be updated
- before continuing to copy records.
- - Fixed bug which caused cursors to remain open in the source database after
- the copy operation was complete.
-
-DB2 Plugin:
- - Added tab for displaying the source code for DB2 MQTs as well as DB2
- tables.
- - Added support for OS/400 (trigger source and details not yet implemented).
- Special thanks goes to Tilmann Brenk for submitting OS/400 versions of all SQL
- statements required to support the plugin features.
- - Added support for showing user-defined functions in the object tree and the
- source code that is associated with them if it is available.
- - Exceptions from DB2 Universal JDBC driver are now interpreted as
- DB2Diagnoseable exceptions so that the cause of the exception can be printed
- (Thanks to Christoph Schmitz).
- - When the source tab of a C-language stored procedure is selected, we now
- show the user a nice informative message stating that the source code is
- unavailable instead of merely displaying the word "null".
-
-Code Completion Plugin:
- When Ctrl+Space is hit while completion popup is already open the prefix up to
- where all completion candidates match will be written to the SQL editor. The
- completion popup will remain open.
-
-Derby Plugin: New custom QueryTokenizer which allows Derby sessions to give the
- command: run '<abs-path-to-script>'
- This reads in the file and executes it's statements. This is
- supported in Derby's own ij command-line interpreter.
-
-Firebird Plugin: Added triggers node for each table to display triggers.
-
-Informix Plugin:
- - 1732161: Fixed Source code of procedures and triggers to work
- with Informix version 7.3.1
- - When executing an SQL statement with a syntax error, the driver is now asked
- to provide the position of the error in the statement. If it is available,
- the cursor is moved to the position of the incorrect syntax.
-
-LAF Plugin: Added Substance 4.0 look and feel as an option.
-
-MySQL Plugin:
- - Added support for handling stored procedure create statements.
- - Added source tab for Stored Procedures, Triggers and Views. Triggers are
- displayed as object nodes beneath tables as is done in other plugins.
-
-Oracle Plugin:
- - 1446678 (SQL Error Help) Added capability to put the cursor at the position
- in the SQL where the statement failed.
- - 890843, 1787653: Added support Oracle's SYS.XMLTYPE column.
- - Warning message is displayed if string literal timestamp setting is used for
- internal where clauses - this setting may result in the inability to edit
- tables.
- - (Feature Request 1735530: Hide Oracle Bin$.....==$0 tables )
- Added configuration for removing the Recycle Bin tables from the object tree.
- - Show the source for Oracle tables, as well as materialized views.
- - Added additional query tokenization pass to find begin...end;/ type
- anonymous procedures.
-
-PostgreSQL Plugin:
- - Added database locks display tab for PostgreSQL sessions. Click on the top
- node in the object tree and look for a "Locks" tab. Code was adapted from Rocco
- Rutte's tab of the same name and purpose in the EclipseSQL project.
-
-Refactoring Plugin:
-
- - Fixed problem where the comment of a column could not be altered if it was
- null.
- - Refactored drop tables command to not use the event dispatch
-thread for calculating foreign keys(UI Responsiveness). Also, now FKs in child
-tables are dropped before any parent tables are dropped when cascade
-constraints is selected.
-
-SQLScripts Plugin: Now uses types generated by Hibernate dialects for create
-table script feature. Also, it now uses the session query tokenizer.
-
-Sybase Plugin: Added new trigger and index nodes beneath tables in the tree.
-Also, added trigger source tab for triggers.
-
-Patch 1761706 (Miscellaneous Java 5 Generics) submitted by Bron Eubanks
-
-Task 138098 (Plugins Session Menu Items (Disable)) When using a session that
- is not supported by a db-specific plugin, that plugin should disable it's
- Session menu items
-
-Task 137959 (Refactor PreferencesManager) removed redundant plugin class
- definitions related to Preferences which were very similar.
-
-- Added unload button to plugin summary dialog which will cause the selected
- plugin to be unloaded.
-
-- Added support for setting whether or not plugins are loaded at startup
- (without physically removing them), using the plugin summary dialog. You must
- restart SQuirreL for plugin change to take effect.
-
-- Added 'Use PK' button on the "Edit Where clause" dialog which will cause only
- PK columns to be used for updating rows in the table contents panel.
-- Added "All Objects" to alias properties.
-- Use the last directory that a file was imported from when importing
- additional files for binary fields.
-
-1757076: (DATE column seen as TIMESTAMP, update in editable mode fails) Changed
-the default of "Read Date as Timestamp" to false. This setting breaks editing
-dates on Derby.
-
-1743720: (Save settings immediately, not only when closing SQuirreL). Now there
-is a setting in Global Preferences to "Save Preferences Immediately" (Default
-is true) Additionally, if this is not desired and it can be disabled to give the
-old behavior (faster), and a new menu item under "File" called "Save Preferences"
-is available to immediately save everything that is normally saved during
-shutdown.
-
-1742033: (Skipping quoting escape in table dropping) Refactoring plugin drop
-table functionality now handles tables with embedded double quotes by doubling
-the double quotes to allow the database to recognize the doubled quote as a
-single quote which is part of the identifier. Thanks goes to Thomas Mueller
-(from www.h2database.com) for contributing code to fix the issue)
-
-1731251: (Cryptic exceptions with DB2 JCC driver) Provides an API to allow
-plugin authors to create and register custom exception formatters to be used
-when displaying error messages and the like in the session message panel.
-
-Updated French translation (Thanks to Erwan Duroselle)
-Finished German translation
-
-Bug-Fixes:
-
-Statements like
-"SELECT TestTab.testid, TestTab.testname FROM TestTab"
-were not editable.
-
-Fixed bug in CodeReformator which is exposed when the statement separator
-is "|". Also, made formatted source tab able to handle this type of problem
-more gracefully by showing the source in it's original form, instead of
-nothing at all.
-
-Goto line dialog (ctrl+g) was missing labels.
-
-1752089 (ConcurrentModificationException raised when loading schema)
-
-1716859 Can't see data in content tab or row count tab (MS SQLServer databases
- with a dash ("-") in their name would cause the content tab or row count
- tabs to render no data.
-
-1714476 (DB copy uses wrong case for table names) The copy operation would
- sometimes fail to select records from the source table. Since the
- case for the source table is always known to be correct, the plugin
- no longer erroneously attempts to correct the case.
-
-1714475: (Adding rows from the content tab) When inserting row data, pay
- attention to isAutoIncrement flag so that these columns are excluded
- like rowId columns. After insert, refresh the table data so that
- auto-generated fields are populated.
-
-1704798 ISQLExecutionListeners cannot return "null"
-
-1701380 addSQLExecutionListener is broken
-
-1700093 Formatter fails for insert script with multiple sub-selects
-
-1699294 Squirrel imports BLOB, but does not update data
-
-138092 (PostgreSQL table types) Now PostgreSQL table types list and object tree
- exclude "SYSTEM INDEX" type. Treating these objects as tables causes
- lots of SQLExceptions from the PostgreSQL jdbc driver.
-
-Refactoring Plugin:
- - When building a new TableColumnInfo, if the defaultValue textfield is blank,
- then make the default value be null.
-
-Task 137984 (Bug in alias delete) The problem was that notifications were
- being sent to the alias drop-down that the item was being deleted which
- triggered an update and new selection forcing the connect to alias window to
- be launched. Now, the alias drop down is disabled while the update is
- happening and enabled immediately afterward.
-
-Fixed a bug that occurred when no plugin installs a custom QueryTokenizer in
-a Session - changing the session properties for query tokenizing has no
-effect.
-
-Fixed bug which appeared while editing tables in PostgreSQL 8.1. If the table
-was created without an OID column, the last column would not be editable.
-
-Fix for issue where dates aren't correctly displayed or updated when using
-'treat date as timestamp' pref in the SQl Editor result panel.
-
-2.5 (4/7/2007)
-==============
-
-Enhancements:
-
-- Updated Czech translation (Thanks to Jan Kostrhun)
-- Updated Simplified Chinese translation (Thanks to xpdz)
-- Updated French translation (Thanks to Erwan Duroselle)
-- Updated Italian translation strings (Thanks to Ivo Neri)
-
-- When the user control-clicks on an identifier in the SQL editor it takes you
- will show that object in the object tree (Same behavior as Ctrl-b).
-
-- Dialog prompt to save file changes on exit, now includes the filename in
- case there are multiple open files in different sessions. Also, the session
- alias name appears in the title, in case the editor contents aren't yet
- associated with a file.
-
-- SQL history window
- The contents of the SQL history combo box can now be opened in a window
- where the user can search for formerly excuted statements. The history
- is available through a button next to the SQL history combo box or through
- tools pop up (ctrl+t).
-
-- Export: Warn the user when exporting data to CSV/Excel if there are Clob
- placeholders (<Clob>) in the table data being exported. Also, let the user
- know when the export to file is complete, if no command is to be executed to
- show the exported file.
-
-- 'Delete Records' action now orders the selected tables in order to satisfy any
- FK dependencies. Previously, this operation would fail if PK tables preceded
- (by name alphabetically) FK tables in the object tree list.
-
-- Certain plugins (Oracle, Sybase, MS SQL-Server) now have configuration tabs
- (in Global Preferences) to allow for configuration of the statement separator
- for scripts independently from the Session properties configuration. For
- example, this means that now when you switch between session windows that use
- different statement separators (Oracle = ';' / Sybase = 'GO'), you no longer
- have to change the global statement separator for all sessions to get the
- correct one for script execution. As long as you have the plugin installed
- which corresponds to the type of database that a session is accessing, a
- reasonable default is supplied to make this configuration unnecessary in most
- cases.
-
-- Added better support for executing large scripts (by default, a script is
- considered large if it has > 200 SQL statements selected for execution in the
- script). Now, only one message is written in the message panel at the bottom
- of the session window at the end of running many statements summarizing the
- details of execution (timing, statement type and count, etc). The message
- "SQL Statement x of y <some sql...>" is still displayed in the results panel to
- indicate progress. Also, the history bar isn't updated during large script
- execution. The "200 SQL statement" default is configurable in Global
- Preferences under 'SQL' tab and all of this new functionality can be disabled
- by using '0' (zero) as the value of large script statement count. This
- dramatically improves UI responsiveness for large scripts (especially those
- with statement counts in the thousands) and makes it possible to cancel the
- execution using the cancel button - which is otherwise effectively disabled
- while the UI attempts to keep up with all of the UI updates in a large script.
-
-New Plugins for H2, PostgreSQL and DB2
- These plugins provide source tabs for stored procedures, views and triggers.
- They also provide details tab for sequences and triggers
-
-New Plugin for Sybase ASE by Ken McCullough
- The plugin allows to script the code of Views and Stored Procedures of the
- Sybase ASE DB.
-
-Code Completion:
- - The number of table columns that should be displayed on top of the
- completion list when completion is called outside of the scope of a
- table/view is now configurable in code completion properties.
-
-Edit Extras:
- - New formatting action - remove newlines. This is useful when copying SQL
- from console windows that insert end-of-line characters when copying.
-
-Refactoring Plugin
- - Added support for modifying the column type from varchar2 -> clob and
- clob -> varchar2 (which isn't directly supported by Oracle's column modify
- alter statement).
- - 'Drop Tables' action now orders the selected tables in order to satisfy any
- FK dependencies. Previously, this operation would fail if PK tables
- preceded (by name alphabetically) FK tables in the object tree list.
-
-SQL Scripts Plugin
- - Now when selecting 'Create Data Script', the insert statements created are
- ordered by the first column.
-
-Oracle Plugin
- - Added configuration panel for Oracle plugin in Global Preferences to allow
- configuration of new custom Oracle query tokenizer.
- - Added support for executing create procedure, create function and create
- trigger blocks delimited by a single "/" such as is supported in SQL-Plus.
- Also, added support for the "@" construct which is used to specify a script
- file to be executed without loading it into the SQL Editor first.
- - Source tab for views now presents source code that is formatted and
- correctly formed to allow it to be used as an SQL statement to replicate
- the view.
- - Added the schema name to the SID for session nodes - it's easier now to
- find the session you are looking for.
-
-Informix Plugin
- - Is now using the code reformatter for formatting the Source Tab for views
- The code reformatter was written by Gerd Wagner and previoously located in
- the EditExtras plugin. It has been moved to core so that other plugins can
- take advantage of this capability.
-
-DBCopy Plugin
- - Allow the user to set "0" for the fetch size to indicate that this should
- not be called. JDBC-ODBC bridge driver fails to execute *any* SQL once you
- have set the fetch size to *any* value.
- - Analyzes FKs to be copied and skips them if they already exist in
- destination database.
- - Now the plugin reorders source tables to satisfy FK dependencies when
- copying data into existing tables with similar constraints.
- - The error message for SQLExceptions now includes the SQL statement that was
- last executed (including bind variable values if it was a PreparedStatement)
-
-Data Type Controls/DBCopy preference sheet scrolling - sped up the scrollbar
-so that one click of the down arrow gives ~10 pixels of scroll instead of
-only 1 pixel. This makes it so that scrolling with a wheel mouse moves from
-top edge to bottom edge in about three full rotations of the wheel instead of
-about thirty.
-
-Bug-Fixes:
-- Fixed issue where USERS, SESSIONS, INSTANCES nodes in the object tree for
- Oracle sessions weren't being populated with child nodes when the session is
- first started.
-- Added support for identifying Informix XPS, so that the Informix plugin can
- be used (Thanks to Dieter Engelhardt for the patch)
-- When treating dates like timestamps, simply use the DataTypeTimestamp class
- instead of trying to make the DataTypeDate class smart enough to interpret
- timestamps. This fixes the issue where a Number format error was encountered
- while editing DATEs when they are being interpreted as TIMESTAMPS.
-- Fixed NPE that is seen on startup when sessions are set to "Connect at Startup"
-- Fixed functions like Quote/Unquote SQL or Format SQL which were removing new lines.
- (Now there is a separate function to remove newlines)
-- Caching of schemas (serializing to disc) failed. A NotSerializableException
- was thrown, due to development code introduced during version 2.5 development.
-- An error occured when F5 (Refresh) was hit in a SQL Work Sheet or an Object Tree Window.
-
-1689040 (plugins prefs files saving)
- Now preferences for some plugins (DBCopy, MS SQL-Server, Oracle, SQLScript and
- Sybase ASE) that were formerly stored in the program plugin directory, are now
- stored in the user's settings directory. This means that preferences for these
- plugins should now be preserved when re-installing SQuirreL to a new location.
- To migrate existing settings, command-line arguments can be given:
-
- -DmigratePreferences=true -DoldSQuirreLInstallDir=<old location>
-
- This will result in migrating newer prefs.xml files that are located in
- the program plugin directory
-
- (e.g. <old location>/plugins/dbcopy/prefs.xml)
-
- to the user's settings directory
-
- (e.g. USER_HOME/.squirrel-sql/plugins/dbcopy/prefs.xml)
-
- You should edit the launch script to add these settings, start SQuirreL,
- stop SQuirreL gracefully, then remove these settings from the launch script.
-
-1682289 Schema browser won't show all schemas.
- (Thanks to Robert Williams for the patch)
-
-1681202 Access to column metadata by name (that is, COLUMN_NAME) fails. This
- affected the SQLScripts and Graph Plugins for some versions of the DB2
- JDBC driver)
-
-1680919 failure to export cvs/excel on mac osx (incomplete ClassPath entry in
- Info.plist)
-
-1679998 DOUBLE PRECISION is rounded with locale datatype setting
-
-1675787 Bad link in Online Help
-
-1672207 Create Data Script - PostgreSql. PostgreSQL requires insert statement
- boolean values to be literal strings "true" or "false", instead of 1/0.
-
-1660412 Create insert script hangs on explicit Oracle DATE fields (A bug in the
- the SQL parsing routine would hang the thread when the word "from"
- appeared in a column name in the select statement)
-
-1659412 TIMESTAMP WITH TIME ZONE shows as <Unknown (-101)> - Support was added
- for rendering values of columns with this Oracle-specific type.
-
-1646886 (SQL Bookmarks: Duplicate parameters show as duplicates in the dialog box)
- Now parameter that appear multiple times in an SQL statement do not
- result in multiple entry fields in the boolmark run dialog.
-
-1643307 Title is missing in Save-Dialog (When ending a session for file saves)
-
-1617839 Two new lines with white spaces in between do not separate SQLs when
- SQLs are executed without selection.
-
-1639680 Cannot export smallint and decimal to MS Excel
-
-1635259 Session menu has two items with mnemonic "T"
-
-1639662 Block comments can be ended prematurely
- (Thanks to Sam Polak for the patch)
-
-1631392 (Dropping materialized views) - The 'Drop' menu item has been replaced
- by a 'Drop Table(s)' menu item available with the Refactoring Plugin.
- The new menu item allows the user to specify whether or not to cascade
- constraints as well as being able to see the SQL that will be executed.
-
-1471672 Float numeric field precision loss in output (DBMS:Oracle)
-
-1447227 Object tree should refresh when changing object tree filters
-
-DBCopy Plugin
- - If the source/dest database is Oracle, and the type of column being copied
- is DATE, then treat it like a TIMESTAMP for reading or writing the value.
- Oracle stores a time component in date columns and this change prevents the
- time component value from being lost if the destination database can also
- store a time component in DATE columns.
-
-Derby Plugin
- - Transformed trigger source tab contents into valid SQL that can be used
- to re-create the trigger.
- - Fixed multiple bugs that occurred in the source tab when the same
- view/trigger name is used in multiple schemas.
-
-Informix Plugin
- - Fixed to work with IDS 9 - qualified references to all system views by
- prefixing them with the string 'informix.' (no quotes).
- - Fixed ordering segements within the body of Stored Procedures.
- - Applied code formatting to triggers and view source.
- - Fixed erroneous inclusion of extra whitespace which for some definitions
- made the SQL invalid.
-
-Oracle Plugin
- - Fixed a memory leak where the plugin was holding on to closed sessions
-
-Refactoring Plugin
- - 'Drop Column' action now properly delegates db-specific drop column command
- to the appropriate dialect for the session.
- - Now allows precision and scale for new or modified columns to be set to 0.
- - The scrollbar in the column list dialog now appears, where previously it
- did not, making tables with many columns difficult to work with for
- Add/Modify/Drop column.
-
-
-2.4 (12/31/2006)
-================
-
- New Features/Enhancements:
-
-Note: This is the first release of SQuirreL that specifically requires JDK 1.5
-or higher to compile and run. The build scripts and the installer now check for
-at least 1.5 before proceeding.
-
-MS Excel export of displayed tables:
- Besides the exporting tables displayed in SQuirreL to CSV files it is now
- possible to export to MS Excel files. Thanks to Andr� Schild for the patch.
-
-Graph Plugin: New right mouse menu item for tables: "View table in Object tree"
-
-Derby Plugin: A new plugin which allows the user to view source for triggers and
-views. Also, detailed information about triggers is available.
-
-Informix Plugin: A new plugin which allows the user to view source for stored
-procedure, trigger and view objects. Also provides Informix-specific details
-for indexes and triggers. Special thanks goes to Doug Lawry for help setting
-up an Informix instance for developing the plugin, and providing the system
-catalog queries necessary for the object information provided by this plugin.
-
-Refactoring Plugin: A new plugin which currently allows users to alter
-tables by adding, modifying and dropping columns as well as adding/dropping
-Primary Keys. Uses an extended Hibernate dialect framework to derive SQL which
-is syntactically correct for the database being modified.
-
-Made SQuirreL work with hxtt drivers. See www.hxtt.com. Thanks to Yonghong Zhao
-for patches.
-
-Oracle Plugin:
- Windows for
- - DB Output,
- - Session Info,
- - SGA Trace,
- - Invalid Objects
- were changed in the following ways:
- - Tool bar buttons are not in the main frame tool bar any more but in the
- Session tool bar.
- - Each window has its own tool bar icon.
- - All windows restore their last size and position.
- - All windows provide a "Stay on top" check box.
-
-Syntax plugin: Corrections/Abreviations allow new lines. Use \n to create a
-new line. Note: Bookmarks are more powerful than abreviations.
-
-SQuirreL paths (-home, -user) are shown in Global Preferences
-
-LAF Plugin: Added Napkin Look and Feel (JDK 1.5 only)
-
-Completion Popup (Code Completion ctrl+space, Tools Popup ctrl+t,
-Bookmarks Popup ctrl+j): When the beginning/end of the pop up list is reached
-another arrow up/down jumps to the last/first entry.
-
-1015274: Provided better DB2/400 system naming support
-
-1602255: 'Interpret DATE columns as TIMESTAMP' also in SQL view. When this
-configuration item is checked, any SQL query result that contains a DATE column
-will show the DATE values as TIMESTAMP values (This is useful with Oracle where
-DATE columns also contain TIME components)
-
-Schema refresh on catalog combo box change:
-Schemas are refreshed automatically, when the user switches to another catalog.
-On systems that support Catalogs like Sybase or MSSQL, Schemas within a Catalog
-only become accessible when the catalog combo box is switched to the their
-Catalog. To make Schemas available in the Object Tree, Code completion etc.
-after a Catalog switch Schemas are now automatically refreshed.
-(Thanks to Stan Berka for this patch)
-
-Graph Plugin:
-The Graph plugin now allows to save jpg images to files instead of printing them.
-The image files are an exact copy of what would be sent to a printer and
-can easily be used within other applications.
-(Feature requested by David Karr)
-
-DBCopy Plugin: Added support for Informix and HADB. Relocated dialect framework
-to core to allow other plugins to use (Refactoring) - this version is now no
-longer compatible or supported for previous versions of SQuirreL.
-
-Re-organized the table and view context menus so that the SQLScripts
-plugin menu items now appear under the "Scripts" menu item and in the
-same order that they appear in the session menu "Scripts" menu item.
-
-Updated Spanish translation strings (Thanks to Diego Schulz)
-
-Added JDBC driver CLASSNAME and CLASSPATH to the Metadata tab so that
-it is not necessary to open the driver definition for the current session to
-get this information.
-
- Bug-Fixes:
-
-When reconnecting a Session with the current connection dead
-SQuirreL always switched to Autocommit = false state. Now the Sessions
-Autocommit state is preserved.
-
-
-MySQL Plugin: Fixed bug which caused the MySQL all of the tabs to appear with no
-content.
-
-SQL editor function "View Object at cursor in Object tree" (ctrl+B) now works
-for fully qualified object names with leading and trailing quotation marks and
-slashes.
-
-Oracle plugin: Fixed the rendering of details/source tabs for indexes
-sequences and triggers.
-
-Added support for Informix way of referring to database objects within
-catalog and schema as catalog:"schema".objectname.
-
-DBCopy plugin:
- - Removed reflective code used for backward compatibility which was causing
- IllegalAccessExceptions when the keyword test was applied to column names.
-
- - Fixed bug in copying FK constraints which left cursors open by not properly
- closing ResultSets when they were no longer needed.
-
- - Fixed bug in copying FK constraints w...
[truncated message content] |
