Version 2.2

• Bug [SQLQ-13] - Plugin not working on Mac
• Bug [SQLQ-15] - Editing of date columns doesn't work
• Cosmetics [SQLQ-4] - Output messages are sometimes in the wrong order
• New Feature [SQLQ-1] - Import of data files. See documentation.
• New Feature [SQLQ-6] - Add support for Microsoft SQLServer 2005 Driver
• New Feature [SQLQ-16] - Allow relative dates for table date editors. See documentation.
• New Feature [SQLQ-17] - Add viewer for image BLOB's

Version 2.1.1

• Fix: Fixed error which caused the loss of the plugin settings if the 'Refresh Data' action was used.
• Fix: Fixed exception which sometimes occured if the plugin settings dialog was closed.

Version 2.1

• New: Added BooleanFormat to display values like 0 and 1 as check box. Warning: If you use your own custom formats you may have to replace the interface ObjectFormat with the new interface TextFormat in your classes.
• New: Added ability to hide/show table grid lines
• New: Added ability to use alternating row colors
• New: Added ability to modify the colors used to mark primary and foreign keys in the result table
• New: Added 'Show Referenced Table' and 'Show Referencing Table' to result table context menu.
• Fix: Fixed Help Action in plugin toolwindow
• Fix: Made Ctrl+C work for all nodes in browser tree
• Change: Added line break in 'Copy to Clipboard' action of result tables
• Change: Primary keys and foreign keys are now marked with a small colored bar.

Version 2.0

• New: Ability to specify multiple JDBC driver locations
• New: Use IDEA action system
• New: Moved configuration (except statements) from project into application configuration. Warning: Old settings will be lost.
• New: Added 'Copy' (to system clipboard) action in browser
• New: Show current connection status for databases (green diamant - connected, blue diamant - not connected, red diamant - no driver)

Version 1.4.6

• New: Added quick access for some plugin settings to query panel
• New: Added option 'Stop on Error'
• New: Allow hiding of table columns (See action 'Manage Columns...' in context menu of result table header)
• New: Added links from message pane to result tabs.
• Bug Fixes

Version 1.4.5

• New: Added support for jTDS SQL Server JDBC driver (Thanks to Chris Maurer)
• New: Delete rows from result tables.
• New: Added ability to save character and binary data.
• New: Added support for secure servers to HSQLDB driver support (old database configurations may not work anymore)
• New: Added additional connection properties to set properties not supported by the driver support classes
• Fix: Use second connection to get meta data
• Fix: Improved cancellation of statements
• Fix: Improved handling of Oracle 9.x Data Types
• Fix: Added name to server URL's for HSQLDB driver support

Version 1.4.4

• Show foreign key columns in different color
• Add context action to show referenced rows for foreign key columns
• Improved memory release after closing an IDEA project
• Added option for loading LOB's
• Show exported keys in browser

Version 1.4.3

• Added Excel export (Requires Installation of Apache's POI)
• Added Fixed Width export
• Moved export configuration to application level (old export configurations will be lost)
• Added Column/Cell Statistics.
• Don't resize columns if executing the same query again.
• Improved text and date table editors
• Show modified rows in different color.
• Align values in HTML export like they are aligned in the result table.
• Added foreign keys in browser

Version 1.4.2

• Added DB2 driver.
• Added option to include query in HTML export.
• Added menu item to copy the column name to the clipboard.
• Added viewer for BLOB data
• Made custom column formats working for IntelliJ IDEA 4.x

Version 1.4.0

• Add statement templates (using velocity)
  Usage: @<template-name> <parameters>
  Example: @persons "Max", Peter
• Removed variable binding (replaced by templates)
• Fixed bug from version 1.3.9 which prevented that the driver is loaded from lib directory.

Version 1.3.9

• Added support for HSQLDB
• Added option to load drivers from other location than plugins directory
• Added option to keep connection if tool window is closed

Version 1.3.8

• Added option to automatically refresh result tables

Version 1.3.7

• Added support for Informix and AS/400 driver
• Allow refresh of result tables

Version 1.3.6

• Added support for Postgresql driver
• Fixed default schema name for MySQL and SQLServer

Version 1.3.5

• Added actions to browser context menu
• Show query as tooltip of the result tabs

Version 1.3.4

• Bugfix for 100% CPU usage during editing
• Added possibility to display columns in other fonts
• Remember selected formats, fonts, sort columns for last statements (option to save the information to the workspace)
• Sort database groups
• Convert all oracle.sql.Datum values to JDBC values

Version 1.3.3

• Small Bugfixes

Version 1.3.2

• Bugfix for NPE if editing table cells
• Browser: Removed duplicate procedures
• Browser: Show procedure parameters
• Browser: Don't show 'Indices' node for tables of type 'VIEW'

Version 1.3.1

• Bugfixes:
  • NPE with DB2 databases
  • Save state of browser window
  • Use column format for 'Copy to Clipboard' action
• Browser:
  • Performance improvement for loading tables
  • Group tables by table type
  • Show procedures, functions and types
• Result Table:
  • Enabled sorting for more than one column
  • Convert oracle.sql.TIMESTAMP into java.sql.Timestamp
  • Added API for adding custom column formats
• Use user name for default schema
• Made describe case insensitive
• Show value of Auto-Commit in status bar
• Distinguish between 'Empty password' and 'No password'
• Possibility to execute statement without parsing

Version 1.3.0

• Changed structure of data in workspace
• Bugfix: Opening dialogs outside of event thread
• Added database groups
• Moved database browser into separate tool window
• Save queries into workspace
• Copy query parts from browser window to query window
• Show update statements in message tab if editing a result table
• Confirmation dialogs for 'Commit', 'Rollback' and 'Close all connections'

Version 1.2.3

• Bugfix for Result Table

Version 1.2.2

• Bugfixes
• Enabled Character Encoding for MySQL driver
• Display strings in different encodings

Version 1.2.1

• Bugfixes
• Added driver for Firebird database (Thanks to Sergey Bervinov)

Version 1.2.0

• Added variables
• Copy java strings

Version 1.1.1

• Configurable String to indicate NULL values
• Load BLOB objects if class is located in project classpath
• Save passwords as free text
• Column sum

Version 1.1.0

• Bugfixes for Sybase FAKE_METADATA
• Added column formats

Version 1.0.10

• Bugfix for metadata
• Added option to display dates with time
• Display multiple results
• Fit column width to data
• Rename queries

Version 1.0.9

• Bugfixes
• Added default option for auto-commit to connection properties
• Added syntax highlighting to editor pane
• Added actions 'Copy to Clipboard' and 'Mark as primary key column' to result table context menu
• Added action in IDEA editor popup 'Send to SQLPlugin'

Version 1.0.8b

• Bugfixes
• Added 'Commit' and 'Rollback' button
• ResultTable:
  • Added editing of table and writing back to database
  • Configurable if primary keys columns should be highlighted (Problems with some JDBC drivers)
  • Configurable number of rows loaded
• Execute queries in separate thread
• Add option to cancel queries
• Support keyword 'describe'
• Added support for JDBC-ODBC Bridge, Microsoft SQLServer and Sybase
• Added option 'Auto-Commit' to connection properties
• Made browser none modal
• Allow reset option to execute selected text

Version 1.0.7b

• Bugfixes
• Added button to refresh all connections
• Added 'Save Password' option (requires Sun-JCE)
• Added viewer for CLOB and BLOB (Java objects) values
• Show primary key columns in different color
• Added option to execute the selected text
• Save and load queries
• Align items in HTML export
• Save last export path
• Modified MySQLDriver to work with older versions of MySQL Connector/J
• Added default driver