DbVisualizer Changelog

New in version 9.2.8

June 29th, 2015
  • Enhancement:
  • DDL Generator - Include DDL tab for tables in generic database profile (DbVisualizer Pro)
  • SQL Commander - Allow execute current/execute selected statement in the SQL Commander in DbVisualizer Free
  • SQL Editor - Make auto-indent configurable in Tool Properties
  • Bug:
  • Connection Setup - Honoring searchStringEscape should be disabled for generic databases
  • Connection Setup - Connections can be created with the same name
  • DB Support: Vertica - Drop View action runs SQL drop table including cascade
  • Database Profile: Actions - Regression in Script Table whereas time/date/timestamp values are propagated with current time instead of a empty quoted string
  • Export - The ${dbvis-object}$ variable is not resolved in Filename when ExcelFileFormat is "ooxml"
  • Import - Wrong sheet is used when a sheet is chosen for XML import (xlsx)
  • OS Support: Linux - Error with IBM Java 7: java.lang.NoClassDefFoundError: com.sun.org.apache.xml.internal.serialize.OutputFormat
  • OS Support: Windows - Settings files may be destroyed if performing an uncontrolled shutdown of Windows
  • SQL Commander - Failing setting schema makes schema drop-down change
  • SQL Commander - If an array or struct data type hold primitive types DbVisualizer reports an error
  • SQL Commander - Auto Completion fails if the statement is preceded by a comment
  • SQL Editor - Right-click outside a selected text area deselects the text on Windows
  • SQL Editor - Replace All Backwards may freeze DbVisualizer
  • SQL Editor - Template abbreviations are only expanded if preceded by whitespace
  • SQL Editor - Setting database in Editor not possible if multiple database exists with same name
  • Tool Properties - Import/export of user settings may fail with a java.lang.ArrayIndexOutOfBoundsException
  • Tool Properties - Empty file named "unnamed" in keymaps dir after import settings

New in version 9.2.7 (May 14th, 2015)

  • Enhancement:
  • Auto Completion: Make it possible to initialize Database/Schema to Connection Default, None or Most Recent
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3316&tstart=0 ]
  • Connection Setup: Add a connection property used to disable honoring searchStringEscape in JDBC driver
  • DB Support: Oracle: Add Grants tab for Materialized View
  • Bug:
  • App Logging: Connecting to HSQLDB gives StackOverflowException since 9.2.4
  • Create/Alter Table: If JDBC driver provide an empty list of supported data types an error occur in create/alter table and table data import
  • Create/Alter Table: Exception may occur in Create/Alter Table and the columns tab while searching data types
  • DB Support: DB2 z/OS: The Create and Drop options are missing for Script Table and Script View
  • Filtering/Filter Sets: Values for "in" filters doesn't restore at restart
  • [http://www.dbvis.com/forum/thread.jspa?messageID=19242 ]
  • Query Builder: Identifiers starting with numbers must be delimited (quoted) when loading into the Query Builder to avoid errors
  • Query Builder: DbVisualizer freezes when all joins are removed
  • SQL Commander: Selecting the [Choose Connection] entry in the Database Connection drop-down gives an error
  • SQL Commander: @ddl and @desc commands only support one qualifier
  • SQL Commander: Having a variable in string format with more than 4 elements results in an exception
  • SQL Commander: Selected Database/Schema should not be reset when connecting or disconnecting
  • SQL Commander: Catalog/Schema drop-downs are not updated after execution to reflect any changes of catalog/schema in the script
  • Tool Properties: Exception while loading border files that are not images

New in version 9.2.6 (April 17th, 2015)

  • ENHANCEMENT:
  • DB Support: NuoDB: Add support for user defined functions in NuoDB 2.2
  • Filtering/Filter Sets: Add object filters for: like, not like, and regex
  • BUG:
  • App Logging: dbvisgui.sh -help and -version outputs to the error.log rather than the console
  • App Logging: DbVisualizer fails to start if initialization of logging fails
  • Compare: No colors in margin until scrolling
  • Connection Setup: The file browser for e.g. the Database field does not allow a folder to be selected
  • Connection Setup: Switching between Connection Type: Service and SID for Oracle connections may result in an error
  • Connection Setup: A connection previously used by a closed SQL Commander may be reused for a new SQL Commander
  • DB Support: Informix: Catalog separator (:) for Informix does not work in 9.2
  • DB Support: SQL Server: Cannot drop column with default value via Alter Table due to dependency on system object
  • General: Escape any _ and % characters in arguments to JDBC meta data calls
  • Grid Component: Selecting entry from data type drop-down in Create/Alter Table using mouse doesn't work on Linux
  • Import: NumberFormatException in Import of XLSX
  • Import: Reloading Table Details may cause an exception
  • Import: Exception may occur when Load Default Settings in import wizard
  • Import: Empty column included in wizard when importing excel
  • Import: Import does no longer save certain wizard settings when saving defaults
  • Import: Suggested size for number does not change when changing preview rows during excel import
  • References: java.awt.geom.IllegalPathStateException: missing initial moveto in path definition in references graph
  • SQL Commander: GO delimiters must be written in lowercase
  • SQL Commander: An error occurs if a user specified log file is locked by another application and the execution is halted
  • SQL Commander: Allow formatting of custom Date/Time/Timestamp variables in the same way as for predefined date/time variables
  • SQL Commander: Having for example @echo before any SELECTs in a script results in that the Database drop-down selection is not used to set current database
  • SQL Editor: A line comment just before a @delimiter command cause an error when triggering auto-complete

New in version 9.2.5 (March 18th, 2015)

  • ENHANCEMENT:
  • Chart: Change default number format for Y-axis labels to #,##0,# [http://www.dbvis.com/forum/thread.jspa?threadID=5241 ]
  • General: Allow log files to be attached to a Contact Support request
  • BUG:
  • DB Support: PostgreSQL: Constraints with the same name in multiple tables are included in the DDL for all of those tables
  • Database Objects Tree: Sporadic NPE when re-connect
  • General: OverlappingFileLockException during startup
  • Java 8: Mac OS X and Java 8: A single ArrayIndexOutOfBoundsException occurs without any stack trace and after that the UI is unresponsive
  • SQL Commander: "Database connection cannot be changed while executing" is displayed randomly

New in version 9.2.4 (March 6th, 2015)

  • Enhancement:
  • Command Line Support (dbviscmd) - Make the command line honor the Strip Comments setting by default
  • Bug:
  • DB Support: Oracle - :new.xxx and :old.xxx should not be prompted as parameter markers
  • Driver Manager - Regression in the DriverManager resulting in JdbcOdbcDriver always being used in a custom driver
  • Import - Import CSV doesn't work properly
  • SQL Commander - Unexpected prompting for parameter marker values may occur if there is an empty quoted string earlier in the SQL

New in version 9.2.3 (February 26th, 2015)

  • ENHANCEMENT:
  • Java 8: Experimental support for Java 8
  • BUG:
  • Command Line Support (dbviscmd): A statement with any kind of delimited text, such as a quoted string, is not executed
  • Navigator: The Max Rows setting is not honored
  • Query Builder: Aggregator functions are not recognized as such when loading SELECT statement
  • SQL Editor: Print Preview and Print may cause error when lines must be wrapped to fit on page
  • Tool Properties: Changing Presentation of CLOB Data to Value doesn't survive between sessions

New in version 9.2.2 (February 19th, 2015)

  • Enhancement:
  • DB Support: MySQL - Add support for explain plan in MySQL
  • Bug:
  • Chart - Copy chart to clipboard don't work on Mac OS X
  • DB Support: Informix - A colon in an identifier is processed as a parameter marker
  • Driver Manager - Having P6Spy in a JDBC driver jar file will fail during search of drivers
  • Filtering/Filter Sets - Object filters that are migrated from pre 9.2 versions re-appear when deleting them in 9.2.x
  • Filtering/Filter Sets - Object filtering drop-down entries are not selectable when they should
  • General - The -DMaxPermSize Java property is not supported with Java 8
  • Grid Component - Selecting all cells in a grid by clicking row number and then Command+C copies the row number rather than the selected data cells
  • Key Bindings - Create a key binding gives an error with Java 8
  • Navigator - Exception may occur while opening related tables in the Data Navigator
  • OS Support: Mac OS X - Exception using key binding in SQL Commander with Java 8 on Mac OS X
  • OS Support: Mac OS X - Dropping tables in Query Builder results in an error with Java 8
  • OS Support: Mac OS X - Mac OS X fullscreen support is fixed in Java 1.8.0_20
  • OS Support: Mac OS X - Java 8: "Invalid parameter not satisfying: [self canBecomeMainWindow]..." may appear when actions are executed
  • OS Support: Mac OS X - Holding down a letter key in a text component can freeze the GUI
  • Procedure Editor - No trigger source is shown if the BEGIN or DECLARE keyword is not the first word on a line
  • SQL Commander - Backslash-escaped quotes in strings cause incorrect parsing of an SQL script
  • SQL Commander - An SQL Block end delimiter on the last line without a corresponding start delimiter results in an ArrayIndexOutOfBoundsException
  • SQL Commander - With "Strip Comments when Executing" disabled, statement delimiters (e.g. ";") in a comment results in the comment being sent in pieces to the database
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18724 ]
  • SQL Editor - Loading a SQL history entry in a modified editor should include a "Do not show this message again. Always Discard & Load" setting in the warning dialog
  • SQL Editor - If holding a key in the SQL editor to repeatedly insert a character only a single char is inserted (as per OS X defs) but after that it is impossible to insert any character at all
  • Tool Properties - Mac OS X: Cannot change font with mouse in Tool Properties - SOLVED by using Java 1.7.0_72 and later
  • Tool Properties - Export/import user settings doesn't work as database connections are empty
  • [http://www.dbvis.com/forum/thread.jspa?threadID=5090 ]

New in version 9.2.1 (January 29th, 2015)

  • ENHANCEMENT:
  • DB Support: DB2 iSeries: Add setting for DB2 iSeries to convert CHAR FOR BIT data to text
  • DB Support: MySQL: The MySQL driver should by default disable the "Buffer All Rows for a Result Set" to minimize memory issues
  • Export: Custom sheet name for Excel export
  • BUG:
  • Connection Setup: Updating a connection with an empty SSH Tunnel section may cause an error
  • DB Support: Vertica: Show argument types next to name for SQL Functions and UDFs in the Databases tab
  • DB Support: Vertica: The Function Editor may load the wrong source for an overloaded SQL Function
  • Database Objects Tree: Occasional errors may happen while browsing database objects or during schema export
  • General: Unable to startup due to configuration file issue(s)
  • Grid Component: A large number of dbvis-. files in the temporary directory
  • Import: Exception in wizard when preparing import of excel file (xslx)
  • Key Bindings: Remove Next/Previous Word default key bindings not correct on all platforms
  • OS Support: Mac OS X: Unattended install (-q) shows a window
  • Procedure Editor: Parameterized SQL must be enabled regardless of user setting for the SQL Commander
  • Query Builder: Invalid keyword may result in an error when loading a SELECT statement
  • SQL Commander: Error parsing parameter markers
  • SQL Editor: Parameter markers incorrectly detected when between brackets or backtick quotes
  • Table Data Editor: Result set is not editable if using a sub query in the select statement
  • Tool Properties: An error may occur when import of user settings

New in version 9.2 (January 12th, 2015)

  • ENHANCEMENTS:
  • Auto Completion: Full auto completion support for client side commands and their parameters
  • Compare: Allow comparison of two cells in the same grid
  • Connection Setup: Re-introduce the "single physical database connection" behavior
  • Connection Setup: Add support for editing multiple database connections
  • Connection Setup: Add optional master password protection for DbVisualizer
  • Connection Setup: Add a Connection Keep Alive feature
  • Connection Setup: The DB2 z/OS database type should be set when using the DB2 z/OS driver definition
  • DB Support: DB2 iSeries: The Schema list in the SQL Commander should really change the current schema
  • DB Support: H2: Upgrade to H2 1.3.175
  • DB Support: Oracle: Add DDL support for GLOBAL TEMPORARY TABLE
  • DB Support: Oracle: Add support for export of sequences and synonyms in Export Schema
  • DB Support: PostgreSQL: Add support for editing HSTORE, JSON and JSONB values in the grid
  • DB Support: SQLite: Upgrade to SQLite 3.8.6
  • Database Objects Tree: Make it possible to hide certain object types
  • Database Objects Tree: Support for multiple named filters
  • Database Objects Tree: Support filter sets with pre-defined filters that can be switched easily
  • Database Objects Tree: Support sharing object tree filters between database connections
  • Database Objects Tree: Allow de-activating some filters in the objects tree
  • Database Objects Tree: Ensure Database Connection and Folder names are unique under its parent node
  • Database Objects Tree: Support more filtering conditions (ex in, not in, starts with, contains, ...)
  • Database Profile: Actions: Allow showing result sets generated by action in a text viewer
  • Export: Exported binary Excel files has sheets selected initially resulting in edits being made in one sheet are propagated to all sheets
  • Export: Default sheet names does not follow Excel standard at export (Sheet1, Sheet2, Sheet3)
  • Export: Should be possible to specify qualifiers and delimited identifiers (for SQL format) in Export
  • Grid Component: Add option to allow free horizontal scrolling in grids instead of the current column-by-column based scrolling
  • Grid Component: Add new Copy Selection actions to grids: Copy as Comma list, Copy as IN clause
  • Import: Add support for Excel (xls/xlsx) import of table data
  • Import: Make it possible to specify in which row any header starts and the data in CSV import
  • Import: File row numbers in import preview panel
  • Import: Import into new table with a DECIMAL column should suggest size,scale for the DECIMAL data type
  • Installation/Update Installation: Offer a Debian software package installer
  • Key Bindings: Can't set key bindings for Tools->Compare
  • OS Support: Windows: Show splash screen when starting second DbVisualizer instance
  • SQL Commander: An SQL Commander tab with a file loaded should be removed at next startup if the referred file has been deleted and the SQL Commander is not modified & auto-saved in previous DbVisualizer session
  • SQL Commander: Allow having the Log and all result set tabs in a floating window that persist as long as the SQL Commander tab or when docked
  • SQL Commander: The Set Auto Commit command in the SQL menu should show on/off based on current mode to make it more intuitive
  • SQL Commander: The Schema list in the SQL Editor should really change the current schema for PostgreSQL
  • SQL Commander: Allow use of parameter markers (?, :pm, &pm, or :{pm}) for any database
  • SQL Commander: Support the :'x' parameter marker format
  • SQL Commander: Add a @sleep command
  • SQL Commander: Add new client side command (@set resultset name ) used to set a name for the next result set
  • SQL Editor: Add support for pre-defined templates and custom SQL templates
  • SQL Formatter: Option to format a SQL statement into a single line by removing newlines, tabs, etc.
  • Table Data Editor: Show current cell data format in the table editor status bar
  • Tool Properties: Import Settings should merge database connections.
  • BUG FIXES:
  • DB Support: SQLite: [SQLITE_NOTADB] File opened that is not a database file (file is encrypted or is not a database)
  • DB Support: Vertica: "Map to String" viewer for Flex Tables show an error
  • Export: Export to XLSX doesn't output non-printable characters properly
  • Installation/Update Installation: Add Mac OS X installer that include Java 7
  • SQL Editor: Exception when click "Discard Edits" and then click in editor when dialog: "The loaded file is no longer available for editing. Confirm save or discard edits and then clear the SQL editor" is displayed
  • SQL Editor: Navigating vertically with arrow keys may change horizontal position if a line holds both TAB and SPACE characters
  • SQL Editor: Ctrl+Left-click does not trigger the popup menu
  • Scripts: An exception may occur when filtering and expanding/selecting nodes
  • Scripts: Duplicating file in Scripts tab ruins file extension. "name.sql1" instead of "name1.sql"
  • Scripts: Drag & drop of file to folder containing a file with the same name gives an error
  • Table Data Editor: Unable to save data grid changes when table names containing spaces
  • Table Data Editor: Force close of an object view tab while saving table data edits may result in an error

New in version 9.1.13 (January 12th, 2015)

  • Bug fixes:
  • Command Line Support (dbviscmd): Make it possible to execute @run commands in a script specified by -sqlfile
  • Command Line Support (dbviscmd): Retrieval and prompting for SSH credentials, especially the passphrase, is not working
  • DB Support: SQL Server: Connecting by expanding a connection node may cause an invalid URL to be used
  • DB Support: SQL Server: DATE columns generate ALTER COLUMN statements in Alter Table even when unchanged
  • DB Support: Sybase ASE: Function and Procedure code for large objects may be out of order for older versions of Sybase ASE
  • DDL Generator: ClassCastException when generating DDL for a View in Mimer 10.x or later
  • Database Profile: Actions: The Script action gives an error for the CREATE option for some object types in some databases
  • Export: Rare SQL SELECT syntax may stop execution during @export
  • Grid Component: Embedded array produced by for example the SDO_GEOMETRY type in Oracle is not properly displayed
  • Navigator: Exception occurs when selecting some nodes in a Navigation graph. Selecting other nodes (from the same table) in the same graph works fine
  • Procedure Editor: Syntax error messages are not marked as errors in the log
  • SQL Commander: Error highlighting is off when using SQL Block delimiters
  • SQL Commander: A client side command is not processed if it is preceded by a comment
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18595 ]
  • SQL Commander: SQL syntax errors stops execution when preprocessing is disabled

New in version 9.2.2339 Beta (December 18th, 2014)

  • Enhancement:
  • SQL Commander - Support the :'x' parameter marker format
  • Bug:
  • Command Line Support (dbviscmd) - Retrieval and prompting for SSH credentials, especially the passphrase, is not working
  • Command Line Support (dbviscmd) - Make it possible to execute @run commands in a script specified by -sqlfile
  • Connection Setup - Database password may be corrupt if mixing "Save Password Between Session" and "Save Password During Session" on the database type and a specific database connection
  • DB Support: Sybase ASE - Function and Procedure code for large objects may be out of order for older versions of Sybase ASE
  • DDL Generator - ClassCastException when generating DDL for a View in Mimer 10.x or later
  • Database Profile: Actions - The Script action gives an error for the CREATE option for some object types in some databases
  • Explain Plan - Explain plan for PostgreSQL doesn't work if having parameter markers in SQL
  • Export - "Parameter 'sqlqualifycolumnname' is not valid for this command" when exporting table
  • Navigator - Exception occurs when selecting some nodes in a Navigation graph. Selecting other nodes (from the same table) in the same graph works fine
  • SQL Commander - A client side command is not processed if it is preceded by a comment
  • SQL Commander - Error highlighting is off when using SQL Block delimiters
  • Table Data Editor - Unable to save data grid changes when table names containing spaces

New in version 9.2.2335 Beta (December 9th, 2014)

  • ENHANCEMENT:
  • DB Support: Oracle: Add support for export of sequences and synonyms in Export Schema
  • Database Objects Tree: Ensure Database Connection and Folder names are unique under its parent node
  • Grid Component: Add new Copy Selection actions to grids: Copy as Comma list, Copy as IN clause
  • Tool Properties: Import Settings should merge database connections
  • BUG:
  • DB Support: Oracle: Trigger names are invisible in the database objects tree
  • DB Support: Vertica: "Map to String" viewer for Flex Tables show an error
  • Filtering/Filter Sets: In some rare situations an error may appear when clicking a database objects node
  • SQL Commander: Multiple uses of a DbVis variable with the same name prompts for values equally times
  • SQL Editor: Navigating vertically with arrow keys may change horizontal position if a line holds both TAB and SPACE characters
  • SQL Editor: Ctrl+Left-click does not trigger the popup menu
  • Scripts: Duplicating file in Scripts tab ruins file extension. "name.sql1" instead of "name1.sql"
  • Scripts: Drag & drop of file to folder containing a file with the same name gives an error
  • Table Data Editor: Force close of an object view tab while saving table data edits may result in an error

New in version 9.1.12 (November 27th, 2014)

  • ENHANCEMENTS:
  • Create/Alter Table:
  • Removing the last column in a Primary Key should automatically remove the Primary Key
  • DB Support: SQL Server:
  • Add an Instance field in the Connection tab for SQL Server
  • SQL Commander:
  • Key binding to start Execution can not be set to any of the key bindings Java/Swing have assigned to for example the Max Rows textfield, etc.
  • BUG FIXES:
  • Auto Completion:
  • Activating Auto Completion can in some circumstances freeze the GUI
  • DB Support: Mimer SQL:
  • References graph may show duplicate table nodes
  • DB Support: MySQL:
  • An error may occur when generating DDL for a MySQL table, e.g. in Alter Table or the DDL tab
  • DB Support: Oracle:
  • Rename the Session Properties tab to accurately state that it shows database properties and add a new Session NLS Parameters tab
  • DB Support: Oracle:
  • Handle procedure DATE parameters as TIMESTAMP instead of TIME for Oracle 12
  • DB Support: PostgreSQL:
  • Two dimensional arrays no longer render correctly in result sets
  • DB Support: SQL Server:
  • SELECT ... INTO ... will limit number of copied rows by setMaxRows()
  • DB Support: Vertica:
  • The ON COMMIT PRESERVE ROWS clause is always included when creating a temporary table
  • Database Profile: Actions:
  • Using List input in an action should match default value independent of case
  • Database Profile: Actions:
  • A action element without tags around the message will break
  • Export:
  • Date/Time literals are not in the database-specific format unless Format is set to uppercase "SQL"
  • OS Support: Mac OS X:
  • F1-F10 cannot be used as part of a key binding on Mac with Java 7 using the FN key
  • SQL Commander:
  • An exception may be reported if doing a rollback and then reconnect
  • SQL Commander:
  • Possible NPE when highlight execute
  • SQL Editor:
  • Dropping a file in the SQL Editor should load that file using the same encoding as used in the editor

New in version 9.2.2329 Beta (November 26th, 2014)

  • Enhancement:
  • Compare: Allow comparison of two cells in the same grid
  • DB Support: Oracle: Add DDL support for GLOBAL TEMPORARY TABLE
  • DB Support: Oracle: Handle procedure DATE parameters as TIMESTAMP instead of TIME for Oracle 12
  • DB Support: PostgreSQL: Add support for editing HSTORE, JSON and JSONB values in the grid
  • Import: File row numbers in import preview panel
  • OS Support: Windows: Show splash screen when starting second DbVisualizer instance
  • SQL Commander: The Set Auto Commit command in the SQL menu should show on/off based on current mode to make it more intuitive
  • SQL Formatter: Option to format a SQL statement into a single line by removing newlines, tabs, etc.

New in version 9.2.2328 Beta (November 12th, 2014)

  • Bug:
  • SQL Commander - ${...}$ variables without type information are erroneously when executed treated as parameter markers rather than literals
  • Scripts - Rendering of Favorites and Scripts lists are broken

New in version 9.1.11 (October 14th, 2014)

  • Bug:
  • Auto Completion - Auto Completion of column names does not work after linefeed
  • Chart - The value for a point in the chart tool tip is always rounded to one decimal
  • Compare - NullPointerException when closing the Compare window with a cell selected
  • Connection Setup - SSH tunneling does not work with long DNS target server names
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3938]
  • Connection Setup - Disconnecting progress window is displayed even after connection(s) closed
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4975]
  • DB Support: DB2 LUW - Error running explain with DB2 LUW 10.5
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4971]
  • DB Support: Vertica - Move Table to Schema may display an error
  • Database Objects Tree - Vertical scrollbar in the action window appears only after a resize
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18248]
  • Database Profile: Actions - Should be possible to specify other schema for new trigger than the table schema
  • Database Profile: Actions - Exception is raised if there is not static text specified in the element for an action
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18320]
  • Database Profile: Actions - Actions with many fields may take time to open and respond slow when editing
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18280]
  • General - Error when getting columns information using the HIT JDBC driver
  • Grid Component - Unsortable grids should not have sorting entries in header popup menu
  • OS Support: Linux - Double-click on the same file twice in the file chooser results in an exception
  • SQL Commander - Merge result sets doesn't work having Remove Original Result Sets checked
  • SQL Commander - Failing to save a file due to file system exceptions such as permissions still remove the modified indicator for that file
  • SQL Commander - For PostgreSQL, Vertica and H2: Are prompted to commit/rollback transaction(s) even if running only SELECTs
  • Workspace - Exception: AIOOBE when clicking tab

New in version 9.1.10 (August 9th, 2014)

  • ENHANCEMENT:
  • DB Support: Vertica: Add support for Vertica in DbVisualizer Pro
  • SQL Editor: Make it possible to set the caret color in the SQL editor
  • BUG:
  • DB Support: MySQL: YEAR(4) values are not being displayed correctly and cannot be edited in the grid
  • DB Support: NuoDB: The column names in the Index DDL are incorrect
  • DB Support: PostgreSQL: Running a erroneous query in auto-commit off mode will result in a result set never being editable due to the 25P02 error in PostgreSQL
  • Database Objects Tree: Windows: Opening a floating window using key bindings may display the new window behind the main window
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4303 ]
  • Export: Exporting in XmlDataSet and FlatXmlDataSet format adds the unnecessary DbVisualizer-Export tag
  • Import: Preserve import window size and position during session
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4923 ]
  • SQL Commander: Execution error may lead to rare NullPointerException situations
  • SQL Editor: The spacing between characters is incorrect when using a some fonts, like 14 points Menlo Plain, on a Mac with Retina display
  • SQL Editor: The Find/Replace dialog does not use the selected text for "Find what" the first time it is displayed

New in version 9.1.9 (June 11th, 2014)

  • Enhancement:
  • Grid Component - Tool tip for long filenames in Scripts and Favorites tabs
  • Performance/Stability - Enhance detection of high memory usage
  • Performance/Stability - Provide more meaningful info about memory usage by ignoring memory for short-lived objects
  • Bug:
  • Compare - Memory may not be released when closing the Compare window
  • Compare - Compare Grids dialog is not closed when one of the compared result set grids is closed
  • DB Support: DB2 z/OS - Indexes listing doesn't show correct information
  • DB Support: NuoDB - The Types node does not show any content and cause an error when clicked
  • DB Support: Oracle - TNS connections fails when used with the command line interface
  • DB Support: Oracle - For very large views, the DDL may be incomplete
  • DB Support: SQL Server - List Stored Procedures and Functions ordered by schema and then name
  • DB Support: SQL Server - Expanding the Sequences node gives an exception if the MS JDBC driver is used
  • Database Objects Tree - JDBC drivers returning null for getCatalog() fail in later steps
  • Import - Import into new table with a DECIMAL column should suggest size,scale for the DECIMAL data type
  • Performance/Stability - Memory is not always released when closing result set tabs from the High Memory Usage dialog
  • SQL Commander - With a driver that throws UnsupportedOperationException for cancel(), queries cannot be stopped
  • SQL Commander - Error when executing @run command with "Log to GUI"
  • SQL Formatter - NATURAL JOIN is not formatted correctly
  • SQL Formatter - Formatting a Mimer statement call gives an error
  • Tool Properties - The Application (Rest of UI) font size setting have no effect when using one of the Synthetica L&Fs

New in version 9.1.8 (April 16th, 2014)

  • Enhancement:
  • Command Line Support (dbviscmd): Make it possible to execute a large script specified by -sqlfile
  • DB Support: NuoDB: Add support for NuoDB domains and sequences
  • DB Support: Sybase ASE: Add support for CLUSTERED keyword in CREATE INDEX DDL
  • Database Search: Add button to select target database objects in the Databases tab from the Database Search result list
  • Key Bindings: Add Alt-Backspace as binding for Delete to Word Start and Cmd-Backspace as binding for Delete Preceding Characters in Line for Mac OS X. Also add Meta+Shift+A for Select None in SQL editors for all platforms
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4826 ]
  • Query Builder: Automatically set a table alias if a table is added multiple times
  • Bug:
  • Chart: Bar/Stacked Bar charts doesn't display
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17810 ]
  • Create/Alter Table: Regression in copy/paste of column details (paste does nothing)
  • DB Support: DB2 LUW: The "Empty Table" action to truncate a table doesn't work with DB2 10 and later
  • DB Support: DB2 LUW: DDL generation fails for a View if there is no whitespace between the AS keyword and the left parenthesis
  • DB Support: Informix: Synonyms cannot be dropped in Query Builder
  • DB Support: Oracle: Column order is not preserved in DDL for UNIQUE constraints
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4811 ]
  • DB Support: SQL Server: DATETIME2, UNIQUEIDENTIFIER, GEOGRAPHY and GEOMETRY types are not handled correctly in DDL and Alter Table
  • DB Support: SQL Server: Add support for synonyms
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4774 ]
  • DB Support: Sybase ASE: Columns tab for System Table shows columns for all tables in the schema
  • DB Support: Vertica: Vertica: Loosing DB connection while working in the SQL Commander doesn't prompt for reconnect at next execute
  • Database Search: Database Search list should show object paths of found objects by default
  • Export: Exporting to XLSX with appendFile="clear/true" may result in errors on Mac OS X
  • Grid Component: Incorrect handling of database when saving grid updates for a query with a fully qualified table for Informix, Sybase ASE and SQL Server
  • Monitor: Settings in a monitor may be cleared or lost from the Monitors window
  • Monitor: An IllegalStateException may be reported while reloading monitors
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17796 ]
  • Monitor: Series and category drop-down menus may not reflect the columns in the underlying result set
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17804 ]
  • Performance/Stability: Clicking Create Heap Dump in the High Memory Usage dialog when one exists causes an error
  • SQL Commander: Script files executed with the @run command should be closed directly at the end of execution
  • SQL Commander: File->Revert to Saved and Compare with Saved should always be available when file is loaded
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4866 ]

New in version 9.1.7 (March 8th, 2014)

  • Bug:
  • Connection Setup: Connecting to OpenEdge with Server Info checked in Connection tab results in an error
  • Create/Alter Table: Incorrect handling of data types with more than one parenthesis pair, e.g. INTERVAL DAY(2) TO SECOND(9)
  • DB Support: H2: Filtering schemas in H2 doesn't work
  • Favorites: Hovering a database object in the favorite bar or favorites editor that has been removed may result in an exception
  • Grid Component: Exception when launching the Form Editor by double-clicking in the margin for an empty grid
  • SQL Editor: Replace All may cause an error if the Find What string contains a hashmark
  • SQL Editor: Quick Find does not honor blanks for the first match
  • SQL Editor: Occasionally an error (NullPointerException in AttributedString) is triggered by various editor operations, e.g. the Find and Replace dialogs or simply double-clicking
  • Tool Properties: DbVisualizer on Linux won't start if overridden Java Properties have no trailing newline
  • Tool Properties: User Java VM Properties cannot be edited using Java 7 on OS X
  • Workspace: Exception may occur when floating a tab

New in version 9.1.6 (January 27th, 2014)

  • Enhancement:
  • DB Support: Sybase ASE: Add support for UNICHAR/UNIVARCHAR size in DDL
  • General: Support user.vmoptions and modifying Java properties in Tool Properties for all installer types
  • Grid Component: Should be possible to copy/paste external files to binary/BLOB and CLOB grid cells
  • Grid Component: Should be possible to copy/paste binary/BLOB and CLOB data between grids
  • SQL Commander: Clicking on an icon for an error in the Log tab should move the caret to the error instead of selecting the statement
  • Workspace: Adjust active tab stripe color based on current look and feel. Allow override it in tool properties
  • Bug:
  • Connection Setup: Set Database Type to Auto Detect by default when using the Connection Wizard
  • Connection Setup: Pressing Tab in the Database Userid field in the Connection Wizard selects the value instead of moving to the next field
  • Database Objects Tree: Using any of the "Script..." or "Open in..." right-click options in the Tables grid with the Generic database type will result in an exception if TABLE_SCHEM is null
  • General: Occasional "Comparison method violates its general contract" error may be reported
  • Grid Component: Right double-click in the row number field without having a grid selection results in an exception
  • OS Support: Mac OS X: com.jidesoft.plaf.aqua.AquaPreferences loadGlobalPreferences may be listed in the debug window on OS X
  • SQL Commander: Highlighting errors for huge statements takes a very long time
  • SQL Commander: Sometimes the Elapsed Time field in the Log tab shows an incorrect value and the script may be executed multiple times
  • SQL Commander: Connection drops while executing in the SQL Commander require a manual reconnect rather than automatically at next execute
  • SQL Editor: Occasionally an error (NullPointerException in AttributedString) is triggered by various editor operations, e.g. the Find and Replace dialogs or simply double-clicking
  • Table Data Editor: Null cells should be preserved when copy/paste between grids independent what "Show Null As" is set to
  • Workspace: Exception: IndexOutOfBoundsException while closing or move tab
  • Workspace: Tab text color is too bright and "Show Tab Title in Bold" doesn't work with Metal L&F

New in version 9.1.5 (December 16th, 2013)

  • Enhancement:
  • SQL Commander - Present a Reconnect dialog when detecting a dropped connection at Execute
  • Bug:
  • SQL Commander - Having "Process Parameter Markers in SQL" enabled may consume cursors and cause following SQLs to fail during execution
  • Table Data Editor - Result set is not editable if using a sub query in the select statement

New in version 9.1.4 (December 7th, 2013)

  • Enhancement:
  • SQL Commander - SQL Commander->Strip Comments when Executing should be unchecked by default (for new users. Existing users need to uncheck manually)
  • SQL Commander - Add key binding to move focus between SQL editor and the result sets (View menu)
  • Tool Properties - Don't insert "save at" timestamp in the settings XML files
  • Workspace - Add key binding to activate and focus current workspace tab (Object View or SQL Commander)
  • Workspace - Focus is not set when using key binding to switch to Database, Scripts and Favorite tabs
  • Bug:
  • Connection Setup - Clicking the Ping button may result in an IndexOutOfBoundsException
  • DB Support: Other - Indexes doesn't show in the Indexes tab for a table for Progress databases
  • Data tab - While Data tab is being loaded (or saved) some controls are enabled that may result in an error due to the processing state
  • Database Objects Tree - Using keyboard to paste into the Databases tab list show an exception
  • General - An error may occur when connecting with the bundled Java VM: "Unsupported ccsid, encoding, or locale: "Cpxxx""
  • SQL Commander - Getting column information for unqualified tables fails for some databases, affecting Auto Complete and enabling of editing controls for result sets
  • Table Data Editor - Saving table data may give an error if saving to a table in non default schema
  • Table Data Editor - Pressing tab or enter key in a cell that contain newline or tab characters should not start the inline editor

New in version 9.1.3 (November 23rd, 2013)

  • Enhancement:
  • Check for Update: Show underlying error message when not being able to connect
  • Data tab: Should be possible to assign key binding to the "Show in Navigator" action in the Data tab
  • General: Show underlying error message when not being able to connect for Pro evaluation
  • General: It should be possible to modify vmoptions per user and not only for the installation which may be shared by many users
  • Import: Dropping a file on a Tables or Table object should open the Table Data Import feature
  • Installation/Update Installation: Changes in the vmoptions file should survive when installing new versions
  • Workspace: Add option to set that "Open in Tab" should switch to the already open object tab first, otherwise open a new tab
  • Bug:
  • Check for Update: Use System Proxy Settings does not work on Windows if an automatic configuration script is used for system setting
  • Connection Setup: Disconnect All may take a while if having a lot (100+) of database connections
  • DB Support: Oracle: Max Size is not summarized correctly (DBA Views->Storage->Tablespaces) if having multiple data file for a tablespace
  • DB Support: SQL Server: Size parameter is not included in DDL for VARBINARY column and the MAX value is not supported for VARBINARY in Create/Alter Table
  • Database Objects Tree: Using the pre 9.0 scripting features doesn't honor the scripting settings in connection properties
  • Database Objects Tree: It is not possible to connect (using the node expand handle) a database connection in the Databases tab if it is in an error state
  • Database Profile: Actions: The Drop Table action doesn't generate good SQL for MaxDB
  • Driver Manager: De-selecting a driver jar file doesn't disable the command buttons. Invoking these without an active selection may result in an error
  • Grid Component: Clicking 'Reset Columns' button in the Grid Column Chooser while the underlying resultset is being loaded results in an error
  • Monitor: Reloading monitor scripts will reset the current results of any active monitors
  • Monitor: Re-displaying the monitor window with monitors running may display an empty dialog in front of it
  • Query Builder: Missing whitespace between an operator and its expression cause an error when loading a SELECT statement
  • SQL Commander: Getting column info for a result set fails if the table identifier is qualified with a different database than the default
  • SQL Commander: Executing queries for large tables with Sybase IQ may be dramatically slower than versions older than 9.0.5
  • SQL Commander: NullPointerException when executing a script containing an error with Preprocess Script disabled for databases that support error highlighting
  • SQL Commander: When executing a script for a connection that has dropped, an error is reported for the first statement but a new connection is acquired and the rest are executed, possibly with the default database/schema instead of the selected
  • SQL Formatter: Formatting a "WITH tableName -- comment AS (SELECT ..." statement does not work as intended
  • SQL Formatter: Variables for non-literal strings are mangled when using the Add One Space whitespace setting for the SQL Formatter
  • Table Data Editor: Paste in row form editor doesn't work
  • Tool Properties: Setting the "Show Null Value as" to en empty string in Tool Properties->Data Formats will break the scripting and table data editing features

New in version 9.1.2 (October 28th, 2013)

  • Enhancement:
  • Chart: Add "Allow Label Overlap" property for the X-axis in chart
  • DB Support: PostgreSQL: Add nodes and actions for Materialized Views for PostgreSQL 9.3 and later
  • Database Profile: View: Use count_big() instead of count() for DB2 LUW, SQL Server and Sybase ASE when calculating number of rows
  • Export: Export to Excel should name the sheets Sheet1, Sheet2, ... instead of DbVisualizer Pro1, DbVisualizer Pro2, ...
  • Import: Interpret all quoted data as String
  • SQL Commander: Add "Compare to Saved" option when warning about file has been edited (in another tool) since it was opened
  • SQL Editor: Save the settings in the Find/Replace dialog between sessions
  • Table Data Editor: Improve performance of Paste into grid
  • Table Data Editor: Add new Set Selected Cells->"Set to UUID" action
  • Table Data Editor: Improve performance for the "Set Selected Cells" actions
  • Table Data Editor: Improve performance when selecting/deselecting rows in the grid using the row header field
  • Workspace: Introduce new labeling variables for Object View tabs: ${catalog} (database name) and ${schema}
  • Bug:
  • Auto Completion: Column list is not shown in CASE expressions (after CASE, WHEN, THEN and ELSE)
  • DB Support: DB2 LUW: No source code is shown for functions and procedures implemented in Java
  • Data tab: If auto complete in the Data tab filter field while the grid is loading results in an error
  • Database Objects Tree: An error may occur in some rare situations when opening the right-click menu in the database objects tree
  • Database Objects Tree: Any active object tree filters are not disabled if moving from Pro to Free
  • Driver Manager: An error may occur during startup
  • Export: An unrelated error is displayed when saving export settings to a file that is not writable
  • General: Exception is raised when removing task due to out of memory situation
  • General: Errors may be displayed with IBM Java VM
  • Grid Component: Double-click a value cell in an "Info" grid may result in an exception
  • Import: An error is displayed when saving import settings to a file that is not writable
  • OS Support: Mac OS X: Internal error may occur with Java 7 on Mac OS X
  • References: While references graph is being loaded and the user activate a command an exception may appear
  • SQL Commander: Error marking tooltips do not show text embedded with < and >
  • SQL Commander: The Database list value changes when executing a SELECT where the table name is qualified with another database than the current list value
  • SQL Commander: Running a SELECT with Sybase IQ fail with long response time and a connection closed exception
  • SQL Commander: Triggering Show Object at Cursor while it is already running causes an error
  • SQL Commander: Using keyboard to execute query while any of an pinned result set or log tab is maximized will result in an error
  • SQL Editor: Replace All does not trigger the Pending Edits state
  • SQL Editor: Up/Down arrows do not retain the caret column position after edit
  • Table Data Editor: Converting BLOB value into text in the cell editor results in "BINARY, nnn bytes" rather than the actual data
  • Workspace: Opening database object in floating window should not change currently selected tab in main window

New in version 9.1.1 (October 1st, 2013)

  • Enhancement
  • DB Support: DB2 LUW - Add GRANT info for Sequence objects
  • DB Support: DB2 LUW - Add a node for Global Temporary Tables
  • Database Profile: Actions - The Script xxx feature should automatically save its settings
  • Database Profile: Actions - Add DROP TABLE action for the Generic profile
  • General - Add predefined DbVisualizer variables for "current database type" and "current connection"
  • References - Include object qualifiers in the Specified Tables selection dialog
  • SQL Commander - Not easy to determine which editor the "truncate log" window belongs to
  • SQL Editor - Make Find Next/Previous work with Find Selection just as with Find with Dialog
  • SQL Editor - Add "Insertion Point to Matching Brace" keyboard shortcut
  • Bug:
  • Auto Completion - Vertical bar is not recognized as a column separator
  • DB Support: Oracle - TIMESTAMP WITH LOCAL TIME ZONE types are displayed as oracle.sql.TIMESTAMPLTZ@1e663400
  • Data tab - Auto completion in inline data filter may leave garbage text
  • Installation/Update Installation - Installing 9.1 in a directory where 5.1.1 or older is already installed results in an error launching 9.1
  • Installation/Update Installation - RPM install on Fedora 19 doesn't work
  • SQL Commander - A ConcurrentModificationException is sometimes thrown when running a script that creates result sets
  • SQL Commander - Canceling the confirmation dialog asking whether to discard or save current editor when loading a file in DbVisualizer Free may result in an error
  • SQL Editor - While execution is running in the SQL Commander any selected text in the editor is flashing
  • Table Data Editor - Saving text in a binary type may use wrong encoding when re-opening the value in the cell editor
  • Workspace - "Malformed \uxxxx encoding" error may appear while starting DbVisualizer
  • Workspace - NPE will occur if there is a mismatch in the meta data file managing tabs that should be open and the actual files available

New in version 9.1 (September 9th, 2013)

  • Enhancement:
  • Chart: Should be possible to set the Y-axis value at any specified value and not only by the actual data
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4582 ]
  • Check for Update: Improve the check for update feature
  • Connection Setup: Add an Auto Detect choice for Database Type
  • DB Support: HSQLDB: Disconnecting a HSQLDB embedded database keeps the database file locked until DbVisualizer is closed
  • DB Support: Informix: Highlight SQL errors in the editor
  • DB Support: JavaDB/Derby: Highlight SQL errors in the editor
  • DB Support: JavaDB/Derby: Disconnecting a JavaDB/Derby embedded database keeps the database file locked until DbVisualizer is closed
  • DB Support: Mimer SQL: Highlight SQL errors in the editor
  • DB Support: MySQL: Highlight SQL errors in the editor
  • DB Support: Oracle: Highlight SQL errors in the editor
  • DB Support: Oracle: Add tempfile actions for Remove, Offline and Online
  • DB Support: Other: Database objects names are listed as (null) in the Databases tab for the Redshift database
  • DB Support: PostgreSQL: Highlight SQL errors in the editor
  • DB Support: PostgreSQL: Must be possible to easily enable that Explain Plan should be run with/without with the Analyze option
  • DB Support: PostgreSQL: Add option to display native explain output for PostgreSQL
  • DB Support: SQL Server: Add sequence objects to the Databases tab tree
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4507 ]
  • Data tab: Key binding for auto completion in the inline filter field should use the same key(s) as defined for SQL Commander->Show Auto Completion
  • Database Objects Tree: Various problems may occur if schema/database name contain an embedded dot "."
  • Database Objects Tree: Database->Copy Database URL should only be enabled if the currently selected entries(s) are all database connection objects
  • Database Profile: Add support for extending a database profile
  • Database Profile: Add support for custom icons for use in database profile (object type icons)
  • Database Profile: Actions: Introduce a element for actions in the database profile
  • Database Profile: Tree: Add icon (optional) attribute for DataNode's
  • General: Add "Contact Support" feature in DbVisualizer (under Help menu)
  • General: Start evaluation of DbVisualizer Pro should be possible from within DbVisualizer Free without requiring to sign-up on web-site
  • General: Automatically remove evaluation license when it expire
  • General: Upgrade bundled JDBC drivers for DB2 (4.15.82), JavaDB/Derby (10.10.1.1), H2 (1.3.172), jTDS (1.2.7), MySQL (5.1.25), PostgreSQL (9.2-1002.jdbc4), SQLite (3.7.2)
  • General: Clearly tell what user should do when a beta version license expire
  • Grid Component: Allow setting max scale in the Aggregation Data for Selection window
  • Installation/Update Installation: Should be possible to automatically upgrade to newer version without needing to manually visit web site
  • Installation/Update Installation: Check for Update should set response headers to prevent products.xml being retrieved from a cache
  • OS Support: Mac OS X: Add support for Java 7 on Mac OS X
  • References: Add support for EMF as an export format
  • SQL Commander: Opening a SQL file or load from Recent menu should set database connection, database and schema from most recently used object or SQL editor
  • SQL Editor: Clicking the encoding status bar item should allow changing encoding
  • SQL Editor: Add keyboard navigation for moving the caret to the next or previous error marking
  • Table Data Editor: Add connection property controlling encoding of text data when it is stored in a binary DB type
  • Tool Properties: Add a property for max connection pool size
  • Workspace: Add option to control where new workspace tabs should be inserted
  • Bug:
  • Auto Completion: Cached table name alias may appear in auto completed column output even if no alias is currently specified
  • Auto Completion: A NullPointerException may be thrown for a partly typed table identifier
  • Chart: Chart settings revert to default if rerun a query in same SQL Commander
  • Data tab: Auto completion in inline data filter may leave garbage text
  • Database Objects Tree: Remove is-empty-output="continue" in database profiles to minimize follow-up errors when all databases/schemas has been filtered
  • Export: Exporting numeric null values to Excel results in zero instead of null
  • Table Data Editor: A value containing only characters matching the DbVisualizer variable delimiter cannot be saved
  • Workspace: Key bindings to jump between tabs in the focused tab group doesn't work properly

New in version 9.0.9 (September 3rd, 2013)

  • Enhancement:
  • DB Support: Oracle - Add support for domain index type clause in DDL for Index
  • Bug:
  • Auto Completion - Column names must never be qualified within a USING clause
  • Database Objects Tree - A NullPointerException may appear when opening a new database object
  • Import - Load custom import settings may result in an error if referenced CSV file doesn't exist
  • Query Builder - When the Query Builder overwrites text in the SQL editor, the change cannot be undone
  • References - Triple-click on a table in the references graph may result in an error
  • References - Table in References not highlighted when clicked in search result list and if already selected
  • References - A NullPointerException is thrown if a JDBC driver returns null for the KEY_SEQ column in a ResultSet for exported/imported keys
  • References - There is a regex error when finding table nodes in the references graph and the search string contain parenthesis
  • References - Zoom status bar information is not updated when zooming with mouse wheel
  • SQL Editor - Highlight DATETIME as a keyword in the SQL Editor for SQL Server, Sybase ASE, Informix and MySQL
  • SQL Editor - Setting background color for SQL editors doesn't affect the DDL viewer or Procedure Editor
  • SQL History - Setting Max Entries to a negative number causes the GUI to freeze when executing a statement in the SQL Commander
  • Table Data Editor - "Cannot launch run() while processing" message may occur during save

New in version 9.0.8 (August 29th, 2013)

  • Enhancement:
  • DB Support: Oracle - Add support for domain index type clause in DDL for Index
  • Bug:
  • Auto Completion - Column names must never be qualified within a USING clause
  • Database Objects Tree - A NullPointerException may appear when opening a new database object
  • Import - Load custom import settings may result in an error if referenced CSV file doesn't exist
  • Query Builder - When the Query Builder overwrites text in the SQL editor, the change cannot be undone
  • References - Triple-click on a table in the references graph may result in an error
  • References - Table in References not highlighted when clicked in search result list and if already selected
  • References - A NullPointerException is thrown if a JDBC driver returns null for the KEY_SEQ column in a ResultSet for exported/imported keys
  • References - There is a regex error when finding table nodes in the references graph and the search string contain parenthesis
  • References - Zoom status bar information is not updated when zooming with mouse wheel
  • SQL Editor - Highlight DATETIME as a keyword in the SQL Editor for SQL Server, Sybase ASE, Informix and MySQL
  • SQL Editor - Setting background color for SQL editors doesn't affect the DDL viewer or Procedure Editor
  • SQL History - Setting Max Entries to a negative number causes the GUI to freeze when executing a statement in the SQL Commander
  • Table Data Editor - "Cannot launch run() while processing" message may occur during save

New in version 91.2044 Beta (August 22nd, 2013)

  • Enhancement:
  • Chart - Should be possible to set the Y-axis value at any specified value and not only by the actual data
  • DB Support: Oracle - Add support for domain index type clause in DDL for Index
  • DB Support: SQL Server - Add sequence objects to the Databases tab tree
  • Data tab - Key binding for auto completion in the inline filter field should use the same key(s) as defined for SQL Commander->Show Auto Completion
  • Database Objects Tree - Database->Copy Database URL should only be enabled if the currently selected entries(s) are all database connection objects
  • References - Add support for EMF as an export format
  • Bug:
  • Auto Completion - Column names must never be qualified within a USING clause
  • Data tab - Auto completion in inline data filter may leave garbage text
  • Database Objects Tree - A NullPointerException may appear when opening a new database object
  • Import - Load custom import settings may result in an error if referenced CSV file doesn't exist
  • OS Support: Mac OS X - Launching a key binding where the ENTER key is one of the keys will run the target action twice if the key binding is also listed in the screen menu bar
  • Query Builder - When the Query Builder overwrites text in the SQL editor, the change cannot be undone
  • References - There is a regex error when finding table nodes in the references graph and the search string contain parenthesis
  • References - Table in References not highlighted when clicked in search result list and if already selected
  • References - Triple-click on a table in the references graph may result in an error
  • References - Zoom status bar information is not updated when zooming with mouse wheel
  • References - A NullPointerException is thrown if a JDBC driver returns null for the KEY_SEQ column in a ResultSet for exported/imported keys
  • SQL Editor - Highlight DATETIME as a keyword in the SQL Editor for SQL Server, Sybase ASE, Informix and MySQL
  • SQL Editor - Setting background color for SQL editors doesn't affect the DDL viewer or Procedure Editor
  • SQL History - Setting Max Entries to a negative number causes the GUI to freeze when executing a statement in the SQL Commander
  • Table Data Editor - "Cannot launch run() while processing" message may occur during save
  • Workspace - Key bindings to jump between tabs in the focused tab group doesn't work properly

New in version 91.2037 Beta (August 5th, 2013)

  • Enhancement:
  • DB Support: PostgreSQL - Must be possible to easily enable that Explain Plan should be run with/without with the Analyze option
  • DB Support: PostgreSQL - Add option to display native explain output for PostgreSQL
  • Performance/Stability - Handle ExecutorExceptions nested in RuntimeException the same as other ExecutorExceptions, e.g. show "connection closed" message instead of stack trace
  • SQL Editor - Add keyboard navigation for moving the caret to the next or previous error marking
  • Table Data Editor - Add connection property controlling encoding of text data when it is stored in a binary DB type
  • Bug:
  • Auto Completion - Cached table name alias may appear in auto completed column output even if no alias is currently specified
  • Chart - Chart settings revert to default if rerun a query in same SQL Commander
  • Database Objects Tree - Remove is-empty-output="continue" in database profiles to minimize follow-up errors when all databases/schemas has been filtered
  • Explain Plan - Looking at the Tree View for Explain don't show the buttons to change view
  • Installation/Update Installation - If canceling the auto-updater once then it is not possible to launch it again via check for update unless restarting DbVisualizer
  • OS Support: Mac OS X - The splash screen is not displayed on Mac OS X with Java 7
  • Table Data Editor - A value containing only characters matching the DbVisualizer variable delimiter cannot be saved

New in version 9.0.8 (July 17th, 2013)

  • Enhancement:
  • Auto Completion: Auto completion should support the USING keyword
  • General: Allow the dbviscmd.sh and dbvisgui.sh scripts to use a preset DBVIS_HOME value
  • Grid Component: Make it possible hiding a grid column by right-click its label
  • Performance/Stability: Add a Shutdown DbVisualizer button to Memory Monitor dialog
  • Bug:
  • Compare: Icons missing for the compare windows
  • Create/Alter Table: Alter Table window don't get focus when displayed or react to ESC button
  • DB Support: DB2 LUW: The TRUNCATE option is missing in the Empty Table action for DB2 LUW 10.x versions
  • DB Support: Informix: Significant whitespace may be missing in the code retrieved by the Trigger Editor
  • DB Support: PostgreSQL: Saving changes in the Data tab when the table has UUID columns results in an error
  • DB Support: PostgreSQL: Saving changes in the Data tab when the table has INTERVAL columns results in an error
  • Data tab: Loading and saving CLOB data from/to a file in the Cell Editor ignores the specified encoding
  • Database Profile: Actions: Default values are not handled by type="grid" actions (ex. Create Index for Tables)
  • Export: Exporting binary columns may fail when running @export in the SQL Commander if the table name is not qualified with the schema
  • General: User settings may not be stored properly
  • General: The following error may appear randomly "WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs ..."
  • General: Locale handling changed in Java 7 potentially showing data (numbers, date, time, etc.) in wrong format. Introduce backwards compatibility fix
  • Grid Component: Invoking some actions in a grid doesn't grab focus
  • Installation/Update Installation: Selecting an entry in the "Select Directory" dialog during install may scroll the list of directories
  • Query Builder: Loading a SELECT statement with .* or operations (e.g. col1 || col2) in the select list leads to an error
  • SQL Commander: An exception may appear when creating a new SQL commander tab or when merging result sets
  • SQL Commander: @run on an empty script file gives a "null" error
  • Tool Properties: Some of the predefined patterns for Date and Timestamp data formats incorrectly use "mm" for month instead of "MM"

New in version 9.1.2030 Beta (July 4th, 2013)

  • Enhancement:
  • Auto Completion - Auto completion should support the USING keyword
  • Database Objects Tree - Various problems may occur if schema/database name contain an embedded dot "."
  • Explain Plan - Explain plan don't show for any database but PostgreSQL in v91.2029
  • Export - An error may occur during export or import
  • General:
  • Locale handling changed in Java 7 potentially showing data (numbers, date, time, etc.) in wrong format. Introduce backwards compatibility fix
  • Grid Component - Allow setting max scale in the Aggregation Data for Selection window
  • Bug:
  • DB Support: DB2 LUW - The TRUNCATE option is missing in the Empty Table assistant for DB2 LUW 10.x versions
  • DB Support: Informix - Significant whitespace may be missing in the code retrieved by the Trigger Editor
  • DB Support: PostgreSQL - Saving changes in the Data tab when the table has UUID columns results in an error
  • DB Support: PostgreSQL - Saving changes in the Data tab when the table has INTERVAL columns results in an error
  • Data tab - Loading and saving CLOB data from/to a file in the Cell Editor ignores the specified encoding
  • Database Profile: Actions - Default values are not handled by type="grid" actions (ex. Create Index for Tables)
  • General - The following error may appear randomly "WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs ..."
  • General - User settings may disappear
  • SQL Commander - An exception "DockableFrame object-view doesn't exist" may appear when creating a new SQL commander tab

New in version 9.1.2029 Beta (June 25th, 2013)

  • Ehancement:
  • Check for Update - Improve the check for update feature
  • Connection Setup - Add an Auto Detect choice for Database Type
  • DB Support: HSQLDB - Disconnecting a HSQLDB embedded database keeps the database file locked until DbVisualizer is closed
  • DB Support: Informix - Highlight SQL errors in the editor
  • DB Support: JavaDB/Derby - Highlight SQL errors in the editor
  • DB Support: JavaDB/Derby - Disconnecting a JavaDB/Derby embedded database keeps the database file locked until DbVisualizer is closed
  • DB Support: Mimer SQL - Highlight SQL errors in the editor
  • DB Support: MySQL - Highlight SQL errors in the editor
  • DB Support: Oracle - Add tempfile actions for Remove, Offline and Online
  • DB Support: Oracle - Highlight SQL errors in the editor
  • DB Support: PostgreSQL - Highlight SQL errors in the editor
  • DB Support: PostgreSQL - Move the "Explain Analyze" setting from PostgreSQL connection properties to the explain plan toolbar for faster access
  • Database Profile - Add support for extending a database profile
  • Database Profile - Add support for custom icons for use in database profile (object type icons)
  • Database Profile: Actions - Introduce a element for actions in the database profile
  • Database Profile: Tree - Add icon (optional) attribute for DataNode's
  • General - Start evaluation of DbVisualizer Pro should be possible from within DbVisualizer Free without requiring to sign-up on web-site
  • General - Add "Contact Support" feature in DbVisualizer (under Help menu)
  • General - Automatically remove evaluation license when it expire
  • General - Upgrade bundled JDBC drivers for DB2 (4.15.82), JavaDB/Derby (10.10.1.1), H2 (1.3.172), jTDS (1.2.7), MySQL (5.1.25), PostgreSQL (9.2-1002.jdbc4), SQLite (3.7.2)
  • Installation/Update Installation - Should be possible to automatically upgrade to newer version without needing to manually visit web site
  • OS Support: Mac OS X - Add support for Java 7 on Mac OS X
  • SQL Commander - Opening a SQL file or load from Recent menu should set database connection, database and schema from most recently used object or SQL editor
  • SQL Editor - Clicking the encoding status bar item should allow changing encoding

New in version 9.0.7 (June 4th, 2013)

  • Enhancement:
  • DB Support: DB2 LUW - Include index partition info in the Indexes tab for DB2 LUW 9.7 or later
  • DB Support: Oracle - Add ELSIF as a keyword for highlighting in the editor
  • Database Objects Tree - Show any border icon for each database connection in the
  • Connections overview
  • Grid Component - Introduce "Hide Column" in the grid column header right-click menu
  • Java - Pre-support (unofficial) for Java 8 (preview versions) in DbVisualizer on Windows and Linux
  • SQL Commander - Add "Select in Databases Tab" action in the SQL Commander tab right-click menu (will locate the current database connection)
  • SQL Editor - The caret should not blink when typing or pressing control keys to move it
  • Bug:
  • DB Support: Oracle - The error position information in the Trigger Editor is off; it should be interpreted as relative to the start of the PL/SQL block
  • DB Support: Oracle - The Session->Plan Data is empty if the child number for the SQL Statement > 0
  • Data tab - Table filters (data tab) is not saved if database connection have the same name as one of the objects in the path for the table
  • Favorites - Right-click a favorite bar item now work with Java 7
  • Grid Component - Left-click a grid cell and then immediately right-click to show the menu will not only show the menu but also the cell viewer window
  • SQL Commander - An error may occur if trying to save an auto-saved file that originates from an existing file
  • SQL Commander - Comments with single quotes within an SQL Block may cause parsing errors when Strip Comments When Executing is disabled

New in version 9.0.6 (April 15th, 2013)

  • Enhancement:
  • Auto Completion: Auto Complete should not look for tables/columns when the caret is at word separated from the name by space
  • Auto Completion: Ignore underscore when looking for matching table and column names
  • Connection Setup: Add instructional message for how to resolve the "Malformed reply from SOCKS server" problem
  • DB Support: PostgreSQL: Add support for functions with RETURNS TABLE
  • DB Support: SQL Server: Include required DLLs in the path so that windows authentication works out of the box with the jTDS driver
  • Grid Component: Make it possible always showing the Cell Editor when double-clicking a cell for editing that contains special character
  • Import: Save the source file with the other settings at Save as Default
  • SQL Commander: The menu choice for "New SQL Commander" should also be available in the SQL Commander top-level menu and not only in the File menu
  • SQL Commander: The File->Open Recent menu should be extended to show saved SQL files in addition to loaded files
  • SQL Editor: Improve horizontal caret placement when moving then caret up or down
  • Scripts: F2 doesn't work to start editing selected name in Scripts and Favorites lists
  • Workspace: Add "Modify Default Tab Labelling" in the tab right-click menu for Object View, SQL Commander and Result Set tabs
  • Bug:
  • Compare: The cell background color for all cells disappear when a cell in a block of changed cells is selected
  • Connection Setup: Driver properties are not retrieved for some drivers
  • DB Support: MySQL: Scale and precision are not included in the DDL for a DECIMAL column if scale is 10 or precision is 0
  • DB Support: Oracle: Qualify Object with Schema/Database must be enabled to qualify a Function/Procedure with package name when executing from the Package Body Editor
  • DB Support: SQLite: Generating DDL gives a "column 23 out of bounds [1,22]" error
  • Data tab: Creating a new row count monitor in the Data tab may show an error if there are folders in the Scripts feature
  • Import: Settings->Load Default Settings on the first wizard page may result in an NullPointerException
  • SQL Commander: The result set may be read-only if the table name is not qualified by a schema and no schema is specified via the Schema list
  • SQL Editor: To Uppercase/Lowercase does not work with a rectangular selection when CRLF linefeeds are used

New in version 9.0.5 (March 5th, 2013)

  • Enhancement:
  • Compare - Allow column mapping between the two grids, so that tables with different column names can be compared
  • Compare - Make it possible to specify which columns are key columns and which columns to ignore
  • Data tab - Show full filter (WHERE and ORDER BY) in tooltip for filter under mouse
  • SQL Editor - Shift-Up and Shift-Down arrow keys should move caret and select to beginning/end when on first/last line
  • Scripts - Assign the F2 keybinding for editing selected name in Scripts and Favorites lists
  • Bug:
  • DB Support: DB2 z/OS - Changing auto commit or requesting commit or rollback in the SQL Commander may result in DB2 threads being occupied in DB2 server on z/OS
  • DB Support: Sybase ASE - Showing object details for a Sybase Function results in an error
  • Database Profile: Actions - The "Preparing xxx" dialog is displayed indefinitely and the action window is never displayed with Java 7 on Linux
  • General - Creating a new folder in the file chooser using Synthetica L&F will not highlight or enable the newly created folder name in edit mode
  • SQL Commander - Using file chooser to drill-down into a directory using keyboard is not possible (double-click is required)
  • SQL Commander - The result set for a SELECT FOR UPDATE statement may be read-only in some cases
  • SQL Formatter - The "lower" keyword is not formatted to uppercase when requested

New in version 9.0.4 (February 19th, 2013)

  • ENHANCEMENTS:
  • Compare: Allow comparison of similar data types, e.g. Integer and BigDecimal
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4336 ]
  • Compare: Center the current difference vertically when navigating between them
  • Create/Alter Table: Create/Alter Table window need to be larger and optimize column sizes
  • DB Support: MySQL: Order procedures and triggers by name in the objects tree
  • DB Support: SQL Server: Remove dependency on SQL Server 2000 compatibility views in the DDL generator and the profile queries
  • Database Objects Tree: Support re-arranging multiple database connections and folders using drag and drop
  • Database Profile: Actions: The Create Trigger action should support setting multiple trigger events (INSERT, UPDATE, DELETE)
  • Favorites: Favorites editor and the favorites bar should support adding multiple objects at once
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4350 ]
  • Favorites: Support re-arranging multiple favorites and folders using drag and drop
  • Grid Component: Add an entry for the Column Chooser in the grid header right-click menu (is currently only available as a button above the vertical scrollbar)
  • Grid Component: Add "Inverse Selection" action in grid right-click menu
  • [http://www.dbvis.com/forum/thread.jspa?messageID=15826 ]
  • Performance/Stability: Improve performance for getting column information in most cases, e.g. when deciding if a result set should be editable
  • Query Builder: Should be possible to remove all joins for a specific table (i.e. right-click in table node and select "Remove All Joins")
  • SQL Commander: Add a "Load SQL in New Editor" to result set tab right-click menu and log icon
  • [http://www.dbvis.com/forum/post!reply.jspa?messageID=15852 ]
  • SQL Editor: Do not move the caret and scroll positions when doing Replace All
  • SQL Editor: Up and Down arrow keys should move caret to beginning/end when on first/last line
  • SQL History: Opening a history entry from the SQL History editor should make the main window active
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4273 ]
  • BUGS:
  • Compare: Flip may cause an error (NullPointerException)
  • DB Support: PostgreSQL: Data types with "WITH/WITHOUT TIME ZONE" and declared precision are not handled correctly in Create/Alter Table
  • Favorites: The "Add to Favorites" window should only display folder objects in the Favorites list
  • Grid Component: The coloring of XML data in the XML Viewer makes it difficult to read when rows are selected
  • Monitor: Changing series while auto reloader is running may clear all active series
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4349 ]
  • SQL Commander: Passing both -connection and -sqlfile arguments doesn't set the connection in the SQL Commander loaded with the file
  • [http://www.dbvis.com/forum/thread.jspa?messageID=15854 ]
  • SQL Commander: Recognize WITH as a SELECT in the execution permission control

New in version 9.0.3 (January 28th, 2013)

  • Enhancement:
  • Connection Setup - Allow (null) to be specified as the value for Database Userid and Password
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4300 ]
  • DB Support: Oracle - Add enhancements for the Oracle Scheduler and Resource Manager
  • DB Support: Oracle - Add Session Wait and Session Event view for DBA Views->Sessions->Session
  • DB Support: Oracle - Add views for Oracle Direct NFS (dNFS) in DBA Views->Storage
  • DB Support: PostgreSQL - Add support for refcursor OUT parameters and return values
  • Database Objects Tree - Should be possible to configure in Tool Properties which of Open In Tab, Open in New Tab or Open in Floating Tab should run when double-click a database object
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4190 ]
  • Database Profile: View - Would be great if the tables list (and other lists) have the "Open in New Tab" and "Open in Floating Tab" right-click commands
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4061 ]
  • Performance/Stability - Add a "Don't show this again" checkbox to the "still not enough memory" dialog for the Memory Monitor window
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4216 ]
  • SQL Commander - File->Save (Ctrl+S) should be active even if no file is loaded and in that case show the "Save As" window
  • SQL Commander - Should be possible to configure if the database object scripting feature should be launched or simply insert object name when dropping object in SQL editor
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4251 ]
  • Workspace - Remove "Do you want to close the tab or restore it in the main window" question when closing floating window
  • Bug:
  • DB Support: DB2 LUW - The Data Type list for Create Table includes BOOLEAN and other types that cannot be used as a column data type
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4237 ]
  • DB Support: SQL Server - An exception may appear when displaying column information for a table
  • Database Profile: Actions - Related list field(s) are not updated when changing the list selection of another field. Example: Oracle->Statistics->AWR->Run Report
  • Database Profile: Actions - Statements executed via Actions are not committed if auto-commit is not enabled for the connection
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4325 ]
  • Import - Schema is missing in INSERT statements for some databases (e.g. SQL Server) when importing to new table
  • Key Bindings - Cmd-W doesn't close SQL History, Monitor and Driver Manager windows when using Mac OS X key map - [http://www.dbvis.com/forum/thread.jspa?threadID=4273 ]
  • SQL Commander - The "Confirm Close of Unsaved Editors" tool property have no effect in some situations
  • [http://www.dbvis.com/forum/thread.jspa?messageID=15724 ]
  • Workspace - UI may flicker and focus may move to another component while DbVisualizer is auto saving editors and layout
  • [http://www.dbvis.com/forum/thread.jspa?messageID=15684 ]
  • Workspace - Using key binding to close floating tab, doesn't close the window but rather the active tab in the main window

New in version 9.0.2 (December 18th, 2012)

  • Bug:
  • Connection Setup: A NullPointerException is reported when connecting with my custom driver definition
  • Installation: Add a Windows 64-bit zip installer

New in version 9.0.1 (December 18th, 2012)

  • Enhancement:
  • DB Support: Mimer SQL: Optimize SQL for getting metadata in v10 and later
  • Performance/Stability: Closing tabs and stopping jobs in the Memory Monitor window does not always release memory
  • Query Builder: Columns should be sorted in the table windows
  • SQL Commander: Show warnings, if any, even when an exception is thrown
  • Tool Properties: Make it configurable to set that active tabs are rendered with a bold title font
  • Workspace: Add a "Open in Floating Tab" action for database objects
  • Workspace: Floating windows should be possible to maximize, minimize and not always be in front of main window
  • Bug:
  • Connection Setup: Pressing the explain properties button in the explain plan feature sometimes render the Explain Plan properties pane (in Connection Properties) twice (on top of each other)
  • Connection Setup: The Connection Properties pane is not updated if changing for example Database Type or Driver in the Connections tab
  • Connection Setup: Error message is incomplete if connect fail due to unexpected problem in the JDBC driver
  • Connection Setup: Driver Properties is empty unless setting the Database URL in the Settings Format->Database URL
  • Create/Alter Table: The Referenced Column cannot be selected
  • Create/Alter Table: The Referenced Catalog and Schema defaults in the Create Table Foreign Key tab do not match the current Tables node
  • DB Support: Oracle: Role names with special characters need to be quoted in the Clone User action
  • Database Objects Tree: Not possible to dock floating Databases, Scripts or Favorites windows using standard close window button
  • Database Objects Tree: Disabling object tree filtering does not remove the Filtered label for entries
  • Database Objects Tree: Object tree filtering don't work properly with Sybase ASE, DB2 z/OS and DB2 LUW
  • Database Objects Tree: Press Enter key while there is no selection in the Databases list generates an error
  • Database Objects Tree: (Default) and Filtered labels in the databases objects tree are not colored properly if appearing for the same entry
  • Favorites: Hide/display of the favorite and main tool bars have no effect on new windows created with File->New Window
  • General: Problem starting DbVisualizer if using the Turkish locale
  • OS Support: Windows: Open a .sql file on Windows starts DbVisualizer but doesn't load file
  • SQL Commander: Execute Current with the caret on a line with a comment executes the wrong statement
  • SQL Commander: Partial result sets are not shown when the query is stopped
  • SQL Editor: Replace with parenthesis in "what" does not work
  • SQL Formatter: DbVisualizer variables should be kept as-is instead of expanded to their full format
  • Scripts: Saving bookmark script may not save database connection, schema and catalog
  • Table Data Editor: Saving table data changes always save to default database in Informix

New in version 9.0 (November 30th, 2012)

  • Enhancement
  • Chart - The point value popup (displayed when hovering a chart point) should appear even when not exactly over the point and remain active if moving cursor to another point
  • Connection Setup - Add support for custom component borders
  • Connection Setup - Remove the "Single Physical Connection" feature and tool property
  • Connection Setup - Give focus to the Database Userid field when entering the Database Setup page in the wizard
  • Create/Alter Table - Make the Create/Alter Table dialog non-modal
  • DB Support: Informix - The database qualifier should be recognized in various features, e.g. for auto-completion when looking for matching tables and columns
  • DB Support: Oracle - Choosing Connection Type = TNS for Oracle should show an instruction how TNS names are loaded if the list of names is empty
  • DB Support: Oracle - Bundle the Oracle JDBC driver with DbVisualizer
  • DB Support: PostgreSQL - Add visual Explain Plan support for PostgreSQL version 9 and later
  • Data tab - Auto completed column names in the table data filter should respect the "Case for Completed Names" and "Delimited Identifiers" in Tool Properties
  • Database Objects Tree - Need to visually show that child nodes has been filtered in the objects tree
  • Database Objects Tree - While browsing database objects and the connection is lost with the database, preserve the currently visible tab at re-connect
  • Database Objects Tree - Don't use the SHIFT modifier in the objects tree
  • Database Objects Tree - Add feature for multi deletion of Database Connections
  • Database Objects Tree - Add a way to insert "Script Object to Editor" results at the caret position in the current editor
  • Database Objects Tree - Double-click an object in the Databases tab should open the object and not expand any child objects
  • Database Objects Tree - Allow for multiple "object view" tabs opened at the same time
  • Database Objects Tree - Allow rename of object view tabs
  • Database Profile: Actions - Support multiple action windows without locking the rest of the user interface (Ex: Create Table, Rename Table, Create Trigger, etc).
  • Database Profile: Actions - Copy in SQL Preview in Object Action window and Variable substitution window should copy selected text and not all of the text
  • Database Profile: View - Add support to load a database object in a specific object view tab using drag from databases tab to the target object view tab
  • Database Profile: View - Add support to save and reset the layout of sub tabs for object view top-level tabs (bound to database type and object type)
  • Export - Add support for export in "json" format
  • Favorites - Support drag and drop of the favorites toolbar so that it can be positioned after the main toolbar buttons
  • Favorites - Add "Select Target Object" in Favorites tab list right-click menu and in the favorites bar right-click menu for a favorite
  • Favorites - Show path of target object as tooltip
  • Favorites - Add sort capability in the Favorites tab (right-click menu)
  • General - Improve the database access strategy, e.g. to minimize or remove the need to ever lock the GUI, prevent freezes when a connection is down, etc.
  • General - Replace the multi row tab component with a single row tab solution (for object view, SQL commander, result set and monitor tabs)
  • General - Change name of "DbVisualizer Personal" to "DbVisualizer Pro"
  • General - Improve the management of the commit/rollback prompt window at disconnect
  • Grid Component - Add support for comparing result sets
  • Grid Component - The grid column auto resizer may truncate data
  • Import - Add a way to Save and Restore the import settings
  • Import - Add control for disabling the use of delimited identifiers when importing to a new table
  • Import - Make the Import Table Data dialog non-modal
  • Import - The file filter in the import file chooser should default to .csv file extension
  • S Support: Mac OS X - Add full screen support for Lion/Mountain Lion
  • Performance/Stability - Get Table Row Count data in a background thread
  • Performance/Stability - Better handling of high memory usage
  • Procedure Editor - Add keyboard shortcut for hide/show errors
  • Procedure Editor - Execute a procedure/function within the context of the Procedure Editor instead of the current SQL Commander
  • References - Add support to script CREATE, DROP, DELETE and INSERT statements for tables in the References graph
  • References - Keep "Specified Tables" enabled after reload in the References graph
  • SQL Commander - Make it possible to disable preprocessing for scripts of any size
  • SQL Commander - Make it possible to detach any result set in SQL Commander and Monitor in own window
  • SQL Commander - Add support for compare of SQL Commander editors and editor with file
  • SQL Commander - Auto-save SQL Commander editor buffer between sessions
  • SQL Commander - Add a "Connect and Execute" button to the establish connection dialog
  • SQL Commander - The database connection lists should support showing any color and/or border defined for the database connection
  • SQL Commander - SQL Commander - unify the transaction management for non result set commands in the SQL editor and edits made in result sets for the same editor
  • SQL Commander - Add support for loading multiple SQL files
  • SQL Commander - Move the SQL Commander properties (right pane when visible) into Tool Properties
  • SQL Commander - Support merging multiple result sets in a single text view
  • SQL Commander - Add a "Save no SQL Commander editors" option when closing editors and quitting DbVisualizer
  • SQL Commander - Opening a file that is already open in a SQL Commander should switch to that tab rather than opening a new
  • SQL Commander - The vertical splitter in a newly created SQL Commander should have the same position as the previously active SQL Commander
  • SQL Commander - Database Connection setting in a new SQL Commander tab should be set based on if the focus is in the databases tab, if not then the same settings as previously used editor should be applied
  • QL Commander - Make stripping of comments configurable
  • QL Editor - Support regular expressions in the SQL editor
  • SQL History - Don't put focus in the Max Entries input field at first display
  • Scripts - Sort scripts by organizing directories first and then regular files
  • Workspace - Add support to show any tab in a separate window (float)
  • Workspace - Drag a tab outside the window boundaries should float the tab in a separate window (same as Floating)
  • Workspace - Add support for setting tab background color based on database connection
  • Workspace - Add support for re-arranging tabs
  • Workspace - A list of all unsaved editors at exit should show those that are unsaved and allow all/some to be saved at once instead of a query per editor.
  • Workspace - Should be possible to set a custom label for the result set tabs
  • Workspace - Verify main and sub tab locations
  • Workspace - Should be possible to label SQL editor tabs regardless of any file being loaded
  • Workspace - Double-click on Databases, Scripts and Favorites tabs should minimize these
  • Workspace - Make it configurable whether the (gray) object view header should be visible in object view tabs
  • Workspace - Remove the Alloy look and feel
  • Workspace - Add support for preserving open SQL Commander (with content) and Object View tabs between DbVisualizer sessions
  • Workspace - Introduce a close button in SQL Commander, Object View, Result Set and Monitor tabs
  • Workspace - Allow using middle mouse button (alt+click) to close a tab
  • Workspace - Maximize tab by double click tab header
  • Bug:
  • DB Support: SQL Server - Source for a procedure is not available after rename with other tools
  • Database Objects Tree - Add search by typing in the databases objects list and support for down/up keyboard buttons to move forward/backward
  • Explain Plan - Fix explain plan for DB2 LUW version 10
  • Explain Plan - Any variable values in the SQL are not passed with the SQL when Explain Plan
  • Favorites - Renaming the database connection or changing its folder structure or folder names will break a database object favorite
  • General - Commit/Rollback dialog freezes application upon network disruption
  • Grid Component - The Grid Warnings popup should be closed on window move
  • Grid Component - Focus is lost from result set when using for example Ctrl+R (reload)
  • Query Builder - Extremely slow to add or remove columns in complex/large query
  • SQL Commander - Warning when using Execute Current with a line comment on the first line and caret on first line
  • Scripts - Should be possible to assign key bindings to the Open and Execute right click commands in the scripts tree
  • Table Data Editor - An error is displayed if applying table data filter while grid is being reloaded

New in version 8.0.12 (November 28th, 2012)

  • Enhancement:
  • DB Support: DB2 LUW - Show Grants for Views
  • DB Support: Informix - Add support for Informix 11 data types BIGINTEGER and BIGSERIAL in Create/Alter Table and DDL
  • Bug:
  • Auto Completion - Typing a character hides the list rather than narrowing the list
  • Auto Completion - Triggering auto-completion within a string literal like '..A' may cause a NullPointerException
  • DB Support: DB2 LUW - Error showing DDL for tables in DB2 LUW version 10
  • DB Support: Oracle - Random exception may occur while browsing certain database synonyms
  • DB Support: PostgreSQL - Columns of type MONEY can not be shown or edited in a grid
  • DB Support: SQL Server - Large triggers are listed multiple times under the table node and in the table -> Triggers view
  • DB Support: SQL Server - Invoking a function returning a table with the @call command results in a syntax error
  • Export - Exception when exporting result set after database connection has been disconnected
  • General - The settings file (dbvis.xml) can sometimes be damaged when exiting DbVisualizer
  • SQL Editor - Column auto-completion after a single period causes a StringIndexOutOfBoundsException
  • SQL Formatter - DbVisualizer Variables should be left as-is by the formatter
  • Table Data Editor - Table data editing fail if schema, catalog, table or column name contain $$

New in version 9.0 Beta 90.1866 (November 22nd, 2012)

  • Bug:
  • Connection Setup - Physical database connection(s) may not be released when disconnect
  • Database Profile - The list of database profiles is empty on Windows
  • Workspace - An error may appear at startup-up if preserved object view files are broken
  • Enhancement:
  • Database Objects Tree - Change "Open in Tab" (double-click) for database objects to show the object in first free tab if there is one
  • Workspace - Close Closeable Tabs and Close Other Tabs should not close any pinned tabs
  • Workspace - Change "Show in Window" in References Graph, Database Search and Show Object at Cursor to "Open in New Tab"

New in version 9.0 Beta 90.1863 (November 17th, 2012)

  • Enhancement:
  • Database Objects Tree - Drag&drop a database object to a tab of an existing object view tab should update the visited state of the object being dragged
  • Scripts - Sort scripts by organizing directories first and then regular files
  • Bug:
  • SQL Editor - Unindent (Shift Tab) does not unindent the last line in an editor

New in version 9.0 Beta 90.1861 (November 15th, 2012)

  • Database Profile: View - Add support to load a database object in a specific object view tab using drag from databases tab to the target object view tab
  • Workspace - Drag a tab outside the window boundaries should float the tab in a separate window (same as Floating)
  • Bug:
  • DB Support: SQL Server - Source for a procedure is not available after rename with other tools
  • Driver Manager - An error may occur when stopping the driver manager
  • Workspace - The vertical divider position between the navigation tabs (databases, scripts, favorites) is not preserved when de-maximize a workspace tab

New in version 8.0.11 (September 27th, 2012)

  • Improvement:
  • DB Support - DB2 LUW: Add support for index DDL with INCLUDE columns and ALLOW REVERSE SCANS
  • DDL Generator: Include precision and scale for NUMERIC types for Generic databases
  • Explain Plan: Should be possible to specify a target schema for the explain plan tables in DB2 LUW
  • OS Support - Mac OS X: Add support for high resolution Retina displays
  • Bug:
  • DB Support - DB2 LUW: Multiple columns in the "Columns" tab for a DB2 table are labelled "NAME" instead of "TABLE_NAME" and "COLUMN_NAME"
  • DB Support - DB2 LUW: DB2 LUW 9.7.6 with the 4.13 and 4.14 versions of the IBM JDBC driver gives erroneous top level objects in the Databases list which results in empty object details for other object types
  • Export: @set maxrows have no effect when used in a @export on command
  • General: A broken Java installation may result in an error while loading DbVisualizer (in sun.util.calendar.ZoneInfoFile.getZoneIDs)
  • OS Support - Mac OS X: If DbVisualizer closed while the main window is maximized, it is impossible in following sessions to have DbVisualizer start-up in non maximized mode
  • References: Exception may occur while the references graph is rendered with Java 7
  • SQL Commander: The JDBC Connection#prepareStatement() is called with CRLF linefeeds when parsing for parameter markers
  • SQL Editor: Incorrect caret position after selecting by double-clicking on second to last line

New in version 8.0.10 (July 11th, 2012)

  • Improvement:
  • DB Support: PostgreSQL - Sequences should be sorted by name
  • [http://www.dbvis.com/forum/thread.jspa?messageID=14228 ]
  • General - Updated bundled JDBC drivers to latest versions for DB2, PostgreSQL, SQLite, H2, MySQL and JavaDB/Derby
  • OS Support: Mac OS X - Digitally sign DbVisualizer with Apple for the new Gatekeeper feature introduced in Mac OS X Mountain Lion
  • OS Support: Mac OS X - Add support for Java 7 on Mac OS X
  • OS Support: Windows - Digitally sign DbVisualizer on Windows to guarantee that the software is produced by DbVis Software AB and to prevent unnecessary warnings at installation
  • Bug:
  • Auto Completion - Column completion does not work if a quoted table name is used as a qualifier
  • [http://www.dbvis.com/forum/thread.jspa?messageID=14248 ]
  • DB Support: DB2 LUW - If Explain Plan tables already exist and there is a case mismatch between login user name and the explain plan tables schema an error is reported
  • DB Support: DB2 LUW - The size for columns of type GRAPHIC and DBCLOB is not included in the DDL
  • DB Support: DB2 z/OS - Displaying the source for VIEWS don't work with DB2 z/OS v10
  • DB Support: Oracle - The DDL for VARCHAR2 columns lack the size information
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3946 ]
  • DB Support: PostgreSQL - Default schema is not determined correctly if search_path contain "$user"
  • DDL Generator - Invalid syntax for column default values containing function calls, e.g. to_char(sysdate, 'HH24:MI:SS')
  • Export - NPE when including indexes in Table Export with Generic Database Type
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3954 ]
  • Grid Component - The Aggregation Data for Selection is not updated when extending selection with cells on the same row
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3889 ]
  • Grid Component - If moving a grid column and then show column header tooltip, information about another column is displayed
  • Key Bindings - Cut, copy and paste key bindings in text fields on Mac OS X should follow the currently used key map rather than always require the CMD key
  • Navigator - Deleting a table in the navigator pane may result in an exception
  • Query Builder - IN and NOT IN operators with a single value cause an exception
  • Scripts - The height of the lower details pane in the Script tab is reset between DbVisualizer sessions
  • SQL Commander - Using the ~ operator in a SELECT statement results in a read-only result set
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3873 ]
  • SQL Editor - An exception is logged when typing some chinese characters
  • SQL Editor - The syntax coloring is not properly updated after Comment Block and requires a scroll to fix
  • [http://www.dbvis.com/forum/thread.jspa?messageID=14114 ]

New in version 8.0.9 (May 1st, 2012)

  • New Feature:
  • General: Add dbvisgui -windowtitle parameter for customization of the DbVisualizer window title
  • Improvement:
  • Chart: Make it possible saving default chart settings between sessions
  • General: Increase default max Java memory for DbVisualizer from 256MB to 512MB
  • Bug:
  • Database Objects Tree: Show Table Row Count does not work for tables with mixed case names or names containing reserved characters
  • DB Support: DB2 LUW: Source for Procedures, Functions etc. not available when created with CREATE AND REPLACE
  • DB Support: SQLite: Need to always treat non-decimal numbers as BIGINT and decimal numbers as DOUBLE to handle large values
  • DB Support: SQLite: Export Schema is not available for SQLite
  • DB Support: SQLite: Tables are not listed in alphabetic order under the Tables node
  • Export: Empty CLOB/BLOB values are represented as NULL when exporting as Value
  • General: Using a single right parenthesis as the variable prefix leads to invalid generated SQL
  • Import: When importing very large files (more than 2,147,483,647 bytes), the progress indication is incorrect
  • Navigator: No warning about pending edits when reloading the graph or deleting a selected node
  • Navigator: Reloading the graph eats memory
  • Procedure Editor: Ctrl+Enter in the procedure editor results in exception
  • SQL Commander: Load and execute of a bookmark or monitor script don't load its visual layout between sessions
  • SQL Commander: Stopping a query in the SQL Commander for Sybase IQ erroneously clears any partially retrieved result set
  • SQL Commander: NullPointerException when using Execute Current with the caret in a comment on the first line

New in version 8.0.8 (February 14th, 2012)

  • Improvement:
  • Database Profile: Commands - Add new continueonerror="true" attribute for the element
  • DB Support: DB2 LUW - Missing "Schema Index" field in the Create Index action
  • DB Support: MySQL - Include DEFINER attribute in CREATE PROCEDURE/FUNCTION/TRIGGER statement for Procedure Editor
  • DB Support: PostgreSQL - Add Cascade option for the Drop Schema action
  • SQL Editor - Use keybindings for Find Next/Previous also for Quick Find
  • SQL Editor - Make the line highlight color configurable
  • Bug:
  • Chart - An error occur when displaying a chart when all values in a serie is 0
  • Connection Setup - Right-click on category labels in the Connection tab gives ClassCastException
  • Database Objects Tree - Java 1.7: Reconnecting database connections may show an error
  • DB Support: PostgreSQL - Support for the UUID data type is missing in the Create Table action
  • DB Support: Sybase ASE - Show Default Database/Schema doesn't work with Sybase
  • DB Support: Sybase ASE - Auto completion doesn't work for Sybase
  • Driver Manager - Cannot load directory of driver classes in the Driver Manager
  • Import - Colors indicating skipped rows in the import preview are not visible
  • SQL Commander - Clicking in the Log to select the corresponding statement in the editor selects the wrong statement when it has been executed with Execute Current or Execute Selected
  • SQL Commander - Pinned result set produced by procedures are not properly cleared at next execute or remove
  • SQL Editor - An empty debug window is displayed (if auto popup is enabled) when pasting text copied from IntelliJ IDEA
  • SQL Editor - Horizontal scrollbar disappears when moving the caret to the beginning of a single long line
  • SQL Editor - Caret position is moved horizontally after a find and then press down keyboard button
  • SQL Editor - Drag-n-drop database objects from another instance of DbVisualizer into the SQL editor results in an error

New in version 8.0.7 (December 23rd, 2011)

  • Improvement:
  • DB Support: DB2 iSeries - Support multiple result sets generated by stored procedure for DB2 iSeries
  • SQL Commander - Should be possible to force presentation of the real column name even if column alias is used in queries
  • SQL Editor - Make it possible to have Find scroll match to center of editor rather than just enough to show the match
  • SQL Editor - Make it possible to turn off the caret blinking
  • Bug:
  • DB Support: Informix - Default value is missing in the DDL for NOT NULL character type columns
  • DB Support: SQL Server - An NVARCHAR(MAX) column is generated as NVARCHAR(0) in DDL
  • DB Support: SQL Server - No code is shown for procedures, functions and triggers if the database name contains a space or other special character
  • DB Support: SQLite - Column nullability and default value should be disabled in Alter Table
  • DDL Generator - The primary key column order may be incorrect when using the Generic, H2, SQLite, Oracle or Mimer database types
  • Export - Excel OOXML export may output special characters in wrong encoding
  • Navigator
  • Related Table is not enabled when using Show in Navigator in the Data tab even when cells are selected
  • OS Support: Mac OS X - Add workaround for the memory leak introduced in Java 1.6.0_29 on Mac OS X
  • SQL Commander - Opening a non-existing file with File->Open Recent show truncated error and the file is then kept in the recent files list
  • SQL Editor - Find All does not scroll to make the first match visible
  • SQL Editor - Find Next does not use criteria set up by Find All
  • SQL Editor - When pasting really fast after typing, Undo undoes both the typing and the pasting
  • SQL Editor - Find does not reset highlighted matches made by Find All
  • SQL Editor - Problem with special characters in the search string for Quick File Load
  • Table Data Editor
  • Mime type for ZIP archives is wrong
  • Table Data Editor - Unrecognized binary data is marked as modified just by opening it in the cell editing window
  • Table Data Editor - Using column alias in selects may disable data editing for some databases

New in version 8.0.6 (November 22nd, 2011)

  • Improvement:
  • DB Support: H2 Add support for linked tables in H2
  • DB Support: SQL Server Add enable/disable actions for triggers
  • DB Support: SQL Server Disabled triggers for SQL Server should be indicated with different icon in objects list
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3715 ]
  • SQL Commander Column aliases in SELECT column list for MySQL 5.1+ don't appear in result grid
  • SQL Editor Text on the system clipboard is not included in the Paste Dialog
  • [http://www.dbvis.com/forum/thread.jspa?messageID=13155 ]
  • Bug:
  • DB Support: SQL Server Exception when switching to "Columns" tab with the SQL Server JDBC driver
  • SQL Commander Filtering log entries with "Show SQL" enabled will always display the SQL even if the entry doesn't match the enabled result categories (success/warning/error)
  • SQL Commander Very slow to convert a large result set to text
  • SQL Editor Unindent (Delete Tab) doesn't work for an unselected line with the caret at the beginning of the line
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3648 ]
  • SQL Editor Comments are not highlighted if starting immediately after a statement delimiter

New in version 8.0.5 (November 4th, 2011)

  • Improvement:
  • Scripts - Add "Open Enclosing Directory" command for script, history and favorite files
  • SQL Commander - Redefine "Execute Current" to mean "Execute statement containing the caret or ending on line with caret" - [http://www.dbvis.com/forum/thread.jspa?threadID=3554 ]
  • SQL History - Show file encoding in the SQL History feature
  • Bug:
  • Auto Completion - Auto-completed names may contain whitespace
  • Command Line Support (dbviscmd) - Variables used in the export file name retain the delimiters after substitution when executed via the command line interface
  • Connection Setup - Changing some options, e.g. Authentication Method, does not add/remove related fields immediately
  • DB Support: HP Neoview - If data format for numbers or decimal numbers in Tool Properties include thousand separator it may result in errors while walking the objects tree
  • DB Support: MySQL - The SQL used internally to get a list if users does not work when sql_mode is set to ANSI_QUOTES
  • DB Support: PostgreSQL - Exception when expanding Triggers node or opening Trigger Editor with PostgreSQL 9.1
  • Export - Export to XLSX doesn't drop column headings when column data is dropped - [http://www.dbvis.com/forum/thread.jspa?threadID=3666 ]
  • Grid Component - Quick filter doesn't work in the Variable Replacor window
  • Import - Import doesn't properly handle embedded escaped quotes in quoted data i.e. 'smith''s'
  • Navigator - Switching tabs with pending grid edits cause a NullPointerException
  • SQL Commander - History file entries created by the SQL Commander are not using the encoding as specified in Tool Properties->Encoding
  • SQL Commander - Clicking on the Locate Error Statement icon in the log when the script has been executed with Execute Buffer results in an exception
  • SQL Commander - Disabling "Process Variables in SQL" or "Process Parameter Markers in SQL" have not effect and variables and markers are always processed
  • SQL Editor - Caret position is misleading for CRLF line break, counted as two positions

New in version 8.0.4 (September 17th, 2011)

  • Improvement:
  • Grid Component - Allow adding/removing non-adjacent rows in selection by ctrl+click in the grid row header
  • SQL Commander - Show any chained errors when executing in the SQL Commander
  • Bug:
  • Data tab - Memory leak while reload in a SQL Commander result set or in the table Data tab - DB Support: Mimer SQL - User Defined types are not expressed properly in the CREATE TABLE DDL
  • Grid Component - Exception is raised if opening the cell editor with a (null) value
  • Query Builder - Expressions containing operations (e.g. "a - b + c") are corrupted when loaded into the Query Builder
  • SQL Commander - Showing result sets in the SQL Commander will generate an OutOfMemoryError with Alloy L&F and having the "Automatically Show Grid Warnings" enabled
  • SQL Editor - Delete to Word Start/End only works once if the caret is in the middle of a word
  • SQL Editor - The Insertion Point to End of Line shortcut moves the caret to a position one column beyond the end of line for scripts with CRLF (Windows) line terminators

New in version 8.0.3 (August 30th, 2011)

  • Improvement:
  • DB Support: Mimer SQL: Show error position in the SQL log when running a statement in SQL Commander
  • Explain Plan: The node tooltip should be disabled while in the magnifying mode
  • Grid Component: Allow using the SPACE key to select entries in editable cell lists
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3504 ]
  • Grid Component: Enable the hex viewer for any data type and not only binary/BLOB
  • Grid Component: The read-only only cell viewer window should include the button to convert XML (and any other formatted views) to plain text
  • Key Bindings: Command-W should close tab/internal windows rather than Commands-F4 when using OS X key map
  • Table Data Editor: Column names specified in different case may result in table data editing being disabled
  • Bug:
  • Auto Completion: If a TAB precedes the completion list, the selection replaces all content on the line
  • Database Profile: Actions: Actions with password data appear in clear text in the preview area [http://www.dbvis.com/forum/thread.jspa?threadID=3631 ]
  • DB Support: DB2 LUW: Explain plan don't work properly if setting the currentSchema driver property
  • DB Support: DB2 LUW: VARGRAPHIC size is not included in DDL[http://www.dbvis.com/forum/thread.jspa?threadID=3611 ]
  • Grid Component: Java VM error may occur when using copy in grid or export [http://www.dbvis.com/forum/thread.jspa?threadID=3618 ]
  • Grid Component: Scrollbars are not reset when loading a smaller CLOB in the Data Cell Editor
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3612 ]
  • Navigator: Selecting a Related Table with the mouse picks the currently selected entry and not the entry under the mouse [http://www.dbvis.com/forum/thread.jspa?messageID=12986 ]
  • SQL Commander: When passing a variable to the @run command, a "file does not exist" message is erroneously logged
  • SQL Editor: Expand All does not adjust the horizontal scroll bar size appropriately
  • SQL Editor: With Expand Tab to Whitespace enabled, the TAB key always inserts a fixed number of spaces instead of aligning at tab positions
  • SQL Editor: The Comment Line/Block features comment only the visible region in the editor
  • SQL Editor: The Comment Line feature comments the row where the caret is even if that row is not part of the selection
  • SQL Editor: Caret is invisible or is not blinking while executing a script [http://www.dbvis.com/forum/thread.jspa?threadID=3499 ]
  • SQL Editor: The radio button in the Target section in the Find/Replace dialog can not be set by clicking on the labels
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3573 ]
  • SQL History: Details pane may not show in the Scripts and History features
  • Workspace: Double-click a .sql file in the finder, DbVisualizer starts but the file is not loaded. (Works fine on Windows)

New in version 8.0.2 (August 8th, 2011)

  • Improvement:
  • Navigator - Handle large list of Related Tables in a better way, e.g. make the list scrollable
  • SQL Editor - Restore the 7.1 behavior for Insertion Point to End of Line
  • SQL Editor - Add option to show non-printable characters (tab, whitespace, etc) in the editor
  • Table Data Editor - Table data editor need to save edits in the following order: 1) deletes, 2) updates, 3) inserts to prevent triggering constraint rules
  • Bug:
  • Chart - Range of Y-axis is erroneous if the max value in a serie is negative
  • Database Objects Tree - The objects tree right click menu may render some actions as disabled
  • DB Support: PostgreSQL - Select composite type column gives exception
  • DB Support: PostgreSQL - Exception or incomplete info when getting column info for DDL
  • DB Support: SQL Server - The default schema cannot be determined for some database configurations
  • References - Not possible to open references graph GML files in yED
  • References - A NullPointerException occur when exporting references graph in SVG or PDF formats
  • SQL Editor - Selection not cleared by Move Caret o Next/Previous Word
  • SQL Editor - Triple-clicking a line to select it and then extending the selection by dragging the mouse down deselects the first line
  • SQL Editor - Delete Line clears all text but does not remove the line break
  • SQL Editor - The action for moving/selecting to the previous word places the caret at the end of the target word instead of at the beginning
  • SQL Editor - The statement parsing is off if a file containing CR linefeeds is loaded in to the editor
  • SQL Editor - "Invalid location" warning when deleting all text as the first edit action
  • SQL Editor - The caret placement may be off when the font specified in the settings file does not exist on the current platform
  • SQL Editor - Copy of multiple lines and pasting them over the selection may lose indentation
  • SQL Editor - Horizontal scroll with wheel/trackpad scrolls vertically
  • SQL Editor - Extending the selection by dragging the mouse up in the row number area stops suddenly
  • SQL Editor - The action for moving/selecting to the previous word places the caret one character to the left of the target when caret is at the beginning of a line
  • Table Data Editor - After saving in data editor, edited cells may still show old value
  • Table Data Editor - While saving in the data editor, edited cells flicker and show the old value
  • Table Data Editor - Fix so that when editing a cell value (for duplicated rows) to the same value it currently have, should preserve the edited state

New in version 8.0.1 (June 30th, 2011)

  • Improvement:
  • Connection Setup - Embedded databases taking filename as part of the database URL should offer a file chooser in the connection setup (Server Info only)
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3550 ]
  • Bug:
  • Data tab - The "Max Rows at First Display" setting have effect only for the very first table data being displayed
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3538 ]
  • DB Support: PostgreSQL - Exception or incomplete info when getting column info for DDL
  • Export - Export in XLS/XLSX format occasionally leave the exported file locked by DbVisualizer
  • General - Browsing the online documentation from the Help->Users Guide in DbVisualizer results in a 404 (Page not found) error
  • Import - Changing Decimal Number Format in Tool Properties from Unformatted may lead to data truncation during import
  • Performance/Stability - Occasional exceptions may appear at startup
  • SQL Commander - Running SQL blocks may result in error
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3558 ]
  • SQL Editor - Changing SQL Editor font is not preserved for the primary editor when re-starting DbVisualizer [http://www.dbvis.com/forum/thread.jspa?messageID=12756 ]
  • SQL Editor - When dropping a name into the SQL editor the position of the cursor is not moved after the name but stay at the drop position
  • SQL Formatter - The Format SQL->Paste Formatted clear the editor and reset undo buffer while it should just paste at caret position and keep undo buffer
  • SQL Formatter - Format SQL->Copy Formatted should operate on selection rather than whole buffer [http://www.dbvis.com/forum/thread.jspa?threadID=3407 ]

New in version 8.0 (June 20th, 2011)

  • General:
  • Support drag and drop of bookmark, monitor and favorite files between DbVisualizer and external tools such as Windows Explorer, Finder (Mac) and File Browser (Linux)
  • Screen estate adjustments and new controls to hide menu, tool and status-bars
  • Support for Java 1.7
  • Connection Management:
  • Integrated SSH support with trusted-host and private key support enabling connecting secure databases with a single-click.
  • SQL Editor:
  • New SQL/text editor:
  • SQL editor now support anti-aliased fonts
  • Monospaced fonts automatically set based on platform: Consolas (Windows), Menlo (Max OS X), DejaVu (Linux/UNIX)
  • Quick Search
  • Support for Paste from clipboard history
  • Support for database specific keyword highlighting
  • Regular expressions in Find and Replace
  • Show details for object at cursor
  • Support to configure editor colors and text styles
  • Support for text folding used to hide parts in the editor
  • Macro recording and playback
  • Charts:
  • Brand new chart component giving more appealing charts with pre-defined color schemes, gradient backgrounds and shadows.
  • Now supports re-executing the query and preserving the chart configuration style (colors, fonts, etc).
  • Monitor:
  • New option to hide monitor toolbars
  • Database Support:
  • Support for SQLite (bundled with DbVisualizer)
  • Support for H2 (bundled with DbVisualizer)
  • Explain Plan support for Mimer SQL
  • Export:
  • Export DDL support for individual object types such as procedures, functions triggers, views, etc.
  • Export in TXT format
  • Support for export in Excel 2007 (OOXML) format in addition to the current binary Excel format.
  • Grid:
  • Added "Copy Selection as Text (With Column Header)" in grids. Formats the selection in a fixed width output.
  • Navigator:
  • The foreign key Navigator now support editing table data
  • Added quick filter support in Navigator
  • Jump directly from the Data tab to the Navigator with preserved selections, sorting etc.

New in version 7.1.5 (February 24th, 2011)

  • Data tab - Decimal number precision may be cleared if using another Decimal Format than "Unformatted" and the formatting rules for the current locale use a "," as decimal separator
  • Export - Exception thrown when exporting table data with a driver that does not provide schema/catalog info, such as the Transoft driver
  • General - Having Tool Properties->General->Table Data->Show Table Row Count enabled may lock the GUI if two or more main windows are displayed
  • Grid Component - The auto column width formatter sometimes truncate columns showing "..." at the end cell
  • SQL Editor - SQL editors may lose sync with what file is being loaded and what file is reported in the editor title [http://www.dbvis.com/forum/thread.jspa?messageID=12015]

New in version 7.1.4 (November 23rd, 2010)

  • Improvement:
  • Connection Setup
  • Change the variable delimiters in Connection setup details from $$...$$ to the same used in SQL Commander (default ${...}$)
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3319]
  • SQL Commander
  • Format the numbers in execution result counters in the progress information area
  • Bug:
  • Connection Setup
  • Jumping between two database connections with the same URL may accidentally modify the second connections URL if editing the URL in the first connection
  • DB Support: DB2 LUW
  • Explain plan can only be performed with EXPLAIN_xxx tables being stored in the login schema even if using "set current sqlid = "" as connection hook
  • DB Support: Informix
  • The DBA keyword is missing in the source loaded into the source editor for procedures and functions
  • DB Support: JavaDB/Derby
  • Exporting indexes for a table fails with Derby 10.6
  • DB Support: Oracle
  • Explain Plan in Oracle present less information than in versions prior to 7.1
  • DB Support: SQL Server
  • Opening the Groups node with SQL Server 2008 or newer gives an error
  • DB Support: Sybase ASE
  • The DDL shown or exported for a large view declaration may have text segments out of order
  • DB Support: Sybase ASE
  • Procedure is shown twice in the Object Type list in the Object Filter section
  • DDL Generator
  • Precision and scale are not included in DDL type declaration for decimal data types when using the Generic profile
  • DDL Generator
  • The DROP INDEX syntax is incorrect for some databases
  • Export
  • DROP statements should not be generated for indexes, since they are dropped when the table is dropped
  • Export
  • When exporting a table with BIT data, the BIT values are quoted in the INSERT statement
  • [http://www.dbvis.com/forum/thread.jspa?messageID=11501]
  • Export
  • The exportsettings.xml/exportschemasettings.xml files may be empty resulting in an XML error when exporting
  • [http://www.dbvis.com/forum/thread.jspa?messageID=11702]
  • Installation
  • The 64-bit Windows installer may download a 32-bit Java VM which will result in errors
  • [http://www.dbvis.com/forum/thread.jspa?threadID=2155]
  • Key Bindings
  • Control+S may switch to Database Search if using the key binding to save an already saved SQL editor
  • References
  • Showing table references for a specific table results in an error if doing a Reload
  • SQL Commander
  • Preprocessing of a script larger than 5 MB fails
  • SQL Commander
  • Whitespace should be ignored after the block end delimiter
  • SQL Commander
  • The Elapsed Time counter is not running when parsing and executing large scripts without preprocessing
  • Workspace
  • Default file encoding is not considered when opening a SQL file in the OS environment (with for ex. Windows Explorer or OS X Finder)

New in version 7.1.3 (September 11th, 2010)

  • Improvement:
  • DB Support: DB2 LUW
  • Add support for dropping columns in Alter Table for database version 9 or later
  • [http://www.dbvis.com/forum/thread.jspa?messageID=11522]
  • References
  • Reload in References graph should reload from the database rather than just layout the cached tables in the graph
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3263]
  • Bug:
  • DB Support: Sybase ASE
  • Calling sp_procxmode to preserve the mode in versions prior to 15 cause various problems, so do not try to preserve the mode in older versions
  • Import
  • NullPointerException may occur if selecting "Map by Column Name" or "Map File Data Type = Table Data Type"
  • References
  • Press "All Tables" or "Specified Tables" in the References graph after doing reload in the objects tree results in an error
  • SQL Commander
  • Copy in the SQL Commander log should only copy the selected text rather than all of the log

New in version 7.1.2 (August 18th, 2010)

  • Improvement:
  • DB Support: Oracle - Improve the support for Program, Replication, ASM, AWR, Scheduler, Resource Groups, DataGuard and Streams object types
  • Procedure Editor - Show the same error message for a lost connection when selecting a procedure as is shown when selecting a table
  • Tool Properties - The Permission confirmation window should show number of SQLs that are affected for each permission level
  • Bug:
  • Connection Setup - Connection variables may be lost if DbVisualizer is abruptly exited
  • DB Support: DB2 LUW - The "Empty Table" action to truncate a table don't work if not using DB2 9.7 and later
  • DB Support: MySQL - Data type names are converted to uppercase in DDL, including the parameters for ENUM and SET types
  • DB Support: PostgreSQL - The COMMENT statements in the DDL for a PostgreSQL table may reference incorrect columns if a column has been dropped
  • DDL Generator - Incorrect table reference in FK constraint when the referenced table is in another catalog/schema than the referencing table
  • Explain Plan - Oracle/DB2 LUW: Changing schema with the Schema drop down and then run Execute Explain will not set the new schema in the database
  • Export - DROP statements are not generated for code objects (procedures, functions, etc.) for some databases when Create DROP Statements is enabled
  • Export - Using multiple "@export set" commands in a script resets the Filename
  • General - The "You need to re-connect..." error window may appear while exiting DbVisualizer
  • Navigator - Incorrect grid data shown when sorting the source table before navigating to the target table
  • SQL Commander - When using Anonymous SQL Blocks in a script executed with the @run command, the end delimiter is included in the statement
  • SQL Commander - Clicking Stop may result in a stack trace in the Debug window
  • SQL Commander - Client-side command syntax errors displayed as generic exceptions with stack trace in log
  • SQL Editor - Must be possible to turn of the "save changes" confirmation when jumping in the history

New in version 7.1.1 (June 23rd, 2010)

  • Check for Update - Check for Update shows that Free Upgrade is available when it is really not a free upgrade
  • Data tab - An error may appear when viewing the Data tab containing BLOB/Binary data

New in version 7.1 (June 16th, 2010)

  • New Feature:
  • DB Support: Informix
  • Verify DbVisualizer with Informix 11.5
  • DB Support: MySQL
  • Add Create and Drop User actions
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3112]
  • DB Support: Oracle
  • Add Create and Drop Role actions
  • DB Support: Sybase ASE
  • Add Create Function action
  • DB Support: Sybase ASE
  • Add Drop and Script CALL to Editor actions for Function objects
  • DB Support: Sybase ASE
  • Add support for User Defined Functions
  • Driver Manager
  • The Driver Finder should always run when launching a new DbVisualizer version
  • [http://www.dbvis.com/forum/thread.jspa?threadID=2494]
  • Driver Manager
  • When upgrading DbVisualizer version then automatically upgrade all bundled JDBC drivers
  • Grid Component
  • Add "Find Column" feature which will automatically scroll horizontally to next column that match by name
  • [http://www.dbvis.com/forum/thread.jspa?threadID=2627]
  • Grid Component
  • Add "Reload with Column Sorting as Sorting Filter" right click menu command in the Data tab
  • Grid Component
  • Add a viewer for PDF documents
  • Grid Component
  • Add option to treat number values in text data types as numbers in the "Aggregation Data for Selection" feature
  • [http://www.dbvis.com/forum/thread.jspa?threadID=2964]
  • Grid Component
  • Allow custom colors for quick filter match, nulls, notifications and editing in the grid component
  • [http://www.dbvis.com/forum/thread.jspa?messageID=10874]
  • SQL Commander
  • New client side command: @run
  • SQL Commander
  • Add a File->Revert to Saved command to revert all changes made to a SQL file
  • [http://www.dbvis.com/forum/thread.jspa?messageID=7577]
  • SQL Commander
  • Add audio notification capability in the SQL Commander
  • [http://www.dbvis.com/forum/thread.jspa?messageID=7938]
  • Workspace
  • When opening an SQL file in for Windows Explorer or the Finder in OS X it should load the file in the currently running DbVisualizer instance rather than opening a new
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3051]
  • Improvement:
  • Connection Setup
  • Select new database connection in the objects tree when created with the Connection Wizard
  • Create/Alter Table
  • Add support for IDENTITY columns options (ALWAYS/BY DEFAULT, START WITH and INCREMENT BY)
  • Create/Alter Table
  • Add support for the ENUM and SET data types in the Create/Alter Table dialogs
  • Create/Alter Table
  • Allow auto completion in the Data Type column
  • Data tab
  • "Script: DELETE WHERE" should accept a multi row selection
  • Data tab
  • Make it possible to set number of max table data filters
  • Data tab
  • The "Filter & Sort" right click menu should have an option to also consider current column sorting in the generated filter
  • Database Profile: View
  • Make the Row Count tab "stoppable"
  • [http://www.dbvis.com/forum/thread.jspa?messageID=6981]
  • DB Support: DB2 LUW
  • Add support for START WITH and INCREMENT BY for IDENTITY columns in DDL
  • DB Support: DB2 LUW
  • Add "Indexes" child node for Materialized Query Tables
  • [http://www.dbvis.com/forum/thread.jspa?threadID=1954]
  • DB Support: JavaDB/Derby
  • Add support for IDENTITY columns in DDL
  • DB Support: MySQL
  • Add support for the "FULLTEXT" option in Create/Alter Table and Create Index dialogs
  • DB Support: Oracle
  • Change the process for updating a CLOB/BLOB column via the data grid for 10g and later to stop UPDATE triggers from firing twice
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3014]
  • DB Support: Oracle
  • Show execute permissions for stored procedures
  • DB Support: PostgreSQL
  • Enable changing column data type in the Alter Table dialog for PostgreSQL 8
  • DB Support: SQL Server
  • Add support for seed and increment parameters for IDENTITY columns in DDL
  • DB Support: Sybase ASE
  • Add sp_procxmode call for procedure export DDL and maintain transaction mode in Procedure Editor
  • DB Support: Sybase ASE
  • Show table indexes in the objects tree for each database
  • [http://www.dbvis.com/forum/thread.jspa?messageID=5916]
  • Driver Manager
  • An invalid driver definition (JAR file not found) should not have the same visible state as a driver that has not yet been configured
  • Driver Manager
  • Drivers marked as invalid due to non existing driver jar files should be cleared when loading new jar files in the connection wizard
  • Export
  • It should be possible to specify whether to qualify object names and use delimiters for Export
  • Favorites
  • Favorite Editor: Add ALT+Double Click key binding for opening database object favorite in new window
  • Grid Component
  • Add "Reset Sorting" command in the right click column header menu
  • Grid Component
  • Copy/paste of binary data should be supported
  • Grid Component
  • Preserve selection when sorting grid
  • Grid Component
  • Preserve sorting in grid when quick filter is activated
  • Grid Component
  • Should be possible to configure whether the Max Rows warning should appear automatically or not
  • Procedure Editor
  • Keep cursor position when clicking Save
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3158]
  • SQL Commander
  • Add "Create New SQL Editor" button in the main toolbar
  • SQL Commander
  • Add new "Default Display Mode" setting used to determine default display for result sets in the SQL Commander (one of Grid, Text, Chart)
  • SQL Commander
  • File->Open should default to "Open in New Editor" rather in the current editor
  • [http://www.dbvis.com/forum/thread.jspa?messageID=7296]
  • SQL Commander
  • If numbers are set to include thousand separators (,) in Tool Properties then these are also part of the generated SCRIPT: xxx SQLs
  • SQL Commander
  • Preserve scroll position in the SQL Preview while editing values
  • SQL History
  • Add setting to control whether failed SQLs should be saved in the SQL history
  • SQL History
  • Don't save duplicate entries in the SQL history for statements being executed in sequence
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3099]
  • Tool Properties
  • Export User Settings: Add option to convert all paths to be relative rather than absolute
  • [http://www.dbvis.com/forum/thread.jspa?threadID=2815]
  • Bug:
  • Database Objects Tree
  • Long object filter pattern requires resizing of Objects Tree pane to access buttons for adding and removing filters
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3139]
  • General
  • An error may occur in various places when a SELECT with a sub query is used, such as when exporting the result of the query
  • General
  • Opening a web browser from DbVisualizer may result in an error
  • SQL Commander
  • Unexpected JDBC driver errors may freeze DbVisualizer while executing in SQL Commander

New in version 7.0.7 (May 25th, 2010)

  • Improvement:
  • DB Support: MySQL - Add support for declaring Procedure/Function characteristics in the Create Procedure/Function dialogs
  • SQL Commander - Show an error message if the path specified for the @cd command doesn't exist or isn't a directory
  • Bug:
  • Create/Alter Table - Open Create Table and add a new column, if the database connection is lost then an NPE is displayed
  • Create/Alter Table - Size information is declared in the wrong position for FOR BIT DATA data types
  • DB Support: DB2 LUW - CHAR/VARCHAR FOR BIT DATA are shown as CHAR/VARCHAR in DDL
  • DB Support: MySQL - Key constraint treated as a separate index in DDL for Export
  • DB Support: Oracle - Explain Plan doesn't work with Oracle 11.2
  • DB Support: Sybase ASE - Problem browsing database objects if quoted_identifier is off
  • Export - The AppendFile="clear" option does not clear an existing file when exporting to XLS files
  • Grid Component - There is a newline after last copied cell
  • Grid Component - Wrong HEX representation in the Cell Viewer
  • SQL Commander - The @delimiter command does not work when used in a script called with the @run command
  • SQL Commander - Variable values for variables with option "nobind" are not quoted when needed
  • SQL Commander - "Processing Command" message should show SQL with any control characters (newline, tab) and multiple white spaces replaced with single white space

New in version 7.0.6 (April 21st, 2010)

  • Improvement:
  • DB Support: DB2 z/OS - Enable using the schema selected in the SQL Commander as the default schema for the connection
  • Import - Clear the log after import
  • SQL Commander - Fix progress message by splitting "Acquiring connection..." into "Acquiring connection..." and "Executing..."
  • SQL Commander - The Max Rows/Max Chars warning should be made more visible than it is currently
  • Bug:
  • DB Support: Firebird - The generated CREATE INDEX statement does not work with Firebird
  • DB Support: Informix - BOOLEAN and BLOB columns are shown to be included in all indexes in the Indexes tab and subnode for a table node
  • DB Support: JavaDB/Derby - Various errors accessing a database created with TERRITORY_BASED collation
  • DB Support: Oracle - Clone a user and then clone the new user don't work properly
  • DB Support: PostgreSQL - NOT NULL constraints are shown in the Check Constraints tab in the Alter Table dialog
  • Export - Export in CSV should add a newline on last row
  • Export - Export to clipboard results in an error
  • General - Opening the browser for Online Resources or Users Guide doesn't work if the default browser is Opera
  • SQL Commander - Executing just a single client side command, e.g. "@export on", results in an error dialog
  • SQL Commander - Stopping the SQL Commander while the database connection has been interrupted may result in an unrecoverable error
  • Table Data Editor - Sub queries in table filters (Data tab) may be corrupted
  • Table Data Editor - The object path delimiter was changed in 7.0 from " | " to "/". Any table filters are not updated to reflect this change resulting in no filters will appear in the Data tab
  • Tool Properties - Max SQL history entries limit is not migrated when upgrading from pre 7.0 versions

New in version 7.0.5 (March 16th, 2010)

  • Improvement
  • Connection Tab
  • dbVisualizer should stay connected even if the driver cannot handle setting auto commit while initializing the connection
  • [http://www.dbvis.com/forum/thread.jspa?messageID=10698]
  • DB Support: MySQL
  • Fail to navigate the objects tree if "show databases" privilege is missing
  • [http://www.dbvis.com/forum/thread.jspa?threadID=2676]
  • DB Support: Oracle
  • Add new view for DBA->Session->Plan Data that show the plan information along with the SQL for the current session
  • [http://www.dbvis.com/forum/thread.jspa?messageID=10284]
  • Import
  • In the Import Destination->Database Table pane add column for "File Data Type" and make it editable
  • Import
  • Round estimated character column sizes for new table up to closest multiple of 10
  • Monitor
  • Add an Auto Adjust setting in the Monitor window to control whether the timer should be adjusted automatically (default) or not
  • [http://www.minq.se/forum/thread.jspa?messageID=7101]
  • SQL Commander
  • Add new property to control whether the "Auto Commit is OFF" confirmation window should be displayed for any statement (except SELECTs)
  • SQL Editor
  • New setting to control upper/lower-case of auto completed names
  • Table Data Editor
  • Add "Key Columns" button in the data editing result window (used to re-define WHERE columns in case old table row cannot be identified)
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3031]
  • Web
  • Describe workaround how to disable so that the MySQL Connector/J driver should not cache all result set data in memory leading to OutOfMemory in DbVisualizer
  • [http://www.dbvis.com/forum/thread.jspa?messageID=10610]
  • Bug
  • Chart
  • Specifying a directory as the destination for export grid, graph or chart gives an error
  • Database Objects Tree
  • "Clear Visited State" should also clear the state for any child objects
  • Database Objects Tree
  • Reload objects tree action should reload all objects one level up and not only the selected object
  • DB Support: Informix
  • Invalid CHECK constraints in DDL with long column names
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3026]
  • DB Support: PostgreSQL
  • Invalid quoting of character default values in DDL
  • DDL Generator
  • Showing DDL for a View causes an exception if the AS keyword is not immediately preceded by a blank
  • Monitor
  • Chart series may not be saved between DbVisualizer sessions
  • Monitor
  • Using column values from the previous execution of a monitor doesn't work properly
  • [http://www.dbvis.com/forum/thread.jspa?threadID=2990]
  • References
  • Specifying a directory as the destination for export grid, graph or chart gives an error
  • SQL Commander
  • "Pin New Result Sets" doesn't work for second editor even if it is the default between sessions
  • [http://www.dbvis.com/forum/thread.jspa?messageID=10594]
  • SQL Commander
  • A line comment before a "go" statement delimiter causes "go" to be appended to the preceding statement
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3031]
  • SQL Editor
  • Using Save As in SQL Commander should automatically add the ".sql" extension
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3024]

New in version 7.0.4 (February 26th, 2010)

  • Reload in Objects Tree or Reconnect a database connection may result in an error

New in version 7.0.2 (February 3rd, 2010)

  • Bug:
  • Database Profile: View - Re-introduce the debugging feature of viewers i.e Ctrl+Click tab.
  • Import - Filename don't appear in grid window title when doing import to Grid.
  • SQL Commander - Massive resource usage (threads and memory) when running a large script.
  • SQL History - Entering an invalid value in the History Max Entries field results in an error on next start-up.

New in version 7.0.1 (January 29th, 2010)

  • Improvement:
  • General - Show full text of entries that don't fit in a list as tooltips
  • DB Support: Cache - Add support for T-SQL style join WHERE clause operators ("=*" and "*=")
  • DB Support: Oracle - Optimize query used to get Tablespace Files
  • Bug:
  • Check for Update - Check for Update window is truncated
  • DB Support: SQL Server - ClassCastException when generating DDL
  • DB Support: Sybase ASE - ClassCastException when generating DDL
  • General - Stop in the Data tab or SQL Commander does not stop long running statement
  • Grid Component - Copying and pasting a CLOB value results in "CLOB, xxx Bytes" instead of the value
  • Grid Component - Double click below the data in a grid results in an error
  • Query Builder - Group By is not set when loading a SELECT statement that use table name aliases
  • SQL Commander - Current database connection, database and schema are cleared when loading new file into editor
  • SQL Commander - Quick File Open may when invoked result in a NullPointerException
  • SQL Commander - Recent Files menu is slow to show if any file is located on a network disk
  • SQL Commander - The Log in SQL Commander keeps only the log entries for the last execution even if Auto Clear is disabled
  • SQL Editor - Dragging an object from the databases tree into the SQL editor visually indicates the focus is in the editor but it isn't
  • SQL History - Execution in SQL Commander gets slower and slower with increasing number of SQL history files
  • Tool Properties - Daylight savings time adjustments may occur even when default timezone is set to UTC

New in version 7.0 (January 17th, 2010)

  • New Feature:
  • Bookmarks - Redesign the old bookmark management into new features for SQL History, Bookmark and Monitor scripts
  • Command Line Support (dbviscmd) - Add command line support for executing SQLs
  • Connection Wizard - Add a "database ping" feature which will test on TCP level whether there is a server responding on the specified host/port
  • Database Profile: Actions - Add action dialogs for setting comments on columns and other database object types
  • DB Support: Oracle - Add new "TNS" connection mode for Oracle. DbVisualizer will then show a list with all connections defined in tnsnames.ora
  • Export - Add an Export Table feature
  • Export - Allow BLOB/CLOB data to be exported and imported
  • Favorites - Add new Favorites Editor and Favorites Toolbar feature for database objects and script files
  • General - Require a minimum of Java 1.6
  • Grid Component - Add a "Aggregation Data for Selection" feature with aggregate functions for Date, Time, String, Number, etc.
  • Import - Allow BLOB/CLOB data to be exported and imported
  • Import - Make it possible to create a new table while importing table data [http://www.dbvis.com/forum/thread.jspa?threadID=2201]
  • Procedure Editor - Add support for execution of functions/procedure
  • References - Support export of graphs in SVG, PNG and PDF format
  • SQL Commander - Add a "Quick File Open" feature to search and load Recent Files, Bookmarks, SQL History and Monitor files into the SQL editor (mimic IntelliJ Ctrl+N popup) [http://www.dbvis.com/forum/thread.jspa?messageID=6045]
  • SQL Commander - Add support for parameter markers representing OUT/INOUT parameters
  • SQL Commander - Make it possible controlling statement DELIMITER via a client side command [http://www.dbvis.com/forum/thread.jspa?threadID=1878]
  • Improvement:
  • Bookmarks - Add multi bookmark (script file) deletion
  • Bookmarks - Add option to insert selected bookmark in the SQL Editor and not only replace everything in it [http://www.dbvis.com/forum/thread.jspa?threadID=2152]
  • Check for Update - Add "Proxy Settings" link in the Check for Update feature
  • Check for Update - Show optional "Comment" in Check for Update feature + minor fixes
  • Connection Properties - The auto commit/rollback feature at disconnect need to be revised as it may block the GUI
  • Database Profile: Tree - Add a "Copy Database URL" and a "Copy Object Path" action in the objects tree right click menu
  • DB Support: Other - Remove support for PointBase and DaffodilDB
  • Export - Allow Export Schema to export objects to separate files [http://www.dbvis.com/forum/thread.jspa?threadID=1623]
  • Export - Make it possible to export to new destination: SQL Commander->New Editor [http://www.dbvis.com/forum/thread.jspa?messageID=10013]
  • Export - Allow use of ${dbvis-object}$ (former ${table}$) variable in other fields than just the filename
  • Export - Possible to use ${dbvis-date/dbvis-time/dbvis-timestamp}$ variables in filename for @export commands
  • General - Add capability to open multiple main windows (File->New Window)
  • General - Upgrade to new icon collection
  • General - Disable client/server capability in the DbVisualizer GUI (via command line arguments)
  • General - Make command line argument "-up" deprecated and replace it with new "-prefsdir" argument
  • General - Remove the command line arguments for the DbVisualizer GUI used to control connection setup and execution control. These are now managed by the new command line interface
  • Grid Component - Save column widths when dbvis.savedatacolumns=true [http://www.dbvis.com/forum/thread.jspa?messageID=5966]
  • Grid Component - Use the "Execute" key binding to start filtering in the Data tab inline filter field and filtering window
  • Monitor - Reload of a result set that was produced by a procedure call may give a warning that result set cannot be re-executed since it is part of a multi statement execution [http://www.dbvis.com/forum/thread.jspa?messageID=9801]
  • Navigator - Allow for multiple selections in the Table Navigator grid and equal number of target nodes will show in the diagram
  • Performance/Stability - Various operations, such as Reload of a tab in the Object view, hangs the GUI if the database connection has dropped
  • References - Add magnifying glass zoom
  • References - Do not show the member list for ENUM and SET column types, since it can be very long
  • References - Add capability to pan the references graph with the mouse instead of scrollbars only
  • References - Enhance the "Specified Tables" feature so that it is easier to choose what tables to show in the references graph
  • References - The data types presented for a table are sometimes too verbose [http://www.dbvis.com/forum/thread.jspa?threadID=2256]
  • Scripts - Should be possible to define default target editor when exporting or double-click a bookmark and history entry [http://www.dbvis.com/forum/thread.jspa?messageID=10053]
  • SQL Commander - If @ is used as the anonymous block begin delimiter, no client-side commands are recognized
  • SQL Commander - Extend the Permission feature with controls for Commit/Rollback/Set Autocommit
  • SQL Commander - Loading a file with File->Open Recent should not show file chooser but instead load file directly
  • SQL Commander - Make it possible to run scripts of unlimited size with the @run command
  • SQL History - Show "bytes" column in the History feature for each history file
  • Table Data Editor - Active Table Data Filter with same key binding as execute in SQL Commander (Ctrl+Enter, Cmd+Enter, etc).
  • Bug:
  • Table Data Editor - Mac OS X: The first character is removed when editing in the grid and form data editors
  • SQL Commander - Initiating SQL->Execute using key binding may execute in a non visible editor
  • General - Dock icons for minimized windows are represented by a badly scaled image (these should not appear on OS X)
  • Performance/Stability - UI locking up on database lock
  • Tool Properties - TimeZone info in Connection tab status bar is empty on Windows 7

New in version 6.5.12 (December 22nd, 2009)

  • DB Support: Informix - BOOLEAN columns are shown as BLOB in DDL.
  • Import - Setting "Commit Batch Size" for the Import Table Data feature doesn't work.
  • OS Support: Mac OS X - At startup a window display "You need to restart to see the new look and feel". This is due to changes in the Java 1.6.0_17 version.
  • SQL Commander - Execute Current may in some cases execute the preceding statement instead on Windows platforms.

New in version 6.5.11 (December 6th, 2009)

  • Improvement:
  • DB Support: SQL Server - Add key sort order for Primary Key in DDL
  • Export - Export objects selected in the Export Schema dialog in alphabetic order per object type
  • Bug:
  • DB Support: Oracle - Foreign Key constraints are duplicated in the DDL when the same FK target is used in another table in another schema
  • DB Support: PostgreSQL - The column order in a PK constraint in the generated DDL is incorrect for some tables
  • DB Support: SQL Server - Index order (DESC vs ASC) missing in the DDL
  • DB Support: Sybase ASE - Problem with database names having special characters in them (ex "-")
  • Export - All values are exported as 0 for a BIT column is a format other than "true/false" is selected
  • Grid Component - cript options (SELECT and DROP) are missing in the Tables grid popup [http://www.minq.se/forum/thread.jspa?threadID=2816]
  • SQL Commander - "invalid statement type: 0" error when executing a statement in an anonymous block
  • SQL Editor - Auto completion popup for column names not displayed if having "KEY JOIN" in the SQL [http://www.minq.se/forum/thread.jspa?messageID=9904]
  • SQL Formatter - Format Buffer incorrectly adds a partial statement at the end (only on the Windows platform)

New in version 6.5.10 (October 23rd, 2009)

  • Improvement:
  • OS Support: Support for Windows 7
  • OS Support: Add installer for Windows x64
  • Bug:
  • DB Support: DB2 z/OS - Some DB object types are displayed for all schemas instead of the selected
  • DB Support: MySQL - An explicitly declared 0 default for a not-nullable int column is not preserved in the generated DDL
  • DB Support: Oracle - (null) appear as table space name in "Remove Datafile" action
  • DB Support: Oracle - Incorrect index column order in objects tree
  • DB Support: PostgreSQL - Incorrect FK declarations generated in DDL when multiple FKs to/from the same table has the same name
  • DB Support: PostgreSQL - The Table and Column lists for the Referenced Table FK constraints in the Create/Alter Table dialog contains too many entries
  • Explain Plan - Explain plan feature for Oracle doesn't properly quote the schema and PLAN_TABLE names
  • General - Fix regression problem with connection being timed out
  • SQL Commander - Java 1.6: Focused component is not restored when jumping between the Object View and SQL Commander tabs
  • SQL Formatter - Comments after the last statement are removed when formatting
  • [http://minq.se/forum/thread.jspa?threadID=2771]
  • Table Data Editor - An error occur in the form data editor and if selecting another object in the objects tree or disconnect/refresh

New in version 6.5.9 (August 30th, 2009)

  • DB Support: PostgreSQL - The "Databases" object in the objects tree is empty.

New in version 6.5.8 (August 28th, 2009)

  • Improvement:
  • Database Profile - Add section in Database Profile
  • DB Support: HP Neoview - Add object type actions such as Create Trigger, Rename Table, Create View, Create Materialized View, etc
  • DB Support: HP Neoview - Auto determine the value of the METACAT driver property for HP Neoview 2.4+ (user should not need to specify it)
  • DB Support: HP Neoview - Default Delimited Identifiers for HP Neoview should be (")
  • DB Support: HP Neoview - Enhance HP Neoview support so it handles ISO & UCS2 systems properly
  • DB Support: HP Neoview - Schema drop down list in SQL Commander isn't sorted
  • DB Support: PostgreSQL - Add support for the INHERITS clause in the DDL generator
  • DB Support: PostgreSQL - Add object actions for Create and Drop Schema for PostgreSQL 8
  • Bug:
  • Database Profile: Tree - Stopping a database search may not stop at once
  • DB Support: MySQL - An explicitly declared 0 default for a nullable int column is not preserved in the generated DDL
  • DB Support: Oracle - Fix the issue with "No sub element for ObjectActionType: oracle-schedulerjobs-create" being displayed in the debug window
  • DB Support: Oracle - ORGANIZATION INDEX is not included in DDL
  • General - Some operations may hang the GUI if the database connection has been dropped or is unresponsive
  • Grid Component - (null) values are rendered with a gray background color which is fine but when using the quick filter sometimes this gray color appear in non null fields
  • Procedure Editor - NullPointerException when saving if the editor is used as a separate window
  • Procedure Editor - Format Buffer incorrectly formats the code as multiple statements

New in version 6.5.7 (August 28th, 2009)

  • Improvement:
  • Database Profile: Actions
  • value must not match the list of values for the "list" style if the input field is editable
  • Database Profile: Actions
  • Add support for "hideif" attribute for and elements controlling whether action should be hidden for an object and whether an input field for an action should be hidden
  • DB Support: Oracle
  • Add more support for Oracle Scheduler
  • Bug:
  • Database Objects Tree
  • Must be possible to use the objects tree filter for compound object names such as schema.table
  • [http://www.minq.se/forum/thread.jspa?threadID=2633]
  • Database Profile: Actions
  • Database and Schema lists in the SQL Commander are not updated when executing action that create/removes database/schema
  • DB Support: Informix
  • Problem with delimited identifiers in Informix
  • [http://www.minq.se/forum/thread.jspa?threadID=1846]
  • DB Support: Informix
  • The Grants tab for a table in Informix doesn't show correct information
  • DB Support: PostgreSQL
  • Auto completion popup lists index and constraints while it should only show tables and views
  • DB Support: PostgreSQL
  • Browsing tables in PostgreSQL 8.4 gives an error
  • Export
  • Error using Export Schema when block delimiters are set to "@" due to conflict with command identifier character
  • OS Support: Mac OS X
  • Cannot launch DbVisualizer on Mac OS X with the Java 1.6.0_13 version
  • [http://www.minq.se/forum/thread.jspa?threadID=2727&tstart=0]
  • References
  • References are not correct for Mimer
  • SQL Commander
  • Applying Connection Properties changes the selected Database in the SQL Editor
  • SQL Commander
  • Executing a "{ call }" statement will fail for Oracle if there is a newline before the first "{"

New in version 6.5.6 (May 15th, 2009)

  • Database Profile: Actions - Stopping a long running action may result in a NullPointerException [http://www.minq.se/forum/thread.jspa?threadID=2677]
  • DB Support: Oracle - Error when using Create Index dialog for a table that is not in the default schema
  • Export - Export in Excel with append mode results in the document being cleared if a result set has no data
  • Grid Editor - Pasting a value into a single cell in a sorted editable grid may result in a flickering of other cells
  • Grid Editor - Start edit of a "(null)" value will mark it as edited and set the value to a space even if not really editing the value.

New in version 6.5.5 (April 6th, 2009)

  • Improvement:
  • Database Profile: Actions - Support execution of procedure in an action which generates DBMS_OUTPUT.
  • Bug:
  • Database Profile: Tree - Can't "Show in Window" if the node in the objects tree have an overlay icon (representing new, error, warning state) on top of the normal object icon.
  • Database Profile: Tree - Focus is lost when traversing the objects tree with the keyboard.
  • Database Profile: View - An error may appear when clicking in the "Database Info" grid.
  • DB Support: Oracle - Source code lines for a routine may occasionally be reordered when read from the database.
  • DB Support: Oracle - Trigger source is not viewable when logged in as SYS.
  • DB Support: SQL Server - Viewing a the code for a function with no read access gives an exception rather than a detailed message.
  • DDL Generator - An empty column list is shown when the column list for a View is unavailable.
  • Export - NullPointerException when format is not specified for @export.
  • Import - java.io.IOException: Pushback buffer overflow if using "Nothing" as Quote Character in "Import Table Data".
  • Import - StackOverflowError if importing a file that contain only a single row.
  • Procedure Editor - Exception when the source for a stored procedure is not available.
  • SQL Commander - Execute Current with the cursor after the last statement in a script executes the complete script.
  • SQL Commander - Pressing "Stop" in the SQL Commander clear any partially fetched result set while pre-6.5.3 versions did not.
  • SQL Formatter - Invalid formatting when MySQL delimited identifiers contain special characters (e.g. "-") or keywords (e.g. "from").

New in version 6.5.4 (February 6th, 2009)

  • Improvement:
  • DB Support: MySQL - Add a Table DDL tab that shows constraint names even when they are system generated.
  • DB Support: MySQL - Collation should be shown in the Columns tab for a table.
  • Import - The table data import feature should allow multi character column separators.
  • Bug:
  • Database Profile: Actions - Cannot type in text fields in some dialogs (ex. "create table", "rename table" and so on).
  • Database Profile: View - The "Show in Window" window may appear behind the main window on Windows.
  • Database Profile: View - Window displayed by "Show in Window" command don't get focus.
  • DB Support: MySQL - Collation is not shown in DDL for columns with non-default collation.
  • DDL Generator - Single quotes in comments are not duplicated.
  • Export - BigInteger numbers may appear as 0 in exported Excel file.
  • Export - Export in Excel format may result in an error if result set was not created by executing SQL.
  • Export - Should be possible to specify that embedded double quote in text data should be escaped (duplicated) and not just single quotes.
  • Export - The ExcelIncludeSQLCommand="true" option with @export didn't have any effect.
  • Export - The exported XML document lacks a root element and may contain illegal characters.
  • General - Bookmarks containing SQL with CDATA identifiers results in an error.
  • Import - Import to grid may result in a NPE.
  • Import - The String type is suggested for a column with a mixture of integer and decimal number values.
  • SQL Commander - The "go" string should only be recognized as a delimiter when it is on its own line.
  • SQL Commander - Manually selected catalog/schema may be reset to the default after execution of a script.

New in version 6.5.3 (January 12th, 2009)

  • Improvement:
  • Grid Component - Show column number in grid column header tooltip
  • Grid Component - Extend Calculation feature in grid right click menu with metrics for string lengths
  • Bug:
  • Grid Component - Selection mode in grid may erroneously be set to complete rows only.

New in version 6.5.2 (January 9th, 2009)

  • Improvement:
  • SQL Formatter - Do not add blank lines around UNION, INTERSECT, etc., restoring the previous formatting behavior.
  • Bug:
  • Connection Tab - Use of variables ($$...$$) in connection data may not properly revert to variable notation after exiting DbVisualizer while still connected with the database.
  • Create/Alter Table - The size value cannot be reset.
  • DB Support: DB2 z/OS - Listing triggers results in a database error.
  • DB Support: Informix - Getting the DDL for a stored procedure fails with Informix 7.
  • DB Support: PostgreSQL - Incorrect source shown in the Procedure Editor for procedures with the same name and number of arguments, differing only in parameter types.
  • DB Support: PostgreSQL - Procedure parameter list in Procedure Editor does not include parameter names when all parameters are IN parameters.
  • Export - Erroneous ALTER TABLE ADD statements generated for system generated CHECK NOT NULL constraints for some databases.
  • Export - @export in XLS format may result in a 0 byte file.
  • General - Maximize Window doesn't work correctly on a dual monitor setup.
  • General - Window sizes, positions and splitter positions fail to save between sessions if using dual monitors.
  • Grid Component - "Copy Name" in the column header right click menu doesn't work.
  • Grid Component - GUI is blocked (how long depends on amount of data in grid) and CPU peaks if modifying what grid columns should be visible while there is a quick filter active.
  • Grid Editor - EditingNotStoppedException may occur if entering an invalid value and click outside the data editor grid.
  • Grid Editor - Error dialog may show if there is a DB error getting unique indices or primary keys when saving table data edits.
  • OS Support: Mac OS X - Application icon on Mac OS X is scrambled.
  • OS Support: Mac OS X - Grid column header have white background on Mac OS X with the Aqua L&F.
  • SQL Commander - A block end identifier (e.g. "/") should only be recognized as such when it is on its own line.
  • SQL Commander - The "go" string should only be recognized as a delimiter when it is on its own line.
  • SQL Commander - An NPE error may occur when using @export with a SELECT statement.
  • SQL Commander - The "Copy SQL" command in the variable substitution window results in the SQL being executed.

New in version 6.5.1 (November 24th, 2008)

  • Improvements:
  • Bookmarks - Add a size limit for History Bookmarks
  • Database Objects Tree - The window that appear when requesting "Show in Window" in the objects tree can not be maximized or iconified
  • DB Support: MySQL - Use SHOW TABLES to populate the Tables and Views trees instead of SELECT on INFORMATION_SCHEMA for better performance
  • SQL Commander - Disable SQL Preview in the Variable prompt dialog when there is not enough memory available to show it
  • Bugs:
  • Database Search - A NullPointerException may occur at start
  • DB Support: Informix - Error when opening a Function node if the code was created with CREATE PROCEDURE
  • DB Support: Informix - Saving a Function/Procedure with explicitly declared IN, INOUT or OUT parameter directions in the Procedure Editor fails
  • DB Support: Mimer - The View DDL content is incorrect for some Views in 9.3
  • DB Support: MySQL - National characters (e.g. umlaut o) in a procedure or function are corrupted by the source editor
  • DB Support: MySQL - UNSIGNED types are duplicated in the Data Type lists
  • DB Support: Neoview - A character set error may occur if displaying column information for a table
  • DB Support: PostgreSQL - Error when opening function in PostgreSQL 8.3
  • DB Support: SQL Server - The Triggers node for a Table node lists all triggers in the database rather than only those for the table
  • DB Support: SQL Server - With "set quoted_identifier off" as a Connection Hook, selecting a Function/Procedure node results in an error
  • DB Support: Sybase ASE - With "set quoted_identifier off" as a Connection Hook, selecting a Function/Procedure node results in an error
  • Export - NullPointerException when a SELECT statement that is part of an @export fails
  • Installation - A trojan is erroneously reported by eTrust during installation
  • Procedure Editor - The Execute button gets disabled when all content is deleted
  • SQL Commander - Executing a SELECT in the SQL Commander may take long time if using INNER JOIN clauses
  • SQL Commander - Using JDBC escape features, {d 'xxx'}, {fn 'xxx'}, {ts 'xxx'} and so on doesn't work in the SQL Commander
  • SQL Formatter - Indentation size hardcoded to 4 when indentation set to "Use Tab"
  • Tool Properties - An error occur if setting "Whitespace(s) per tab" = 0 in Tool Properties->SQL Editor category

New in version 6.5 (October 24th, 2008)

  • New Features:
  • DB Support: DB2 - Add support for creating and editing triggers
  • DB Support: DB2 - Add support to edit and compile of procedures and functions
  • DB Support: Informix - Add support for creating and editing triggers
  • DB Support: Informix - Add support to create, edit and compile procedures and functions
  • DB Support: JavaDB/Derby - Add support for creating and editing triggers
  • DB Support: JavaDB/Derby - Add support to create, edit, compile and drop of procedures and functions
  • DB Support: Mimer - Add support for creating and editing triggers
  • DB Support: Mimer - Add support to edit and compile procedures, functions and modules
  • DB Support: MySQL - Add support for creating and editing triggers
  • DB Support: MySQL - Add support to edit and compile procedures and functions
  • DB Support: Oracle - Add support for creating and editing triggers
  • DB Support: PostgreSQL - Add support for creating and editing triggers
  • DB Support: PostgreSQL - Add support to edit and compile functions
  • DB Support: SQL Server - Add support for creating and editing triggers
  • DB Support: SQL Server - Add support to create, edit and compile procedures and functions
  • DB Support: Sybase ASE - Add support for creating and editing triggers
  • DB Support: Sybase ASE - Add support to create, edit and compile procedures
  • Export - Export DDL and data for all or selected objects in a schema/database
  • General - Add "Check for update" feature to check if there's a new version available
  • SQL Commander - Add support for executing SQL with IN parameter markers, ex: WHERE ID = ? AND NAME LIKE ?
  • Tool Properties - Add feature to export/import user settings (properties, database connections, bookmarks, ...)
  • Improvements:
  • Database Profile: Actions - Add support for an action to prompt/handle parameter markers (i.e a "processmarkers" attribute for the tag)
  • Database Profile: Tree - variables in the section should not appear in the GUI unless visible="true" is added as attribute
  • DB Support: Oracle - Add new views for the Oracle Scheduler
  • DB Support: Oracle - Add support for enabling and disabling Oracle trace
  • DB Support: Oracle - Update the database profile for Oracle with support for viewing Redo Logs, Objects per Datafile/Tablespace, new actions, etc.
  • DB Support: Other - Add Netezza database type
  • Export - Provide support for user-defined export setting defaults
  • General - Make it possible to log to file instead of to the window
  • General - Move debug tool properties to debug window + add new debug window controls for save, copy, etc.
  • General - Upgrade all bundled JDBC drivers
  • Grid Component - "Select Row" in grid component should be "Select Row(s)"
  • Grid Component - Add "Match Exactly" in the Quick Filter popup menu
  • Import - Import should set data types of columns based on analyzing the data
  • Query Builder - Add an Execute Directly button in the Query Builder
  • SQL Commander - Clicking the log icon should select the corresponding statement in the editor, not replace the editor content with the statement
  • SQL Commander - Setting the database/catalog or schema in the SQL Commander should be reflected in the corresponding GUI elements
  • SQL Commander - Add option to easily format the SQL "FROM " and "TO "
  • SQL Commander - Copy/script to SQL Commander should ask what editor is target
  • SQL Commander - Re-design the variable dialog feature and allow for sorting, multi line editing, etc.
  • SQL Commander - SQL preview in substitution dialog shoud appear below the entry area and update instantly
  • SQL Formatter - Add additional SQL formatting options
  • SQL Formatter - Add option to format the current statement (at the cursor)
  • SQL Formatter - SQL formatting enhancements
  • Tool Properties - Make it possible to set a default file encoding via Tool Properties

New in version 6.0.14 (September 22nd, 2008)

  • Database Profile: Actions - Opening the action dialog doesn't put focus in first editable field
  • DB Support: Oracle - Error "isEditable Error: ORA-01219: database not open: queries allowed on fixed tables/views only" is displayed if unmount Oracle instance.
  • General - An exception is displayed if starting DbVisualizer with 2 identical command line arguments.
  • Grid Component - An extra row is inserted when pasting data from Excel into the table data grid.
  • Import - Import into Grid doesn't show or keep the grid window visible after import window is closed.
  • Monitor - Error appear in the Monitor if switching database connection for an existing monitor.
  • SQL Commander - Auto Completion doesn't work if the EXPLAIN keyword is first.
  • SQL Commander - Table data editor is not enabled if the WHERE clause is composed of a "IN/NOT IN (SELECT ...) clause.

New in version 6.0.13 (August 19th, 2008)

  • DB Support: Informix Index information in the objects tree for a specific table display erroneous or no information [http://www.minq.se/forum/thread.jspa?messageID=8494]
  • DB Support: JavaDB/Derby Default delimited identifier characters missing for JavaDB/Derby.
  • DB Support: Oracle DbVisualizer is not compatible with the JDBC 11.x (JDBC4) driver [http://www.minq.se/forum/thread.jspa?threadID=2405]
  • DB Support: SQL Server: "user" shown instead of "schema" for Stored Procedures, Functions and Triggers with SQL Server 2005 [http://www.minq.se/forum/thread.jspa?messageID=8513]
  • General: Help->Users Guide not showing
  • General: Loading user settings from version 4 may result in an error
  • Grid Component: Configuring a table data filter as a BETWEEN clause don't output the second value in the final filter
  • SQL Commander: SQL Commander is associated with the previous connection after selecting "[Choose Connection]" [http://www.minq.se/forum/thread.jspa?messageID=8587]
  • SQL Commander: The output buffer taking care of SQL warnings is limited to handle a maximum of 500 rows [http://www.minq.se/forum/thread.jspa?messageID=8618]
  • SQL Commander: With multiple SQL Commander tabs open, the database connection controls are disabled in all of them when disconnecting one of the connections [http://www.minq.se/forum/thread.jspa?threadID=2440]
  • SQL Commander: Execute a SQL that doesn't query a database table may take very long time to complete.

New in version 6.0.12 (June 26th, 2008)

  • DB Support: Informix - Separate system procedures and functions from user created procedures and functions in the objects tree
  • Export - Default format for numeric types in Export should be "Unformatted"
  • General - Re-introduce the pre 4.2 backward compatibility support so that old user settings files is loaded properly
  • Bug Fix: DB Support: DB2 - NullPointerException when executing SQL if the database connection is lost
  • Bug Fix: DB Support: PostgreSQL - Invalid FK clause in DDL for some tables
  • Bug Fix: DB Support: Sybase ASE - The DDL tab results in an error for Sybase versions prior to 12
  • Bug Fix: General - String auto-quoting truncates values for "[NOT] IN" conditions when quoted values contain delimiter characters (e.g., space)
  • Bug Fix: Navigator - Delete Selected Node is enabled even when no node is selected, and gives NullPointerException if clicked
  • Bug Fix: Navigator - The grid for a related table show incorrect values if the source table has been sorted
  • Bug Fix: SQL Commander - Any string starting with "go" is interpreted as the "go" delimiter

New in version 6.0.11 (May 29th, 2008)

  • Connection Properties: Delimited identifiers for database/schema
  • Connection Properties: The use of delimited identifiers with schema/database must be consistent
  • DB Support: JavaDB/Derby: The Alter Table dialog should allow columns to be dropped in Derby 10.3 and later
  • Always use delimited object names for all SQL issued automatically by DbVisualizer, regardless of property settings
  • Create/Alter Table: When adding a new column in the Alter Table dialog, the Auto Increment checkbox is always disabled
  • Database Profile: Actions: Add automatic scrollbars in the action dialog
  • DB Support: MySQL: Default values for NOT NULL columns are not included in DDL
  • DB Support: MySQL: The NULL declaration for a timestamp column (NOT NULL by default) is not shown in the DDL
  • DB Support: Oracle: Information about synonym objects is empty when looking at for example Info, Columns, Indexes, etc. for a Table
  • Export: Date, Time and Timestamp settings from Tool Properties are not used by Export in DbVisualizer Free
  • Export: Error occur when exporting data in a grid when the connection has been disconnected
  • Export: Table and column names are not delimited when export in SQL format. This may result in an erroneously generated SQL if these contain special characters or spaces
  • Form Editor: Error occur when using find/replace in the table data cell editor
  • Form Editor: Undoing a table data change in the Cell editor doesn't undo visually
  • Grid Component: Edit/browse cell in window don't work if value is null
  • Grid Component: The Data Type cells in the Create/Alter Table, Import and Import Column Mapper are empty while selected with the Aqua L&F on Mac OS X
  • Import: Import table data and the lists of data types are occasionally erroneous
  • OS Support: Mac OS X - The menu bar is always located in the DbVisualizer window instead of the standard top screen location in Mac OS X
  • Query Builder: Date literals are not automatically quoted in SQL
  • Query Builder: Strings containing character sequences also used as operators can cause problems when loading SQL into the Query Builder
  • Query Builder: The ignored comments/keywords warning dialog may truncate comments containing special characters, like ""

New in version 6.0.10 (April 11th, 2008)

  • SQL Commander: @spool log should output the complete log if auto clear is disabled and not the last execution
  • DB Support: DB2: Invalid DDL generated for View with "SELECT" as part of the name
  • DB Support: Informix: Connecting with a URL that does not specify a database results in an error
  • DB Support: Informix: The Schema list in the SQL Commander should be set to "no schema" by default
  • DB Support: Oracle: Invalid SQL used for Alter Table and DDL tab for Oracle versions older than 9
  • DB Support: Oracle: An Oracle error occur if scripting for example the SELECT SQL for a VIEW
  • DB Support: Oracle: DDL can not be displayed for foreign keys
  • DB Support: Other: Error populating Catalog/Schema lists when connecting with a JDBC driver that does not support getCatalogs() or getSchemas()
  • General: Identifier Delimiters are not used for schema/catalog in generated SQL even when enabled in Tools Properties
  • Import: Error when importing table data with blank date, time and timestamp
  • SQL Commander: Max Rows/Columns in SQL Commander are ignored until changed
  • SQL Commander: Reconnecting occasionally causes a ClassCastException

New in version 6.0.9 (March 17th, 2008)

  • Database Profile: Actions - Make it possible to cancel the Action dialogs during initialization
  • Import - Add option to map columns by name in an imported file with columns in the target database table
  • Fix: DB Support: Informix - Schemas that do not correspond to a user are not included in the Schema List
  • Fix: DB Support: Oracle - Synonyms sometimes not listed even if they do exist
  • Fix: Export - Format Date, Time and Timestamp data as appropriate for the selected database at export
  • Fix: SQL Commander - Opening a new SQL Commander tab freezes the GUI if the database is unresponsive

New in version 6.0.8 (February 25th, 2008)

  • Grid Component: The quick search feature must support searching for nulls
  • References: Add an option controlling if tables names should be qualified in the References and Navigator graph
  • SQL Commander: Allow selection of current schema in the SQL Commander for DbVisualizer Free
  • SQL Commander: Show "Elapsed Time" in the SQL Commander progress pane
  • Database Objects Tree
  • Database Objects Tree: The object tree filtering and "Show Only Default Database/Schema" results in an error if the object name contain a backslash
  • DB Support: DB2: DDL tab gives exception for Views where "AS" is not immediately followed by "SELECT"
  • DB Support: MySQL : Invalid ALTER statements generated by Alter Table for tables with ENUM or SET columns
  • DB Support: Oracle : There is a problem looking at synonymed objects located in another Oracle instance
  • DB Support: PostgreSQL: An error occur when the connection is interrupted with PostgreSQL
  • DB Support: PostgreSQL: Only tables and views should be listed in the auto completion popup for PostgreSQL
  • DB Support: SQL Server: Exception for Alter Table and DDL tab when IDENTIFIER_CASE = SENSITIVE
  • Export" If Variable Identifier is changed in Tool Properties then export in SQL format won't work
  • Form Editor: Show JPG thumbnails in the image viewer is very slow
  • Form Editor" The XML viewer fail to show the XML tree for any data type other than CLOB
  • Grid Component" Trailing and leading spaces not displayed in the Data tab grid
  • Grid Editor: Spaces and newline characters are removed from the beginning and the end of data that is pasted into the table data grid editor
  • Grid Editor: The inline table data editor may corrupt any control character(s) such as newline (
  • ), tab ( ) or carriage return ( )
  • Navigator: NullPointerException in Navigator when navigating with a FK column with a null value selected
  • Navigator: NullPointerException when reloading graph after refresh of the object tree
  • Navigator: Related Tables list is incorrect when multiple FKs link the same table
  • SQL Commander: Requesting Stop in the SQL Commander doesn't always stop execution

New in version 6.0.7 (December 7th, 2007)

  • [Improvement] Connection Properties
  • Add setting to control whether any connect/disconnect hooks should be executed
  • [Improvement] Create/Alter Table
  • Extend the space available for the lists in the FK and Unique Constraints tabs
  • [Improvement] Database Profile: Actions
  • Save the setting of "Format SQL" in the actions dialog between sessions
  • [Improvement] Database Profile: Actions
  • The DDL tab and Alter Table dialog are slow to display
  • [Improvement] DB Support: Oracle
  • Add new support for: Clone User, File IO view, Enhanced Tablespace usage, Resize Datafile, View Trigges
  • [http://blog.nathanaaron.net/?page_id=32]
  • [Improvement] DB Support: Oracle
  • Add support for the following objects: Job, Database Links, Directories, Table and Index Partitions
  • [http://blog.nathanaaron.net/?page_id=32]
  • [Improvement] Grid Component
  • In grids with row header, highlight the text for selected row(s)
  • [http://www.minq.se/forum/thread.jspa?threadID=2159]
  • [Improvement] Tool Properties
  • Make it possible to define how boolean/bit data should be presented
  • [Bug] Database Objects Tree
  • Having a filter on a non text column in the objects tree results in an error when entering a filter value in DbVisualizer
  • [http://www.minq.se/forum/thread.jspa?threadID=2140]
  • [Bug] Database Objects Tree
  • The "( Default )" label in the objects tree is not visually moved when changing default database/schema with a connection hook
  • [http://www.minq.se/forum/thread.jspa?threadID=2111]
  • [Bug] Database Profile: View
  • Using non text data in the grid right click "menuItems" results in an error
  • [http://www.minq.se/forum/thread.jspa?threadID=2140]
  • [Bug] DB Support: DB2 z/OS
  • Schema name filtering doesn't work
  • [http://www.minq.se/forum/thread.jspa?threadID=2067]
  • [Bug] DB Support: DB2 z/OS
  • The generic Create Table feature doesn't display
  • [Bug] DB Support: Firebird
  • Connection wizard produce an erroneous URL for the Firebird database
  • [Bug] DB Support: Informix
  • Invalid DDL generated for View with "SELECT" as part of the name
  • [Bug] DB Support: Informix
  • SELECT from unqualified table name may result in read-only result set in the SQL Commander
  • [http://www.minq.se/forum/thread.jspa?threadID=2150]
  • [Bug] DB Support: MySQL
  • Browsing table or view DDLs in MySQL with JDBC driver version 5.0.8 or later results in an error
  • [Bug] Export
  • Using @export with Excel output format may result in error if empty result set
  • [Bug] Grid Component
  • Creating a filter via the grid right click "Filter" menu options may refer wrong column if a column is not visible
  • [http://www.minq.se/forum/thread.jspa?messageID=7498]
  • [Bug] Grid Editor
  • Data tab filtering doesn't quote text data with special characters in it
  • [http://www.minq.se/forum/thread.jspa?threadID=2131]
  • [Bug] Grid Editor
  • Editing table data in form editor with a quick filter active results in a NPE
  • [Bug] Grid Editor
  • ESC key doesn't close the Filter window
  • [http://www.minq.se/forum/thread.jspa?messageID=7394]
  • [Bug] Grid Editor
  • If the physical database connection is dropped and then save result set data edits a NPE error occur
  • [Bug] Grid Editor
  • Inserting a new row in an empty table that is sorted via the column header results in an error
  • [Bug] Import
  • Import preview is not updated when changing for example "Header in First Row"
  • [http://www.minq.se/forum/thread.jspa?messageID=7493]
  • [Bug] Import
  • Importing an empty number field is not converted to null
  • [http://www.minq.se/forum/thread.jspa?threadID=2157]
  • [Bug] OS Support: Mac OS X
  • Mac OS X 10.5 (Leopard): Help menu take ages to show and main menus are slow in general
  • [Bug] OS Support: Mac OS X
  • Mac OS X 10.5 (Leopard): NullPointerException when clicking in the query builder diagram pane
  • [Bug] OS Support: Mac OS X
  • Mac OS X 10.5 (Leopard): Row number and editing icons don't show in the Data tab or in result sets
  • [Bug] OS Support: Mac OS X
  • Mac OS X 10.5 (Leopard): Table nodes in the Query Builder cannot be resized
  • [Bug] Query Builder
  • Load to Query Builder fails to find a table if the name in the SELECT does not match the name in the database in a case-sensitive manner
  • [Bug] SQL Commander
  • "No rows were affected" is always logged even though table rows were affected (ex: commit/rollback)
  • [Bug] SQL Commander
  • @spool log client side command never executed if @stop on error/warning enabled and an error/warning occur
  • [http://www.minq.se/forum/thread.jspa?messageID=5795]
  • [Bug] SQL Commander
  • The SQL Commander leaks memory

New in version 6.0.6 (October 16th, 2007)

  • Connection Tab: An exception error may be reported when connecting
  • Export: Apostrophe is exported as ' in HTML exports and are not rendered properly by all browsers. Should be '

New in version 6.0.5 (October 8th, 2007)

  • Improvements
  • DB Support: Oracle indexes of table are only shown when the index is in table owner's schema
  • DB Support: Oracle List all objects stored in tablespaces
  • Bug
  • Connection Tab: If database connection cannot be established in "invisible" mode then DbVisualizer hang and never finish
  • Create/Alter Table: Alter Table and DDL tab do not work for SQL Server 7 and 2000
  • DB Support - MySQL: UNSIGNED data types not supported in Create/Alter Table dialogs
  • DB Support - Oracle: Running a query for Oracle may be slow if not qualifying table name with the schema
  • Export: Export to clipboard doesn't work
  • SQL Editor: Syntax coloring doesn't handle strings with escaped double quotes properly

New in version 6.0.4 (September 26th, 2007)

  • Improvement
  • Connection Tab: Allow editing the database URL in a multi line editor
  • Connection Tab: It should be possible to launch the URL Builder in the Connection tab
  • DB Support - Oracle: Show active sessions and their SQLs
  • [http://www.minq.se/forum/thread.jspa?threadID=2040]
  • DB Support - Mimer: Add support for databank in the Create Table dialog
  • Bug Fixes
  • Create/Alter Table: Alter Table and DDL tab do not work for SQL Server 7 and 2000
  • Database Profile - Actions: The Create Index action generates an erroneous SQL in the generic profile
  • DB Support - SQL Server: Size not recognized for VARCHAR(MAX) columns in Alter Table
  • Navigator: The Navigator doesn't show the data for selected table
  • [http://www.minq.se/forum/thread.jspa?messageID=7167]

New in version 6.0.3 (September 18th, 2007)

  • New Feature
  • DB Support: Mimer - Add support for databank in the Create Table dialog
  • DB Support: Oracle - Add actions for Datafile management (Add, Remove)
  • DB Support: Oracle - Add actions for Rollback Segment management (Create, Remove, etc)
  • DB Support: Other - Add actions for Tablespace management (Create, Remove, Offline, Online, etc)
  • Improvement
  • Database Profile: Actions - Convert the "Create Index" feature to be based on the actions framework add delimited identifier support
  • DB Support: DB2 - Add support for Sequences in DB2
  • [http://www.minq.se/forum/thread.jspa?messageID=7022]
  • DB Support: DB2 - IDENTITY columns not supported in DDL generation and Create/Alter Table dialogs
  • DB Support: DB2 - Show columns for tables in the objects tree
  • DB Support: JavaDB/Derby - Show columns for tables in the objects tree
  • DB Support: MySQL - Show columns for tables in the objects tree
  • DB Support: Oracle - Add action to compile all invalid objects
  • DB Support: Oracle - Add connection property to control whether schema list should show empty schemas or ignore them
  • DB Support: PostgreSQL - Show columns for tables in the objects tree
  • DB Support: SQL Server - IDENTITY columns not supported in DDL generation and Create/Alter Table dialogs
  • DB Support: SQL Server - Show columns for tables in the objects tree
  • DB Support: Sybase ASE - IDENTITY columns not supported in DDL generation and Create/Alter Table dialogs
  • [http://www.minq.se/forum/thread.jspa?threadID=2070]
  • DB Support: Sybase ASE - Show columns for tables in the objects tree
  • Export - Excel export doesn't handle Unicode properly
  • SQL Commander - Show database connection name in result set tab tip [http://www.minq.se/forum/thread.jspa?messageID=7077]
  • Bug
  • DB Support: DB2 z/OS - Table name filtering for DB2 on z/OS doesn't work [http://www.minq.se/forum/thread.jspa?threadID=2067]
  • DB Support: Informix - Drop and Empty Table actions doesn't work for Informix [http://www.minq.se/forum/thread.jspa?messageID=7029]
  • DB Support: JavaDB/Derby - Problem showing BLOB data in Derby 10.3.1.4
  • DB Support: MySQL - DDL for ENUM and SET with just one element gives NumberFormatException
  • DB Support: MySQL - Table name object filter doesn't work with MySQL version 4 and older
  • DB Support: SQL Server - Table DDL functions (Alter Table, DDL tab) does not work for SQL Server 7
  • Export - Excel export fail if the result set table name is longer then 31 characters or include special characters
  • Export - Nothing happen when moving rows up and down in the export columns setup
  • Export - The export preview pane clears the system clipboard
  • Grid Editor - "Mark Selected Cells as Edited" reverts any cells to their original values in the table data editor [http://www.minq.se/forum/thread.jspa?messageID=7126]
  • Import - Cannot select a file column name for mapping to table column name [http://www.minq.se/forum/thread.jspa?messageID=7063]
  • Navigator - Label show incorrect values for sorted source tables
  • Query Builder - Loading SQL from the SQL Editor into the Query Builder sometimes results in wrong tables with similar name being loaded in the Query Builder
  • Query Builder - With more than one instance of the same table, joins can only be made to one of them