Try out DbVisualizer Pro for 21 days

Start the trial by running the latest version and then open the Evaluate Pro Edition under the Help menu.

DbVisualizer 10.0

Select version

Release Notes

Improvements

  • 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

Improvements

  • Chart
    Object View
    Allow the chart object view to be triggered on a drill-down request in a parent grid
  • Connection Setup
    DB Support: Exasol
    Support multi hostname/IP addresses in the Ping Server function
  • DB Support: Exasol
    DB Support: Oracle
    Export
    Extra delimiter in DDL when exporting function
  • DB Support: MySQL Upgrade the bundled MySQL JDBC driver to version 5.1.45
  • DB Support: PostgreSQL Show all possible values for ENUM types
  • Update bundled PostgreSQL JDBC driver to 42.2.2
    See the discussion here
  • DB Support: Vertica Upgrade the bundled Vertica JDBC driver to version 9.1.1
  • Export Add support for multi-file output for the JSON format
  • General Use separate icons for "duplicate" actions and Favorites
  • Object View Show database connection name in not yet loaded object view tabs title
  • Add ability to select and copy (ctrl+c, cmd+c) the object name from the object view tab header title
  • SQL Editor
    Tool Properties
    Make the Special Character color configurable

Bugs Fixed

  • DB Support: Exasol Partition Keys are not shown in the DDL
  • Wrong DDL Creation when having tables twice in different schemas
  • DB Support: Exasol
    Explain Plan
    If the EXA_PARAMETER: PROFILE = ON prior to running explain plan it should not be set to OFF after explain is executed
  • DB Support: PostgreSQL Action Condition is not shown in Trigger DDL
  • The Object View Columns tab is empty for a Partitioned Table
    See the discussion here
  • DB Support: SQL Server
    DDL Generator
    Schema name must not be specified for an index in the DDL
  • Grid Component Column aliases not picked up in Copy Selection as HTML table
  • Import Import of XLSX containing negative elapsed times gives errors
  • Exception when importing data using fractions and timezone data
  • SQL Commander Regression: A DbVisualizer variable e.g. ${name||value||type}$ may loose the type setting for identically named variables but first
  • Table Data Editor Set to NULL functionality is broken and may insert the literal (null) rather than null

Improvements

  • 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
  • Excel with empty column leads to misaligned data
  • Batch import may not import all rows for Excel

Improvements

  • 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

Improvements

  • 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

Bugs Fixed

  • Connection Setup Connection Keep-Alive may fail with multicore hardware
  • Database Profile: Actions "Attempt to mutate in notification" error when editing in some actions fields
  • Table Data Editor Paste in an editable grid doesn't work

New Features

  • 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

Sub-task: Improvement

  • 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

New Features

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"

Improvements

  • DB Support: Oracle Add support for IDENTITY and Virtual columns when generating DDL

Bugs Fixed

  • DB Support: Oracle Actions using resultaction="mergeasscript/mergeastext" such as Clone User in Oracle are broken since 10.0.3
  • Export Exporting more than 1,048,576 rows to XLSX gives a cryptic error that should be transformed into something more useful
  • Query Builder Exception when selecting Aggregate or Group By in the Columns tab

Improvements

  • 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

Improvements

  • DB Support: Redshift Add a Vacuum Table action

Bugs Fixed

  • Command Line Support (dbviscmd)
    OS Support: Linux
    OS Support: macOS
    The command line interface is broken in 10.0.3 for macOS/Linux
  • Data tab Exception when saving in Data grid while having a quick filter in the row form window
  • Grid Component Cells are editable in read-only form grids
  • Import Importing Excel files that starts with empty rows may lead to unexpected data being imported
  • SQL Commander SQL block identifier does not work for @run when the end delimiter is not followed by a newline

Improvements

  • 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)

Improvements

  • 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

Improvements

  • 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

Improvements

  • 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
  • Add support to automatically merge generated result sets to text
    See the discussion here
  • SQL Commander
    SQL Log
    Improve the capability for writing the execution log to a file (@spool is now replaced with new "@log <filename> 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
  • Make the log in the SQL Commander more interactive
    See the discussion here
  • 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
  • SQL Editor Entering "(<tab>" in the SQL editor shows the templates popup for © and (™). Change "(c)" to ".(c)" and "(tm)" to ".(tm)"
  • 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.

Close