SQuirreL SQL Client

Please cast your vote here:http://java.sys-con.com/general/readerschoice.htmWe are nominated for the categories Best Database Tool or Driverand Best Java Data Access Tool (0 comments)

This is just a big-fix release. Changes since 2.3 final in this release are as follows:1554175: (Aliases lost on close) 1532997: (NullPointerException when trying to save alias)1522229: (Error occured saving Alias Definitions ... [More] 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)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]

Older JVMs (and even 1.5.0_09 according to one user) would experience a NullPointerException on exit, causing Alias changes not to be saved. There was a bug in one of the SQuirreL JavaBean classes that supports persisting Aliases to an XML format ... [More] when SQuirreL is closed. This bug was triggering a NullPointException in some JVMs, which is a bug in itself, over which we have no control. However, the errant code was spotted and fixed and the latest snapshot was tested with 1.4.2_05 (which always had the problem) and it appears to be fixed. The snapshot installer and source code with the fixed code is here:http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=460927Rob Manning (0 comments) [Less]

Changes since 2.3 RC2:Enhancements:An Italian translation of SQuirreL labels/messages is now available in the installer (Thanks to Ivo Neri)Bug Fixes:1563613: Alias property window dies when URL is malformed.1563610: (Only connection specified DB ... [More] schema loaded regardless) Enhanced the catalog selection so that changing the catalog updates the schema info and expands the TABLES node in the tree for the selected catalog.1563603: ORA-01830 error: Date format1561293: Show Loaded Drivers Only" does not work in "Add Alias" dialog.1558509: 'create sequence' rejected as invalid SQL1520156: (Reverse Engineering Foreign Key Cascade Missing). Added configuration for referential actions clause of FK constraints.1426012: PLAN_TABLE not found - look for PLAN_TABLE in other schemas and allow user to choose one.1371587: Not possible to edit data after SQL query 1250855: (Oracle DATE does not display correctly) Added a new configuration item to Global Preferences -> Date Type Controls -> Date Section which allows the user to "Interpret DATE columns as TIMESTAMP".Bug Fix: Fix for issue where the SGA Trace view wasn't displaying data in the "Buffer Gets per Row" column. (0 comments) [Less]

New translation available: Italian by Ivo Neri For details see http://squirrelsql.org/index.php?page=translations (0 comments)

here is be a problem when JDK/JRE 1.4.2_03 or below is used. It seems like SQuirreL can't show and save your Aliases anymore. When you use a JRE/JDK higher than 1.4.2_03 (preferably a 1.5.x version) the problem should be gone. If not try to remove ... [More] the SQLAliases23.xml in your .squirrel-sql directory. The directory should be located in you user home directory. (2 comments) [Less]

Version 2.3 rc2 has been release. Changes made since 2.3 rc1 are: New Features/Enhancements:Feature Request #1556226: New menu items in the right mouse menu of tables - "Adopt all column widths" - Adopts all columns widths of current table to ... [More] header/data. "Always adopt all column widths" (check box) - Widths are automatically adopted for all tables opened in the future.New menu-item "Export CSV" in context menu of table contents spreadsheet allowsthe user to choose whether to use formatting from Global Prefs or defaultformatting.SQL result tabs offer to rerun their SQL query to update their data.Text limit line of Netbeans editor can now be positioned or switched off inSession Properties. Bug Fixes:1448738: (JDK 6.0 regression) This appeared to be a bug in the Java 6 SE, but it turned out that we weren't using the correct method to load classes from the ClassLoader. Sun "fixed" the method (ClassLoader.loadClass) that we were using previously so that it no longer worked as it did in 1.4 and 1.5. For details see: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6446627 We rectified the problem in SQuirreL by following Sun's suggestions regarding which API methods are being called.1544447: (Generated SQL script Table names are not fully Qualified, it should be "SCHEMA"."TABLE_NAME") Added a new global preference panel and checkbox to make this alternative behavior configurable. The default now is to qualify table names with their schema name.1541154: (ArrayIndexOutOfBoundsException in DataTypeDouble)1533824: (NPE when loading keywords from DatabaseMetaData) Check the values returned for null before attempting to parse and store them (DB2 driver returns null for getCatalogTerm())Bug fix: When doing a complete refresh (F5) or a refresh item in the Object tree (see right mouse menu) code completion was not refreshed.Bug fix: In Oracle Plugin - Avoided open cursors when viewing database output ( dbms_output.put_line() ).Bug fix: Stored procedures where not shown in Object Tree when the Oracle Plugin was used.Bug fix: When a Schema was created and the Object Tree was refreshed the new Schema was not shown.Bug fix: In Alias properties for Oracle - Note: This bug took effect when default Alias properties were used. So this fix probably increases Session startup performance for Oracle users who use the Oracle plugin but do not care for Alias properties. Bug: When an Alias was configured to load all Schemas and cache non but the Oracle Alias properties didn't allow to load all schemas SQuirreL still did load all tables and procedures from the database. Though the unallowed tables and procedures did not show up in the Object tree they still caused bad startup perfomance. Fix: Now only tables and procedures for allowed schemas are loaded.Bug fix: Object tree table tab titles were not being internationalized as their values were hard-coded and not available in I18NStrings.properties files. Now they are. Installer Changes:Three new translations were added to the installer: Simplified Chinese (Thanks to xpdz) French (Thanks to Erwan Duroselle) German (Thanks to Andreas Oswald)Added new optional plugin (DBCopy) to the installer which allows database tablesand their content to be copied from one session to another inside of SQuirreLusing Copy/Paste menu items. (0 comments) [Less]

New translation available: French by Erwan DuroselleFor details see http://squirrelsql.org/index.php?page=translations (0 comments)