What's new in Execute Query 4.4.3 Build 5629
Feb 16, 2021
- Fixed issue with SQLite failing on the table view and browser.
- Upgraded Liquibase lib in line with SQLite fix.
- Modified font size for schema tree and menus
New in Execute Query 4.4.2 Build 5494 (May 22, 2018)
- Optimized delimited export process.
- Incremental fix for the Java9 issue and undo/redo for text components.
- Added (finally) DBUnit dataset export support.
- Modified default table header view for dark theme.
- Added connection test action to connection panel.
New in Execute Query 4.4.1 Build 5484 (Nov 9, 2017)
- Fixed missing error messages on exception dialog.
- Fixed missing column and key labels on table node expansion.
- Fixed regression bug that would break the tree model when adding or removing connections.
New in Execute Query 4.4.0 Build 5476 (Oct 4, 2017)
- Added selective connection and folder import and export.
- Minor UI tweaks: sizes, borders, buttons.
- New splash and about images.
- Added fixed height scroller to connections menu.
- Added localisation support Part 1 - limited RU support provided by Red Soft.
- Added option to quote char/varchar values on delimited export and result set export.
New in Execute Query 4.3.0 Build 5427 (Jan 8, 2015)
- Modified format SQL text to apply formatting to query at cursor and replace only that region.
- Added result set filter for the current selection in the Query Editor.
- Added wildcard starts with for browser node search.
- Fixed result set table column in the editor not showing correct label on some DBs when executing statements with aliases.
- Added ability to select the visible result set columns after a query is executed.
- Added procedure and function names to Query Editor autocomplete suggestions.
- Fixed issue with number format errors returned when generating SQL scripts.
- Fixed column data type precision not showing for some database impls.
- Fixed column width size not being retained when set via preferences within the Query Editor.
- Fixed locking issue for certain database types where on open transaction would cause the browser to hang.
- Added new updated default EQ look and feel.
- Modified references tab in Browser panel to always show selected table irrespective of imported or exported constraints.
- Added SQLite to preconfigured database list for driver selection.
- Fixed SQLite issue with rendering query result sets within the editor.
New in Execute Query 4.2.0 Build 5406 (Jun 18, 2014)
- Added user preference option to disable row count query on table selection.
- Fixed export as SQL not respecting column selections for single table exports.
- Fixed multi-line comment issue when start of each line within the comment contains an asterisk (*).
- Added ability to maximize and restore the results pane within the editor tab on double-click.
- Fixed find/replace dialog functionality on replace replacing the next find instead of the current one.
- Added ability to cancel the query executed within the Data tab on table selection.
- Removed dependency on agent to set the correct application name for X11.
- Removed proprietary dependency on sun.misc.BASE64Encoder/Decoder.
- Added column, constraints and index nodes under table nodes within the Browser tree structure.
- Improved Query Editor undo/redo support.
- Improved support for large result set exports.
- Fixed issue where a driver class name change was not being applied on reconnection with that driver.
- Moved to Java7 - no longer direct support for Java 6.
- Modified Execute SQL Script to support progress logging.
New in Execute Query 4.1.1 Build 5388 (Mar 2, 2014)
- Fixed issue with return type and value from executing a stored procedure or function from the Query Editor.
- Modified application update check on startup to not block database connection attempts.
- Added on delete, on update and deferability to SQL generation for constraints.
- Modified Query Editor history dialog to accept multiple selections.
- Upgraded to Liquibase 3.1.1
- Fixed BIT and BOOLEAN column definition with default value for statement generation.
- Fixed transaction isolation level setting not being correctly assigned.
- Added copy action for the connection Show Password dialog.
- Added Insert at Cursor action for the editor's SQL Command History.
New in Execute Query 4.1.0 Build 5326 (Jul 29, 2013)
- Fixed issue where a lost data source causes a closing editor to hang.
- Modified type conversion of result set table views.
- Fixed determination and display of array values in the result set table views.
- Modified the query generated to apply data changes within the Data tab to use a schema or catalog prefix where available.
- Update Liquibase to v3.0.2 and modified to use new API.
- Added new library juniversalchardet to detect file encoding when opening text files and apply this encoding for rendering in the Query Editor.
- Added XML as export option of result set from Query Editor.
- Modified CSV result set exporter to quote char, varchar and longvarchar values.
New in Execute Query 4.0.1 Build 5306 (May 11, 2013)
- Modified result set model to log and return for unsupported data conversions in values.
- Modified time value returns in result set to check for full length as in HH:mm:ss.S or HH:mm:ss before attempting to parse.
New in Execute Query 4.0.0 Build 5297 (Apr 25, 2013)
- Fixed possible NPE on null catalog value when setting show default cat/schema option only.
- Added database table data edit support for the browser Data tab where a primary key exists for that table.
- Modified Query Editor autocomplete to incrementally add to the list instead of waiting to populate the complete list.
- Modified Query Editor autocomplete to retain derived suggestions list with a new action from te toolbar to force a refresh.
- Added main connection and driver details panel to scrollpane to avoid field/button collapsing on view resize.
- Added object count value to all object lists on the Database Browser view.
- Added summary file info to all export data workers.
- Added TRACE log level.
- Modified driver panel class field to use a drop-down box with available drivers in addition to the 'Find' button.
- Misc UI tweaks for for Mac OS look and feel.
- Modified to display column names as returned - previously defaulted to upper.
- Fixed applying a column NULL change being executed as NOT NULL from the Database Browser Table view.
- Modified database object node loading to check for a single item only and load contents on selection from the Database Browser.
- Performance improvements on result set table model.
- Modified to allow for custom settings directory supplied as an argument on startup using: executequery.user.home.dir=[some_path]
- Added key event modifiers check for INS key in the Query Editor.
New in Execute Query 3.6.0 Build 5213 (Feb 8, 2013)
- Added connection folders.
- Fixed issue wth References Panel showing current table multiple times for composite keys.
- Added Collapse All feature for connection nodes in the Browser Tree.
- Added show/hide tools panel for the Query Editor.
- Added alternating row colour for results table.
- Fixed possible hang on connect when open panels are being updated.
New in Execute Query 3.5.1 Build 5196 (Aug 1, 2012)
- Upgraded to Liquibase v2.0.5.
- Added meta data and SQL tabs to database object views in the browser.
- Added SQL text for database views in the browser tab.
- Added improved MAC meta key support for selected command shortcuts.
- Added data row count field for database object views in the browser.
New in Execute Query 3.5.0 Build 5190 (Jul 16, 2012)
- Fixed issue where saving text and selecting 'All Files' would throw an exception on save.
- Added support for SELECT...INTO... queries for the Query Editor.
- Added separate icon for triggers in the database browser.
- Fixed issue where new or deleted connections were not being updated in the connections table list.
- Added double-click to size column to fit largest value in query editor.
- Changed errors in data tab or any object to display on the panel and not use the exception error dialog.
- Modified detection and execution of create function or procedure statement from the Query Editor to strip out any comments.
- Added 'Copy Name' popup menu item for all items in the browser tree.
- Application icons updated.
- Fixed procedure execution from editor reporting invalid procedure when params have were not loaded by EQ.
- Added 'Execute as Single Statement' editor action shortcut key.
- Added database table views to the Query Editor autocomplete list.
New in Execute Query 3.3.0 Build 5181 (Jul 16, 2012)
- Added method to scan and remove old user settings directories from /.executequery
- Modified dialog sizes for ERD panels.
- UI tweaks and new icon set
- Modified node tool tips to be more descriptive, table columns in particular.
- Added type, size and nullability to code-completion column values.
New in Execute Query 3.2.5 Build 5176 (Jul 16, 2012)
- Fixed transaction issue noted on data tab when connection auto commit mode is reset before the result set is closed (noted for SolidDB).
- Fixed lurking transaction isolation issue within the browser tabs holding open locks and preventing query execution elsewhere.
- Modified GUI to use the default screen for positioning where multiple screens exist.
- Changed system properties tables to use sortable models.
- Selective layout changes for row heights in tables and trees.
- Modified entity labels to be text-selectable.
- Added delete button for JDBC advanced property key/value pairs.
- Added limited drag support to the saved connections tree.
- Fixed ERD add existing schema table where under some DBs (Oracle) the column names would be repeated for like tables across different schemas.
- Added ability to change connection names directly from editing the tree node.
New in Execute Query 3.2.4 Build 5169 (Jul 16, 2012)
- Moved build to Java 1.6.
- Added right-alignment for numeric values option for result set table views.
- Fixed unrecoverable location exception on Query Editor when attempting to define a table alias for auto-completion.
- Added multiple connection connect and disconnect.
- Added additional schema objects shown for Query Editor auto-complete popup.
- - Modified procedure execution from the Query Editor to execute 'as-is' when the provided procedure can not be located using the driver meta data.
- Added anti-alias font option.
- Modified to save connections after a sort.
New in Execute Query 3.2.3 Build 5164 (Jul 16, 2012)
- Fixed occassional error (NullPointerException) when opening a script from file and closing the editor without doing anything else.
- Modified host checking for application update to not throw a 'loud' exception.
- Added a warning dialog when attempting to close an editor window where a query is executing. The tab will now not close and suggest further action.
- Added a checkbox to enable/disable the max rows for a result set in the Query Editor.
- Fixed XLS export from result set panel in editor to display correctly read CLOB values.
- Fixed feedback dialog issue when cancel button selected on the progress dialog and the dialog and text fields remain blocked.
- Added output console popup menu for text selection, copy, clear, reset and save to file.
- Added FrontBase, jTDS, MckoiDDB and ThinkSQL to database name list.
- Added new text editor functions including duplicate rows/selections up/down, move row/selection up/down etc.
- Fixed different case identifier detection and use for executed queries (ie. row counts in the database browser that would throw an error if not quoted when required).
- Added customisable coloured results table cells for data types.
- Split out autocomplete option into keywords and database objects - added these to the editor popup menu.
- Updated libraries Log4j, Liquibase, Commons Lang and Commons Codec.
New in Execute Query 3.2.2 Build 5148 (Jul 16, 2012)
- Fixed table editing in browser when deleting a column and restoring / cancelling the action not restoring that column's state.
- Fixed errors in adding and removing column constraints from the table browser.
- Added simple text component popup menu with cut/copy/paste for all panel text fields.
- Fixed export as XML error throwing ClassCastException for DataSource
- Fixed exception thrown for DB2 tables when selecting from browser tree view.
- Added proxy user and password to proxy preferences.
- Added 'show password' action on login panel to reveal password in plain text.
- Improved DESC statement support.
- Fixed JDBC advanced properties not being applied when entered.
- Improved code completion - now recognises table and columns by name and alias in queries.
- Added ability to output generated create/drop statement to the Query Editor and not just to file, file selection and output is no longer required for writing create/drop scripts.
- Added SQL shortcuts to the Quey Editor allowing user defined SQL text abbreviations and autocorrect.
New in Execute Query 3.2.1 Build 5146 (May 24, 2010)
- Minor help doc update.
- Help menu changes.
- Added deb package for download.
- Modified generated queries to use escaped column names where appropriate (ie. in the Query Editor, import/export processes etc).
- Fixed editor auto-complete popup for less than 2 characters not scrolling to 'starts with' word.
- Ongoing look and feel tweaks - field dimension changes, font changes.
- Added option to execute queries with comments, whitespace, line-breaks etc as-is. Defaults to executing 'sanitised' queries with comments etc stripped out as has always been the case.
- Added default insets for UIManager returning null for some look and feels using TabbedPane.tabInsets in determining tab dimensions for scrolling center panel.
- Modified callable statement generation removing left-hand equals where out parameters do not exist.
- Fixed issue with data exports for multiple tables where back/next button selection from export file entry would duplicate selected tables in returning to file selection panel.
- Fixed query execution with trailing semi-colon errors noted with Oracle.
- Added export result set to file allowing for executing arbitrary SQL SELECT statements and writing the output to a delimited file.
- Added open and execute SQL script feature allowing for SQL script execution without loading the script in the editor first.