SQuirreL SQL Client

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. This is a bug-fix release and has the following change log: ... [More] 2.6.3 (12/24/2007) ================= Changes since 2.6.2: Bug-Fixes:1848924: Sybase object browser contents not displayed.1541325: Connection doesn't close when ending session - thanks goes to Alex Pivovarov for the patch that fixed the issue.Oracle Plugin: - Allow the user to configure whether or not to show the syntax error offset in the SQL Editor (0 comments) [Less]

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. This is a bug-fix release and has the following change log: ... [More] 2.6.3 (12/24/2007) ================= Changes since 2.6.2: Bug-Fixes:1848924: Sybase object browser contents not displayed.1541325: Connection doesn't close when ending session - thanks goes to Alex Pivovarov for the patch that fixed the issue.Oracle Plugin: - Allow the user to configure whether or not to show the syntax error offset in the SQL Editor (0 comments) [Less]

This is a bug-fix release and has the following change log:2.6.2 (11/30/2007)=================Changes since 2.6.1:Bug-Fixes:1820792: Sybase ASE - table not shown in object browser1821354: Changing default value of a column in Derby does ... [More] nothing1820214: 2.5.1 DB aliases do not transfer properly to 2.6.11820020: modified tables aren't sorted (0 comments) [Less]

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.We released version 2.6.1 which addresses the following two ... [More] problems:A critical packaging flaw that prevents launch on some platforms: http://sourceforge.net/tracker/index.php?func=detail&aid=1818446&group_id=28383&atid=393414 A bug causing tables in the object tree to appear unsorted alphabetically: https://sourceforge.net/tracker/index.php?func=detail&aid=1805954&group_id=28383&atid=393414 The 2.6.1 release files are available for download here:http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=29193 (0 comments) [Less]

We are aware that the 2.6 release contains a critical packaging flaw that prevents launch on some platforms: http://sourceforge.net/tracker/index.php?func=detail&aid=1818446&group_id=28383&atid=393414as well as a bug causing tables in the ... [More] object tree to appear unsorted alphabetically:https://sourceforge.net/tracker/index.php?func=detail&aid=1805954&group_id=28383&atid=393414We intend to release 2.6.1 soon which will address these two problems. You can monitor the stable release package by visiting the following link (You need to have a SourceForge account to monitor file releases). http://sourceforge.net/project/filemodule_monitor.php?filemodule_id=29193You will receive an email notification when the release is made (0 comments) [Less]

The 2.6 version has been prepared for download. It's been about six months since we released 2.5 so there are quite a few enhancements and bug-fixes. The release notes and change log are available here:http://sourceforge.net/project/shownotes.php?release_id=548400&group_id=28383Enjoy! (0 comments)

All,Version 2.5 is now available for download. Enjoy!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 ... [More] 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 setting1675787 Bad link in Online Help1672207 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 Excel1635259 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 filtersDBCopy 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 sessionsRefactoring 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. (0 comments) [Less]

All,A new bugfix release is now available.Changes since 2.4:Bug-Fixes:Updated Simplified Chinese translation strings (Thanks to xpdz)Updated French translation strings (Thanks to Erwan Duroselle)1659412 TIMESTAMP WITH TIME ZONE shows as <Unknown ... [More] (-101)> - Support was added for rendering values of columns with this Oracle-specific type.1617839 (Line with spaces does not separate SQLs)1639680 (Cannot export smallint and decimal to excel)1635259 (Session menu has two items with mnemonic "t")1639662 (Block comments can be ended prematurely)Fixed a bug which caused the JFileChooser used for opening/saving files in the SQL Editor to display copies of the "sql" and "txt" file types in the file type dropdown. Each time the JFileChooser was re-opened another set of "sql" and "txt" list items were being added erroneously.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 prevents this time component value from being lost if the destination database can also store a time component in DATE columns.- The error message for SQLExceptions now includes the SQL statement that was last executed (including bind variable values if it was a PreparedStatement)Informix Plugin- Fixed Informix plugin 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.Refactoring Plugin - Now allows precision and scale for new or modified columns to be set to 0.- The scrollbar in the column list dialog now appears, wherepreviously it did not, making tables with many columns difficult to work with for Add/Modify/Drop column. (0 comments) [Less]

2.4 (12/31/2006)================Changes since 2.3 Final: 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 ... [More] 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 andviews. 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 altertables 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 http://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 PreferencesLAF 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 support1602255: 'Interpret DATE columns as TIMESTAMP' also in SQL view. When this configuration item is checked, any SQL query result that contains a DATE columnwill show the DATE values as TIMESTAMP values (This is useful with Oracle whereDATE 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 andcan easily be used within other applications.(Feature requested by David Karr)DBCopy Plugin: Added support for Informix and HADB. Relocated dialect frameworkto 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 thesame 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 thatit 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 deadSQuirreL always switched to Autocommit = false state. Now the SessionsAutocommit state is preserved.MySQL Plugin: Fixed bug which caused the MySQL all of the tabs to appear with nocontent.SQL editor function "View Object at cursor in Object tree" (ctrl B) now worksfor fully qualified object names with leading and trailing quotation marks and slashes.Oracle plugin: Fixed the rendering of details/source tabs for indexessequences 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 where the primary key table name wasn't fully qualified the schema of the destination database. This was most noticeable when copying tables with FKs into a schema which was not the default schema for that session. - Fixed bug where cancelling the copy operation during table data transfer did not also cancel the transfer of table constraints.1601610 - Bug while editing integer/long columns 1598162: Fixed the issue when using Java 6 you had to click the Connect button twice when the app is first started.1597463: Maximized and multimonitor window size not saved1595913: Cannot select SQL dropdown under java 6.Added logic to prevent the MacOS X plugin from loading if not on the mac platform. It causes the Global Preferences menu item to disappear when it is loaded and the platform isn't MacLook and Feel Plugin: Plastic Look and Feels (JGoodies) weren't available anymore."Make Editable" on single table SQL did not work when SELECT list contained new lines.1554175: (Aliases lost on close) 1532997: (NullPointerException when trying to save alias)1522229: (Error occured saving Alias Definitions java.lang.NullPointer)Many people complained about this one. At first we determined this was low priority since it didn't seem to be reproducable on all jvms. We inadvertantly changed the SQLDriverPropertyCollectionBeanInfo such that it no longer accurately described the bean SQLDriverPropertyCollection. in 1.4.2_05 this triggered an NPE bug in the jvm code (Introspector.addPropertyDescriptor) which caused the SQLAlias persistence to fail, leaving the user with no aliases.1584283: (DBCopy plugin - Copying LOBs from Oracle to Oracle fails)If destination column type is Types.OTHER (1111), try to get the type name and map it to a valid java SQL type (such as Types.BLOB or Types.CLOB). This only works when the database columntype name as reported by the JDBC driver is a standard type such as BLOB, VARCHAR, CLOB, CHAR, etc... A mapping exception is thrown otherwise.1584260: (DBCopy plugin - Fix for issue where the same table is found in multiple schemas/catalogs that the user has access to. Now we specify catalog or schema if the driver claims to support them.)1577254: Trigger details tabs aren't rendered1532857: (DB2 on AS400 table list not shown) Incorporated Colin Bell's patch to address this issue which causes SQuirreL to give '*ALLUSR' for the schemavalue when calling DatabaseMetaData.getTables.1520156: changed the function of the configurable ref actions checkboxes for SQLScript plugin. Now, they will override what is contained in the DatabaseMetaData if checked. If not checked, we now use whatever the database tells us the ref action is (before we weren't bothering to check the with the database. Now we do, by default)1508503: (Double entry for each column fields): Don't add the column to the list if it is already there - uses the fully qualified version of the column, so may still see duplicate columns with different types.Bug Fix: Editing data in multiple tables would sometimes fail erroneously withan error message like "This row in the Database has changed since you refreshed the data. No rows will be updated by this operation".Bug Fix: Solved issue where tables were not appearing in the object tree forSun HADB (High-Availability Database). Special thanks to Lars Heill of SunMicrosystems, Inc. for technical assistance with installing/configuring HADB. (0 comments) [Less]

2.3.2 (Stable bug-fix release)========= Bug-Fixes:OraclePlugin bug: Use a new info tab instead of re-using. Otherwise, the tabs will not display properlyFixed an NullPointerException that occurs occasionally when an object in the object tree (like a ... [More] table) is refreshed.Fixed an issue involving objects not appearing in the object tree for Sun HADB.1508503 (Double entry for each column fields): Don't add the column to thelist if it is already there - uses the fully qualified version of the column,so may still see duplicate columns with different types.DBCopy plugin: Fixed bug in copying FK constraints where the primary key table name wasn't fully qualified the schema of the destination database. This was most noticeable when copying tables with FKs into a schema which was not the default schema for that session.Applied 1598162 - Under Java 6 you have to click the Connect button twice when the app is first started.Applied 1595913: Cannot select SQL drop-down under java 6 from HEADRemoved dependency on Java 5 from the DBCopy plugin.Applied - 1601610 bug while editing integer/long columns (0 comments) [Less]