Release notes

Version 14.0

14.0.2 released on 2022-11-23

Improvements

DB Support: H2
Add a driver entry for H2, version 2.0
DB Support: Oracle
Add support for WITH statements in the Oracle dialect

Bugs Fixed

Connection Setup
Requested to reconnect when showing the auto completion popup
Connection Setup
Driver Manager
Having a custom driver with an empty "URL Format" disables the "Settings Format" field with the value "Server Info" rather than "Database URL"
Create/Alter Table
Error when opening the Alter Table dialog and connection is closed
Create/Alter Table
DB Support: MySQL
Problem with create/alter table having broken views in the same database
DB Support: Netezza
Driver Manager
Netezza driver jar file is not migrated properly
DB Support: Oracle
Rare error when processing results from "dbms_output.put_line()" in Oracle
DB Support: PostgreSQL
Alter Table broken for PostgreSQL 15
DB Support: PostgreSQL
DDL Generator
The generated DDL for CREATE INDEX may be wrong
DB Support: SingleStore
Create Function issue in SingleStore
The generated DDL for a table in SingleStore results in errors when executed
DB Support: Snowflake
When connecting to Snowflake an error may occur if "Database Name" is not set in the connection tab
DB Support: Vertica
Generate DDL does not work for function in Vertica
Data tab
Rare error when closing a Object View while the Data tab is being loaded
Grid Component
Key Bindings
OS Support: Windows
Change key binding for export to grid to Alt+Ctrl+Shift+E
Import
The "Null Value Text" setting in import is not always respected
OS Support: Windows
The "Slow Drives Detected" dialog should be displayed less frequently
SQL Commander
Exception when expanding a @run log entry while executing
SSH
SSH "Test Connection" may result in an error
SSH credentials may be prompted even with "Settings Format = Database URL"

14.0.1 released on 2022-10-14

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

14.0 released on 2022-09-20

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

DbVisualizer 14.0

You are currently viewing: 14.0.2
released on 2022-11-23

Evaluate Pro version

To activate your free 21-day trial,
read more here.

Requirements

Known Java issues for Windows, Linux, macOS users