Eclipse SQL Explorer [RCP/Plugin] / News: Recent posts

This service release contains some minor fixes and changes. In detail:
* Added new detail tabs for informix (Online Log, Configuration, Database Information)
* Fixed NPE in export to XLS

This service release contains some minor fixes and changes. In detail:
* Fixed tab delimiter in CSV export
* CSV export: added support for date formatting according to preferences page during export to csv
* Fixed truncation of CLOB data caused by getString()
* Added new Results preference to define max length of CLOB data to read, default is 10,000 characters
* Added new Results preference to define character set to use for displaying BLOB data, default is using system character set
* Added logging of all exceptions to detect suspicious NPE on query execution

This service release contains some minor fixes and changes. In detail:
* DB2: Added sequence node, fixed procedures, triggers and explain plan (works now for DB2 v9.1 and above)
* Added explain plan for informix

This service release contains some minor fixes and changes.In detail:
* Added a new configuration option to close unused connections after X seconds
* Fixed problem with MySql connections after calling 'use database' command. Such connections didn't switched back to original database when returned to connection pool.

This service release contains some minor fixes and changes.In detail:
* Updated default drivers xml (added CUBRID, removed outdated drivers).
* New Extensions to informix plugin
* Added preference page 'History'
* New preference to limit SQL history entries.
* New preference to auto save SQL history after a number of statement executions
* fixed User.hashCode: https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3269611&group_id=132863

This service release contains some minor fixes and changes.In detail:
* Added informix plugin, thanks to Vladimir(vladsrynty)
* Check for print statements reworked (sybase/mssql), see http://sourceforge.net/projects/eclipsesql/forums/forum/450662/topic/3967259
* If you cancel a long running query in the progress view a statement.cancel is called to try to realy cancel the statement
* Sorting in result tables now uses correct data type (for instance: numeric values sorted in numeric order)
* If the same statement is executed on different connections it will be listed as separate lines in the SQL-History view now

This main release contains only minor changes. Main reason to this release was to deliver RCP standalone distributions based on Eclipse Helios (3.6.1). With 3.6 comes support for new OS's like macos 64 bit. Nevertheless the SQLExplorer plugin is compatible with Eclipse 3.3.
For mor details see the release info.

Changes in SR4:
* some bugfixes in SQLCompletionProcessor.java
- Insert Table/Viewname without schema, if the schema and a dot are the content before the caret and the schema is part of the tablename.
- Show system tables and system views in the content assistant
- Prevent multiple entries
* feature #2957965, add context menu to db detail tables, see http://sourceforge.net/tracker/?func=detail&atid=725498&aid=2957965&group_id=132863
* fixed Save As Bug, https://sourceforge.net/projects/eclipsesql/forums/forum/450662/topic/3697805
* fixed: menu contributions for SQL-Commands would be displayed in other editors
* fixed: Index out of Bounds exception on calling Execute SQL-Chunk with statement ending at end of file
* fixed default column width for result tables
* fixed NPE in catalog switcher
* fixed: out of range error when retrieving unsigned columns
* show warnings only once
* fixed: XLS export fails with more than 32767 rows
* fixed About Dialog: https://sourceforge.net/tracker/?func=detail&aid=3029327&group_id=132863&atid=725495
* made jar locations in SQLDrivers.xml relative to workspace or eclipse home directory... read more

Changes in SR3:
* fixed IndexOutOfBoundsException in execute SQL chunk
* added Patch #2924692 by ashinger, fixed some problems in JDBC driver preferences
* used commands for SQL actions, new context menu entries and editor tool bar buttons
* cleanup deprecations for preferences

Starting with SR1 we will provide zip's only for the plugin. The standalone distributions
can be updated using the update site (http://eclipsesql.sourceforge.net) integrated Update Manager.
- open menu: Help/Software Updates/Find and Install...
- choose: Serach for updates of the ....
- click Finish
- complete the Update Wizzard

Changes in SR2:
* added patch from patl9 fixing problems with alias saving,
see http://sourceforge.net/tracker/?func=detail&atid=725495&aid=2891491&group_id=132863
* select complete row in result set table
* fixed ClasCastException for PostgreSQL and Oracle if strip comments is enabled
* added check for lines starting with \ in PostgreSQL
* added batch execution results

Starting with SR1 we will provide zip's only for the plugin. The standalone distributions
can be updated using the update site (http://eclipsesql.sourceforge.net) integrated Update Manager.
- open menu: Help/Software Updates/Find and Install...
- choose: Serach for updates of the ....
- click Finish
- complete the Update Wizzard

Changes in Service Release 1 (SR1):
* use getDate for DATE sql type, needed for Teradata, no problems detected with MySql/msSql/Postgres
see https://sourceforge.net/projects/eclipsesql/forums/forum/450663/topic/3435783
* added option to strip comments before executing SQL
see https://sourceforge.net/projects/eclipsesql/forums/forum/450662/topic/3423052

Starting with SR1 we will provide zip's only for the plugin. The standalone distributions
can be updated using the update site (http://eclipsesql.sourceforge.net) integrated Update Manager.
- open menu: Help/Software Updates/Find and Install...
- choose: Serach for updates of the ....
- click Finish
- complete the Update Wizzard

The team is pleased to announce that we have released version 3.5.1 of SQLExplorer;
there is a lot of work which has gone into finalising the code to get us to this point.
Since 3.5.0-RC8, there have been some minor feature additions - the focus has been on fixing bugs or annoyances.
Please report any bugs to the Beta Testing forum, or submit on the Bugs Tracker;
new feature requests should go into the Feature Requests Tracker.
For really, really minor tweaks (i.e. feature requests) please go ahead and post in the Beta Testing forum but we reserve the right to ask you to repost them in the Feature Request Tracker if the request too complex to just slip in.
The main changes since RC8 are:
* New 'Execute Current SQL' action (CTRL+ALT+ENTER) and changeable key binding (patch #2725105 by joco01)
* Fixed bug #2827324, rounded float values in MS-Sql
* Added feature #2827391, problem with auto completion
* fixed bug #2830545, fill db structure view for current database
* Extended database(catalog) support for MySql,Sybase, MS-Sql
* Changed 'File' menu for standalone SE: Added 'New', moved 'Preferences' menu item down
* Re-added export to HTML and XLS action; XLS is now 'real' Excel format build with POI
The SQLExplorer Developer Community

The team is pleased to announce that we have released Release Candidate 8 of SQLExplorer;
there is a lot of work which has gone into finalising the code to get us to this point.
Since RC7, there have been only some minor feature additions - the focus has been on fixing bugs or annoyances.
Please report any bugs to the Beta Testing forum, or submit on the Bugs Tracker;
new feature requests should go into the Feature Requests Tracker.
For really, really minor tweaks (i.e. feature requests) please go ahead and post in the Beta Testing forum but we reserve the right to ask you to repost them in the Feature Request Tracker if the request too complex to just slip in.
The main changes since RC7 are:
* New preferences to setup column sorting and display of SQL warning messages
* New action to generate insert statement
* Added Apache Derby plugin
* New server root node in db structure view
* Various bug fixes and minor tweaks/additions Regards,
The SQLExplorer Developer Community

The team is pleased to announce that we have released Release Candidate 7 of SQLExplorer; there is a lot of work which has gone into finalising the code to get us to this point.

Since RC5, there have been only some minor feature additions - the focus has been on fixing bugs or annoyances.

Please report any bugs to the Beta Testing forum, or submit on the Bugs Tracker; new feature requests should go into the Feature Requests Tracker. For really, really minor tweaks (i.e. feature requests) please go ahead and post in the Beta Testing forum but we reserve the right to ask you to repost them in the Feature Request Tracker if the request too complex to just slip in. ... read more

The team is pleased to announce that we have today released Release Candidate 5 of SQLExplorer; there is a lot of work which has gone into finalising the code to get us to this point and we hope that this will be the final release candidate.

Since RC1, there have been no major feature additions - the focus has been on polishing the user experience and fixing bugs or annoyances.

Please report any bugs to the Beta Testing forum, or submit on the Bugs Tracker; new feature requests should go into the Feature Requests Tracker. For really, really minor tweaks (i.e. feature requests) please go ahead and post in the Beta Testing forum but we reserve the right to ask you to repost them in the Feature Request Tracker if the request too complex to just slip in.... read more

SQLExplorer v3.5.0 RC1 is now available for download; while you should find this release pretty stable please bear in mind that it is still pre-production and you may come across problems. We're concentrating on testing and bug fixing from now until the final release of 3.5.0.

The main changes since v3.0.0 are:

* The separate SqlResultsView has been removed and the query results are now part of the editor that executed them (they appear as tabs in the bottom part of the editor view) ... read more

John (spackers) has released a new beta version: 3.5.0 Beta 1 and is asking for some help to test this new version. Details about this beta release can be found here: http://sourceforge.net/forum/message.php?msg_id=4489435

The files can be downloaded here: http://sourceforge.net/project/showfiles.php?group_id=132863

Results from beta testing can be discussed in the new Beta Testing forum: http://sourceforge.net/forum/forum.php?forum_id=730475

The SQL Explorer website is now available at http://www.sqlexplorer.org.

Eclipse SQL Explorer 3.0.0. has been released as an eclipse plugin and RCP client.

It's been due for a long time and now it's finally here: Eclipse SQL Explorer has a proper homepage.

A preview is available for the newest release of SQL Explorer. This preview is runs on windows and doesn't contain any database specific extensions.
There's lot's of new stuff, so check it out..

This new version of SQLExplorer plugin now works with Eclipse 3.1 final release.

Please report any problems you may find.

Note: now SQLexplorer is dependend of GEF (www.eclpse.org/gef) and you must have it installed.

SQLExplorer 2.2.3 is now available to download.

This version is now packed with extensions for Oracle, MS-SQL, Sybase and Hibernate.

SQLExplorer is now accessible from CVS!

For now there is only the core code on CVS, but over the next few days the extensions will be available too.

I expect to have the update site with a complete version of the plugin (with all the extensions) ready next week.