Version 12.1
Installation Instructions User guide What's New Download

Release Notes 12.1

You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 24.3.3 version.

12.1.9 - Released 2022-03-02

Improvements
Area Details
DB Support: PostgreSQL Update the PostgreSQL driver
Bugs Fixed
Area Details
Create/Alter Table
DB Support: PostgreSQL Alter Table Add Column not null does not correctly work
DB Support: DB2 LUW
Table Data Editor DB2 fails with TIMESTAMP as primary key
DB Support: Oracle Oracle DBMS Output buffer size not working
DB Support: PostgreSQL Same trigger shown multiple times
DB Support: Snowflake Incorrect statement executed for "Rename Table" action in Snowflake
Explain Plan Schema not set before running explain plan
Export Copy Settings to clipboard does not copy the actual entered values in the export dialog
Import Run import fails with "file not found"
Occasional error when importing data from .xlsx to new table
SQL Commander Multiple @run statements gobble up memory
SQL Editor Close All Tabs leaves the dialog dangling at exit

12.1.8 - Released 2022-01-21

Bugs Fixed
Area Details
Cell Viewer/Editor
SQL Editor Selection highlight remains after moving cursor

12.1.7 - Released 2022-01-14

Bugs Fixed
Area Details
Cell Viewer/Editor Highlight Selection Matches is sticky
Grid Component Copy Selection as IN clause gives exception
Problem with negative number presentation as the minus sign may be a hyphen-minus in some locales

12.1.6 - Released 2022-01-11

Improvements
Area Details
DB Support: Exasol
SQL Editor Add new SQL keywords
Driver Manager Update SQLite database profile for use with encrypted database files
References Add GML output format when export references graph
Bugs Fixed
Area Details
Auto Completion
SQL Commander Potential exception in auto completion
Contact Support Failing to create a "Contact Support" ticket may not be communicated to the user
DB Support: Azure SQL "accessToken" erroneously specified as authentication for Microsoft JDBC driver
DB Support: Informix
Export Regression when exporting booleans as 't' (true) and 'f' (false) results in ''t'' and ''f''
DB Support: MariaDB
DB Support: MySQL
DDL Generator PARTITION information missing when generating DDL
DB Support: PostgreSQL Login broken for catalog databases when using .pgpass file
Database Objects Tree
Object View Object view tabs saved between sessions cannot be loaded if database connection name contains "/"
Export
OS Support: Linux DbVisualizer does not open grid as spreadsheet
Grid Component Opening grid "Column Chooser" while grid is loading may result in an exception
Key Bindings Cannot map "Ctrl + Tab" key binding
OS Support: Windows
Performance/Stability DbVisualizer may be slow to start if having slow or non responding network devices mounted
OS Support: Windows
SQL Commander Caret problem with multibyte characters (eg Japanese)
Query Builder Exception may occur when selecting column in Query Builder
Scripts Exception when saving script file
Tool Properties No way to reset custom sample text in Tool Properties font selector

12.1.5 - Released 2021-11-11

Bugs Fixed
Area Details
Auto Completion
Java 11
OS Support: macOS Auto-completion on macOS with JDK 11.0.12 is broken
Connection Setup
DB Support: Greenplum
DB Support: PostgreSQL
DB Support: Redshift
DB Support: Yellowbrick .pgpass file should ignore unescaped backslashes
DB Support: Informix
SQL Formatter Wrong SQL formatting when using CASE statements
Explain Plan Explain plan dropdown button in toolbar should highlight if there are no options
Export Text data is not quoted at export when having displayed the Data Formats window and immediately pressed Close button
General Exception when saving file
Query Builder Moving column in the query builder looses the selection

12.1.4 - Released 2021-10-16

Improvements
Area Details
Compare Support compare for explain output in text format
DB Support: Azure SQL Add support for MFA (ActiveDirectoryInteractive) authentication
Bugs Fixed
Area Details
Connection Setup Message when Ping Server is not supported needs to be improved
Connection Setup
DB Support: Greenplum
DB Support: PostgreSQL
DB Support: Redshift
DB Support: Yellowbrick .pgpass file is not properly reading escaped tokens
Unclear error message when unable to read .pgpass
DB Support: Oracle Change Password for Oracle is broken since clicking it doesn't show the field for New Password
DB Support: PostgreSQL Search path is not set when running Explain plan
Importing to new table with "drop existing table" enabled, fails if there is no existing table
DB Support: Snowflake
DDL Generator View definition is not visible
Import Selecting data type BLOB/CLOB in import table data prevents it from being changed
Some settings are not loaded from import settings file
SQL Commander Error opening right-click menu in new SQL Commander tab
SSH SSH config file parsing is case sensitive

12.1.3 - Released 2021-09-09

Improvements
Area Details
Theme: FlatLaf Improve visibility of tab label in dark them using custom background color
Bugs Fixed
Area Details
Cell Viewer/Editor
DEVENV
Java 11
OS Support: Windows Cursor problem in Cell Editor
DB Support: Exasol
DB Support: Vertica
Query Builder Autojoin fails to join on FK/PK in Exasol and Vertica
Export Some files created with "Save as Default" in the export object features are not handled in export/import settings
Query Builder The elements to JOIN cannot be identified error

12.1.2 - Released 2021-08-25

Bugs Fixed
Area Details
DB Support: MySQL The default useSSL=false driver property is converted by driver to useSSL=true if not explicitly set to false as a parameter at connect
DB Support: Oracle Stopping an execution in Oracle closes the connection
DB Support: Oracle
Database Objects Tree When cancelling a database query in a DataView grid, connection may close
DB Support: Redshift Upgrade the Redshift driver to version 2.0.0.7
Export Export in XLSX to an existing read-only file doesn't show any error
"The workbook already contains a sheet named X" error when export in Excel format
Export/Import User Settings Trying to import an invalid file such as Excel in File->Import User Settings results in an error
OS Support: Windows IllegalStateException: Stopwatch already started
SQL Commander Reload in the result set tab and then stop while fetching results, yields in no partial result set being displayed
SQL Formatter Formatting function in SQL editor will alter SQL statements making them incorrect

12.1.1 - Released 2021-07-23

Bugs Fixed
Area Details
Compare Compare grid ignores differences
DB Support: MySQL
Data tab Data changed in a SQL commander is not visible in the Data Tab
DB Support: PostgreSQL
DDL Generator Some data views are unavailable when in evaluation mode
Data tab The visibility of the Data tab filter pane is not preserved at restart
Database Profile: View DataView could not be created for viewer='xxx'!

12.1 - Released 2021-07-13

Improvements
Area Details
Database Profile Enable database profiles in DbVisualizer Free
Filtering/Filter Sets The objects filtering grid should allow re-arranging rows with DnD and new move actions in the right-click menu
General Add new startup dialog for DbVisualizer Free users
Add new Help->Welcome screen to guide new (and current) users
Provide a demo database with DbVisualizer
Grid Component Support multi line selection and move rows with DnD and actions in grid columns chooser dialog and also in database objects filter pane
OS Support: Windows Native window decorations and embedded menu bar in Windows 10
OS Support: Windows
Theme: FlatLaf Add setting to control the embedded toolbar in Windows 10+
OS Support: Windows
Theme: FlatLaf
Tool Properties Allow setting application font (in addition to the existing grid and editor fonts)
SQL Formatter Separate format settings for SELECT and DECODE
Scripts Add capability to mount any directory in the Scripts tab
Theme Remove the optional theme selector dialog at startup and the "Ask at Startup" checkbox in the Appearance tool property pane
Bugs Fixed
Area Details
DB Support: PostgreSQL RULE objects are not shown for Tables in PostgreSQL

Change Version

[old] Change Version
View all versions ->