DbVisualizer Changelog

What's new in DbVisualizer 24.1.1

Jan 28, 2024

Add support for the WIDTH_BUCKET scalar function
Add a new setting to show the Log tab when SQL warnings occur
Add support for styling delimited identifiers and labels in the new editor
Add support for expanding editor templates using the tab key in the new editor
Add support for multi-caret mode in the new editor (supersedes rectangular selection in previous versions)
Redesign the Editor Templates section in Tool Properties
Bug fixes:
Auto-completion of joins does not work in certain cases
Auto-completion does not work following a :: cast
Auto-completion does not work after DbVisualizer variables
Auto-completion does not work following a column alias that matches a reserved keyword
Exception when auto-completing columns in complex WITH statements
Instant substitution of editor templates does not work
Exception when auto-completing table names with too many qualifiers
Improved auto-completion in delimited identifiers with embedded comments
SQL Preview in Alter Table does not repaint properly
Renaming a column in Alter Table produces broken SQL
MySQL backslash escape not coloured correctly in the editor
Exception showing Access Key when using legacy Redshift drivers
Exception when parsing Snowflake connection strings
"Deselect All" in Export Settings doesn't deselect individual database connections
Result grid is not editable for tables with names that match reserved keywords
Exception when exporting grid data after disconnect
Performance issues with scripts that generate many errors
Optimise memory usage when working with large files in the new editor
Optimised "Replace All" for the case when there are many matches
Undo after load clears the procedure editor
Contents of the procedure editor is still marked as edited after save
Editor cursor disappears when discarding changes in a stored procedure
Regression: vertical scrollbar in SQL Commander is cut off if the window is small enough
"Comment Line" should move the caret to the beginning of the next line
Improved error handling in @run, @open, @cd and @log
"Add Selection as Template" does not work
Exception when the target filename in @export is invalid
"Show Object at Cursor" doesn't work
Exception when parsing tokens in SQL scripts
For some editor templates, description is not displayed in the auto-completion popup
Issues with Replace/Replace All when using group references
Use canonical paths to avoid potential duplicates in the list of recent workspaces
Adjust shutdown/restart messages to clarify that only the current workspace is affected

New in DbVisualizer 23.2.5 (Oct 3, 2023)

New in DbVisualizer 23.2.4 (Aug 15, 2023)

New in DbVisualizer 23.2.3 (Jul 13, 2023)

New in DbVisualizer 23.2.2 (May 16, 2023)

New in DbVisualizer 23.2.1 (May 10, 2023)

New in DbVisualizer 23.2 (May 10, 2023)

New in DbVisualizer 14.0.3 (Jan 2, 2023)

New in DbVisualizer 14.0.2 (Nov 23, 2022)

New in DbVisualizer 14.0.1 (Oct 14, 2022)

New in DbVisualizer 14.0 (Sep 20, 2022)

New Features:
Connection Setup SSH:
Support to share a SSH configuration for multiple database connections
DB Support: Cassandra:
Add support for Cassandra
DB Support: Google BigQuery:
Add support for Google BigQuery
DB Support: Microsoft Access:
Add support for Microsoft Access
DB Support: SingleStore:
Add support for SingleStore
Improvements:
@import:
Add the format="xxx" argument for @import
Connection Setup:
Automatically reconnect when connection is lost
Connection Setup Security:
SSH tunnels can now be used in DbVisualizer Free
DB Support: Azure SQL:
Add support to view, create, drop, and change password for users
DB Support: Azure SQL:
DB Support: SQL Server:
Introduce a "constraints" sub node to show primary, foreign keys, and referenced tables
DB Support: Greenplum
DB Support: PostgreSQL
DB Support: Redshift
DB Support: SQL Server
DB Support: Yellowbrick
Add support for killing sessions
DB Support: H2:
Add support for H2 version 2.x
DB Support: PostgreSQL:
Support generating comment statements for triggers
Add support for generated columns in PostgreSQL Create/Alter
DB Support: SQL Server:
Add support for create, modify, and drop of users and logins
Data tab:
Having a where filter in the Data tab should show a different icon
Driver Manager:
Used By column in the driver manager should when clicked show a list of database connections
Add "Reset Driver" command in driver manager
Export:
Restrict formatting of numbers for SQL exports
Support exporting in TXT also for @export, Export Table and Export Schema
File Chooser OS Support: Windows:
The choice of "list" or "details" in file choosers should be preserved between DbVisualizer sessions
Filtering/Filter Sets:
Make it possible for table filters to be removed after a certain time
General:
Make progress windows larger
Change icon for "duplicate" (yellow start) to the standard "copy" icon
Add icon to external web links to highlight that a browser will be opened
Grid Component:
Add option to show images in binary type columns in grid
Add "Extract Filter & Sort as SELECT" action in Data tab. Used to copy the SELECT statement in Data tab including any grid column filters and sorting
Import:
When Batch Import, commit at every executed batch
Make it easy setting data type for the multiple columns during import to new table
Make "Batch Import" default
Java 17:
Bundle Java 17 with installers
Support the ed25519 algorithm for SSH
OS Support: Windows:
Remove support for Windows 32-bit
OS Support: macOS:
The DbVisualizer window title bar background should follow General / Appearance setting in macOS System Preferences
SQL Commander:
Add "@command ignore/resume" to ignore/resume executing any client-side commands
Add the "@stop now" client-side command used to stop the execution of the script
SQL History:
Make "Search Full Script" default in SQL History
Bugs Fixed:
DB Support: Exasol:
Incorrect primary key order in table DDL
Mail Support:
Creating a mail server account in Tool Properties without Apply, and then Send Test mail results in an error
SSH:
If SSH connect doesn't succeed, pressing disconnect, and then connect again, nothing happens
Tilde sign ('~') doesn't translate to user's home folder for SSH config, known hosts, and private key files

New in DbVisualizer 13.0.5 (Aug 25, 2022)

Improvements:
Connection Setup
DB Support: Oracle
Add configuration option to skip add join alternatives in auto completion
DB Support: PostgreSQL
Improve the PostgreSQL profile to include new columns when getting triggers meta data
Driver Manager
A Reset Driver action which will restore the driver to its default settings
Bugs Fixed:
Auto Completion
Auto complete always uses white as highlight color
Connection Setup
Setting Database Userid to '(null)' should skip passing it to JDBC driver at connect
DB Support: Azure SQL
DB Support: Mimer SQL
DB Support: Redshift
Installation/Update Installation
Blank connection settings changed to being set after upgrade to DbVisualizer 13 (E.g Mimer programpasswd)
DB Support: JavaDB/Derby
ClassCastException when Alter Table with Derby
DB Support: MongoDB
Error running a query in MongoDB
DB Support: MySQL
References
Loading references may hang and task cannot be stopped
DB Support: Oracle
The tnsnames.ora file is not parsed for multiple aliases
DB Support: PostgreSQL
Missing info in DDL for Postgres function
Add DDL for "generated" columns in PostgreSQL
DB Support: PostgreSQL
Procedure Editor
PostgreSQL trigger DDL does not include UPDATE OF column list
DB Support: Vertica
Projection Storage tab for a table in Vertica results in an error
Data tab
DB Support: SQL Server
Exception when scripting a linked server
Driver Manager
Importing a driver results in an error if there already exists a driver with the same name
Filtering/Filter Sets
Compress recent filters in the Data tab when saving to disk
Grid Component
Regression with Ctrl+C/CMD+C as it now doesn't work to copy from property tables such as Connection tab, details pane in Scripts tab, and more
Import
Import Table Data: Mysterious character replacements
Import Table Data thinks size should be 3,0 when it should be at least 4,0
SQL Commander
Tab names may not be presented properly in the tool tip for SQL Commander tabs, and in the search open tabs dialog
@DELIMITER Command is formatted by the SQL formatter
Scripts
Create Linked Folder results in "process has not exited"

New in DbVisualizer 13.0.4 (May 24, 2022)

New in DbVisualizer 13.0.3 (Apr 11, 2022)

New in DbVisualizer 13.0.2 (Mar 21, 2022)

New in DbVisualizer 13.0.1 (Mar 9, 2022)

New in DbVisualizer 13.0 (Mar 3, 2022)

New Features:
DB Support: Elasticsearch:
Add support for Elasticsearch
DB Support: MongoDB:
Add basic support for MongoDB and BSON data viewer
DB Support: Presto:
Add support for Presto
DB Support: Trino:
Add support for Trino
Driver Manager:
Improve the driver management to support download drivers from Maven, version selection and more
Installation/Update Installation:
Add an installer for Apple Silicon, M1
SQL Commander:
SQL Editor:
A new feature to search across all open commander windows
Improvements:
Connection Setup:
Allow copying the actual database URL from the link
Connection Setup Driver Manager:
Add possibilities to set overridden driver properties centrally
Driver properties with pre-defined list of values should be promoted in a drop-down
Connection Setup SSH:
Add support for ssh-agent with SSH Tunnel
DB Support: Exasol:
Add "certificate Fingerprint" for Exasol connections
DB Support: Google BigQuery:
Add driver entry for Google BigQuery
DB Support: Greenplum
DB Support: H2
DB Support: Netezza
DB Support: PostgreSQL
DB Support: Redshift
DB Support: Snowflake
DB Support: Yellowbrick
Add "Rename Schema" in PostgreSQL
DB Support: Oracle
Copying a scheduler job can only be created in connection user's schema
DB Support: PostgreSQL
Add "CASCADE" to Truncate
DB Support: SingleStore:
Create driver entry and database type for SingleStore
DB Support: Snowflake:
Improve support for authenticator=externalbrowser
Database Objects Tree:
Give the option (or by default) to color visited table names
Driver Manager:
Dynamic OS specific libs should be loaded from driver jar files rather than setting java.library.path
Filtering/Filter Sets:
The Database Objects Filters editor should show and allow editing the label1 attribute for DataNodes
Grid Component:
Add a "Reset Grid" action to remove any current quick filters, column filters, sorting, and selection
Installation/Update Installation:
Should be possible to change the location of included user.vmoptions referenced in dbvis.vmoptions
Installation/Update Installation:
Web:
Remove the UNIX installers, replaced by Linux installers
Performance/Stability:
Increase the default value for -Xmx from 768m to 2048m
SQL Commander:
Reload of file should preserve current selection, scrolling, and caret position
SSH:
Support openssh config behavior to handle append, prepend and removal of algorithms
Scripts:
Open multiple script files at once
Bugs Fixed:
Driver Manager:
Unknown driver properties sent to database

New in DbVisualizer 12.1.8 (Jan 21, 2022)

New in DbVisualizer 12.1.7 (Jan 14, 2022)

New in DbVisualizer 12.1.6 (Jan 11, 2022)

New in DbVisualizer 12.1.4 (Oct 17, 2021)

New in DbVisualizer 12.1.3 (Oct 17, 2021)

New in DbVisualizer 12.1.2 (Aug 25, 2021)

New in DbVisualizer 12.1.1 (Jul 24, 2021)

New in DbVisualizer 12.1 (Jul 13, 2021)

New in DbVisualizer 12.0.8 (Jun 14, 2021)

New in DbVisualizer 12.0.7 (Jun 14, 2021)

New in DbVisualizer 12.0.6 (Jun 7, 2021)

New in DbVisualizer 12.0.4 (Mar 16, 2021)

New in DbVisualizer 12.0.3 (Mar 2, 2021)

New in DbVisualizer 12.0.2 (Feb 14, 2021)

Improvements:
Connection Setup:
Ensure database, port, and database fields in the connection setup tab are trimmed from whitespaces
DB Support: Exasol
Update the Exasol database profile
Change the default timeout for Exasol driver from 0 to 10 secs
Grid Component:
Show count of selected rows/columns in grid status bar
Bugs Fixed:
Cell Viewer/Editor:
Error when editing JSON data
Not possible to edit after failure in launching the XML viewer
Cell Viewer/Editor, Grid Component, Tool Properties:
Setting decimal format with adjusted grouping and decimal delimiters may break data
Create/Alter Table:
Changing column name in Create Table dialog for a primary key doesn't rename the primary key
DB Support: DB2 LUW
DB Support: DB2 iSeries
DB Support: DB2 z/OS
CHAR FOR BIT DATA in Db2 are handled as CLOB and not binary
DB Support: Oracle
Executing of an Oracle procedure occasionally fail
DB Support: PostgreSQL
Database Objects Tree:
Connecting to a catalog database that fail in the Databases tree, and then re-connecting it, still shows the error but is expandable
Data tab:
Requesting Stop in the Data tab grid doesn't show any data fetched
Explain Plan:
Copy in explain output details grid throws an exception
Export:
Exception when exporting data
Export/Import User Settings:
Some in-progress dialogs are displayed behind of existing dialogs or not at all
Grid Component:
Paste of data may give: "Unicode String: Row data at 0/0 is null!"
Key Bindings:
'Search Action' field in key binding tool properties cleared when swing back and forth to other window
Object View:
Theme: FlatLaf
The "there are no details" object view pane may contain a previously displayed component
References:
Showing the "List" of tables in References is sometimes empty
SQL Commander:
Getting joins for auto completion is slow
Editor templates are not being completly replaced
Visual artifact in result tabs showing an erroneous close (X) button and when clicked resulting in an error
SQL Editor:
Parsing with two delimiters does not work due to regression in 12.0
Copy selection as 'IN' clause should preserve order
Theme: FlatLaf:
Changing theme doesn't properly update some visual components unless restarting DbVisualizer
Tool Properties:
DbVisualizer hangs when opening Tool Properties using 32-bit Java on Windows

New in DbVisualizer 12.0.1 (Jan 29, 2021)

New in DbVisualizer 12.0 (Jan 25, 2021)

New Features:
DB Support: Azure SQL
Add support for Azure SQL Database
DB Support: Greenplum
Add support for the Greenplum database
DB Support: IBM DB2 on Cloud
Add support for IBM DB2 on Cloud
DB Support: Oracle Cloud
Add support for Oracle Cloud
DB Support: Oracle MySQL Cloud
Add support for Oracle MySQL Cloud
DB Support: Yellowbrick
Add support for the Yellowbrick database
Theme:
Introduce the new FlatLaf Light and Dark themes
Improvements:
Support for BOM identifier in files
Auto completion in SQL editor should match anywhere with the specified pattern on not only from beginning of the target names
Add Auto Complete for JOIN clause
Bundle the SQL Server JDBC driver (for SQL Server and Azure)
Should offer a "Generate CREATE with Storage" option when DDL is generated
Explain for DB2 LUW needs more details
Add keywords for new Exasol version
Update the database profile for Mimer SQL 11.0
Database Profile: Tree
For triggers in PostgreSQL show any related functions for the trigger in the databases tab
Support for new data types in PostgreSQL 13
Add "External Tables" and "Materialized Views" for Snowflake
Allow to configure key binding for "Reload with Filter" in the Data tab
Description for opening an object from a connection in Users Guide does not seem correct
Enabling "Show only default Database/Schema" should de-activate any custom filter for these object types
Introduce new flat icon collection
Allow to configure key binding for Execute in the "Enter Data for Variables" window
OS Support: Windows
Add support for Java 11 on Windows
When columns are sorted in query builder table nodes, any primary keys should be presented first
Reference Graph should allow highlighting columns for a specific relation
Highlight selected tables in References View
Enhance the SQL Statement Parser to eliminate the need for block enclosures when running complex SQL statements (enabled under General / SQL Commander / Statement and the Allow SQL dialects setting)
SQL Editor
Allow changing editor highlighting color in tool properties
Update the JSch library which resolves a few connection issues over SSH
Bugs Fixed:
Alter column statements are generated even with no changes Alter Table window
Data types are not refreshed when launching the Create/Alter Table dialog
MySQL Time data type may hold times from '-838:59:59' to '838:59:59' while the JDBC Time type only accepts '00:00:00' to '23:59:59'
Strings are escaped while they shouldn't with MySQL
Any single quotes in comments needs to be escaped
SQL block problem with dialect for Vertica
Field value not usable in Confirm if the field is not editable
Data export as SQL: wrong table name inserted when loading export settings
NPE when canceling an export
Grid Component
Rare exception when copy in a grid
Names and tooltips of DBMS Output enable/disable buttons refer to "Oracle DBMS Output"
Strange selection when selecting to end of line
Auto highlight in the SQL editor should not highlight if whitespaces or non chars are selected
Having a filter or sort in the SQL Log grid, any click on the command or error link in the grid will not highlight the matching entry in the editor
Theme: FlatLaf
Extra border around combo boxes in connection tab variable dialog

New in DbVisualizer 11.0.5 (Sep 14, 2020)

New in DbVisualizer 11.0.4 (Jul 9, 2020)

Improvements:
@import Trim text field on import for all import types
DB Support: Exasol Updates for Exasol 7
DB Support: Redshift Upgrade the Redshift driver to support IAM authentication
DB Support: Snowflake Show server parameters under DBA->Server Info
Bugs Fixed:
@import Strange results during @import
@import shows failure at end of data
Connection Setup The 'Global Properties' link in connection properties doesn't work
Create/Alter Table
DB Support: PostgreSQL
DB Support: Snowflake When setting Nullable or Default in Alter Table the column name is not delimited potentially leading to "column not found"
Create/Alter Table
DB Support: SQL Server SQL Server DATETIME2 type precision lost when doing Alter Table
DB Support: Informix
DDL Generator Showing DDL for functional index doesn't work
DB Support: MySQL Export of embedded special characters in data should be escaped
DB Support: PostgreSQL Wrong DDL generated for Index if index column contains expression
DB Support: PostgreSQL
Export Bug while exporting schema in SQL file (PostgreSQL)
DB Support: SQL Server
Import Importing CSV automatically maps Strings to SSN type
Export Can not open exported excel file
Open in Spreadsheet with a 1M rows result set, shows the in progress dialog and when stopped, DbVisualizer works as normal but CPU runs high
File Chooser Regression in 'Clear All Recent Paths' action in File Chooser->Recent Paths drop-down
Grid Component Making a column visible in the column chooser doesn't work
Import Cannot clean old imports if one or more files or directories in the import directory lack read access
Mail Support Clicking Apply in the Tool Properties window, the currently selected Mail Server account resets to the first in list
SQL Commander Any exception during script pre processing is not reported
A quoted string containing an escaped quote and single line comment identifiers may result in errors
When merging small but wide result sets the horizontal scrollbar is invisible
SQL Editor Regular-Expression-Replacement does not work as expected with $
SQL Formatter The SQL formatter converts TABLESPACE to TABLE
Formatting splits schema

New in DbVisualizer 11.0.3 (May 21, 2020)

New in DbVisualizer 11.0.2 (May 21, 2020)

New in DbVisualizer 11.0.1 (Apr 30, 2020)

New in DbVisualizer 11.0 (Apr 10, 2020)

New Features:
@import Add a client-side command for import allowing to import table data in SQL scripts
DB Support: MariaDB Add support for MariaDB
DB Support: Snowflake Add extended support for Snowflake
Mail Support:
SQL Commander Add @mail client side command used to email the result set from a query or file
SQL Commander Add a "Morph to Delimited List" function in the SQL Commander
Add new @open <file | URL> command used to open file in associated program or URL in web browser
Improvements:
Cell Viewer/Editor Add options to format/unformat JSON in the cell editor
Chart Resizing Charts on export distorts geometry
Add more color schemes for charts
Command Line Support (dbviscmd) dbviscmd should prompt for variables in connection details and variables used in scripts
The dbviscmd script should use the same environment and JRE detection as the launcher for the GUI (dbvis)
Create/Alter Table:
DB Support: MySQL Add support for check constraints in the Create/Alter table dialog for MySQL
Create/Alter Table:
DB Support: Oracle Make it possible to change the visibility of a column through the Create and Alter table dialog
DB Support: DB2 LUW Add user and role information for DB2 LUW
DB Support: Exasol Always pass SQLs to the Exasol database with LF instead of CRLF line separators
Enable the Procedure Editor for UDFs and Functions in Exasol
DB Support: MySQL:
DDL Generator Improve support of the ON UPDATE clause for temporal types for MySQL
DB Support: MySQL:
Procedure Editor Automatically set SQL Mode when editing Procedures and Functions
DB Support: PostgreSQL:
Query Builder Add support for ~, !~, ~*, !~* operators in the Query Builder for PostgreSQL
Data tab Add capability to set a key binding for the generic "Stop" action
Option to prevent any filter from being used when loading a table during its first display
Data tab should have a "Reload with Sorting as ORDER BY" action used to reload from database using a ORDER BY clause defined by the current sorting in the grid
Database Objects Tree Show all contained database connections when selecting a database connections folder
Need capability to make it easier to scope what database connections that should be updated in multi connections edits
Database Objects Tree:
Database Profile: Commands For DB2 LUW and using the Generic profile, there is a (null) catalog node in the Databases tab
Driver Manager Update bundled JDBC drivers
Export For Excel exports, the "Include original SQL" setting in Export Grid and for @export ExcelIncludeSQLCommand parameter should allow: "sheet" parameter in addition to "none", "top", "bottom"
The Open as Spreadsheet action should put the SQL in a separate sheet
Rename "XLS" output format to "Excel" and accept "XLS" or "XLSX" (default) in the "ExcelFileFormat" parameter in @export
Add "Auto Resize Columns" for Excel export
Add new "Export Visible" and "Open Visible as Spreadsheet" actions for grids that considers any current filters, sorting, and visible columns in the grid
Favorites Opening a favorite object for a database connection that fail to establish give no visible feedback that there is a problem
Grid Component Add a new Copy Selection As->Copy Selection as AND/OR clause
Key Bindings Possible to assign a modifier with TAB as key binding
Should be possible to easily browse all available keyboard shortcuts
Key bindings editor need a filtering/search capability to locate an existing key binding and filtering
References Selected table nodes in the references graph should not change background color
When Highlight Links is checked, do also color code the associated column names in the source and target nodes
Table references to self (same table) should attach to the corresponding column names when using Hierarchic layout and not in random positions
Certain controls in the References graph requires Hierarchic layout. Highlight this condition for controls when not using hierarchic layout mode
SQL Commander Add new "Set Modified State when Scripting" setting in Tools->Tool Properties under General / SQL Commander
Add "Change Default Values..." in the SQL Commander Options menu and SQL Commander toolbar drop-down
Show the full path for the current database connection when hovering the Database Connection drop-down
Have an option in SQL Commander to generate a dbviscmd command string that can be pasted in a terminal
Refresh of the object tree (as a result of for example filtering) does not refresh the Catalog/Schema drop-down lists
SQL Editor Offer GUI help for regular Expression replacement text (similar to the helper for the Find text)
Show visible margin at user specified column
Add support for adding linefeed, tab etc. in the replacement text in the Replace dialog
SQL Formatter Allow setting indent for joins INNER, LEFT OUTER, RIGHT OUTER
Allow for having multiple SQL Formatting profiles
SQL Formatter should use the keyword lists defined for each supported database (use when for example upper/lower case keywords)
Make it possible to add custom keywords that are upper/lowercased along with standard
Introduce a new SQL Formatter:
Add multiple indentation levels and other improvements
The Format SQL->Copy/Paste Formatted should allow setting that formatting should not be applied
SQL Log Allow configuring what columns and order should be displayed in the SQL Log tab for SQL Commanders
Table Data Editor Add a link to tool properties when the "Number of rows limited by <link>Max Rows at First Display</link> setting" balloon in the data tab is displayed
Tool Properties Allow user to edit the sample text when choosing fonts
Bugs Fixed:
Auto Completion Having Fully Qualify Objects for Auto Completion and then AC a table name, database.null.table is inserted
Chart When exporting graph the width and height does not always honor the selected orientation
Connection Setup Copying driver property name copies the wrong name if entries are filtered
DB Support: DB2 LUW:
SQL Commander Stopped query leaves locks on SYSIBM tables
DB Support: H2 DDL Tab for Table with Identity columns are not generated correctly when H2 1.4.199 is used
DB Support: PostgreSQL For some PostgreSQL installations the pg_catalog.pg_database is empty resulting in no databases being displayed in the databases tab
Space is inserted in middle of Operator when formatting
Data tab Generate Filter for quoted string fails
Data tab:
Grid Component NULL and duplicated values not handled properly in "Copy Selection as IN Clause" and "Generate Filter & Sort"
Database Profile: Actions Main windows locks when shutting down action dialogs in the wrong order
Explain Plan:
Performance/Stability Show confirm dialog when executing explain plan with multiple statements
Export Exporting Binary/BLOB to File with JSON format outputs the binary data as is rather than the special ${data8-1||blob/8.png||BinaryData||noshow vl=file}$
Export:
Import Malformed XML generated when export DbVis style XML
OS Support: Linux Application icons on Linux are blurry when placed on desktop, and present in the application (task) switcher
Procedure Editor:
SQL Editor The line break style (CRLF or LF) should be retained when editing an existing file or database code object
Query Builder Conditions tab tree row heights are too small when loading a query in the query builder
References Remove link "handles" in the references graph that are visible on self referencing tables
SQL Commander Find and Replace with regular expression does not work
Some ${dbvis-xxx}$ variables are not case sensitive
SQL Editor Using Ctrl+A/Cmd+A keybinding to Select All will not enable some right-click actions unless opening the menu again
SQL Formatter When applying the SQL formatter the schema name in some situations may be preceded by blanks
UNLOGGED keyword with create table statement breaks formatting
Script Table as INSERT adds the schema in uppercase when SQL formatted
Having comments in a WITH clause breaks the SQL formatting
Format with string literals longer than max Line Width results in invalid SQL
Scripts If focus not in the Scripts tab, renaming a file using right-click immediately cancels the editing

New in DbVisualizer 10.0.25 (Jan 24, 2020)

New in DbVisualizer 10.0.24 (Jan 24, 2020)

New in DbVisualizer 10.0.23 (Oct 23, 2019)

Improvements:
Auto Completion Column names should be auto completed even though preceded by "top <number>"
Compare
Docs: Users Guide Improve usability of the Compare functionality
Connection Setup The connect window should show database connection name in window title
Offer quick search in Driver Properties tab for a database connection
DB Support: Redshift Upgrade the Redshift JDBC Driver to 1.2.34
DB Support: TIBCO
Database Objects Tree All Schemas from every catalog display under each individual catalog when connected to TIBCO Data Virtualization
Database Objects Tree Have an option to set that columns in the Databases tab are sorted alphabetically. (Right-click in Databases tab and select "Sort...")
General The dbviscmd and dbvisgui command scripts should use any JRE that is bundled with the DbVisualizer installation, and then look in the PATH or the JAVA_EXEC environment variable
Grid Component Change default horizontal scrolling in grids to variable (was column)
Look and Feel: macOS
OS Support: macOS Make the unselected tab color darker for the macOS look and feel
Tool Properties Add "Global Properties" link in the connection properties panes
Bugs Fixed:
Command Line Support (dbviscmd) The command-line interface, dbviscmd should run even if logging can not be initiated
dbviscmd does not honor the connection property for "Strip Comments when Executing"
Compare
Grid Component Editing grid shifts focus to the compare view if compare view is open for the same grid
Compare
SQL Editor Undo in original editor not possible after compare
Connection Setup Setting default values for driver properties in drivers.xml should not result in the error balloon being displayed
Contact Support Exception when system clipboard is not available
DB Support: Oracle Exception when creating a Job object with Oracle 11.2
An error may be reported if changing the Attribute for a Scheduler Job object
DB Support: PostgreSQL Non unique Index is marked as UNIQUE in the DDL tab
DB Support: Redshift Stored procedures in Redshift having all unnamed parameters can not be viewed in the Procedure Editor
DB Support: SQL Server Right-click "Open in xxx Tab" and "Script: xxx" actions doesn't work in the Tables/Views grids
DB Support: SQL Server
Procedure Editor Stored procedure with null definition gives an error
DB Support: SQLite An error may occur in Alter Table if table contains a column including "check" in its name
Grid Component Jump to Quick Filter key binding in Row Form window doesn't work
Import
SQL Log ConcurrentModificationException when importing data
Java 8
OS Support: Linux Programatically deactivate the org.GNOME.Accessibility.AtkWrapper on Linux with OpenJDK 8. Solves the infamous "componentResized" issue
SQL Commander When auto-commit is off and commit is clicked in the "there are open transactions" dialog any errors are only visible in the debug log
Changing the data type for a "noshow" variable doesn't have any effect other than for its first reference
Progress percentage to high when go <nn> is used

New in DbVisualizer 10.0.22 (Aug 19, 2019)

Improvements:
DB Support: DB2 LUW
DB Support: Oracle
SQL Commander Add control to automatically clear the DBMS Output buffer between executions
DB Support: Informix Add "Grants" viewer for Views, System Tables and Procedures
DB Support: PostgreSQL
Import Add support in Import Table Data for types such as JSON, MACADDR, MONEY, and others
DB Support: Redshift Upgrade the Redshift JDBC Driver to 1.2.32.1056
DB Support: Redshift
Procedure Editor Add support for Stored Procedures in Redshift
DB Support: SQL Server
SQL Commander Support Error Line Numbers for Official MSSQL JDBC Driver
Export
Import Add "Detect Data Types in Quoted Values" setting in table data import
CSV Column Delimiter settings should accept non-printable characters and Unicode identifier (ex: u2656)
Add "Quote All Values" when export table data
Grid Component Need setting to disable wildcard detection in the grid quick search popup
Grid Component
SQL Editor Show an error if system clipboard is not available during copy
SQL Commander Support "GO <nn>" which runs the previous statement <nn> times
Bugs Fixed:
Command Line Support (dbviscmd)
OS Support: Linux The -Xdock Java arguments in dbvisgui.sh should not be used when running the script on Linux
Compare Occasional error when comparing two editor buffers
Connection Setup The "HIT" JDBC driver may fail at connect with a NullPointerException
DB Support: Hive The "Create Index" action for Hive generates wrong SQL
DB Support: Oracle
SQL Commander Output generated by DBMS_OUTPUT may not include leading/trailing whitespaces that are part of the output
DB Support: SQL Server Running an empty argument list function returning TABLE results in an exception
DB Support: SQL Server
Database Profile: Actions The SQL when creating an "Inline Table Function" in SQL Server is incorrect
DB Support: SQLite
DDL Generator DDL extracting doesn't work properly if original DDL contains comments
Export Any custom set Column or Row Delimiter in Export Schema/Table is reset to first value in the pre-defined delimiters list
Import Occasional error during import
File Data Type is reset when going forth and back in the Import Table Data wizard
Query Builder NullPointerException when Query Builder draws arcs between table nodes
SQL Commander Error when using @run preceded with a @cd to a location specified by user variable
Tool Properties ClassCastException when getting JDBC default fetch size

New in DbVisualizer 10.0.21 (Jun 5, 2019)

Improvements:
App Logging Using dbviscmd shows any passwords set as arguments in the debug output
Connection Setup Allow configuration of the maximum SSH authentication retries
Introduce the "Fetch Size" connection property used to give a hint to the JDBC driver the number of result set rows to get in a single network call
DB Support DB2 LUW Update the DB2 JDBC driver to 4.25.1301
DB Support Elasticsearch Add Database Type and driver entry for Elasticsearch
DB Support Exasol Update Exasol JDBC driver to version 6.1.2
DDLs for Exasol Views are not generated correctly
Updates for Exasol
DB Support H2 Table index node should include the column the index refers to
DB Support InterSystems IRIS Add database type and driver entry for InterSystems IRIS
DB Support SQL Server Include Creation and Modification Date in the listings for tables, views, procedures, etc.
DB Support Sybase ASE
Object View For Sybase ASE add a new DBA->Blocked or Waiting Objects view
Database Profile Add right-click menu item "Open" in the connection Properties->Database Profile list. Will open the selected profile XML file in system editor
Docs EULA Request EULA consent when starting DbVisualizer rather than approving it during installation
Export Allow generating multi-row inserts with a single INSERT statement in the export features
See the discussion here
Installation/Update Installation
Java 8 Now bundles the AdoptOpenJDK 8 on Windows 32/64 and AdoptOpenJDK 11 on macOS
SQL Editor Rearrange the SQL editor right-click menu by moving for example cut, copy, and paste to top level rather than the Edit sub menu
Workspace Loading a file that is already open in a floating window should move that window in front of all other DbVisualizer windows
Bugs Fixed:
Command Line Support (dbviscmd) dbviscmd should fail with a user friendly message if no Java runtime can be found
dbviscmd doesn't tell if there is no command specified in the -sql parameter or if the file identified by -sqlfile doesn't exist or is empty
Compare
DB Support DB2 LUW Grid Compare doesn't honor the Grid->Show Column Alias as Grid Column Label tool property for drivers supporting aliases such as DB2
DB Support Exasol There are no columns listed for database Views
DB Support MySQL
DDL Generator The DDL for a GEOMETRY and its spatial key is incorrect
DB Support Oracle The "Change Password" capability for Oracle is invisible for a brand new Oracle connection. Only restart makes it visible
DB Support PostgreSQL View definition not visible for a user not owning the view
Empty Arrays are displayed as NULL
DB Support PostgreSQL
DB Support Redshift When getting catalogs in Redshift there is suddenly the "oid" column in first index where catalog name is expected
DB Support PostgreSQL
Data tab
Procedure Editor Having "Preserve Object View tabs at Disconnect" disabled and object view tabs with edited content, when reconnect these tabs are closed without confirmation (for ex the Data tab and Procedure Editor)
DDL Generator The DDL for a view object with a comment is "COMMENT ON TABLE" rather than "COMMENT ON VIEW"
Database Objects Tree
SQL Commander Dragging an object name from the Databases tab to the SQL Commander should insert the name at the caret position
Scripts Exception when moving directory to another directory in the scripts Tab
Workspace New tabs may occasionally end up in new tab groups

New in DbVisualizer 10.0.19 (Apr 11, 2019)

New in DbVisualizer 10.0.18 (Apr 3, 2019)

New in DbVisualizer 10.0.17 (Jan 31, 2019)

New in DbVisualizer 10.0.16 (Jan 31, 2019)

Improvements:
App Logging New parameter -errordir <folder> for dbviscmd will output all error logs to that folder
Compare When hovering a grid name in the Compare window, it should show the same tooltip as when hovering the corresponding object view tab
DB Support: Exasol System column name change in Exasol 6.1.rc1 (PARTITION_KEY_ORDINAL_POSITION to COLUMN_PARTITION_KEY_ORDINAL_POSITION)
DB Support: HPE Nonstop Define drivers.xml entry and DatabaseType for HPE NonStop
DB Support: PostgreSQL Indicate Enabled and Disabled state for a Trigger
DB Support: SQL Server Add support for navigating objects on a Linked Server
Java 11 Support for Java 11
Procedure Editor Do not disable Undo in procedure editor after Save
SQL Commander Accept ${java.nnn}$ and ${env.nnn}$ type variables in the path for @cd and @run
SQL Log The settings for "Auto Resize Row Heights" and "Filter Log Entries" toggles in the SQL Log should be saved between sessions
Workspace Add a "Child Tab Group" action used to focus to any child tab groups
Bugs Fixed:
Auto Completion Potential exception when connection has dropped
Connection Setup Improve error handling when pinging with a port number out of range
DB Support: Exasol Exasol - problem with Granted Object/Roles/System Privileges
DB Support: Oracle DDL commands increments the statement counter when Auto Commit is disabled
DB Support: Oracle
SQL Commander Stopping 'create table' on Oracle DB stalls session
DB Support: PostgreSQL Exception when expanding Functions and Aggregates in PostgreSQL 11
DB Support: SQL Server
Export IDENTITY duplicated in DDL generated from a result set when using the jTDS driver
DDL Generator @ddl command fails for functions and procedures when the param list contains brackets
Data tab Stopping execution in the Data tab may leave the "In Progress" text on top of the grid
Database Objects Tree Having no selection, right-click and run "Select All Child Objects" in the Databases tab throws an NPE
Export Rare NullPointerException when exporting grid to SQL with Include Basic DDL enabled
Disable or enable options based on the setting for related options, so invalid combinations are prevented
Import When importing the check of file type (extension) should be case insensitive
SQL Commander Having ${time} in result set tab label, time changes whenever tab is painted
SQL Editor Auto Highlight stops working after using Replace All

New in DbVisualizer 10.0.15 (Jan 31, 2019)

New in DbVisualizer 10.0.14 (Aug 16, 2018)

New in DbVisualizer 10.0.12 (May 15, 2018)

New in DbVisualizer 10.0.11 (May 7, 2018)

New in DbVisualizer 10.0.10 (Apr 6, 2018)

New in DbVisualizer 10.0.9 (Apr 5, 2018)

New in DbVisualizer 10.0.8 Build 2841 (Feb 27, 2018)

New in DbVisualizer 10.0.7 Build 2827 (Jan 28, 2018)

Enhancement:
DB Support: Netezza: Include table/column comments in DDL at export
DB Support: Oracle: Add "Script Sequence" action for sequence objects
DB Support: Oracle: Improve WHERE clause for query getting Synonyms
DB Support: PostgreSQL: Add more support for partitioned tables for PostgreSQL 10
Database Objects Tree: The script dialog should allow the Qualify Names setting when Scripting Type = Object Name
Database Objects Tree SQL Commander: When dragging an object from the Databases tab to SQL editor it should be possible to get it qualified and with the identifier delimited
Import: Add checkbox to enable JDBC Batch inserts in the import table data feature (this was a non documented control previously)
Bug:
Command Line Support (dbviscmd): Running dbviscmd with Java 9 fails if current folder is not HOME
DB Support: MySQL SQL Commander: Database list is reset after execution for database names longer than 34 characters
DB Support: MySQL: StackOverflowException when running batch import and the last batch entry contains incompatible data
DB Support: NuoDB: Correct the list of data types listed in the Create Table action to match NuoDB documentation
Data tab: An error is displayed if Max Filters Limit < 0 in Tool Properties->Table Data
Database Objects Tree: Potential NullPointerException when expanding Databases tree
Export: Stopping while Export Grid is running and then immediately starting another export may result in an exception
Export: Pre-defined variables in export need to adjust to use the variable identifier begin/end from tool properties
Export: Exception during export with invalid filename
Grid Component: The background color in grids should fill to the full width
Import: Import of boolean data broken since 10.0.1
Import: Disabling the Empty Table choice has no effect when importing from a second source
Java 8 OS Support: Windows: Need a workaround for the "IllegalComponentStateException: component must be showing on the screen to determine its location" bug introduced in Java 1.8.0_131 on Windows
OS Support: Linux: DbVisualizer doesn't start with headless Java 8 resulting in "No splashscreen in java.library.path"
DB Support: Redshift: Query to get schema info may be very slow

New in DbVisualizer 10.0.6 Build 2810 (Dec 18, 2017)

New in DbVisualizer 10.0.5 Build 2808 (Dec 11, 2017)

Enhancement:
DB Support: Exasol Add database type and driver entry for Exasol
Export Apply a Style matching the data format specified in DbVisualizer for numeric data
Grid Component Add quick link to the Data Formats setup in Tool Properties also for BLOB and CLOB in the grids status bar
SQL Commander Should be possible to disable error markers in the SQL Commander editor
SQL Editor Add means to add custom keywords for syntax highlighting
SQL Editor Add key bindings (alt-shift-up, alt-shift-down) to move selected rows up or down
[http://support.dbvis.com/support/discussions/topics/1000076593 ]
SQL Editor Add a Duplicate Current Line editor action with option to set keybinding (is not assigned by default)
[http://support.dbvis.com/support/discussions/topics/1000076655 ]
SQL Log Make it possible set the default column width for Message and SQL/Command multiline columns in the SQL Log
Bug:
Create/Alter Table Potential exception when removing constraint in the Create/Alter Table window
DB Support: Vertica
SQL Commander A variable in a comment may cause an execution error
Database Profile: Actions
Export Script Table and Export with INSERT should optionally not generate values for auto-generated columns
Export Exception during export if some database objects could not be fetched and are indicated with an error icon
Export Automatically setting file format from extension fails for XLSX
Export The Export Columns grid in Export Grid sometimes fits the columns poorly
Export
Look and Feel: Windows Specifying an invalid drive letter for the destination file gives an exception
Look and Feel: Synthetica
OS Support: Linux DbVisualizer may crash on Linux with the Synthetica look and feel
Look and Feel: Windows
SQL Commander Execute Current and Format Current may pick an earlier statement if the file contains both LF and CRLF linefeeds, and Format Current may drop the statement delimiter if the file contains CRLF linefeeds
OS Support: macOS Java VM Properties cannot be edited in Tool Properties

New in DbVisualizer 10.0.4 Build 2802 (Nov 16, 2017)

New in DbVisualizer 10.0.3 Build 2799 (Nov 10, 2017)

Enhancement:
XML type not supported in the create table wizard
Setting "Max Rows at First Display" or any of the "Max Rows" to 0, should not load any rows
Exporting with "Export Text" disabled should preserve data types not only for numbers but also date, time and timestamp when output is Excel
Install4j should remember the last used download folder during updates
Installer should request higher privileges when trying to install in a non-writable folder
Make it possible using keyboard to copy grid cells in the query builder
The @cd command should set the default directory also for @export output files
The STARTED log entry should show information about used database connection, database type, database, and schema
Format only selected text and reselect the formatted text
The cell editor should allow dropping images, XML, and other file formats we have viewers for
Bug:
Nothing happens (no visual feedback) when executing against a PostgreSQL database that cannot be connected
Incorrect DDL for columns declared as NVARCHAR(m, r)
Add additional options for Create View (ALGORITHM, DEFINER, SQL SECURITY) and Create Table (DEFAULT COLLATE)
Having auto commit off and doing an export database, the commit/rollback warning window is displayed at quit of DbVisualizer
Add support for IDENTITY columns for PostgreSQL 10
The Object View for a Sequence does not work for PostgreSQL 10
Auto Commit is hardcoded for the Procedure Editor
Renaming a Stored Procedure causes the application to hang
Intermittent error may happen when browsing databases tree
Refresh Objects Tree sometimes does not re-expand open expanded nodes
Obsolete parameters in saved settings make Export Schema/Database/Table fail
Setting Max Rows larger than the number of rows in the exported result set gives an exception
Terribly slow exporting many result sets of various sizes to xlsx
When using @ddl in an @export script the Rows column in the SQL Log is always 0 while when executing only the @ddl Rows is positive
When opening a File Chooser the first time with Synthetica, the selected file is correct but that file is also in edit mode in the list
Databases tab list and grids scrolls one row when right-click to show menu (fixed in Java 1.8.0_152)
IndexOutOfBoundsException when re-opening a BLOB in the cell viewer on Java 9
There is no active key map resulting in exceptions when editing
Tab characters in the SQL are stripped off (not even replaced with whitespace) in the SQL log on Windows
The connection used to execute a code object should be disconnected when the Code Editor is closed
Should not be possible to disconnect if there are running (executing) SQL Commander for the database connection
Floating an SQL Commander in an own window results in key bindings for Save (ctrl+c) and Save As (shift+ctrl+s) not work
Formatting with unquoted variables fails when the Case option is set to Whole SQL Lowercase or Uppercase
Changing connection settings for a bookmark/monitor when save file, doesn't show the new settings in the Scripts tab details pane for the file (unless reload)

New in DbVisualizer 10.0.2 Build 2761 (Oct 14, 2017)

New in DbVisualizer 10.0.1 Build 2759 (Sep 26, 2017)

Enhancement:
Database Objects Tree - Filtering/Filter Sets: Disabled Filtering state should be restored when restarting DbVisualizer
Look and Feel: macOS - Performance/Stability: DbVisualizer runs Java in discrete graphics mode on macOS potentially draining the battery on laptops
SQL Log: Need to make the summary of success/failed entries for the FINISHED summary log entry in the Message column more readable
Bug:
Auto Completion: Potential NullPointerException when a connection drops
Create/Alter Table - DB Support: Oracle: Altering Oracle Spatial Table adds an ALTER statement an unaltered SDO_GEOMETRY column
DB Support: Netezza: DOUBLE should not have precision and scale in DDL
DB Support: NuoDB: A statement in NuoDB that returns both an update count and a result set wont show the result set
DB Support: PostgreSQL: ENUM values cannot be updated in grid
DB Support: Vertica: Upgrade the Vertica JDBC driver to 7.2.3
Database Objects Tree: Rare exception double-clicking in the objects tree
Database Objects Tree - Database Profile: View: Focus changes when Autoscroll is set
Database Search: In the database Search tab grid, selecting a match in the lower grid and then "Select object(s) in the Database tab" action nothing happens
Export: Exporting time and date data is not thread safe
Export: Row count is not in the HTML grid export since 10.0
Export/Import User Settings: ConcurrentModificationException when importing user settings
File Chooser: Closing file chooser dialog with ESC key or the red cross button may result in an error
General - OS Support: macOS: Cancelling quit of DbVisualizer (in Confirm Exit dialog) using cmd-q will result in a no-op if doing cmd-q again
Grid Component: Having CLOBs presented by "Value" still shows as "Size" in the row form grid
Grid Component - Look and Feel: Darcula: Missing separator in grid column header for last column with Darcula
Import: Conversion error when importing with comma (,) character as decimal separator
Import: The data formats settings in Tool Properties may effect import if the import data format settings are different than those specified in import
Key Bindings: Ctrl-Alt-R is mapped to both Record Macro and Rollback
SQL Commander: Running SQL files with relative paths does not work
SQL Commander: NullPointerException in ExecutorHandler when creating index
SQL Commander: Stop on no rows only considers first result if many are produced
SQL Commander: Add "Integer" to the list of data types in the variable/parameter substitution dialog
SQL Commander: Multiple result sets generated as cursors by a stored procedure shows only the first results in all result sets
SQL Commander: StringIndexOutOfBoundsException in ScriptExecutor when calling procedure
SQL Editor: NullPointerException when handling LogEntry for error in SQLEditor
SQL Log: Not logging Success and/or Failed entries will if more than 10000 statements say that the log is truncated when it is not
Tool Properties: Restarting DbVisualizer doesn't show the same prompt dialogs as when doing a regular quit

New in DbVisualizer 10.0 Build 2753 (Aug 23, 2017)

Enhancement
Command Line Support (dbviscmd) The command-line interface should allow connecting to a database not previously setup in the DbVisualizer GUI
Connection Setup Should be possible to set a default value for a driver property in drivers.xml
Connection Setup DbVisualizer should register its application name ("dbvis") with the database so that any DB server process listing clearly tell what connections belong to DbVisualizer
[http://support.dbvis.com/support/discussions/topics/1000076634 ]
Connection Setup The missing DB2 license jar file message at connect should be transformed to DbVisualizer instruction how to fix it
Connection Setup Remove Authentication Method dropdown and always include the Authentication Domain field in Options
Connection Setup Combine "Keep-Alive SQL" and "Validation SQL" into a single setting: "Validation SQL"
DB Support: Generic Auto detect Database Type for Sybase IQ and Sybase SQL Anywhere (the corresponding JDBC driver must be selected)
DB Support: MySQL Suppress Identical warnings when executing scripts
DB Support: Oracle Allow resetting password for Oracle connections
DB Support: Oracle Password due for expiration warning should be displayed when connecting to Oracle
[http://support.dbvis.com/support/discussions/topics/1000077211 ]
DB Support: PostgreSQL Set the ApplicationName driver property to "dbvis"
[http://support.dbvis.com/discussions/topics/1000078063 ]
DB Support: PostgreSQL Show partition tables for PostgreSQL 10
Database Objects Tree Allow double-click to expand database objects tree (and connect of database connections)
Database Objects Tree Add tooltip with explanation what overlay icons in the Databases tree list means
Database Objects Tree
Filtering/Filter Sets Show number of non filtered objects instead of number of filtered objects
Driver Manager Upgrade bundled JDBC drivers
Driver Manager Remove the System Classpath tab in the Driver Manager and log when loading JDBC drivers classes from the CLASSPATH instead of the JAR files
Export Allow outputting large data exports to different files (out1, out2, out3)
[http://support.dbvis.com/support/discussions/topics/1000077176 ]
Export Allow adding custom statements first/last in file produced by schema export
Export Optionally include column names in CSV only for first result or for all
Export Add option to not convert HTML special characters to HTML codes when exporting to HTML
[http://support.dbvis.com/support/discussions/topics/1000077620 ]
Export Optionally include the Table name in HTML export
Export Make it possible to select all objects for Export Schema with one click
Export Allow for Date/Time/Timestamp data to be exported with JDBC escape syntax
Export Make it possible to assign the names for BLOB/CLOB files, e.g. based on the value of other columns on the same row
[http://support.dbvis.com/support/discussions/topics/1000076641 ]
Export Possibility to set ExcelSheetName in export wizard
Export Should be possible to organize the output of schema export so that all DROP, CREATE and INSERTs are grouped
Export Use a separate File Chooser context for BLOB/CLOB files
Export Add the following parameters for @export set: HtmlColumnHeaderIsColumnAlias, JSONColumnHeaderIsColumnAlias, XmlColumnHeaderIsColumnAlias
Export Should be possible to limit number of rows with a new "Max Number of Rows" setting in Export Schema and Export Table
[http://support.dbvis.com/support/discussions/topics/1000077150 ]
Export Add possibility to use ${dbvis-column-name}$ in BLOB/CLOB output paths to handle multiple columns of these types
File Chooser File choosers should suggest last visited path based on context instead of sharing a single folder for all file choosers
File Chooser Add recently used files/folders list in file selection field and file chooser window
File Chooser Enable file system auto completion in file selection field
File Chooser File chooser windows should have a drop-down list of last visited directories which is used to quickly navigate to a directory
[http://support.dbvis.com/support/discussions/topics/1000076678 ]
File Chooser
SQL Commander The Log to File button should have a drop down with last used files
General Replace spinning red icon with a static one. Reason is that the animated GIF stops spinning suddenly and is too pixly and looks bad on HiDPI displays
General Adjustments to large counters introduced JDBC 4.2
Grid Component The "Describe Data" window should allow generating a CREATE TABLE DDL action
[http://support.dbvis.com/support/discussions/topics/1000076823 ]
Installation/Update Installation Remove the "-XX:MaxPermSize" Java property as it is deprecated with Java 8
Installation/Update Installation Remove the "-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot" Java property
Key Bindings Adding a keybinding for Merge Result Sets
Look and Feel Allow changing look and feel at startup
Look and Feel: Darcula Add support for the Darcula (dark) look and feel
[http://support.dbvis.com/support/discussions/topics/1000078054 ]
OS Support: macOS Change all visual references of 'Mac OS X' to 'macOS'
SQL Commander Add new ${editorindex} to be used in Result Set tab labels
SQL Commander Add an option to name SQL Commander tabs as index only if there is no loaded file name
SQL Commander Consistency between Elapsed Time and Execution/Fetch time
SQL Commander Make filename in SQL editor status bar clickable with options to Copy Path and Open Parent Folder
SQL Commander Use setSchema() to set schema for execution to the selected schema
SQL Commander "@export set" commands are order dependant
SQL Commander Add a way to be able to use Java VM system properties and OS environment variables in DbVisualizer variables
[http://www.dbvis.com/forum/thread.jspa?threadID=507 ]
SQL Commander Move the preprocessing settings (Parameterized SQL, Strip Comments, etc.) as connection properties
SQL Commander Add support to automatically merge generated result sets to text
[http://support.dbvis.com/support/discussions/topics/1000076686 ]
SQL Commander
SQL Log Improve the capability for writing the execution log to a file (@spool is now replaced with new "@log <filename> spool / clear"
SQL History Increase the width of the quick filter field in the SQL History grid
SQL Log Remove "Log to File" option in the SQL Commander and instead instruct users to save log after execution or using new @log commands
SQL Log Make the log in the SQL Commander more interactive
[http://support.dbvis.com/support/discussions/topics/1000076470 ]
SQL Log SQL Log tab entries for @ commands could show more information for the command
SQL Log Should be possible to configure the time format for SQL log entries
Table Data Editor Should be possible to copy (Ctrl+C, Cmd+C) the rows displayed in the XML viewer to clipboard
Tool Properties Change the "Rest of UI" font setting to "Font Scale for Rest of UI"
Workspace Make split pane dividers visible and visually resize content while dragged
Bug
Auto Completion Auto completion shows faulty values when activated for command parameter in client side command
Auto Completion
Query Builder The query builder is unable to find a newly created table if it is referenced in the SQL being parsed
[http://support.dbvis.com/support/discussions/topics/1000078362 ]
Connection Setup
DB Support: PostgreSQL The new PostgreSQL driver writes a SEVERE log entry when connection fails resulting in the DbVisualizer red error balloon to popup
DB Support: DB2 LUW
Table Data Editor Handle XML data types as CLOB/BLOB with the option to show these as a puzzle piece icon in grids and XML viewing in cell editor
[http://support.dbvis.com/support/discussions/topics/1000076747 ]
DB Support: Oracle The Synonymed Objects view should not include synonyms owned by the selected schema
DB Support: Oracle Synonyms with unknown type are not shown in the tree
DB Support: SQL Server
SQL Commander Created schema not visible in SQL commander drop down
DB Support: Sybase ASE
Table Data Editor Having two identically named tables in two different databases, any edits made in both tables shows up only in one of them
Database Objects Tree Quitting DbVisualizer while objects filters are disabled, will only restore the filters at second re-start
Database Objects Tree
Workspace Re-introduce the "single-click to open" database object and to sync the database objects tree with the current object view tab
[http://support.dbvis.com/support/discussions/topics/1000076817 ]
Export @export of two result sets in CSV to the same file will append the second result sets first line to the last line of the first result set
[http://support.dbvis.com/support/discussions/topics/1000077796 ]
Export Export of multiple results to HTML with AppendFile set to false creates a document that is missing the header
Export Exec time is the same for all log entries during Export Schema/Database
Export Export HTML from table with no data generates HTML with one line
Export Export to JSON Array with AppendFile set to clear creates one array per table
Export Any non absolute BLOB/CLOB File paths should be relative to the exported file
Export Cannot export View data with Export Schema
Export/Import User Settings The export/import user settings window is too high
Favorites
Scripts Horizontal scrollbar in Scripts and Favorites tabs is not updated properly
Filtering/Filter Sets Database tree filter is not applied when loading saved Object View tab or when opening a favorite on a non connected database connection
[http://support.dbvis.com/support/discussions/topics/1000077857 ]
Grid Component
OS Support: Linux Using a trackpad or mouse wheel to scroll horizontally will launch any double-click action in grids and tree's
Look and Feel: Synthetica
OS Support: Windows
Query Builder White background for Conditions under some circumstances
Look and Feel: macOS
OS Support: macOS The "All Files" filter can not be selected when opening files with macOS L&F
Look and Feel
Workspace The close icon (X) color must use the same color as the tab title text
Procedure Editor Exception when clicking Execute when the object cannot be loaded
Query Builder Quick Add should not be enabled without a connection, and the other buttons should not be enabled without tables
SQL Commander @set maxchars does not seem to affect the size of the DataSet fetched
SQL Commander Any errors in a @run script are added to the @run marker tooltip equally number of times as there are errors
SQL Commander While SQL Commander is in the "Parsing Script" or "Looking for variables, parameter markers..." phases stopping takes a long time
SQL Commander Error markers are visible only when these are available by the driver/database. There should be markers for all failed statements
SQL Commander @ddl table does not fail for some databases if table does not exist
SQL Commander
SQL Log Executing a script with a comment last (after a statement delimiter) gives a SQL Log entry for it
SQL Editor Entering "(<tab>" in the SQL editor shows the templates popup for © and (™). Change "(c)" to ".(c)" and "(tm)" to ".(tm)"
SQL Editor Right-arrow does not clear selection when the whole text is selected
SQL Editor When hitting enter at the end of a row with data and then up arrow, the caret is placed at the end of the row above and not in position 0
SQL Editor Running a @run with a lot of errors, all these are displayed when hovering the curly line or the error marker in the margin of the editor
SQL Log Having a @spool command without actually logging to a file sends the command to the database. @spool also replaced with @log
SQL Log The SQL in the log for a @call statement shows the variable values after execution rather than the values from when the call was made
Tool Properties Issue specifying -Ddbvis.prefsdir=<folder> in user.vmoptions (Tool Properties->General)

New in DbVisualizer 9.5.7 Build 2611 (Jul 4, 2017)

Enhancement:
DB Support: DB2 LUW Sort triggers in the tree on schema and name
Import Support converting blank cells to null in Excel import
Bug:
Create/Alter Table Size column can not be cleared in create table wizard for SET data type
DB Support: DB2 LUW An explain plan table in DB2 LUW 11 needs an extra column
DB Support: MariaDB The MariaDB database type must set (among other database type settings), delimited identifiers to backtick
DB Support: Oracle Switching schema in SQL Commander increases uncommitted statements counter
DB Support: Oracle Query to get synonyms may be very slow
DB Support: PostgreSQL PostgreSQL JDBC driver fails with an unhandled exception if unpaired quotes in SQL
DB Support: SQL Server IndexOutOfBoundsException when exporting indexes for SQL Server 2008
DB Support: SQL Server Table index view does not work for older versions of SQL Server
Database Objects Tree Right-click and drop two indexes under two different tables. When completed only the first index is removed in the list
Favorites Opening a favorite that targets a database connection object shows "There are no details for this object"
General Exception: in com.jidesoft.tooltip.BalloonTipUI.getBalloonSize
Import Occasional exception when importing Excel (XLS) when clicking Next after choosing Sheet Name to import
Monitor Monitor tab color is not updated when changing to another connection for a monitor
OS Support: Windows
SQL Commander NullPointerException when executing script file (@run or -sqlfile) having statement delimiter last in file
Query Builder Query Builder marks "as" as invalid
SQL Commander Export Excel does not append if AppendFile="clear" in some situations
SQL Commander Database Connection, Database, and Schema are suddenly cleared
SQL Commander The variable substitution window should show the Long data type for numbers rather than Integer which will truncate long numbers
SQL Commander Exception when opening new SQL Commander for a lost connection
Table Data Editor Bad performance scrolling the XML viewer tree
Table Data Editor If the CLOB/BLOB/BINARY cell is null no editor is displayed when opening the cell editor window
Workspace The active tab state is not restored at re-start. A random tab is then the active current one
Workspace UI may flicker and focus may move to another component while DbVisualizer is auto saving editors and layout
[http://support.dbvis.com/support/discussions/topics/1000077279 ]

New in DbVisualizer 9.5.3 Build 2600 (Oct 13, 2016)

New in DbVisualizer 9.5.2 Build 2598 (Sep 15, 2016)

Enhancement:
DB Support: H2 Add explain plan support for H2 (textual);
DB Support: Oracle Need to show INST_ID in the Sessions data and make the actions Oracle RAC aware;
DB Support: Oracle Add support for management of Redo Logs;
Query Builder Add support for CAST(expr AS type) expression;
Bug:
Connection Setup NullPointerException when disconnecting while a script is running;
Connection Setup Better message when using Ping Server for drivers not supporting ping;
DB Support: Netezza The _V_SCHEMA view may not be accessible in all configurations;
DB Support: PostgreSQL Attempt to connect to a database with the same name as the user when connecting with multiple SQL Commander tabs open or stopping an SQL Commander execution;
DB Support: PostgreSQL Right-click in the Tables grid and "Open in New Tab" doesn't open objects in PostgreSQL;
DB Support: PostgreSQL No spinning icon is shown when expanding a Database node;
DB Support: Redshift References object view tab is missing for the Tables node;
DB Support: SQL Server Incorrectly spelled CASCADE keyword in DDL for Table;
DB Support: SQL Server Show Only Default Database/Schema doesn't work in 9.5.x if previously enabled in a 9.2.x version;
DB Support: Sybase ASE:
Database Objects Tree The "Database Objects Filters" sub-menu is empty after right-clicking/expanding a few nodes in the Databases tab;
Database Objects Tree Database objects tree is broken when having multiple main windows with the same database connection expanded, and then doing a re-connect;
Database Objects Tree Database Objects Tree doesn't expand properly when a second main window has been visible;
Favorites Opening favorite with identical names after each other (Connections/NAME/NAME/...) fails;
Filtering/Filter Sets Custom filter sets that are not used by any database connections are removed when exiting DbVisualizer;
Installation/Update Installation Installer asks for "Use a different directory" which may be confusing. Change it to "No, install into a different directory";
Monitor Add reconnect link to Monitor error message;
Query Builder "Add the generated SQL last in the SQL Editor" adds it erroneously at the caret position;
Query Builder Preserve a leading comment for a SELECT when loading back into the SQL Editor;
SQL Commander The Stop button is disabled after values for variables have been entered;
SQL Commander Variables in comments are prompted if "Strip Comments when Executing" is turned off;
SQL Commander Do not prompt for identically named parameter markers more than once;
Table Data Editor Having an embedded colon in table name breaks table data editing and doesn't indicate primary key columns in grid.

New in DbVisualizer 9.5.1 Build 2592 (Aug 18, 2016)

ENHANCEMENT:
DB Support: Oracle References - Add option to set /*+RULE*/ hint for query getting referenced tables
Export - Exporting to binary Excel and exceeding 65K rows should show a more meaningful error message and suggestion to use XLSX instead
Grid Component - Add drop-down filtering capability in grid column headers
Workspace - Make the draggable divider between SQL Commander and results tabs easier to find (bigger)
BUG:
Connection Setup - Exception when disconnecting from server
Create/Alter Table - Adding new index or foreign key doesn't always select the newly added entry
Create/Alter Table - Alter Table should clear some attributes when changing data type
DB Support: DB2 LUW - Row Change Timestamp column constraint not included in DDL
DB Support: DB2 z/OS
SQL Commander - Schema filters are not applied in the schema drop-down list
DB Support: Hive
DB Support: Phoenix - DatabaseException: Could not set catalog to: NoCatalogKey for: Phoenix: null
DB Support: Informix - Delimited identifier should not be used in the informix.getTableTriggers command
DB Support: JavaDB/Derby - Exceptions may occur if using a version of the JDBC driver not compatible with the database version
DB Support: MySQL - AUTO_INCREMENT clause not inserted when Auto Increment is selected in Alter Table
DB Support: MySQL
DDL Generator - DDL does not quote default value for enum
DB Support: Netezza - Only test for multiple schema support for database versions greater than 7.0
DB Support: Oracle - Fail to open index Sub partitions as index name is null
DB Support: Oracle - Having Delimited Identifiers for Scripting enabled erroneously enclosed parameters for "kill session"
DB Support: Oracle - Condition missing in SELECT for getting table indexes
DB Support: Phoenix - There is a (null) schema in the database objects tree for HBase/Phoenix which gives side effects in that Data and Row Count tabs for tables results in a DB error
DB Support: PostgreSQL - Looking at tablespace info in versions older than PostgreSQL 9.0 gives an error
DB Support: PostgreSQL - Collations should only be fetched for PostgreSQL 9.1+
DB Support: PostgreSQL - There is no "(Default)" label for a database when logging in with no database specified in connection details
DB Support: PostgreSQL - Having Single Physical Connection enabled and Auto Commit off doesn't work as expected
DB Support: PostgreSQL
References - Using Open in New Tab in references graph doesn't work for PostgreSQL
DB Support: Presto
References - References graph for Presto shows only table names and no columns information
DB Support: SQL Server - Errors when connecting to SQL Server older than 2008
DB Support: SQL Server
DB Support: Sybase ASE - The database objects tree for the generic profile may not show the correct schemas for an expanded database
DB Support: SQL Server
Export - Errors while retrieving database objects for export doesn't render these with the error icon and red text as in the Databases tab
DB Support: SQL Server
Export - "The statement is closed" error when launching export schema
DB Support: Sybase ASE - Database Devices view does not work for versions earlier than Sybase ASE 15
DB Support: TeraData - GUI may be unresponsive when loading thousands of objects in the Databases tab
DDL Generator - DDL generation fails if driver throws an exception getting primary keys
Data tab - Script to SQL Commander->UPDATE WHERE and the generated "where" clause always refer first column and not selected columns
Database Objects Tree - Highlighting a database object in the Databases tab by click on Select in the disconnected object view tab or by the object path fail in some situations
Database Objects Tree - Reload/reconnect with thousands of expanded nodes in the Databases tab is slow
Database Objects Tree - UI painting problems in Databases tab after opening File->Import Settings
Database Objects Tree - Exception: "path in TreePath must be non null" when reloading filters
Database Objects Tree
DB Support: Vertica - Expanding the Columns node for a table takes longer than it should
Database Objects Tree
Object View - Memory leaks and slow performance in databases tab when there are many thousands objects
Database Profile: Tree
DB Support: Presto
DB Support: Snowflake - Schema names displayed as "(null)" for Presto and Snowflake
Database Search - IllegalStateException when doing a search again after an object tree refresh
Database Search
DB Support: SQL Server - NPE when getting View column info for an IDENTITY column
Export - No icon found for: "Error" reported when expanding objects types check box tree in export schema and there was a database error getting the objects
Filtering/Filter Sets - Show Only Default Database/Schema should do case insensitive comparison
Monitor - Data Monitor doesn't work with PostgreSQL
Monitor
Scripts - Clicking or opening a MySQL Scripts file for a connected connection with Java 7 gives exception while with Java 8 the UI is not properly painted
OS Support: Mac OS X - "Invalid Seal" error when starting DbVisualizer with a newly installed license key
SQL Commander - Connecting a database connection that have thousands of schemas, and if a SQL Commander tab for that connection is visible, the GUI hangs
SQL Commander - Any value in Max Chars in SQL Commander doesn't have any effect
SQL Editor - Rectangular edit issue when copy/paste
Scripts - Renaming bookmarks folder makes a file in the folder show as two nodes

New in DbVisualizer 9.2.14 Build 2495 (Dec 22, 2015)

Enhancement:
DB Support: Mimer SQL: Update the Mimer JDBC driver to 3.35b(19427)
DB Support: MySQL: Do not quote an already quoted default value for a column
DB Support: Oracle: RAW data should be displayed as a Hex String by default
DB Support: Oracle: Add connection property to hide the DBMS Output tab in the SQL Commander
DB Support: SQLite: The default database file name for SQLite should not include the tilde (~) character
DB Support: SQL Server: Upgrade the bundled jTDS driver to 1.3.1
DB Support: Sybase ASE: Upgrade the bundled jTDS driver to 1.3.1
Export: Changed settings in the last Export Grid pane are not saved when Settings->Save as Default Settings
OS Support: Mac OS X: Should be possible to show the Monitor window in OS X fullscreen mode
References: Add option to render only selected tables in the References graph
References: Mark foreign key with icon in reference graph
SQL Commander: Add tool property to control focused result set tab after execution (Result Sets->Focused Result Tab after Execution)
Bug:
Chart: The Auto Adjust Start Value/Manual Start Value settings are also applied to the corresponding "End" settings when chart configuration is saved to file
Connection Setup: The specified method name for any of java.sql.statement.X and java.sql.connection.X driver properties need to be trimmed
Data tab: Current sorting and cell selections are not cleared when opening another table in the same Data tab
Driver Manager: Driver Name and Version String are not reset when loading new JAR file
Filtering/Filter Sets: The Data tab filter editor window errors if defining an IN or NOT IN value with multiple subsequent commas
Grid Component: Grid column chooser configurations are not saved between reloads or DbVisualizer sessions
Monitor: ConcurrentModificationException when running monitors
Navigator: Regression in 9.2.13 preventing Data Navigator from working properly
SQL Commander: @-command parameters with unquoted values should not be silently ignored
SQL Commander: Exception while SQLEditor discovers that the Database Connection drop-down changed
Table Data Editor: Inserting new rows or duplicate existing in the table data editor aren't sorted based on current column sorting
Table Data Editor: Undoing edits in a sorted table data editor doesn't resort the grid if sorted

New in DbVisualizer 9.2.13 Build 2488 (Nov 19, 2015)

New in DbVisualizer 9.2.12 Build 2486 (Oct 21, 2015)

New in DbVisualizer 9.2.11 (Oct 21, 2015)

Enhancement:
Connection Setup - Upgrade JSch to version 0.1.53
Create/Alter Table - Specifying a referenced column for an FK should be optional
DB Support: Mimer SQL - Enhance Mimer explain to handle new "partial" mode whereas these nodes should be rendered in orange color
DB Support: PostgreSQL - Add support for function parameter default value in the DDL generator
Grid Component - Allow assigning key binding to Remove Column (grid column header right-click menu)
Bug:
Connection Setup - Make the Ping Server dialog more informative that it is used to do a basic ping with the server and not a full Test Connection procedure
DB Support: Informix - CLOB values may be corrupted when loaded if the database use non-default character set
DB Support: MySQL - Add auto increment column fails for Alter table
DB Support: MySQL - Altering a column to primary key and auto increment does not work
DB Support: NuoDB - NuoDB erroneously returns a backtick (`) as getSearchStringEscape() while it should return a backslash (\)
DB Support: PostgreSQL - Parameter markers starting with :: followed by whitespace is erroneously prompted as a marker
DB Support: Sybase ASE - Getting procedure's DDL from different schemas under the same connection fails when using the jTDS driver
DB Support: Sybase ASE - Procedure Editor shows no source for Sybase ASE 16 or later
DB Support: Vertica - Some tree nodes are not sorted, e.g. user names under the Users node
Data tab - Reload in the Data tab doesn't apply any (inline) data filter changes unless Use Filter button has first been clicked
Database Objects Tree - Occasional NPE when reload database objects list
Export - XmlDataSet and FlatXmlDataSet should have just one element embedding all tables, not one for each table
Export - @export of two result sets in CSV to the same file will append the second result sets first line to the last line of the first result set
Import - Importing number containing a blank as thousand separator does not work
Java 8 - DbVisualizer fail to start with IBM Java 8
Procedure Editor - The editor should be cleared when the source code cannot be retrieved
SQL Commander - Make it possible run script with no internal SQL being executed
SQL Commander - Having a permission level that shows the confirmation dialog in the SQL Commander in combination with OS X and Java 8 causes the variable dialog to not accept text entry

New in DbVisualizer 9.2.10 Build 2477 (Aug 27, 2015)

Enhancement:
DB Support: Hive - Add a Database Type for HIVE enabling for example SSH support
DB Support: Hive - Adjust the Data tab and result set tabs for HIVE to enable data editing
References - Add support for mouse wheel to scroll in graphs. (Use Alt+MouseWheel or Ctrl+MouseWheel to zoom)
Bug:
Auto Completion - Sporadic exception while using auto completion in SQL editor
DB Support: DB2 LUW - Catch AIOOB if extracting DDL fails
DB Support: Hive - The error log complains about setAutoCommit() warnings for HIVE
Database Profile: Actions - In the error dialog that is displayed after unsuccessful execute of an action, double-click the rightmost cell value and a CCE is displayed
Grid Component - Occasional ArrayIndexOutOfBoundsException when reloading a result set
Grid Component - The XML viewer should check the target database data type in addition to the content mime type to determine if it's XML or not
Grid Component - Hiding a column in a grid on Linux with DbVisualizer running on a secondary monitor fail with some Linux distros/environment setups
Import - The import progress information is not updated when importing from Excel
Import - CSV import does not detect carriage return (\r) as representing new lines
Import - If errors occur while import Excel (xlsx) the error row number reference is wrong
Import - Import does not honor "Import Only" properly as error rows are not counted
Import - The Import progress information is only updated every 100th inserted row rather than at least once per second
References - java.awt.geom.IllegalPathStateException: missing initial moveto in path definition in references graph
References - The references List view should translate the values for UPDATE_RULE, DELETE_RULE and, DEFERRABILITY to readable text
References - While References graph is loaded a small blue box is rendered on top of the nodes
SQL Commander - Inconsistent display of rollback/commit dialog when auto commit off
SQL Commander - The Auto Commit status bar item is always Auto Commit: ON for disconnected connections and before the very first statement has been executed
SQL Editor - Find next/previous (fn+F3) in quick search shows any search previously made in the find with dialog
SQL Editor - Rectangular editing does not change last line correctly when selecting top right to bottom left
Table Data Editor - An editable grid with a large number of rows (ex 100,000) which is sorted takes unreasonable long time to reload, close (tab) or even quit DbVisualizer

New in DbVisualizer 9.2.9 Build 2473 (Jul 31, 2015)

New in DbVisualizer 9.2.8 Build 2466 (Jun 29, 2015)

New in DbVisualizer 9.2.7 Build 2457 (May 14, 2015)

New in DbVisualizer 9.2.6 Build 2447 (Apr 17, 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 DbVisualizer 9.2.5 Build 2430 (Mar 18, 2015)

New in DbVisualizer 9.2.4 Build 2423 (Mar 6, 2015)

New in DbVisualizer 9.2.3 Build 2415 (Feb 26, 2015)

New in DbVisualizer 9.2.2 Build 2407 (Feb 19, 2015)

New in DbVisualizer 9.2.1 Build 2402 (Jan 29, 2015)

New in DbVisualizer 9.2 Build 2348 (Jan 13, 2015)

Enhancement:
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:
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 DbVisualizer 9.1.13 Build 2310 (Jan 12, 2015)

New in DbVisualizer 9.2 Build 2339 Beta (Dec 17, 2014)

New in DbVisualizer 9.2 Build 2335 Beta (Dec 9, 2014)

New in DbVisualizer 9.1.12 Build 2306 (Nov 27, 2014)

New in DbVisualizer 9.2 Build 2329 Beta (Nov 25, 2014)

New in DbVisualizer 9.2 Build 2328 Beta (Nov 12, 2014)

New in DbVisualizer 9.2 Build 2327 Beta (Nov 12, 2014)

New in DbVisualizer 9.2 Build 2320 Beta (Nov 12, 2014)

Enhancement:
Auto Completion: Full auto completion support for client side commands and their parameters
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 itself
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: H2: Upgrade to H2 1.3.175
DB Support: SQLite: Upgrade to SQLite 3.8.6
Database Objects Tree: Support filter sets with pre-defined filters that can be switched easily
Database Objects Tree: Make it possible to hide certain object types
Database Objects Tree: Support for multiple named filters
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: Object Type changes after Save Filter
Database Objects Tree: Allow object tree filtering with LIKE and not LIKE
Database Objects Tree: Show/hide filter pane using key bindings
Database Profile: Actions: Allow showing result sets generated by action in a text viewer
Export: Should be possible to specify qualifiers and delimited identifiers (for SQL format) in Export Grid and Export Table
Grid Component: Add option to allow free horizontal scrolling in grids instead of the current column-by-column based scrolling
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: 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
SQL Commander: Allow use of parameter markers (?) for any database
SQL Commander: Add a @sleep command
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 Schema list in the SQL Editor should really change the current schema for PostgreSQL
SQL Editor: Add support for pre-defined templates and custom SQL templates
Table Data Editor: Show current cell data format in the table editor status bar
Bug:
Export: Export to XLSX doesn't output non-printable characters properly

New in DbVisualizer 9.1.11 Build 2303 (Oct 14, 2014)

New in DbVisualizer 9.1.10 Build 2295 (Aug 9, 2014)

New in DbVisualizer 9.1.9 Build 2148 (Jun 11, 2014)

New in DbVisualizer 9.1.8 Build 2137 (Apr 16, 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
Query Builder - Automatically set a table alias if a table is added multiple times
Bug:
Chart - Bar/Stacked Bar charts doesn't display
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
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
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
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
Monitor - Series and category drop-down menus may not reflect the columns in the underlying result set
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

New in DbVisualizer 9.1.7 Build 2132 (Mar 8, 2014)

New in DbVisualizer 9.1.6 Build 2117 (Jan 27, 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 DbVisualizer 9.1.5 Build 2105 (Dec 16, 2013)

New in DbVisualizer 9.1.4 Build 2099 (Dec 7, 2013)

New in DbVisualizer 9.1.3 Build 2091 (Nov 23, 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 DbVisualizer 9.1.2 Build 2070 (Oct 28, 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
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 DbVisualizer 9.1.1 Build 2063 (Oct 2, 2013)

New in DbVisualizer 9.1 Build 2050 (Sep 9, 2013)

New in DbVisualizer 9.0.9 Build 1943 (Aug 28, 2013)

New in DbVisualizer 91.2044 Beta (Aug 22, 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 DbVisualizer 91.2037 Beta (Aug 5, 2013)

New in DbVisualizer 91.2030 Beta (Aug 5, 2013)

New in DbVisualizer 91.2029 Beta (Aug 5, 2013)

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
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 DbVisualizer 9.0.8 Build 1940 (Jul 17, 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 DbVisualizer 9.0.7 Build 1935 (Jun 17, 2013)

New in DbVisualizer 9.0.6 Build 1928 (Apr 15, 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 DbVisualizer 9.0.5 Build 1924 (Mar 5, 2013)

New in DbVisualizer 9.0.4 Build 1920 (Feb 19, 2013)

Enhancement:
Compare - Allow comparison of similar data types, e.g. Integer and BigDecimal
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
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
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
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
Bug:
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
SQL Commander - Passing both -connection and -sqlfile arguments doesn't set the connection in the SQL Commander loaded with the file
SQL Commander - Recognize WITH as a SELECT in the execution permission control

New in DbVisualizer 9.0.3 Build 1916 (Jan 26, 2013)

Enhancement:
Connection Setup - Allow (null) to be specified as the value for Database Userid and Password
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
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
Performance/Stability - Add a "Don't show this again" checkbox to the "still not enough memory" dialog for the Memory Monitor window
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
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
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
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
SQL Commander - The "Confirm Close of Unsaved Editors" tool property have no effect in some situations
Workspace - UI may flicker and focus may move to another component while DbVisualizer is auto saving editors and layout
Workspace - Using key binding to close floating tab, doesn't close the window but rather the active tab in the main window

New in DbVisualizer 9.0.2 Build 1912 (Dec 18, 2012)

New in DbVisualizer 9.0.1 Build 1909 (Dec 18, 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 DbVisualizer 9.0 Build 1902 (Dec 3, 2012)

More room to work:
We have made a large number of changes to the user interface in DbVisualizer 9.0 to give you control over the screen real estate.
Favorites integrated:
The Favorites list is now a top-level tab in the same group as Databases and Scripts, giving you a more natural layout of all navigation features.
Optimize your workspace:
When you are working on a smaller screen, you can hide the large header area in the Object View tab and the editor status bar in the SQL Commander. All tabs in the navigation area can be minimized, and you can hide sub tabs in the Object View tab that you don't need.
Maximize tab with double-click:
Want to really focus on one tab? Maximize it using double-click to cover most of the window. And if you're on Mac OS X Lion or later, we have made it possible to run as a full-screen application.
Easier to work with multiple database objects:
The new user interface is extremely flexible. You can open as many Object View and SQL Commander tabs as you need. If you want to see two objects at the same time, you can place their Object View tabs side-by-side. To have easy access to an SQL Commander, you can place it above or below your Object View tabs. Just drag and drop the tabs to any location you want. Or float any tab in its own window.
Run actions on multiple database objects:
In the Databases tab, you can now select multiple nodes and many object actions operate on multiple objects. For instance, if you want to delete a number of tables, just select them in the tree and then open the Drop Table action dialog and drop them all with one click.
To insert SQL for a couple of tables in a script, select them and drag and drop them in the SQL Commander.
Edit and run multiple actions concurrently:
Action dialogs are no longer "modal." This means you can have a dialog open and still access other things in the main window, for instance to look up a foreign key name while you have the Alter Table action dialog open.
Easier to work with SQL scripts:
You can now open multiple scripts at once, either by selecting multiple files in the File Open dialog or by drag and drop from your OS file manager. When you open a file that is already available in an SQL Commander tab, the tab is made active instead of loading the file again. The new Save All feature is convenient as it saves all open editors in a single run.
Rename tabs:
All the new tab features mentioned earlier also apply to the tabs in the SQL Commander. You can arrange the result set tabs any way you like, and you can rename result set tabs (this also includes SQL Commander and Object View tabs) to make them easier to keep track of.
Flexible object scripting:
A new Script Object dialog makes it easy to insert SQL for one or more objects selected in the Databases tree, anywhere in an open editor or in a new editor. The new Merge Result Sets feature lets you combine the text view of multiple result sets into one, which you can then print or save as a file.
Customized layout saved between sessions:
The tab layout you create is saved between sessions, so you get right back to the arrangement you like. Even better, you can get all Object View tabs preserved between sessions, so tabs for the objects you worked with last are opened automatically the next time you start DbVisualizer.
All SQL Commander tabs are also preserved between sessions. They open automatically the next time you start DbVisualizer, scrolled to the location where you left off.
Windows 8:
DbVisualizer 9.0 introduces support for Windows 8.
Easy to compare editors and grids
A new Compare tool makes it easy to find differences between two versions of a script or any grid.
Compare SQL files:
In the SQL Commander, you can compare the script to its copy on disk, to a script loaded in another SQL Commander, or to the content of the system clipboard.
Compare result sets and grid data:
You can also compare any grid in an SQL Commander or Object View tab, such as a Result Set grid, the Data tab grid for a table, or the Tables grid for a schema, to any other open grid.
The two objects are shown side-by-side in the Compare dialog, with added, removed, and changed content clearly indicated. You can navigate through the differences by clicking on buttons in the toolbar or markings in the margin. If the right pane is editable, you can also apply individual differences one by one or all at once.
Easier to see which tabs belong to a certain connection:
If you work with multiple connections, it can be tricky to keep track of which tabs belong to each connection. To help you, we have added the ability to choose a tab color for each connection. This color is shown as the tab background in SQL Commander, Object View, Monitor, and Result Set tabs.
We have also generalized the use of borders. Previously, connections marked as Production or Test got a special border. Now you can use a border for any connection, regardless of its Permission Mode. You can even create your own custom borders from a small image file.
Minimized risk of lost edits:
Nothing is worse than losing hours of work by accidentally closing a tab or because the application crashes. We have done a lot to prevent this from happening to you in DbVisualizer 9.0.
Auto-save:
First of all, all SQL Commander editors are now auto-saved. If your system or DbVisualizer should crash, the editor content is restored when you restart.
Improved memory management:
We have also improved the memory management. If memory usage gets so high that the user interface risks freezing, we suspend all tasks that consume memory and show you a dialog where you can select tabs to close and tasks to stop to free up memory in a controlled manner.
Better state control:
The risk of closing the wrong tab by accident is also minimized. All tabs allowing its content to be edited or execution of databases requests now warn when you try to close them. These and other states are visualized in the tab icon, so you can see at a glance if there are unsaved edits, uncommitted transactions, or if the tab is busy or pinned. If you are uncertain what a specific icon mean just hover the tab title and a popup will explain it for you.
Minimized problems with slow or dropped connections:
In a network-based application, it is important that potentially time-consuming operations do not freeze the user interface. We have gone through all such operations and made sure they run in the background or that they use cached data instead of getting it from the database every time. A new Task Manager shows all background tasks, allowing you to stop any task that is stuck due to a dropped connection.
Databases and drivers:
We now bundle the Oracle JDBC driver to make it easier to get started working with this popular database. We have also updated the JDBC drivers for DB2 LUW, JavaDB/Derby, MySQL, Mimer SQL, PostgreSQL, Sybase ASE, Microsoft SQL Server, SQLite, and H2.
New new Look and Feel:
We believe visual appearance is important, so we have added a couple of flavors of the Synthetica cross-platform look and feel. It's a fresh look and feel with rounded borders and shadowed popup menus. It also comes with its own file chooser, providing sortable list views on all platforms.
... and more:
The default tab naming scheme for SQL Commander, Object View, and Result Set tabs can now be configured in Tool Properties
Visual Explain Plan is now supported for PostgreSQL 7 and later
If a database filter is set each filtered level now clearly indicate number of filtered objects

New in DbVisualizer 8.0.11 Build 1772 (Sep 27, 2012)

New in DbVisualizer 8.0.10 Build 1766 (Jul 11, 2012)

Improvement:
DB Support: PostgreSQL - Sequences should be sorted by name
General - Updated bundled JDBC drivers to latest versions for DB2, PostgreSQL, SQLite, H2, MySQL and JavaDB/Derby
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
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
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
Grid Component - The Aggregation Data for Selection is not updated when extending selection with cells on the same row
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
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

New in DbVisualizer 8.0.9 Build 1751 (May 1, 2012)

New in DbVisualizer 8.0.8 Build 1745 (Feb 15, 2012)

New in DbVisualizer 8.0.7 (Feb 15, 2012)

New in DbVisualizer 8.0.6 Build 1737 (Nov 22, 2011)

New in DbVisualizer 8.0.5 Build 1714 (Nov 5, 2011)

New in DbVisualizer 8.0.4 Build 1712 (Sep 20, 2011)

New in DbVisualizer 8.0.3 (Sep 20, 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
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
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
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
Grid Component - Java VM error may occur when using copy in grid or export
Grid Component - Scrollbars are not reset when loading a smaller CLOB in the Data Cell Editor
Navigator - Selecting a Related Table with the mouse picks the currently selected entry and not the entry under the mouse
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
SQL Editor - The radio button in the Target section in the Find/Replace dialog can not be set by clicking on the labels
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 DbVisualizer 8.0.2 (Sep 20, 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 DbVisualizer 8.0.1 (Sep 20, 2011)

New in DbVisualizer 8.0.0 (Sep 20, 2011)

New Feature:
Chart - Replace the outdated charting component with a modern one
Connection Setup - Add support for SSH tunneling
Connection Setup - Redesign the Connect tab to enable SSH tunneling, more prominent placement of common properties, etc.
DB Support: H2 - Add extended support for the H2 database
DB Support: JavaDB/Derby - Add Sequence support for JavaDB/Derby
DB Support: Mimer SQL - Add Explain Plan support for MimerSQL
DB Support: SQLite - Add extended support for the SQLite database
DDL Generator - Add DDL generator and application support for CREATE INDEX
Export - Add Export actions for individual object, i.e. View, Procedure, Function, Package, Package Body, and Trigger
Export - Add support for export in OOXML (xlsx) format. Enables export of more than 65K rows in a single sheet
Export - Add TXT export format used to export fixed width columns output (grid export only)
General - Add support for the -connection, -userid and -password arguments for the DbVisualizer GUI. When passed as arguments then automatically connect the database connection at startup
General - Adapt DbVisualizer for the upcoming Java 1.7 version
Grid Component - Add "Copy Selection as Text (With Column Header)" in the grid right-click menu
Navigator - Allow editing in the Navigator grid
Navigator - Add Quick Filter for the Navigator grid
SQL Commander - Add "Show Object at Cursor" feature that will locate the object at the cursor position and show its details in window
SQL Editor - Replace the SQL/text editor component to allow for various improvements
Workspace - Optimize screen estate usage. Allow for configuring visibility of certain components
Improvement:
Auto Completion - Auto completion doesn't work if command is "WITH"
Auto Completion - Add the supported client side commands to the auto completion popup
Auto Completion - Auto Completion should show database specific reserved words
Chart - Support date/time/timestamp columns in X axis with proper scaling
Chart - A monitor script with manually adjusted chart settings are not used if re-executing the monitor in the SQL Commander
Chart - Chart setting changes made in the SQL Commander should be used automatically for new charts
Chart - Make more chart settings persistent
Chart - Automatically setup serie in chart at first display
Chart - Support GIF export format for Charts
Chart - A bookmark in SQL Commander should apply any chart settings from the bookmark
Command Line Support (dbviscmd) - Use a better error message when the specified connection does not exist
Connection Setup - Using the connection wizard to create a connection should insert the new connection based on the current object tree selection
Connection Setup - Change the controls to make it clear that Save Password and Clear Password at Disconnect are mutually exclusive
Create/Alter Table - Include table name in constraint name suggestions
Data tab - The data filtering feature automatically add WHERE first making it impossible to manually add for example "with (NOLOCK)". Fix by allowing !WHERE to be specified first in the filter
Database Objects Tree - The cache with primary keys and unique indexes need to be reset when reloading the objects tree (and also implicitly at reconnect)
Database Profile: Actions - The object action window need to be bigger for some actions such as "Create Tablespace" in Oracle
Database Profile: Actions - Unsaved edits in the object action window should be confirmed when user request canceling the action
DB Support: Oracle - The list of TNS names for Oracle should be sorted
DB Support: Oracle - Use the temporary table SYS.PLAN_TABLE$ for explain plan in Oracle 9+
DB Support: Oracle - Better support for "Object Type" objects in Oracle
DB Support: Oracle - Add "resize datafile" and "add datafile" actions for UNDO and TEMP tablespaces
DB Support: Oracle - ASM updates for Oracle
DB Support: Oracle - Support for Oracle rules, /*+rule */, without need for special configuration
DB Support: PostgreSQL - Support for array types in DDL
DB Support: SQL Server - Show computed column expression in DDL
DB Support: Sybase ASE - Order objects based on schema and name, as opposed to just name without regard for the schema
Explain Plan - Add copy to clipboard functionality for explain plan result set
Explain Plan - The tree view in explain plan should be exportable
Explain Plan - Copy Selection as Text and Export Grid (TXT and HTML formats) in Explain Plan grid should indent the tree column accordingly
Export - Make it possible to select how to delimit SQL blocks for procedure DDL
Export - Option to control position of SQL statement in export output (above/below result set)
Favorites - Add Replace action for a favorite that references a database object. This should replace the information for the favorite with the data for the selected database object
General - Quitting DbVisualizer should wait for all active connections to properly disconnect
Import - Optionally drop an existing table with the same name when using Import to New Table
Import - Add copy/paste support in "New Database Table" and in the "Map Table Columns with File Columns" import table data grids
Installation - Allow command line flag to the installer that disable file associations when installing in silent mode
Monitor - Should be possible to hide the toolbar for each monitor window/tab
Monitor - Save chart font, colors and other settings with monitor
Monitor - Auto started monitors need to run the connect prompter
Navigator - Add possibility to select a row in the Data tab grid and use it as start for the Data Navigator
Print - Print text in the SQL Editor as text instead of as a screenshot
Query Builder - Improve the support for CASE clauses in a query
References - Add option to control whether compound references should be rendered only with one link
References - Add an option to control auto zooming when searching in the references graph
Scripts - Loading a file from the Scripts tab should use the Default File Encoding in Tool Properties if encoding for the file is not set
Scripts - Minimize file access operations to increase performance when accessing files on remote hard drives
SQL Commander - Should be possible to open a .sql file and load it into a running instance of DbVisualizer
SQL Commander - Connections with same alias aren't visibly differentiated in for example the Connection drop down in the SQL Editor
SQL Commander - Path errors in the @run and @cd command should be handled just like other errors instead of showing an alert dialog and stopping the execution
SQL Commander - Allow for relative paths to be used with the @cd command
SQL Commander - Caret position and focus in SQL editors should be preserved when jumping between editor tabs using mouse
SQL Commander - Add support for ${dbvis-pwd} that will be replaced with the current directory
SQL Commander - Add new setting to control whether result sets produced in the SQL Commander always should be read-only
SQL Editor - Allow change of background color in the SQL editor and foreground color for text
SQL Editor - Support for code folding in the SQL editor
SQL Editor - Must be possible to change colors in the editor
SQL Editor - Color-coding should not interpret backslash as an escape character other than for MySQL databases
SQL Editor - Underline should not be considered a separator between two words on double click i.e. both words and the underline should be selected
SQL Editor - When opening a new SQL Editor the settings for Max Rows/Max Chars should pick their values from the previously displayed editor
SQL Editor - Should be possible to disable bold for keywords in the SQL Editor
SQL Editor - Add database specific highlighting of reserved words
SQL Editor - Insertion "Point to Next/Previous Word" should ignore underscore characters
SQL Editor - Add a "Search Scope" in the SQL Editor Find feature
SQL Editor - Support regular expression in Find
SQL Editor - SQL Editor shall have focus when going to SQL Commander directly after start-up of DbVisualizer
SQL Editor - SQL editor should support anti-aliased fonts
SQL Editor - Make it possible to change the selection color
SQL Editor - Show position of caret based on current statement
SQL Editor - Add support for editing macro recording and playback
SQL Editor - Add support for Paste from previous clipboard content
SQL History - Quick filter in the SQL History should support searching the SQL script content
Table Data Editor - Table data editor should keep focus when saving or reloading the data
Table Data Editor - Save and undo buttons in table data editor are not activated when editing a single cell or when using functions to fill a single cell
Table Data Editor - Add Enable/Disable All buttons in the key column chooser
Table Data Editor - Table Data editing should not rely on the variable identifier/delimiter specified in Tool Properties
Tool Properties - The settings for proxy should automatically be picked from the system
Workspace - 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)
Workspace - Adjust all windows so that they are no bigger than 1280x800
Bug:
Auto Completion - Manually specified qualifier is removed when using auto completion
Auto Completion - Auto completion doesn't show if name is immediately preceded with a slash
Auto Completion - Table hint for SQL Server is treated as alias in the auto completion feature
Auto Completion - Auto completion should use the database/catalog qualifier when looking for matching tables and columns
Database Profile: Actions - The SQL Formatter spins forever when formatting the action SQL for Create Synonym
DB Support: Oracle - Cannot use a plan_table referenced with a public synonym
General - Copy text from IntelliJ IDEA results in a low level warning message being printed in the debug window
Performance/Stability - Memory leak while running a lot of actions
Performance/Stability - Memory leak
SQL Editor - Color highlighting for comments in the SQL editor doesn't match the settings of comment identifiers
SQL Editor - Syntax coloring doesn't render properly if certain character combinations are in the editor buffer
SQL Editor - Netbeans editor suddenly disappear on Windows
SQL Editor - The warning "The file has been modified externally after it was originally loaded" in the SQL editor may appear erroneously if the file is stored on a network drive
SQL Editor - Extend Selection to Beginning of Line (or Beginning of Text on Line) should not restart selection
SQL Formatter - Formatter breaks erroneously on "TIMESTAMPWITHTIME ZONE..."
Table Data Editor - If selecting a cell directly start edit the value no cursor appear

New in DbVisualizer 7.1.5 (Feb 25, 2011)

New in DbVisualizer 7.1.4 (Nov 27, 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 DbVisualizer 7.1.3 (Sep 10, 2010)

New in DbVisualizer 7.1.2 (Aug 18, 2010)

New in DbVisualizer 7.1.1 (Jun 23, 2010)

New in DbVisualizer 7.1.0 (Jun 17, 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 DbVisualizer 7.0.7 (May 25, 2010)

New in DbVisualizer 7.0.6 (Apr 21, 2010)

New in DbVisualizer 7.0.5 (Mar 18, 2010)

Improvements:
Connection Tab:
DbVisualizer should stay connected even if the driver cannot handle setting auto commit while initializing the connection
DB Support: MySQL:
Fail to navigate the objects tree if "show databases" privilege is missing
DB Support: Oracle:
Add new view for DBA->Session->Plan Data that show the plan information along with the SQL for the current session
Import:
In the Import Destination->Database Table pane add column for "File Data Type" and make it editable
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
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)
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
Bug fixes:
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
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
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
Using column values from the previous execution of a monitor doesn't work properly
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
A line comment before a "go" statement delimiter causes "go" to be appended to the preceding statement
SQL Editor:
Using Save As in SQL Commander should automatically add the ".sql" extension

New in DbVisualizer 7.0.4 (Feb 24, 2010)

New in DbVisualizer 7.0.3 (Feb 24, 2010)

Improvement:
Database Profile: Actions
The Actions dialog should show the Connection Mode border to hilight production, test or production mode
Database Objects Tree
Bind Shift+Double-click in object tree to show selected object in separate window
DB Support: SQL Server
Setting Max Rows limits not only the number of rows returned from a query but also affected rows by updates, deletes, etc.
DB Support: Sybase ASE
Setting Max Rows limits not only the number of rows returned from a query but also affected rows by updates, deletes, etc.
Docs: Users Guide
Add new users guide document specifically for the command line interface with usage examples
Favorites
Opening a database object favorite should also change the tab in the Object View
Grid Component
Add "Copy to Clipboard" for inline filter
Grid Component
Add support for "ORDER BY xxx" in the Data tab "Inline Filter" field
Import
Import log should show finished time
[http://www.dbvis.com/forum/thread.jspa?messageID=10194]
Procedure Editor
Minimize impact of a lost connection, so that edits can be saved before reconnecting
Query Builder
Add a way to include a table by typing its name
[http://www.dbvis.com/forum/thread.jspa?threadID=2573]
Scripts
Allow newline characters in a @call statement
SQL Commander
Clean up the Execute processing so that a disconnected database cannot temporarily cause the GUI to freeze
SQL Commander
Add a "@set maxrows nn" and "@set maxchars nn" client-side commands to control Max Rows and Max Chars from scripts
Bug:
Command Line Support (dbviscmd)
Can't launch the dbviscmd/dbvisgui bat scripts in other directories than the installation directory for DbVisualizer
[http://www.dbvis.com/forum/thread.jspa?threadID=2983]
Check for Update
Opening "Check for Update" may result in an error
Create/Alter Table
Adding a column in the Create Table dialog adds it at the end, not after the selected column
Database Objects Tree
Shift+Click in the database tree switches to the Object View tab but details for selected node is not updated
[http://www.dbvis.com/forum/thread.jspa?messageID=10562]
DB Support: SQL Server
Invalid SQL used for extracting table DDL info for SQL Server 2000
Grid Component
Copying data from the Aggregation for Selection window to clipboard may result in weird formatting due to floating point error
Grid Component
Fix so that the "Inline Filter" preserve any "ORDER BY" that has been specified in the "FIlter & Sort" window
SQL Commander
A hang may occur if having two separate instances of DbVisualizer open at the same time and executing SQL in one of them
[http://www.dbvis.com/forum/thread.jspa?threadID=2968]
User Settings
Importing user settings creates any bookmark and monitor folders in the PREFSDIR root directory rather than in PREFSDIR/Bookmarks and PREFSDIR/Monitors

New in DbVisualizer 7.0.2 (Feb 4, 2010)

New in DbVisualizer 7.0.1 (Feb 1, 2010)

New in DbVisualizer 7.0 (Feb 1, 2010)

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
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)
SQL Commander:
Add support for parameter markers representing OUT/INOUT parameters
Make it possible controlling statement DELIMITER via a client side command
Improvement
Bookmarks:
Add multi bookmark (script file) deletion
Add option to insert selected bookmark in the SQL Editor and not only replace everything in it
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
Make it possible to export to new destination: SQL Commander->New Editor
Allow use of ${dbvis-object}$ (former ${table}$) variable in other fields than just the filename
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)
Upgrade to new icon collection
Disable client/server capability in the DbVisualizer GUI (via command line arguments)
Make command line argument "-up" deprecated and replace it with new "-prefsdir" argument
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]
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
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
Do not show the member list for ENUM and SET column types, since it can be very long
Add capability to pan the references graph with the mouse instead of scrollbars only
Enhance the "Specified Tables" feature so that it is easier to choose what tables to show in the references graph
The data types presented for a table are sometimes too verbose
Scripts:
Should be possible to define default target editor when exporting or double-click a bookmark and history entry
SQL Commander:
If @ is used as the anonymous block begin delimiter, no client-side commands are recognized
Extend the Permission feature with controls for Commit/Rollback/Set Autocommit
Loading a file with File->Open Recent should not show file chooser but instead load file directly
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:
Activate 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 DbVisualizer 6.5.12 (Dec 23, 2009)

New in DbVisualizer 6.5.11 (Dec 6, 2009)

New in DbVisualizer 6.5.10 (Oct 23, 2009)

New in DbVisualizer 6.5.9 (Aug 31, 2009)

New in DbVisualizer 6.5.8 (Aug 28, 2009)

New in DbVisualizer 6.5.7 (Jun 19, 2009)

New in DbVisualizer 6.5.6 (May 15, 2009)

New in DbVisualizer 6.5.5 (May 15, 2009)

New in DbVisualizer 6.5.4 (May 15, 2009)

New in DbVisualizer 6.5.3 (May 15, 2009)

New in DbVisualizer 6.5.2 (May 15, 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 DbVisualizer 6.5.1 (May 15, 2009)

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
Bug
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 DbVisualizer 6.5 (Oct 23, 2008)

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