Release Notes

23.2.5 - Released 2023-10-03

Improvements
Area Details
SSH
Tool Properties
Use relative paths for SSH settings
Bugs Fixed
Area Details
Connection Setup
DB Support: Cassandra
Changing authentication settings may produce errors when configuring Cassandra connections
Contact Support Adapt dialog size when application font size changes
DB Support: Greenplum
DDL Generator
"PARTITION BY" clause is missing from table DDL
DB Support: Informix
DDL Generator
Incorrect DDL generated for DECIMAL(p) columns
DB Support: Snowflake Inconsistent type information in the Columns tab
Database Objects Tree
DB Support: H2
Multi-column indexes are shown multiple times in the database objects tree for H2
Driver Manager Creating driver from template does not work in some cases
File Chooser
OS Support: Windows
File chooser crashes for certain types of directories on Windows
Grid Component Auto resize column widths should be preserved between reloads
Interacting with the table header while reloading may result in errors
SQL Commander Filtering in SQL Log may result in errors in some cases
SQL History Sorting in SQL History is slow when there are many entries
SQL Log Sorting does not work in SQL Log
Table Data Editor Row is marked as changed after leaving the value editor although no change was made

23.2.4 - Released 2023-08-15

Improvements
Area Details
DB Support: Google BigQuery Upgrade the template driver for BigQuery
DB Support: SQL Server Add the "Script Index" action allowing to generate DDL for the selected indexes
Bugs Fixed
Area Details
Auto Completion Potential error when using auto completion while database connection goes down
Connection Setup A duplicated database connection may connect using the database connection details specified in the original connection even if details are changed in the duplicate
DB Support: DB2 LUW
Imports
Wrong rounding when importing decimal numbers from Excel
DB Support: Google BigQuery Table data editor does not work with recent BigQuery drivers
DB Support: H2
DDL Generator
@ddl indexesfortable gives an error in H2 2.x

23.2.3 - Released 2023-07-13

Improvements
Area Details
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
Area Details
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

23.2.2 - Released 2023-05-16

Improvements
Area Details
Database Objects Tree Include SSH information in the database connection tooltip
Bugs Fixed
Area Details
@import
Import
Exception when importing table data
Table Data Editor The permission checker doesn't issue a warning when updating or deleting rows in the table data editor

23.2.1 - Released 2023-05-10

Bugs Fixed
Area Details
Table Data Editor Exception when deleting or updating rows in the table data editor

23.2 - Released 2023-05-09

Improvements
Area Details
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
Area Details
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

Change Version

[latest] Change Version
View all versions ->
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗