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