DB Support: Exasol
Virtual schemas are not ordered according to their name
Database Objects Tree
Add right-click action to rename selected folder in the Databases tab
References
Color code pk/fk edges in the References graph
Must be possible to chose color scheme when export and print of references graph
Make a compound graph instead of having two (exported/imported) for a single table See the discussion here
Bugs Fixed
DB Support: DB2 LUW
DB2 VARGRAPHIC column sizes are reported incorrectly in Columns tab
DB Support: MySQL
Import
String is mapped to TINYTEXT during import using MySQL Connector/J 8.0.x
DDL Generator
Fully Qualified Column Names only generated for first column
Grid Component
Copy Selection as IN Clause having columns qualified with table names that are enclosed in delimited identifier, will duplicate the delimiters if multiple cells
References
References graph for table shows up blank if selecting Exported or Imported when no such relations exist if "Show only referenced"
SQL Editor
Add setting to truncate the text being displayed when "Show SQL in Tooltip" in the General / Tabs tool properties category
Auto Completion
Column names should be auto completed even though preceded by "top <number>"
Compare
Docs: Users Guide
Improve usability of the Compare functionality
Connection Setup
The connect window should show database connection name in window title
Offer quick search in Driver Properties tab for a database connection
DB Support: Redshift
Upgrade the Redshift JDBC Driver to 1.2.34
DB Support: TIBCO
Database Objects Tree
All Schemas from every catalog display under each individual catalog when connected to TIBCO Data Virtualization
Database Objects Tree
Have an option to set that columns in the Databases tab are sorted alphabetically. (Right-click in Databases tab and select "Sort...")
General
The dbviscmd and dbvisgui command scripts should use any JRE that is bundled with the DbVisualizer installation, and then look in the PATH or the JAVA_EXEC environment variable
Grid Component
Change default horizontal scrolling in grids to variable (was column)
Look and Feel: macOS
OS Support: macOS
Make the unselected tab color darker for the macOS look and feel
Tool Properties
Add "Global Properties" link in the connection properties panes
Bugs Fixed
Command Line Support (dbviscmd)
The command-line interface, dbviscmd should run even if logging can not be initiated
dbviscmd does not honor the connection property for "Strip Comments when Executing"
Compare
Grid Component
Editing grid shifts focus to the compare view if compare view is open for the same grid
Compare
SQL Editor
Undo in original editor not possible after compare
Connection Setup
Setting default values for driver properties in drivers.xml should not result in the error balloon being displayed
Contact Support
Exception when system clipboard is not available
DB Support: Oracle
Exception when creating a Job object with Oracle 11.2
An error may be reported if changing the Attribute for a Scheduler Job object
DB Support: PostgreSQL
Non unique Index is marked as UNIQUE in the DDL tab
DB Support: Redshift
Stored procedures in Redshift having all unnamed parameters can not be viewed in the Procedure Editor
DB Support: SQL Server
Right-click "Open in xxx Tab" and "Script: xxx" actions doesn't work in the Tables/Views grids
DB Support: SQL Server
Procedure Editor
Stored procedure with null definition gives an error
DB Support: SQLite
An error may occur in Alter Table if table contains a column including "check" in its name
Grid Component
Jump to Quick Filter key binding in Row Form window doesn't work
Import
SQL Log
ConcurrentModificationException when importing data
Java 8
OS Support: Linux
Programatically deactivate the org.GNOME.Accessibility.AtkWrapper on Linux with OpenJDK 8. Solves the infamous "componentResized" issue
SQL Commander
When auto-commit is off and commit is clicked in the "there are open transactions" dialog any errors are only visible in the debug log
Changing the data type for a "noshow" variable doesn't have any effect other than for its first reference
App Logging
Using dbviscmd shows any passwords set as arguments in the debug output
Connection Setup
Allow configuration of the maximum SSH authentication retries
Introduce the "Fetch Size" connection property used to give a hint to the JDBC driver the number of result set rows to get in a single network call
DB Support: DB2 LUW
Update the DB2 JDBC driver to 4.25.1301
DB Support: Elasticsearch
Add Database Type and driver entry for Elasticsearch
DB Support: Exasol
Update Exasol JDBC driver to version 6.1.2
DDLs for Exasol Views are not generated correctly
Updates for Exasol
DB Support: H2
Table index node should include the column the index refers to
DB Support: InterSystems IRIS
Add database type and driver entry for InterSystems IRIS
DB Support: SQL Server
Include Creation and Modification Date in the listings for tables, views, procedures, etc.
DB Support: Sybase ASE
Object View
For Sybase ASE add a new DBA->Blocked or Waiting Objects view
Database Profile
Add right-click menu item "Open" in the connection Properties->Database Profile list. Will open the selected profile XML file in system editor
Docs: EULA
Request EULA consent when starting DbVisualizer rather than approving it during installation
Export
Allow generating multi-row inserts with a single INSERT statement in the export features See the discussion here
Installation/Update Installation
Java 8
Now bundles the AdoptOpenJDK 8 on Windows 32/64 and AdoptOpenJDK 11 on macOS
SQL Editor
Rearrange the SQL editor right-click menu by moving for example cut, copy, and paste to top level rather than the Edit sub menu
Workspace
Loading a file that is already open in a floating window should move that window in front of all other DbVisualizer windows
Bugs Fixed
Command Line Support (dbviscmd)
dbviscmd should fail with a user friendly message if no Java runtime can be found
dbviscmd doesn't tell if there is no command specified in the -sql parameter or if the file identified by -sqlfile doesn't exist or is empty
Compare
DB Support: DB2 LUW
Grid Compare doesn't honor the Grid->Show Column Alias as Grid Column Label tool property for drivers supporting aliases such as DB2
DB Support: Exasol
There are no columns listed for database Views
DB Support: MySQL
DDL Generator
The DDL for a GEOMETRY and its spatial key is incorrect
DB Support: Oracle
The "Change Password" capability for Oracle is invisible for a brand new Oracle connection. Only restart makes it visible
DB Support: PostgreSQL
View definition not visible for a user not owning the view
Empty Arrays are displayed as NULL
DB Support: PostgreSQL
DB Support: Redshift
When getting catalogs in Redshift there is suddenly the "oid" column in first index where catalog name is expected
DB Support: PostgreSQL
Data tab
Procedure Editor
Having "Preserve Object View tabs at Disconnect" disabled and object view tabs with edited content, when reconnect these tabs are closed without confirmation (for ex the Data tab and Procedure Editor)
DDL Generator
The DDL for a view object with a comment is "COMMENT ON TABLE" rather than "COMMENT ON VIEW"
Database Objects Tree
SQL Commander
Dragging an object name from the Databases tab to the SQL Commander should insert the name at the caret position
Scripts
Exception when moving directory to another directory in the scripts Tab
Workspace
New tabs may occasionally end up in new tab groups
Auto Completion
The auto completion popup should display automatically only if already connected
DB Support: Exasol
Add sort of roles and grantees
DB Support: SQLite
Upgrade to SQLite 3.27.2
Export
Import
Add pipe ("|") and percent ("%") as pre-defined characters for CSV import and export
Favorites
Tool Properties
User settings files should be saved when modifying favorites
Installation/Update Installation
The OpenJ9 (Eclipse) JVM should be detected by the install4j launcher when its Java home is path specified in .install4j\prefs_jre.cfg
SQL Commander
DbVisualizer should recognise (earlier than at time of save) if any external changes in a file that is already loaded in the SQL Commander and warn user
Bugs Fixed
Connection Setup
IndexOutOfBoundsException when fetching tooltip
DB Support: PostgreSQL
Tablespaces with a role as an owner doesn't show up
DB Support: PostgreSQL
Database Profile
DDL is not formatted in the DDL Tab
DB Support: PostgreSQL
SQL Commander
When getting into the "current transaction is aborted, commands ignored until end of transaction block" state, the search_path is reset at next execution in the SQL Commander which will not consider any non default Schema drop-down choice
OS Support: Windows
Startup exception on Windows with Java 9+
Monitor
Possible exception when running monitors
SQL Editor
Doing a Copy in the editor when there is no selection will clear the clipboard
Rectangular selection select wrong part when Auto Highlight is enabled
Table Data Editor
The Table Data Editor don't consider any unique indexes during save
Setting too large value in table data editor is not detected
Workspace
Open a object view tab as a favorite with a pre-defined tab doesn't work
Connection Setup
Make the use of the SSH config file optional
DB Support: Exasol
Action for "Comment Column" is missing
Database Profile: View
The formatSQL="false" attribute setting needs to be supported for the DDL viewer
SQL Editor
Find should use any selected text as text to find
Bugs Fixed
DB Support: Oracle
NOT NULL constraint is erroneously generated for IDENTITY columns
The SQL for the "Create Package" action is erroneous
Compiling package may render a lot of "Malformed OGNL expression" errors in the log
Wrong SQL generated when creating table with an IDENTITY NOT NULL column
DB Support: PostgreSQL
Various issues in connection to Function and Procedure Editor for PostgreSQL
DB Support: PostgreSQL
DB Support: Yellowbrick
Many object names are sorted in ASCIIbetical order rather than alphanumeric
Data tab
Table Data Editor
The data type information displayed in the Data tab and result set grids is wrong if changing order of the columns in the grid
Database Profile: Actions
Rare error when closing the object action dialog
Grid Component
Selection is cleared when editing in grids
SQL Editor
Creating a new SQL Commander doesn't put focus in editor
References
Exception when showing Specified Tables and selected tables in reference graph
Table Data Editor
While editing a cell having quick filter active, that edit may affect another cell if quick filter is cleared
Connection Setup
Add support for SSH "config" file
DB Support: DB2 iSeries
SQL Commander
Using iSeries "library list" doesn't work properly
DB Support: Exasol
Improvements in the Exasol database profile
DB Support: HPE Nonstop
Improve the HPE NonStop SQL driver entry
DB Support: PostgreSQL
Add support for stored procedures introduced in PostgreSQL 11
DB Support: SQL Server
SQL Server profile needs to be adjusted for the limitations in Azure
Do not show "Linked Servers" for SQL Server - Azure edition
Grid Component
Add key bindings to focus the "where" (Win/Linux: Alt Shift f, macOS: Cmd Ctrl f) and "quick filter" (Win/Linux: Alt Shift w, Cmd Ctrl w) fields
SQL Commander
The format option is not applied for "now" variables
Bugs Fixed
Cell Viewer/Editor
Grid Component
OS Support: Windows
Saving a non binary object to file in the cell viewer/editor leaves the file open and held by DbVisualizer until exiting DbVisualizer
DB Support: PostgreSQL
Generated "CREATE INDEX" DDL will be "CREATE UNIQUE INDEX" if index name contains the "unique" string
DB Support: Presto
Query Builder
SQL Commander
Presto: 1) A primary key error occurs when adding table to the query builder. 2) Columns are not displayed in the auto completion feature in the SQL editor
Export
"Fixed Width Text" view(s) should consider line breaks in data
Grid Component
An exception may occur while viewing Binary/BLOB data as "HEX"
Import
Rare exception when importing Excel file
Java 11
OS Support: macOS
IllegalArgumentException: Width (0) and height (0) cannot be <= 0
Look and Feel: Windows
SQL Log
Any line breaks in the SQL/Command column needs to be displayed as whitespace if "Width for Multiline Columns" <= 0
SQL Commander
The timestamp displayed in the tooltip for a result set tab changes whenever tab tab is re-focused
DB Support: DB2 LUW
DDL Generator
Add support for CODEUNIT column length declaration in DDL
DB Support: SQLite
Add Native DDL tab
SQL Editor
Current text selection highlights in current document for the duration of selection
Bugs Fixed
Connection Setup
Potential exception when connecting multiple databases concurrently
A script running in one SQL Commander prevents disconnect of other databases
DB Support: DB2 LUW
DB Support: DB2 z/OS
Having auto-commit off and after executing some SQL, disconnect. The disconnect silently fails with an exception and leaves the connection connected in the DB server
DB Support: DB2 LUW
DB Support: H2
DB Support: Netezza
DB Support: NuoDB
DB Support: Oracle
DB Support: PostgreSQL
DB Support: SQLite
DB Support: Vertica
Explain Plan
Parameter markers in SQL during explain will fail with an error when execute
DB Support: SQL Server
Opening Extended Properties tab for a table may show syntax error
Database Profile
WARN: "Error auto detecting profile" due to exception
File Chooser
Hidden attribute doesn't work on Windows directories
General
ClassCastException: sun.awt.Win32GraphicsConfig cannot be cast to sun.java2d.d3d.D3DGraphicsConfig
General
OS Support: Windows
java.lang.InternalError: HTHEME is null
Grid Component
Exception when loading serialized Java object
Import
Import large XLSX failed - Zip bomb detected (which is not)
Parameterized SQL
Rare exception may occur in the variables prompting window
Query Builder
Column dropdown menu in the Details tabs should not extend below the window
References
Different sort order of tables in the Databases tab and the References->Select Tables to Graph table lists
SQL Editor
Having SQL Editor Background color set to None results in an error when copying text
Character encoding problem when restarting DbVisualizer after force quit or system crash
SQL Log
Potential ConcurrentModificationException in log during import
Table Data Editor
Editing Date, Time, and Timestamp fields with only a partial input may result in a broken value
Create/Alter Table
DB Support: Exasol
Add support for Partition Key in the Create/Alter table dialog for Exasol
Add support for Distribution Key in the Create/Alter table dialog for Exasol
DB Support: DB2 LUW
Show more Object View tabs for an alias
DB Support: Exasol
Add explain plan support for Exasol
Add support for Identity columns for Exasol
DB Support: Exasol
Export
Support export scripts in Export Schema dialog for Exasol
DB Support: Oracle
Allow granting multiple privileges at the same time
Import
Allow unreadable control characters to be stored as default column delimiter for import
Parameterized SQL
SQL Commander
The "Account:withdraw" or "(something):withdraw" should not be identified as parameter markers
Bugs Fixed
Chart
Y-Axis is not rendered and chart is empty if all values in a single serie are null (even if there are other series with non null values in the chart)
DB Support: DB2 LUW
DB Support: DB2 z/OS
Schema and/or Table names may be displayed as (null) with DB2 and DB2 z/OS
DB Support: DB2 LUW
DDL Generator
Error when generating DDL for a Table with DB2 9.1 or older
DB Support: Oracle
Exception when opening the Grant Privilege action dialog for a non-DBA account
Data tab
DbVisualizer fails to start if erroneous unicode sequence is in the user settings files
Export
If "Include Original SQL" in Excel exports, truncate it if larger than 32K since an error occurs otherwise
Import
Exception when entering \t in CSV Column delimiter during import setup
DB Support: Exasol
Add support for generating DDL for Exasol objects
DB Support: Oracle
Database Profile: Actions
Include both Users and Roles in the Grantee list for Grant Privilege
Grid Component
Show a "In progress" overlay message in components while data is loading
Bugs Fixed
DB Support: Generic
DDL Generator
Show a more user-friendly error message for the lack of View DDL with the Generic profile
DB Support: Netezza
DDL Generator
The VARARGS argument type is not included in the DDL
The ANY keyword for a generic size return value is not included in the DDL
The size for CHARACTER VARYING is missing in the RETURNS clause
Data tab
Table Data Editor
Using Data tab and the Script to SQL Commander right-click actions results in an exception if the data contains a BLOB/CLOB type
Grid Component
Exception when hiding column(s) in grid Column Chooser
Copy Selection as HTML does not work with Windows Outlook and Word
Chart
Database Profile: View
Add a new chart object viewer (viewer="chart")
Monitor
Object View
SQL Commander
Add right-click menu for Show as: Grid, Text, and Chart as these are now only available in the toolbar for the result set viewers
DB Support: Exasol
Add reserved keywords for Exasol
DB Support: Redshift
Show Distribution Key and Sort Keys for a table in the tree
Export
Remove not used files produced by DbVisualizer in Java TEMP directory
Grid Component
Add a "Copy Selection as HTML" (table) action for grids
Add a "Copy Selection as JIRA" (table) action for grids
Java 9
Due to Java 9 issues, downgrade to Java 8 as recommended and bundled Java version
Bugs Fixed
DB Support: Exasol
Choosing a schema in the Schema list for Exasol doesn't work
DB Support: Netezza
Procedure Editor
Running a procedure with an empty argument list prompts for one argument
DB Support: PostgreSQL
Use $body$ for dollar-quoting a Function body instead of $dbvis$
DB Support: Redshift
External Schemas should not be listed with regular Schemas
DISTKEY, SORTKEY and ENCODING missing in DDL for tables not in the default schema
DB Support: SQLite
Error when generating DDL for a View
Import
Importing CSV data but using for ex. NULL as Null Value String will properly convert to nulls. Problem is that any (null) strings in the data are also treated as nulls
OS Support: Linux
Cannot launch a second DbVisualizer instance on Linux
Table Data Editor
Rare ClassCastException when pasting in the grid
DB Support: Exasol
Add database profile for EXASOL
Improvements
Contact Support
Should be possible to attach files in Help->Contact Support
DB Support: Exasol
Bundle JDBC driver for Exasol
DB Support: Oracle
Exclude Hidden Columns in DDL export
DB Support: Vertica
Improvements for Vertica
Grid Component
Should be possible to force showing the XML viewer (Cell Viewer/Editor) even if there is no proper XML header
Parameterized SQL
Allow setting a named parameter marker as "Literal"
Parameterized SQL
SQL Commander
The "Account:withdraw" syntax should not be identified as a parameter marker
Bugs Fixed
Connection Setup
Keep-Alive may fail after network issues and reconnect does not restart it
DB Support: Oracle
Exception when expanding the Columns node for a view based on a table with an IDENTITY column
DB Support: PostgreSQL
Partition owner is incorrectly used as the database name in the partition DDL for PostgreSQL 10
Export
The CLOBFormat and BLOBFormat option values are case-sensitive
General
Potential race condition error when a background task ends
Import
An exception may occur when importing Timestamp data
Import of Excel file with erroneous data gives NullPointerException
Java 9
Key Bindings
OS Support: macOS
SQL Commander
Using key binding to activate a toggle main menu action doesn't work properly with Java 9 on macOS (ex Expand/Restore Editor Area/Result Set Area)
Parameterized SQL
Error when using named parameter marker with delimiters
Tool Properties
Writing "invisible" characters in XML settings files are not handled properly
If an exception occurs at exit during save of user setting XML files, DbVisualizer main window is closed but the process is still active
Java 9
OS Support: Linux
OS Support: Windows
Support HiDPI on Windows and Linux (requires Java 9)
Improvements
Create/Alter Table
DB Support: SQLite
Add support for column collation rule
DB Support: Redshift
Add basic support for External Schema objects
Database Profile: Actions
Export
Import
Show affected database object in the action window, import and export windows title
Java 9
OS Support: Linux
OS Support: Windows
OS Support: macOS
Support for Java 9
Look and Feel: Darcula
Query Builder
Darcula Theme Query Builder Window Borders Too Small
SQL Editor
Change the cursor to be more visible when having a dark background color in editor
Change Copy in an SQL Commander to copy the styled text (RTF)
Bugs Fixed
Create/Alter Table
DB Support: PostgreSQL
DDL Generator
Table owner is incorrectly used as the database name in Alter Table and DDL for PostgreSQL 10
DB Support: Oracle
TNS alias entries may be missing from a tnsnames.ora file with mismatched parentheses
Graphical "explain plan" using DBMS_XPLAN fails if cardinality is to high
DB Support: Oracle
OS Support: Windows
When DbVisualizer looks up Oracle TNS environment variables, it needs to consider case insensitivity
DB Support: PostgreSQL
DDL Generator
Error when generating DDL for table with mixed-case identifiers in PostgreSQL 10
DB Support: SQLite
DDL Generator
Exception when opening Alter Table or DDL tab for a table with an FK declaration with implied target column
Export
Export table changing "Qualify Name" ( schema ) does not change create index statements
Export
OS Support: Windows
Workspace
After export of database objects, the DbVisualizer window is moved to front on the desktop
OS Support: Linux
Cannot run program "dbvis-multi.exe": error=2, No such file or directory
SQL Commander
Parameter markers in a comment are substituted to "?" when executing resulting in driver errors during bind
Table Data Editor
Having a FOREIGN KEY defined as DEFERRABLE INITIALLY DEFERRED will postpone constraint errors until commit() in the Table Data Editor
DB Support: PostgreSQL
Add more support for partitioned tables for PostgreSQL 10 See the discussion here
Improvements
DB Support: Netezza
Include table/column comments in DDL at export
DB Support: Oracle
Add "Script Sequence" action for sequence objects
Improve WHERE clause for query getting Synonyms
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 See the discussion here
Import
Add checkbox to enable JDBC Batch inserts in the import table data feature (this was a non documented control previously)
Bugs Fixed
Command Line Support (dbviscmd)
Running dbviscmd with Java 9 fails if current folder is not DBVIS-HOME
DB Support: MySQL
StackOverflowException when running batch import and the last batch entry contains incompatible data
DB Support: MySQL
SQL Commander
Database list is reset after execution for database names longer than 34 characters
DB Support: NuoDB
Correct the list of data types listed in the Create Table action to match NuoDB documentation
DB Support: Redshift
Query to get schema info may be very slow
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
Exception during export with invalid filename
Stopping while Export Grid is running and then immediately starting another export may result in an exception
Pre-defined variables in export need to adjust to use the variable identifier begin/end from tool properties
Grid Component
The background color in grids should fill to the full width
Import
Import of boolean data broken since 10.0.1
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: Exasol
Add database type and driver entry for Exasol
Export
Apply a Style matching the data format specified in DbVisualizer for numeric data
Grid Component
Add quick link to the Data Formats setup in Tool Properties also for BLOB and CLOB in the grids status bar
SQL Commander
Should be possible to disable error markers in the SQL Commander editor
SQL Editor
Add means to add custom keywords for syntax highlighting
Add key bindings (alt-shift-up, alt-shift-down) to move selected rows up or down See the discussion here
Add a Duplicate Current Line editor action with option to set keybinding (is not assigned by default) See the discussion here
SQL Log
Make it possible set the default column width for Message and SQL/Command multiline columns in the SQL Log
Bugs Fixed
Create/Alter Table
Potential exception when removing constraint in the Create/Alter Table window
DB Support: Vertica
SQL Commander
A variable in a comment may cause an execution error
Database Profile: Actions
Export
Script Table and Export with INSERT should optionally not generate values for auto-generated columns
Export
Exception during export if some database objects could not be fetched and are indicated with an error icon
Automatically setting file format from extension fails for XLSX
The Export Columns grid in Export Grid sometimes fits the columns poorly
Export
Look and Feel: Windows
Specifying an invalid drive letter for the destination file gives an exception
Look and Feel: Synthetica
OS Support: Linux
DbVisualizer may crash on Linux with the Synthetica look and feel
Look and Feel: Windows
SQL Commander
Execute Current and Format Current may pick an earlier statement if the file contains both LF and CRLF linefeeds, and Format Current may drop the statement delimiter if the file contains CRLF linefeeds
OS Support: macOS
Java VM Properties cannot be edited in Tool Properties
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 See the discussion here
Installation/Update Installation
Install4j should remember the last used download folder during updates See the discussion here
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 See the discussion here
SQL Commander
SQL Log
The STARTED log entry should show information about used database connection, database type, database, and schema See the discussion here
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
Bugs Fixed
Connection Setup
DB Support: PostgreSQL
Nothing happens (no visual feedback) when executing against a PostgreSQL database that cannot be connected See the discussion here
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
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
Refresh Objects Tree sometimes does not re-expand open expanded nodes
Export
Obsolete parameters in saved settings make Export Schema/Database/Table fail
Setting Max Rows larger than the number of rows in the exported result set gives an exception
Terribly slow exporting many result sets of various sizes to xlsx
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
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)
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
Bugs Fixed
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
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
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
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"
Potential NPE if closing the Procedure Editor while compiling
@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
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
Bugs Fixed
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
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
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
Look and Feel: Darcula
Look and Feel: Windows
OS Support: Windows
Toggle state for buttons in menus and toolbars doesn't show well on Windows with the Darcula and Windows look and feels
OS Support: Linux
StackOverflow: java.awt.AWTEventMulticaster.componentMoved
SQL Commander
Running SQL files with relative paths does not work
NullPointerException in ExecutorHandler when creating index
Stop on no rows only considers first result if many are produced
Add "Integer" to the list of data types in the variable/parameter substitution dialog
Multiple result sets generated as cursors by a stored procedure shows only the first results in all result sets
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
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
DbVisualizer should register its application name ("dbvis") with the database so that any DB server process listing clearly tell what connections belong to DbVisualizer See the discussion here
The missing DB2 license jar file message at connect should be transformed to DbVisualizer instruction how to fix it
Remove Authentication Method dropdown and always include the Authentication Domain field in Options
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
Password due for expiration warning should be displayed when connecting to Oracle See the discussion here
DB Support: PostgreSQL
Set the ApplicationName driver property to "dbvis" See the discussion here
Show partition tables for PostgreSQL 10
Database Objects Tree
Allow double-click to expand database objects tree (and connect of database connections)
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
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) See the discussion here
Allow adding custom statements first/last in file produced by schema export
Optionally include column names in CSV only for first result or for all
Add option to not convert HTML special characters to HTML codes when exporting to HTML See the discussion here
Optionally include the Table name in HTML export
Make it possible to select all objects for Export Schema with one click
Allow for Date/Time/Timestamp data to be exported with JDBC escape syntax
Make it possible to assign the names for BLOB/CLOB files, e.g. based on the value of other columns on the same row See the discussion here
Possibility to set ExcelSheetName in export wizard
Should be possible to organize the output of schema export so that all DROP, CREATE and INSERTs are grouped
Use a separate File Chooser context for BLOB/CLOB files
Add the following parameters for @export set: HtmlColumnHeaderIsColumnAlias, JSONColumnHeaderIsColumnAlias, XmlColumnHeaderIsColumnAlias
Should be possible to limit number of rows with a new "Max Number of Rows" setting in Export Schema and Export Table See the discussion here
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
Add recently used files/folders list in file selection field and file chooser window
Enable file system auto completion in file selection field
File chooser windows should have a drop-down list of last visited directories which is used to quickly navigate to a directory See the discussion here
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
Adjustments to large counters introduced JDBC 4.2
Grid Component
The "Describe Data" window should allow generating a CREATE TABLE DDL action See the discussion here
Installation/Update Installation
Remove the "-XX:MaxPermSize" Java property as it is deprecated with Java 8
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 See the discussion here
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
Add an option to name SQL Commander tabs as index only if there is no loaded file name
Consistency between Elapsed Time and Execution/Fetch time
Make filename in SQL editor status bar clickable with options to Copy Path and Open Parent Folder
Use setSchema() to set schema for execution to the selected schema
"@export set" commands are order dependant
Add a way to be able to use Java VM system properties and OS environment variables in DbVisualizer variables
Move the preprocessing settings (Parameterized SQL, Strip Comments, etc.) as connection properties
SQL Log tab entries for @ commands could show more information for the command
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
Bugs Fixed
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 See the discussion here
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 See the discussion here
DB Support: Oracle
The Synonymed Objects view should not include synonyms owned by the selected schema
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 See the discussion here
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 See the discussion here
Export of multiple results to HTML with AppendFile set to false creates a document that is missing the header
Exec time is the same for all log entries during Export Schema/Database
Export HTML from table with no data generates HTML with one line
Export to JSON Array with AppendFile set to clear creates one array per table
Any non absolute BLOB/CLOB File paths should be relative to the exported file
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 See the discussion here
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
Any errors in a @run script are added to the @run marker tooltip equally number of times as there are errors
While SQL Commander is in the "Parsing Script" or "Looking for variables, parameter markers..." phases stopping takes a long time
Error markers are visible only when these are available by the driver/database. There should be markers for all failed statements
@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
Right-arrow does not clear selection when the whole text is selected
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
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
The SQL in the log for a @call statement shows the variable values after execution rather than the values from when the call was made
Tool Properties
Issue specifying -Ddbvis.prefsdir=<folder> in user.vmoptions (Tool Properties->General)
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.
