DbVisualizer Changelog

What's new in DbVisualizer 24.1

Jan 9, 2024

Introducing DbVisualizer 24.1. This new release comes with an all-new Code Editor, that has been completely overhauled and improved. It comes with improvements such as a better Find and Replace tool and a smarter Auto-complete function. We're also introducing Workspaces, a handy feature that makes switching between contexts and tasks simpler. You’ll also see updates to how you create new connections, how the master password behaves, performance improvements, better database support, and more.
Version 24.1 is our first release of 2024, and we are excited for what’s yet to come. Our plan is to accelerate development even more this year, build on our progress from 2023, and invest even further in additional capabilities and reliability in 2024.
SQL Editor rebuilt from the ground up:
We've completely overhauled the SQL editor in our latest update to be more user-friendly and efficient. This new version includes many improvements, both big and small, all aimed at giving you a great environment to work in.
Find and Replace:
We've redesigned the Find and Replace functions for efficiency and ease of use. Now, you can seamlessly switch between searching and replacing text, choose to match by case or whole words, utilize regular expressions for complex searches, and easily navigate between matches. All of this is accessible through a straightforward, inline panel.
Auto-complete:
The new SQL editor features a newly developed auto-completion engine designed to be smarter and more accurate than before. Among other things, it handles complex queries better and understands the difference in context between the inner and the outer parts of the query.
The default shortcut to trigger the auto-complete feature in the editor is CTRL + SPACE.
Switch between multiple contexts using workspaces:
The new release includes support for workspaces, a feature that allows you to switch effortlessly between different work contexts. Each workspace operates independently, complete with its own connections, drivers, scripts, and settings. This functionality makes it easy to manage distinct environments, projects, or client engagements. You have the flexibility to tailor each workspace to suit your specific requirements.
Workspaces can be created and opened through the File -> Workspaces menu.
Create a connection from a database URL:
We've introduced an additional method to create database connections, to simplify the setup process. Now, you can begin by entering your database URL, and DbVisualizer will automatically choose the matching drivers for you.
Streamlined handling of the master password:
If security is a priority for you, you're likely already familiar with our master password feature. In this new release, we've refined the master password experience to make it more intuitive and less obtrusive. This enhancement allows you to maintain robust security without compromising on ease of use.
Performance and stability fixes:
Improved database read performance:
We've reduced the need for roundtrips and are handling paging in a smarter way for BigQuery, SingleStore, Vertica, and Oracle databases. This results in better response times and less load on the database.
Additional syntaxes for multi-row inserts:
We’ve added support for additional syntaxes for multi-row inserts that can be generated when exporting table data. Using multi-row inserts is essential to the performance when importing large data sets. This release extends the support for the default SQL-92 syntax to also include syntaxes specific to Oracle and Cassandra, as well as the generic union-based syntax.
Multi-Row INSERT exports for tables in DbVisualizer
Smarter memory management:
Memory used by scripts and result sets is released faster, making DbVisualizer more efficient when processing large result sets and working with complex scripts.
Improved database support:
Oracle:
The Grant Privilege action has been added for materialized views, functions, and procedures in Oracle databases. With this addition, you can give privileges to database users to perform operations on the corresponding database object. To give privileges to several objects at once, select them in the database objects tree first.
Microsoft SQL Server:
In the new release, default constraints are displayed alongside primary key, foreign key, unique and check constraints in the database objects tree for SQL Server. This allows for a more comprehensive view and easier navigation of the database schema.
SingleStore:
Now, DbVisualizer includes the capability to display the DDL for pipelines in SingleStore. This allows users to view the underlying SQL statements that define the structure and configuration of pipelines in their database.
Vertica:
Support for procedures in Vertica has been improved. Now it is possible to create stored procedures as well as external procedures in the GUI, and more information about existing procedures is shown both in the Procedures view and in the database objects tree.
Additional improvements across the board:
Navigation in the row form editor:
We've added navigation buttons to the row form editor in DbVisualizer. This update makes it easier to move between rows within a full result set, while staying within the familiar interface of the row form editor. This enhancement streamlines the process of reviewing and editing data, providing a more seamless and efficient user experience.
Adjust window sizes to the selected application font:
As you adjust the font size within the application, the windows will automatically resize to match, ensuring a consistent and optimal viewing experience. This feature not only improves readability but also provides a more comfortable and adaptable user interface, catering to various screen sizes and user preferences.
Security updates:
We keep strengthening our security infrastructure by upgrading to the latest version of the Java platform and updating third-party dependencies. This approach to maintaining up-to-date software components is a key part of our commitment to providing a secure environment for our users. DbVisualizer now comes bundled with Java 17.0.9.

New in DbVisualizer 23.2.5 (Oct 5, 2023)

New in DbVisualizer 23.2.4 (Aug 16, 2023)

New in DbVisualizer 23.2.3 (Jul 14, 2023)

Improvements:
DB Support: Snowflake:
Add support for creating JavaScript procedures
Query Builder:
SQL Commander:
"Show SQL Editor" and "Show Query Builder" create a new SQL Commander if necessary
Bugs Fixed:
Auto Completion:
"Show Autocomplete" and "Show Editor Templates" actions do not work when triggered from the main menu or the context menu
Check for Update:
Improved error handling when trying to upgrade while an upgrade is already in progress
DB Support: DB2 LUW:
Using DBMS Output gives too many concurrently open statements
DB Support: DB2 iSeries:
SQL Commander:
Can't select schema in SQL Commander
DB Support: Greenplum:
DB Support: PostgreSQL:
Incorrect partitions reported for partitioned tables
DB Support: Oracle:
Explain Plan:
Handle multiple predicates in Oracle's explain plan
DB Support: Redshift:
Redshift driver artifacts are not compatible with each other
DB Support: Snowflake:
Snowflake Create Procedure SQL Preview has bad javascript syntax
Incorrect code generated when creating a procedure or a function
DB Support: Vertica:
Adjust for overloaded procedures-related changes in Vertica 12.0.4
Data tab:
Rare error when closing an Object View while the Data tab is being loaded
Database Objects Tree:
DB Support: Google BigQuery:
Exception when expanding tables in the database objects tree
Driver Manager:
Exception when changing driver name and class
Export/Import User Settings:
Exception when exporting user settings and a driver file is missing
General:
The link in the "Certificate not trusted" dialog doesn't work
Grid Component:
OS Support: macOS:
Can't paste grid data in some applications on macOS
Installation/Update Installation:
Connections lost after upgrade if running multiple DbVisualizer instances
OS Support: Linux:
Main menu is not merged with the window title bar for the first opened DbVisualizer window
OS Support: Windows:
SQL Commander:
DbVisualizer may lag on Windows as a result of the stale file checker accessing a slow file system
SQL Commander:
Exception when handling a database error
Vertical scrollbar in SQL Commander is cut off if the window is small enough
Table Data Editor:
Exception when stopping an ongoing save operation in the table data editor, and related improvements
Exception when undoing delete of row

New in DbVisualizer 23.2.2 (May 17, 2023)

New in DbVisualizer 23.2.1 (May 10, 2023)

New in DbVisualizer 23.2 (May 10, 2023)

Improvements:
DB Support: DB2 LUW:
DB Support: Oracle:
Add a connection property to enable DBMS output automatically
DB Support: Exasol:
Update the driver and add new keywords
DB Support: Greenplum:
DB Support: PostgreSQL:
Generate DDL for foreign tables
DB Support: Snowflake:
Add data views for database, warehouse, server info and user parameters
Database Objects Tree:
DB Support: Greenplum:
DB Support: PostgreSQL:
Show foreign tables under foreign servers in the database objects tree
Display foreign servers for each database in the database objects tree
Driver Manager:
Upgrade template drivers:
Separate driver artifacts from driver definitions to allow reuse and improve maintainability
Add folders containing any file type to driver path
Driver Manager:
Tool Properties:
Add a server availability indicator to the list of Maven repositories in Tool Properties
Export/Import User Settings
Create user drivers automatically when importing connections exported without the driver
SQL Commander:
Detect missing WHERE clause in DELETE and UPDATE (controlled using Tool Properties > Permissions)
Workspace:
Adjust windows to visible screen area when screen setup changes
Bugs Fixed:
Auto Completion:
The auto completion popup qualifies table names with database and schema
Improved auto completion for object names with mixed case
DB Support: PostgreSQL:
Error in generated DDL when NO INHERIT is used
DB Support: SQLite:
Handle tables with names in mixed case or matching reserved keywords
Driver Manager:
Resetting a driver created from a template with downloaded artifacts refers to artifacts in the template
Clear current filter when opening a connection's driver in Driver Manager
Export:
Improve random data generation in grid export (see "Generating Test Data" in the users guide)
Grid Component:
Pasting table content from DbVisualizer into Slack doesn't work
Import:
Error when clicking the Table Engine drop-down in Import Table Data
Installation/Update Installation:
EULA should only have to be accepted once during upgrade
OS Support: macOS:
Clicking on .sql files doesn't open them in DbVisualizer
Performance/Stability:
Improve performance of the database objects tree by optimising auto detection of database type
SQL Editor:
Tool Properties:
With the JetBrains Mono font, any change of font size is not preserved between DbVisualizer sessions

New in DbVisualizer 23.1 (Mar 17, 2023)

New Features:
DB Support: ClickHouse:
Add support for the ClickHouse database
Improvements:
Compare:
Add support for comparing formatted values in Tools -> Compare
Connection Setup:
Allow using tilde ("~") to represent user's home folder in the "Database File Name" field
Connection Setup:
DB Support: MariaDB:
DB Support: MySQL:
Detect expired passwords and suggest password reset
Connection Setup:
SSH:
Add support for SSH jump servers
DB Support: Cassandra:
Generate DDL for materialized views in Cassandra
DB Support: CockroachDB:
Add a template driver for CockroachDB
DB Support: Greenplum:
DB Support: PostgreSQL:
DB Support: Redshift:
Simplify CREATE VIEW with complex FROM clauses by avoiding unnecessary parentheses
DB Support: Greenplum:
DB Support: PostgreSQL:
DB Support: Redshift:
DB Support: Yellowbrick:
Generate IF EXISTS in DROP statements
DB Support: Mimer SQL:
Update database profile for Mimer SQL with support for multifile data banks
DB Support: Vertica:
Add support for stored procedures introduced in Vertica 11.0
Driver Manager:
Upgrade template drivers and bundled drivers to the corresponding latest version
Export:
Allow using the tilde character ("~") as prefix in file system paths
Export/Import User Settings:
Add support for export/import of SQL Commander tabs
Export/Import User Settings:
Favorites:
When importing favorites, place the imported items in a new folder
Export/Import User Settings:
Installation/Update Installation:
Add support for export/import of the recent files list. Also, recent files are preserved when upgrading to a new version
File Chooser:
Add support for drag and drop in file path fields
Add support for drag and drop in file chooser dialogs
See the discussion here
File Chooser:
OS Support: Windows:
Performance/Stability:
Add an option to ignore disconnected drives that may affect application performance
Grid Component:
Tool Properties:
Adjust the "Grids" font setting in Tool Properties to affect result sets rather than all grid types
Import:
Make the option to stop on error in the import table dialog persistent
Installation/Update Installation
OS Support: Windows:
Web:
Offer a Windows installer with bundled JRE for ARM
Performance/Stability:
SSH:
Add option to choose SSH client package, improved performance of the default setting
SQL Commander:
Display an arrow in drop-down cell editors to indicate there are options to choose from
Theme: FlatLaf:
Look and feel updates with new application and editor fonts, embedded menu bar in Linux, extended file chooser in Windows and more
Workspace:
Wrap around when switching between tabs using menu commands
Bugs Fixed:
Connection Setup:
Long database URL overlaps with connection timer in the Connection tab
Improve filtering in the new connection popup
"Connect All" may fail when there are broken connections and master password is enabled
Create/Alter Table:
Alter Table displays wrong referenced table for foreign key constraints when the referenced table is in a different schema
DB Support: PostgreSQL:
Alter table shows SQL in the SQL Preview even if nothing has been changed
DB Support: Snowflake:
Slow query execution due to incorrect implementation of metadata queries in the database driver
DB Support: Snowflake:
SQL Commander:
Schema drop-down doesn't reflect the last executed 'use schema xxx'
Database Profile: Actions:
Action dialog is placed in top left screen corner rather than center of the parent window
Driver Manager:
Connections may lose driver reference when migrating
Export:
Export of tables with multiple computed columns fails
Export:
SQL Commander:
@export may generate wrong SQL when executing select from a qualified table
Export/Import User Settings:
Improve feedback when importing user settings from an newer version of DbVisualizer
Export/Import Settings dialog is truncated on smaller screens
Favorites:
Exception when dragging a database connections folder into the Favorites tab
Installation/Update Installation:
OS Support: macOS:
Shell scripts for starting DbVisualizer are not executable in 14.0.3
Monitor:
If the monitor is running in auto-load mode and the connection is lost, the monitor is never reloaded despite clicking connect in the error message
OS Support: Windows:
Executing resolveJRE.bat twice in the same command prompt fails
Object View:
Selecting a folder in the connection tree may cause an exception when autoscroll to object view is enabled
Performance/Stability:
Handle "memory pool not found" exception gracefully when running out of memory
SQL Commander:
Extra tab key press needed to focus desired button in the connect dialog
SQL Editor:
Remove duplicate items from the context menu in SQL Commander
Can't change type of variable to literal after use

New in DbVisualizer 14.0.3 (Jan 4, 2023)

New in DbVisualizer 14.0.2 (Nov 28, 2022)

New in DbVisualizer 14.0.1 (Oct 16, 2022)

Improvements:
Create/Alter Table:
Add the ability to edit check constraints in a new window
DB Support: MariaDB:
DB Support: PostgreSQL:
Update the PostgreSQL and MariaDB driver versions due to vulnerability
DB Support: Oracle:
The state of auto clear log in the DBMS output tab should be kept between sessions
File Chooser:
OS Support: Windows:
Alert the user if the Windows file system holds any disconnected drives that may affect the application (file chooser) performance
SQL Log:
The SQL log filtering whether to show success/error entries needs to be available as a button in the toolbar
Bugs Fixed:
App Logging:
Exception when trying to tail log files on network drive
DB Support: Google BigQuery:
No dataset in BigQuery profile for AuthType=2
DB Support: MariaDB:
References:
The references graph shows multiple arcs between tables in MariaDB
DB Support: Oracle:
DBMS OUTPUT tab is cleared between every statement having automatically clear checked (should clear only once per script)
DB Support: PostgreSQL:
Error: Could not find array type for data type information_schema.character_data
DB Support: SQL Server:
The PERSISTED keyword is not highlighted
Data tab:
Extract Filter & Sort as SELECT doesn't consider reordering columns in the grid
Database Objects Tree:
Having "Autoscroll FROM Object View tab" enabled should not automatically connect an object view tab showing a disconnected database connection when selected
Database Profile: Actions:
DB Support: SQL Server:
Script Table should not output PERSISTED columns in the generated SQLs if "Include Auto-Generated Values" is off
Export:
@export is broken if an @export set parameter have whitespaces between "=" and the value
File Chooser:
OS Support: Windows:
File -> Open Recent lags when list holds files on disconnected Windows drives
SSH:
Error opening SSH configurator
Open rename SSH config dialog gives an exception if there is no SSH configuration selected
Prompting of MFA/2FA challenge codes when using SSH doesn't work

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 13, 2022)

New in DbVisualizer 13.0 (Mar 4, 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.2 (Aug 26, 2021)

New in DbVisualizer 12.1.1 (Jul 25, 2021)

New in DbVisualizer 12.1 (Jul 13, 2021)

New in DbVisualizer 12.0 (Jan 25, 2021)

Now supports Yellowbrick database:
Yellowbrick offering massively parallel processing (MPP) data warehouse and SQL analytics solution. Read more about Yellowbrick in DbVisualizer.
Support for the Greenplum database:
Greenplum Database is an open-source massively parallel data platform for analytics, machine learning and AI. Read more about Greenplum in DbVisualizer.
Support for Microsoft Azure SQL Database:
Microsoft's cloud database, Azure SQL Database is now on the list of supported databases in DbVisualizer. Read more about Azure SQL Database in DbVisualizer.
Oracle Cloud, MySQL Cloud, IBM Db2 on Cloud:
The existing support in DbVisualizer for Oracle, MySQL, and Db2 LUW is now verified with the corresponding cloud offerings by these vendors.
New beautifully looking cross-platform themes and flat icon collection:
We've simplified the themes in DbVisualizer by introducing FlatLaf which comes in a Light and a Dark theme. These replaces the former themes (aka "look and feels") on all supported platforms: Windows, macOS, and Linux.
In addition, all images and icons throughout the user interface has been updated to a modern flat look.
SQL Block enclosures:
Complex statements such as CREATE PROCEDURE using semicolons in their body previously required special treatment using SQL block identifiers. This version doesn't require special DbVisualizer identifiers other than what the database require for complex statements. Just enable Allow SQL dialect in Tool Properties in the General / SQL Commander / Delimiters category.
Auto Join:
Auto complete in SQL Commander now suggests join conditions if there are primary/foreign key mappings defined for the tables being part of a query.
.pgpass:
PostgreSQL, Redshift, Yellowbrick, and Greenplum supports reading database connection password from the .pgpass file.
... and more:
Now supporting Java 11 on Windows with support for HiDPI monitors
BOM identifiers are now handled in SQL files and during import
More explain details are now displayed for DB2 LUW

New in DbVisualizer 11.0.6 (Nov 27, 2020)

New in DbVisualizer 11.0.5 (Sep 14, 2020)

New in DbVisualizer 11.0.4 (Jul 9, 2020)

New in DbVisualizer 11.0.3 (May 22, 2020)

New in DbVisualizer 11.0 (Apr 13, 2020)

Support for the MariaDB and Snowflake databases:
We've added extended support for the MariaDB and Snowflake databases.
New client-side commands: @import, @mail, @open:
The collection of client-side commands has been extended with the new @import, @mail, and @open commands that allows importing table data, sending emails, and opening files in native tools from SQL scripts executed in the SQL Commander in the DbVisualizer UI and in the dbviscmd command-line interface. Client-side commands is a DbVisualizer extension allowing database independent processing in SQL scripts executed in the DbVisualizer UI and the dbviscmd command-line interface. A popular example is the @export command which is used to save result sets from SQL queries to file. With the addition of the new @mail command, SQL scripts processed in DbVisualizer can now both extract data and mail them without needing to setup external command files.
@import - Importing data:
The new @import client-side command used to import files into tables is now available for execution in SQL scripts and then also in the command-line interface, dbviscmd. It supports importing CSV, Excel, and fixed width text files.
@mail - Send emails and attach files:
The new @mail command allows sending emails from SQL scripts executed in the SQL Commander in the DbVisualizer UI and in the dbviscmd command-line interface. Client-side commands is a DbVisualizer extension allowing database independent processing in the DbVisualizer UI and the dbviscmd command-line interface. A popular example is the @export command which is used to save the result set from any SQL query to file. With the addition of the @mail command, scripts can run solely in DbVisualizer to both extract results from queries and the mail them.
In the DbVisualizer UI, it is possible to define a mail server account that collects information about a mail server and user credentials. This persists encrypted between DbVisualizer sessions. The named account can then easily be referred in SQL scripts only requiring basic information about to whom the email should be sent, subject, body text, files, etc.
The @mail command supports a lot of customizations such as templates, statistics from the latest run, etc. The following example will send the content of a csv file as part of the body and addition it will be attached as a file. As with normal mail, multiple files can be attached or embedded in the body section.
@open:
The new @open client-side is really as it sounds, it opens the file specified as parameter in the associated native tool. For html files a web browser is opened, for xlsx files a spreadsheet tool such as Microsoft Excel is opened.
Improved SQL Formatter with Preview:
The new SQL formatter preview makes it a lot easier to see the impact of the various formatting settings.
SQL formats can now be saved in named SQL formatting profiles that can be used for all database connection associated with a specific database type (Oracle, MariaDB, Exasol, etc) or for individual database connections.
Morph to Delimited List:
The Morph Selection with Dialog in the SQL editor allows the user to convert a selection of text into a delimited list with the appropriate options.
Improved Key Bindings Editor:
It is now possible to search and filter action names and keystrokes in the key bindings editor. Key bindings can be exported to spreadsheet for external reference.
Export Grid and Open as Spreadsheet Improved:
The export grid and open as spreadsheet commands has previously operated on the result set as fetched from the data source. Any grid sorting, filtering or rearranged columns was not considered in these functions. The new and default Export Visible and Open Visible as Spreadsheet actions now consider the visual appearance in the grid make it a lot more versatile. The old behavior is still available.
Auto Resize of Columns in XLSX Exports:
The annoying step of having to manually adjust column widths to fit the content in a newly exported xlsx is now elimated.
References Graph:
The references graph now highlights inbound and outbound links for one or more selected table with colors for the corresponding columns and links, thus making it easier to understand what columns form references between tables.
Database and Schema Lists Now Follows any Filters:
The database tab object filtering is a powerful tool to limit what objects should be displayed in the Databases tab. This version finally improves the content of the Database and Schema drop-downs in the SQL Commander to adjust automatically without needing to reconnect when a filter is applied or cleared in the Databases tab.
Scoping Database Connections for Multi Edit:
Having several hundreds of database connections defined in DbVisualizer is not very common albeit those setups exists. The Edit Database Connections action in the Databases right-click menu has been around for several years and enables editing common database connection settings in a single run. The new version makes it easier to scope the database connections for edit and is available in the improved Connections overview (the top node in the Databases tab). It allows sorting and filtering making it a lot easier to select the database connections that should be included.
The very same tool is now also displayed for Folder objects which is also a level of filtering as it will only show all Database Connections stored in that folder.
Generator for the Command-Line Interface, dbviscmd:
The new dbviscmd command-line setup generator makes it really easy creating the command-line for dbviscmd, either freely or by using the editor content in the SQL Commander along with current parameter settings as a base. Just click Copy and paste on the command-line to run the command-line interface for DbVisualizer.
dbviscmd, Command-line interface Improvements:
Prompting for Variable and Parameter Marker:
Prompting of variables and parameters markers has been added in the command-line interface, dbviscmd. dbviscmd supports the exact same variable and parameter marker syntax, i.e. SQL scripts as the DbVisualizer UI does. Data types are prompted with default recommendation if applicable.
@mail Client-Side in dbviscmd:
Support for the new @mail command in scripts. @mail will send result sets generated by SQL queries (or any file) by email as either embedded text or attached files. There are many options including a template engine which allows setting up custom emails easy.
Database Dashboard:
The database profile framework in DbVisualizer is a used to define the characteristics of a supported database with database specific functionality that exceeds what JDBC offers. With this release we have added the capability to build dashboards presenting various database metrics as charts. Currently available only for Exasol.
And more:
Automatically set SQL Mode when editing Procedures and Functions for MariaDB and MySQL
Add support for ~, !~, ~*, !~* operators in the Query Builder for PostgreSQ
The new Copy Selection As->Copy Selection as AND/OR clause
Now possible to include charts in Object View tabs
Updated versions for bundled JDBC drivers:
DB2 4.5.23,
Derby 10.14.2,
Exasol 6.2.3,
Mimer SQL 3.40,
MySQL 5.1.48,
NuoDB 21.0.0,
Oracle 19.3.0.0.0,
PostgreSQL 42.2.9 JDBC 42,
Redshift 1.2.37.1061,
SQLite 3.30.1,
Vertica 9.3.1-0

New in DbVisualizer 10.0.26 (Feb 5, 2020)

New in DbVisualizer 10.0.25 (Feb 5, 2020)

New in DbVisualizer 10.0.24 (Nov 4, 2019)

New in DbVisualizer 10.0.23 (Oct 23, 2019)

Improvements:
Auto Completion Column names should be auto completed even though preceded by "top "
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 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
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 " which runs the previous statement times
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
Bugs Fixed:
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 3, 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
Elasticsearch: Add Database Type and driver entry for Elasticsearch
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
InterSystems IRIS: Add database type and driver entry for InterSystems IRIS
SQL Server: Include Creation and Modification Date in the listings for tables, views, procedures, etc.
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
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
MySQL DDL Generator: The DDL for a GEOMETRY and its spatial key is incorrect
Oracle: The "Change Password" capability for Oracle is invisible for a brand new Oracle connection. Only restart makes it visible
PostgreSQL:
View definition not visible for a user not owning the view
Empty Arrays are displayed as NULL
PostgreSQL / Redshift:
When getting catalogs in Redshift there is suddenly the "oid" column in first index where catalog name is expected
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 10, 2019)

New in DbVisualizer 10.0.16 (Dec 18, 2018)

Improvements:
App Logging - New parameter -errordir 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 (Oct 4, 2018)

New in DbVisualizer 10.0.14 (Aug 16, 2018)

New in DbVisualizer 10.0.13 (Jun 12, 2018)

New in DbVisualizer 10.0.12 (May 16, 2018)

New in DbVisualizer 10.0.11 (May 7, 2018)

New in DbVisualizer 10.0.10 (Apr 7, 2018)

New in DbVisualizer 10.0.9 (Apr 5, 2018)

New in DbVisualizer 10.0.8 (Feb 27, 2018)

New in DbVisualizer 10.0.7 (Jan 27, 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
[https://support.dbvis.com/discussions/topics/1000085013]
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
[https://support.dbvis.com/discussions/topics/1000086824]
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 (Jan 6, 2018)

New in DbVisualizer 10.0.4 (Nov 26, 2017)

New in DbVisualizer 10.0.3 (Nov 11, 2017)

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

Enhancement:
Database Profile: Actions
DB Support: Vertica: Add a Purge Table action for a table in Vertica
Export
Grid Component: Add a "Open as Spreadsheet" in grids
Favorites: Add shortcuts for Select Target Object in the Favorites toolbar (Alt+click) and the Favorites tab (Alt+double-click)
General: Allow scaling UI more than 200%
SQL Commander: Add a "Select Target Script File" in the SQL editor status bar filename right-click menu. Used to highlight any corresponding script file in the Scripts tab
Bug:
Connection Setup: ConcurrentModificationException when running "Connect and execute"
Connection Setup
DB Support: Informix: When connecting to Informix "SQLWarning: Database Selected" is displayed at the top of the Connection Message
Database Objects Tree: Dragging a table from the Databases tab to the query builder doesn't work if Autoscroll TO Object View tab is enabled
Database Objects Tree: With "Autoscroll TO Object View Tab" enabled, do not autoscroll if right-click an object or when double-click set to Expand/Collapse Child Objects
Database Objects Tree: A java.util.ConcurrentModificationException may occur while loading database objects tree if there are a lot of objects
Export: Exporting time and date data is not thread safe
Grid Component: Wrong datetime for dates before 1893-04-02
Grid Component: If having a very large grid, select all cells and then reload, the reload takes long time to complete
Grid Component
OS Support: macOS: Paste a multiline selection from Excel to a DbVisualizer grid only paste the first row
Import: Potential exception when importing XLSX
Installation/Update Installation
OS Support: macOS: The macOS menubar is not displayed when the Preferred OS Language is not English
Performance/Stability: The OutOfMemory dialog is not as responsive as it should
Procedure Editor: Closing Procedure Editor while compiling shows the "confirm close" dialog twice if clicking Keep Tab
SQL Commander: Improve meaning of "Confirm unsaved SQL Commanders"
SQL Commander: Potential NPE if closing the Procedure Editor while compiling
SQL Commander: @delimiter command is not detected if preceded by a line comment
SQL Editor: Triple-click in editor loses some of the selection if extending selection with shift-down
Tool Properties: Formatting does not work for patterns following the millis pattern .SSS

New in DbVisualizer 10.0.1 Build 2753 (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 24, 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 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 "(" 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= in user.vmoptions (Tool Properties->General)

New in DbVisualizer 10.0 Build 100.2707 Beta (Jul 24, 2017)

New in DbVisualizer 10.0 Build 100.2703 Beta (Jul 8, 2017)

New in DbVisualizer 10.0 Build 100.2696 Beta (Jun 30, 2017)

New in DbVisualizer 10.0 Build 100.2687 Beta (Jun 23, 2017)

New in DbVisualizer 10.0 Build 100.2674 Beta (Jun 17, 2017)

New in DbVisualizer 10.0 Beta (May 27, 2017)

Enhancement:
Connection Setup: Remove Authentication Method dropdown and always include the Authentication Domain field in Options
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
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]
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 adding custom statements first/last in file produced by schema export
Export: Make it possible to select all objects for Export Schema with one click
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: Allow for Date/Time/Timestamp data to be exported with JDBC escape syntax
Export: Should be possible to organize the output of schema export so that all DROP, CREATE and INSERTs are grouped
Export: Possibility to set ExcelSheetName in export wizard
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
File Chooser: Enable file system auto completion in file selection field
File Chooser: Add recently used files/folders list in file selection field and file chooser window
File Chooser
SQL Commander: The Log to File button should have a drop down with last used files
General: Add support for the Darcula (dark) look and feel
[http://support.dbvis.com/support/discussions/topics/1000078054]
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:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot" Java property
Installation/Update Installation: Remove the "-XX:MaxPermSize" Java property as it is deprecated with Java 8
Key Bindings: Adding a keybinding for Merge Result Sets
OS Support: Mac OS X: Change all visual references of 'Mac OS X' to 'macOS'
SQL Commander: Use setSchema() to set schema for execution to the selected schema
SQL Commander: Add an option to name SQL Commander tabs as index only if there is no loaded file name
SQL Commander: Add a way to be able to use Java VM system properties and OS environment variables in DbVisualizer variables
SQL Commander: Make filename in SQL editor status bar clickable with options to Copy Path and Open Parent Folder
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: Consistency between Elapsed Time and Execution/Fetch time
SQL Commander: "@export set" commands are order dependant
SQL Commander
SQL Log: Improve the capability for writing the execution log to a file (@spool is now replaced with new "@log spool / clear"
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: SQL Log tab entries for @ commands could show more information for the command
SQL Log: Make the log in the SQL Commander more interactive
[http://support.dbvis.com/support/discussions/topics/1000076470]
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: Allow changing look and feel at startup
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]
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
SQL Commander: Regression: Error highlighting marks whole line instead of just the invalid word
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
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 to JSON Array with AppendFile set to clear creates one array per table
Export: Export of multiple results to HTML with AppendFile set to false creates a document that is missing the header
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 HTML from table with no data generates HTML with one line
Export: Exec time is the same for all log entries during Export Schema/Database
Export: Cannot export View data with Export Schema
Export/Import User Settings: The export/import user settings window is too high
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]
Query Builder: Quick Add should not be enabled without a connection, and the other buttons should not be enabled without tables
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: @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: @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: 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: 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
SQL Log: Having a @spool command without actually logging to a file sends the command to the database. @spool also replaced with @log

New in DbVisualizer 9.5.7 (Apr 12, 2017)

ENHANCEMENT
DB Support: DB2 LUW: Sort triggers in the tree on schema and name
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.6 (Feb 5, 2017)

Enhancement:
DB Support: Other - Add a driver entry and database type for MariaDB
DB Support: PostgreSQL - Add Script action for Materialized View
DB Support: PostgreSQL - Add Columns node for Materialized views in PostgreSQL
DB Support: SQL Server - Add support for CLUSTERED and COLUMNSTORE indexes
Database Profile: Actions - The result dialog generated by running an object action should preserve its size between action invocations
References - Add option to show column names w/o data type information
[https://support.dbvis.com/discussions/topics/1000082073 ]
Bug:
Chart DB Support: SQLite - Exception may occur when charting a SQLite table having non data type valid values such as string in a date column
Compare - Various issues when editing inserted or deleted grid row blocks
Connection Setup - NullPointer Exception trying to force disconnect a connection
DB Support: Oracle - The SGA->SQL drill-down view doesn't show any SQL even if having a selection
DB Support: SQL Server - Table index view does not work for older versions of SQL Server
DB Support: SQL Server - Index shown with null in the label for SQL server older than 9
DB Support: SQLite
References - Tables with no data type name for columns are rendered bad in References graph
DB Support: Sybase ASE - Triggers shown for a table may belong to a referenced table
DB Support: Sybase ASE - Bogus Index may be included in Export
DB Support: Sybase ASE - Triggers are not sorted in the tree
Database Objects Tree - The expand icon in the Databases tab is sometimes invisible
Export - Export of a function or procedure may result in an error
Export - NPE if using HTML format and having two export blocks in one script
Export - ConcurrentModificationException when cancelling export
Grid Component - A null value in the column being filtered using the column filtering results in an NPE
Grid Component - Closing a Data Tab with BLOB columns after closing the connection gives error
Import - Column values for calculated value does not work when importing excel
OS Support: Linux
SQL Editor - Middle mouse button paste doesn't work in SQL editor
Query Builder - Table nodes that are moved outside (top or left) the drawing area cannot be moved back
SQL Commander - Default date/time/timestamp value in variable prompter
[https://support.dbvis.com/discussions/topics/1000081718 ]
SQL Commander - Current database connection, database and schema are cleared when running query
SQL Commander - @echo ${dbvis-date}$ does not work when a data type is specified in variable
Tool Properties - "java.lang.IllegalArgumentException: Width and height must be >= 0" when opening font chooser
Tool Properties - Setting "Display Null Value" to a whitespace doesn't preserve between sessions

New in DbVisualizer 9.5.5 (Dec 5, 2016)

Enhancement:
DB Support: Other
Web - Add driver entry for Salesforce (Reliersoft)
DB Support: Sybase ASE - Highlight SQL error lines in the editor with jConnect
Database Objects Tree - Have an option to sort object type grouping nodes in the databases tab
Export - Add a footer field for HTML exports
Bug:
Command Line Support (dbviscmd) - NullPointer exception if -catalog argument is not used when using the command line interface
Connection Setup - Reconnect and Execute does not always do execute
Connection Setup - Connections are not saved if creating a new connection with connection wizard
Connection Setup - Enabled state for Disconnect All is only set when Databases tab has focus
Connection Setup - Save properties after connection changes
Connection Setup - "Database id 0 for 'xxx' is invalid" error when creating connection
DB Support: H2 - Executing H2 function does not work
DB Support: PostgreSQL - PostgreSQL foreign tables show up in all schemas
DB Support: PostgreSQL - HSTORE column where clause fails due to bug in bundled driver
DB Support: Redshift - Errors when getting metadata for BIGINT IDENTITY column
Export - Fix HTML export so that only a single set of "Title" and "Intro Text" is in the document for multiple result sets
Favorites - Using the "Replace with Current Object Tab" action for an existing favorite will save an erroneous object path that doesn't work
File Chooser - Recent path has wrong values for encoding and should store paths as CDATA
Grid Component - Form viewers may get in a strange layout state when there are BLOB/Binary/CLOB data
Navigator - Optionally show qualifiers in the Related Table drop-down
SQL Commander - Setting Database or Schema to first empty entry resets the Database Connection list
SQL Commander - Variable prompter for BLOB/Binary/CLOB values corrupts the data
SQL Commander - Unexpected "Permission ALERT!" for @set resultset name
SQL Commander - Schema drop down is changed after DDL command
Table Data Editor - Leaving a number field empty results in NPE

New in DbVisualizer 9.5.4 (Nov 15, 2016)

ENHANCEMENT:
DB Support: PostgreSQL: Add support for editing data with with the cidr, inet and macaddr data types
Database Objects Tree: Add a Select All Child Objects in the database objects tree right-click menu
SQL Editor: Preserve whitespace in editor templates
Table Data Editor: Allow entering "now" in any of Date, Time, and Timestamp fields during editing. It is then replaced with the corresponding value
BUG:
Auto Completion: Column list should not be displayed when the caret is just after a closing parenthesis
Command Line Support (dbviscmd)
DB Support: PostgreSQL: dbviscmd works only accessing objects in the default database. Argument -catalog doesn't work to access another database
Create/Alter Table: Occasional NullPointerException when adding a Foreign Key
DB Support: Other: net.ucanaccess.jdbc.FeatureNotSupportedException when getCatalogs() and getSchemas() in DatatabaseMetaData for the Ucanaccess driver
DB Support: PostgreSQL: Exception doing database search in PostgreSQL 9.6.1
DB Support: PostgreSQL: CREATEUSER argument for Create User action doesn't work with PostgreSQL 9.6, should be SUPERUSER
DB Support: PostgreSQL: Opening the table Indexes tab for PostgreSQL 9.6 results in "column am.amcanorder does not exist". The bundled JDBC driver needs to be updated
DB Support: Redshift: Incomplete DDL generated for views not owned by current user
DB Support: SQL Server: Precision for TIME, DATETIME2 and DATETIMEOFFSET is not handled correctly in DDL and Alter Table
DB Support: SQL Server: Users are shown as schemas for SQL Server 2005
DDL Generator: Failure when generating DDL for View objects in DbVisualizer free or when using the generic profile
Export: Automatic file name is wrong when exporting synonyms
Query Builder: Joins from WHERE clause should be found even for unqualified columns when loading SELECT
Table Data Editor: Regression in 9.5.3 disallowing entering boolean values as true,1,on,yes,t and false,0,off,no,f
Table Data Editor: Having Decimal Number Format set to something else than Unformatted may indicate a value being edited even if it isn't
Table Data Editor: Editing a formatted number field (ex #,###) by entering for example "1 234" results in "1"

New in DbVisualizer 9.5.3 (Oct 13, 2016)

New in DbVisualizer 9.5.2 (Sep 14, 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
DB Support: Sybase ASE
Filtering/Filter Sets: Show Only Default Database/Schema doesn't work in 9.5.x if previously enabled in a 9.2.x version
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 (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
[http://support.dbvis.com/support/discussions/topics/1000077551 ]
Scripts - Renaming bookmarks folder makes a file in the folder show as two nodes

New in DbVisualizer 9.5 (Jun 15, 2016)

NETEZZA AND REDSHIFT:
Now supporting IBM Netezza and Amazon Redshift allowing browsing generic database objects, creation and altering of tables, DDL generation, export schema, and more.
ORACLE:
In addition to the grand old plan_table support in Oracle, we've added the option to use DBMS_XPLAN to build the explain plan output.
MYSQL:
Event scheduler management. New actions for table maintenance.
DB2 LUW:
It is now possible to display any outputs made with the DBMS_OUTPUT package. Now supporting listing and managing roles and new actions for table maintenance.
INFORMIX:
Better support for delimited identifiers and DELIMIDENT.
POSTGRESQL:
Now possible to access multiple PostgreSQL databases from one DbVisualizer connection. Previously separate DbVisualizer connections were required for each PostgreSQL database.:
New support for tablespaces, servers, event triggers, and management of pgAgent jobs.
SYBASE ASE:
Introduced tbe Schema level in the database objects list to conform how the majority of supported databases are organized.:
New support for managing triggers and managing devices.
SQL SERVER:
Introduced tbe Schema level in the database objects list to conform how the majority of supported databases are organized.:
This version also introduce management of SQL Server Agent jobs and schedules.
SQLITE:
New functionality for management of triggers.
H2:
New functionality for management of triggers and functions (aliases).
TABLE COLUMNS LISTING:
The columns listing for tables now show what column(s) are primary key and sizes.
DB2 Z/OS:
Even though DB2 z/OS is not a fully supported database in DbVisualizer the following improvements has been made::
Now possible to manage comments for table, column, index, view, trigger, function, and procedure
Actions to manage materialized query tables
New support for: temporary tables, synonyms, sequences, users, roles, tablespaces, databases, and storage groups:
... AND MORE:
New icon library
Scaled images for Mac OS X Retina displays
Improved Result Set Merging
Lots of enhancements in how action UI's can be layout
Updated versions for bundled JDBC drivers:
DB2 LUW, DB2 z/OS 4.19.49,
JavaDB/Derby 10.12.1.1,
H2 1.3.176,
MySQL 5.1.38,
NuoDB 2.4,
PostgreSQL 9.4.1208.jre7,
SQLite 3.8.11.2.:

New in DbVisualizer 9.2.15 (Mar 10, 2016)

New in DbVisualizer 9.2.14 (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
[http://www.dbvis.com/forum/thread.jspa?threadID=5502 ]
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 (Nov 19, 2015)

Enhancement:
Chart: Should be possible to set Y-axis end value in chart properties
Connection Setup: SSH should not be available for connections accessing for example the file system
DB Support: Other: Add driver entry for Snowflake
DB Support: SQL Server: Add a DDL tab for Index nodes
Database Profile: Commands: Add support for DatabaseMetaData.getSchemas(catalog, schema) in database profiles (getSchemas2)
SQL Editor: Make the mouse click modifier for rectangular selection configurable
Bug:
Chart: Chart is not properly scaled if having decimal numbers as series with very small differences ( under 0.01 ) between min and max
Chart: Colors for series may change if selecting/de-selecting more/fewer series
Chart: Chart zooming is reset when modifying chart properties, change series/category, and when chart being reloaded
Connection Setup: Ping button may become disabled/enabled in situations when it shouldn't
Connection Setup: Connection cannot be established if getting login schema/database fails
DB Support: JavaDB/Derby: DDL tab for trigger is empty for Derby database
DB Support: MongoDB: DataDirect driver for MongoDB returns a null column name for columns generated by a function
Data tab: Column selections made in the Data tab column chooser are not propagated when "Copy complete SQL" and in the grid right-click "Script to SQL Commander" commands
Data tab: Save in the Data tab doesn't keep any (inline) data filter when grid is reloaded after save
Data tab: Generate Sorting Filter for Column Sorting in Data tab right-click Generate Filter & Sort menu only works if Include Grid Sorting is checked
Data tab: Using a filter in the Data tab that results in "An error occured..." results in that column names can no longer be auto completed
Grid Component: Copy cell(s) in grid inserts a new line at the end of the copied data
Grid Component: Hide Column no longer works using the mouse
Grid Component: Hiding column(s) in the SQL History cannot be restored without re-starting DbVisualizer
Import: Data skipped in XLS import
Import: Precision of decimal numbers during import and table data editing may be affected by the Decimal Number Format tool property
Monitor: A monitor without a connection specified should not be started
Monitor: Potential synchronization issue when executing multiple monitors for different schemas/databases using the same database connection
OS Support: Linux: "sun.awt.image.BufImgSurfaceData cannot be cast to sun.java2d.xr.XRSurfaceData" exception should not be reported as a warning in the error log
OS Support: Mac OS X: Java 8: If dragging a database object to the SQL editor the Script dialog freeze and don't accept any input except the ESC button
Object View: ClassCastException when Restore Hidden Tabs on a nested DataView
SQL Commander: Permission checker should ignore statements being comments
SQL Commander: A comment in the script before executing a SELECT statement will disable result set editing unless Strip Comments when Executing is checked
SQL Commander: @run should result in an error when the specified path is not a file, e.g. when it is a folder

New in DbVisualizer 9.2.12 (Oct 21, 2015)

New in DbVisualizer 9.2.11 (Oct 19, 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
[http://www.dbvis.com/forum/thread.jspa?threadID=5497 ]
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
[http://www.dbvis.com/forum/thread.jspa?messageID=19038 ]
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 (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
[http://www.dbvis.com/forum/thread.jspa?threadID=5030 ]
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
[http://www.dbvis.com/forum/thread.jspa?threadID=5421 ]
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
[http://www.dbvis.com/forum/thread.jspa?threadID=4864 ]
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 (Jul 31, 2015)

New in DbVisualizer 9.2.8 (Jun 29, 2015)

New in DbVisualizer 9.2.7 (May 14, 2015)

New in DbVisualizer 9.2.6 (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 (Mar 18, 2015)

New in DbVisualizer 9.2.4 (Mar 6, 2015)

New in DbVisualizer 9.2.3 (Feb 26, 2015)

New in DbVisualizer 9.2.2 (Feb 19, 2015)

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

New in DbVisualizer 9.2.1 (Jan 29, 2015)

New in DbVisualizer 9.2 (Jan 12, 2015)

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

New in DbVisualizer 9.1.13 (Jan 12, 2015)

New in DbVisualizer 9.2.2339 Beta (Dec 18, 2014)

New in DbVisualizer 9.2.2335 Beta (Dec 9, 2014)

New in DbVisualizer 9.1.12 (Nov 27, 2014)

New in DbVisualizer 9.2.2329 Beta (Nov 26, 2014)

New in DbVisualizer 9.2.2328 Beta (Nov 12, 2014)

New in DbVisualizer 9.1.11 (Oct 14, 2014)

New in DbVisualizer 9.1.10 (Aug 9, 2014)

New in DbVisualizer 9.1.9 (Jun 11, 2014)

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

New in DbVisualizer 9.1.7 (Mar 8, 2014)

New in DbVisualizer 9.1.6 (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 (Dec 16, 2013)

New in DbVisualizer 9.1.4 (Dec 7, 2013)

New in DbVisualizer 9.1.3 (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 (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
OS Support: Mac OS X: Internal error may occur with Java 7 on Mac OS X
References: While references graph is being loaded and the user activate a command an exception may appear
SQL Commander: Error marking tooltips do not show text embedded with < and >
SQL Commander: The Database list value changes when executing a SELECT where the table name is qualified with another database than the current list value
SQL Commander: Running a SELECT with Sybase IQ fail with long response time and a connection closed exception
SQL Commander: Triggering Show Object at Cursor while it is already running causes an error
SQL Commander: Using keyboard to execute query while any of an pinned result set or log tab is maximized will result in an error
SQL Editor: Replace All does not trigger the Pending Edits state
SQL Editor: Up/Down arrows do not retain the caret column position after edit
Table Data Editor: Converting BLOB value into text in the cell editor results in "BINARY, nnn bytes" rather than the actual data
Workspace: Opening database object in floating window should not change currently selected tab in main window

New in DbVisualizer 9.1.1 (Oct 1, 2013)

New in DbVisualizer 9.1 (Sep 9, 2013)

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

New in DbVisualizer 9.0.9 (Sep 3, 2013)

New in DbVisualizer 9.0.8 (Aug 29, 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 9.0.8 (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.1.2030 Beta (Jul 4, 2013)

New in DbVisualizer 9.1.2029 Beta (Jun 25, 2013)

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

New in DbVisualizer 9.0.7 (Jun 4, 2013)

New in DbVisualizer 9.0.6 (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 (Mar 5, 2013)

New in DbVisualizer 9.0.4 (Feb 19, 2013)

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

New in DbVisualizer 9.0.3 (Jan 28, 2013)

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

New in DbVisualizer 9.0.2 (Dec 18, 2012)

New in DbVisualizer 9.0.1 (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 (Nov 30, 2012)

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

New in DbVisualizer 8.0.12 (Nov 28, 2012)

New in DbVisualizer 9.0 Beta 90.1866 (Nov 22, 2012)

New in DbVisualizer 9.0 Beta 90.1863 (Nov 17, 2012)

New in DbVisualizer 9.0 Beta 90.1861 (Nov 15, 2012)

New in DbVisualizer 8.0.11 (Sep 27, 2012)

New in DbVisualizer 8.0.10 (Jul 11, 2012)

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

New in DbVisualizer 8.0.9 (May 1, 2012)

New in DbVisualizer 8.0.8 (Feb 14, 2012)

New in DbVisualizer 8.0.7 (Dec 23, 2011)

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

New in DbVisualizer 8.0.6 (Nov 22, 2011)

New in DbVisualizer 8.0.5 (Nov 4, 2011)

New in DbVisualizer 8.0.4 (Sep 17, 2011)

New in DbVisualizer 8.0.3 (Aug 30, 2011)

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

New in DbVisualizer 8.0.2 (Aug 8, 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 (Jun 30, 2011)

New in DbVisualizer 8.0 (Jun 20, 2011)

New in DbVisualizer 7.1.5 (Feb 24, 2011)

New in DbVisualizer 7.1.4 (Nov 23, 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 11, 2010)

New in DbVisualizer 7.1.2 (Aug 18, 2010)

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

New in DbVisualizer 7.1.1 (Jun 23, 2010)

New in DbVisualizer 7.1 (Jun 16, 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 16, 2010)

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

New in DbVisualizer 7.0.4 (Feb 26, 2010)

New in DbVisualizer 7.0.2 (Feb 3, 2010)

New in DbVisualizer 7.0.1 (Jan 29, 2010)

New in DbVisualizer 7.0 (Jan 17, 2010)

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

New in DbVisualizer 6.5.12 (Dec 22, 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 30, 2009)

New in DbVisualizer 6.5.8 (Aug 28, 2009)

New in DbVisualizer 6.5.7 (Aug 28, 2009)

New in DbVisualizer 6.5.6 (May 15, 2009)

New in DbVisualizer 6.5.5 (Apr 6, 2009)

New in DbVisualizer 6.5.4 (Feb 6, 2009)

New in DbVisualizer 6.5.3 (Jan 12, 2009)

New in DbVisualizer 6.5.2 (Jan 9, 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 (Nov 24, 2008)

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

New in DbVisualizer 6.5 (Oct 24, 2008)

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

New in DbVisualizer 6.0.14 (Sep 22, 2008)

New in DbVisualizer 6.0.13 (Aug 19, 2008)

New in DbVisualizer 6.0.12 (Jun 26, 2008)

New in DbVisualizer 6.0.11 (May 29, 2008)

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

New in DbVisualizer 6.0.10 (Apr 11, 2008)

New in DbVisualizer 6.0.9 (Mar 17, 2008)

New in DbVisualizer 6.0.8 (Feb 25, 2008)

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

New in DbVisualizer 6.0.7 (Dec 7, 2007)

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

New in DbVisualizer 6.0.6 (Oct 16, 2007)

New in DbVisualizer 6.0.5 (Oct 8, 2007)

New in DbVisualizer 6.0.4 (Sep 26, 2007)

New in DbVisualizer 6.0.3 (Sep 18, 2007)

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