DbVisualizer Changelog

New in version 9.2

January 12th, 2015
  • ENHANCEMENTS:
  • Auto Completion: Full auto completion support for client side commands and their parameters
  • Compare: Allow comparison of two cells in the same grid
  • Connection Setup: Re-introduce the "single physical database connection" behavior
  • Connection Setup: Add support for editing multiple database connections
  • Connection Setup: Add optional master password protection for DbVisualizer
  • Connection Setup: Add a Connection Keep Alive feature
  • Connection Setup: The DB2 z/OS database type should be set when using the DB2 z/OS driver definition
  • DB Support: DB2 iSeries: The Schema list in the SQL Commander should really change the current schema
  • DB Support: H2: Upgrade to H2 1.3.175
  • DB Support: Oracle: Add DDL support for GLOBAL TEMPORARY TABLE
  • DB Support: Oracle: Add support for export of sequences and synonyms in Export Schema
  • DB Support: PostgreSQL: Add support for editing HSTORE, JSON and JSONB values in the grid
  • DB Support: SQLite: Upgrade to SQLite 3.8.6
  • Database Objects Tree: Make it possible to hide certain object types
  • Database Objects Tree: Support for multiple named filters
  • Database Objects Tree: Support filter sets with pre-defined filters that can be switched easily
  • Database Objects Tree: Support sharing object tree filters between database connections
  • Database Objects Tree: Allow de-activating some filters in the objects tree
  • Database Objects Tree: Ensure Database Connection and Folder names are unique under its parent node
  • Database Objects Tree: Support more filtering conditions (ex in, not in, starts with, contains, ...)
  • Database Profile: Actions: Allow showing result sets generated by action in a text viewer
  • Export: Exported binary Excel files has sheets selected initially resulting in edits being made in one sheet are propagated to all sheets
  • Export: Default sheet names does not follow Excel standard at export (Sheet1, Sheet2, Sheet3)
  • Export: Should be possible to specify qualifiers and delimited identifiers (for SQL format) in Export
  • Grid Component: Add option to allow free horizontal scrolling in grids instead of the current column-by-column based scrolling
  • Grid Component: Add new Copy Selection actions to grids: Copy as Comma list, Copy as IN clause
  • Import: Add support for Excel (xls/xlsx) import of table data
  • Import: Make it possible to specify in which row any header starts and the data in CSV import
  • Import: File row numbers in import preview panel
  • Import: Import into new table with a DECIMAL column should suggest size,scale for the DECIMAL data type
  • Installation/Update Installation: Offer a Debian software package installer
  • Key Bindings: Can't set key bindings for Tools->Compare
  • OS Support: Windows: Show splash screen when starting second DbVisualizer instance
  • SQL Commander: An SQL Commander tab with a file loaded should be removed at next startup if the referred file has been deleted and the SQL Commander is not modified & auto-saved in previous DbVisualizer session
  • SQL Commander: Allow having the Log and all result set tabs in a floating window that persist as long as the SQL Commander tab or when docked
  • SQL Commander: The Set Auto Commit command in the SQL menu should show on/off based on current mode to make it more intuitive
  • SQL Commander: The Schema list in the SQL Editor should really change the current schema for PostgreSQL
  • SQL Commander: Allow use of parameter markers (?, :pm, &pm, or :{pm}) for any database
  • SQL Commander: Support the :'x' parameter marker format
  • SQL Commander: Add a @sleep command
  • SQL Commander: Add new client side command (@set resultset name ) used to set a name for the next result set
  • SQL Editor: Add support for pre-defined templates and custom SQL templates
  • SQL Formatter: Option to format a SQL statement into a single line by removing newlines, tabs, etc.
  • Table Data Editor: Show current cell data format in the table editor status bar
  • Tool Properties: Import Settings should merge database connections.
  • BUG FIXES:
  • DB Support: SQLite: [SQLITE_NOTADB] File opened that is not a database file (file is encrypted or is not a database)
  • DB Support: Vertica: "Map to String" viewer for Flex Tables show an error
  • Export: Export to XLSX doesn't output non-printable characters properly
  • Installation/Update Installation: Add Mac OS X installer that include Java 7
  • SQL Editor: Exception when click "Discard Edits" and then click in editor when dialog: "The loaded file is no longer available for editing. Confirm save or discard edits and then clear the SQL editor" is displayed
  • SQL Editor: Navigating vertically with arrow keys may change horizontal position if a line holds both TAB and SPACE characters
  • SQL Editor: Ctrl+Left-click does not trigger the popup menu
  • Scripts: An exception may occur when filtering and expanding/selecting nodes
  • Scripts: Duplicating file in Scripts tab ruins file extension. "name.sql1" instead of "name1.sql"
  • Scripts: Drag & drop of file to folder containing a file with the same name gives an error
  • Table Data Editor: Unable to save data grid changes when table names containing spaces
  • Table Data Editor: Force close of an object view tab while saving table data edits may result in an error

New in version 9.1.13 (January 12th, 2015)

  • Bug fixes:
  • Command Line Support (dbviscmd): Make it possible to execute @run commands in a script specified by -sqlfile
  • Command Line Support (dbviscmd): Retrieval and prompting for SSH credentials, especially the passphrase, is not working
  • DB Support: SQL Server: Connecting by expanding a connection node may cause an invalid URL to be used
  • DB Support: SQL Server: DATE columns generate ALTER COLUMN statements in Alter Table even when unchanged
  • DB Support: Sybase ASE: Function and Procedure code for large objects may be out of order for older versions of Sybase ASE
  • DDL Generator: ClassCastException when generating DDL for a View in Mimer 10.x or later
  • Database Profile: Actions: The Script action gives an error for the CREATE option for some object types in some databases
  • Export: Rare SQL SELECT syntax may stop execution during @export
  • Grid Component: Embedded array produced by for example the SDO_GEOMETRY type in Oracle is not properly displayed
  • Navigator: Exception occurs when selecting some nodes in a Navigation graph. Selecting other nodes (from the same table) in the same graph works fine
  • Procedure Editor: Syntax error messages are not marked as errors in the log
  • SQL Commander: Error highlighting is off when using SQL Block delimiters
  • SQL Commander: A client side command is not processed if it is preceded by a comment
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18595 ]
  • SQL Commander: SQL syntax errors stops execution when preprocessing is disabled

New in version 9.2.2339 Beta (December 18th, 2014)

  • Enhancement:
  • SQL Commander - Support the :'x' parameter marker format
  • Bug:
  • Command Line Support (dbviscmd) - Retrieval and prompting for SSH credentials, especially the passphrase, is not working
  • Command Line Support (dbviscmd) - Make it possible to execute @run commands in a script specified by -sqlfile
  • Connection Setup - Database password may be corrupt if mixing "Save Password Between Session" and "Save Password During Session" on the database type and a specific database connection
  • DB Support: Sybase ASE - Function and Procedure code for large objects may be out of order for older versions of Sybase ASE
  • DDL Generator - ClassCastException when generating DDL for a View in Mimer 10.x or later
  • Database Profile: Actions - The Script action gives an error for the CREATE option for some object types in some databases
  • Explain Plan - Explain plan for PostgreSQL doesn't work if having parameter markers in SQL
  • Export - "Parameter 'sqlqualifycolumnname' is not valid for this command" when exporting table
  • Navigator - Exception occurs when selecting some nodes in a Navigation graph. Selecting other nodes (from the same table) in the same graph works fine
  • SQL Commander - A client side command is not processed if it is preceded by a comment
  • SQL Commander - Error highlighting is off when using SQL Block delimiters
  • Table Data Editor - Unable to save data grid changes when table names containing spaces

New in version 9.2.2335 Beta (December 9th, 2014)

  • ENHANCEMENT:
  • DB Support: Oracle: Add support for export of sequences and synonyms in Export Schema
  • Database Objects Tree: Ensure Database Connection and Folder names are unique under its parent node
  • Grid Component: Add new Copy Selection actions to grids: Copy as Comma list, Copy as IN clause
  • Tool Properties: Import Settings should merge database connections
  • BUG:
  • DB Support: Oracle: Trigger names are invisible in the database objects tree
  • DB Support: Vertica: "Map to String" viewer for Flex Tables show an error
  • Filtering/Filter Sets: In some rare situations an error may appear when clicking a database objects node
  • SQL Commander: Multiple uses of a DbVis variable with the same name prompts for values equally times
  • SQL Editor: Navigating vertically with arrow keys may change horizontal position if a line holds both TAB and SPACE characters
  • SQL Editor: Ctrl+Left-click does not trigger the popup menu
  • Scripts: Duplicating file in Scripts tab ruins file extension. "name.sql1" instead of "name1.sql"
  • Scripts: Drag & drop of file to folder containing a file with the same name gives an error
  • Table Data Editor: Force close of an object view tab while saving table data edits may result in an error

New in version 9.1.12 (November 27th, 2014)

  • ENHANCEMENTS:
  • Create/Alter Table:
  • Removing the last column in a Primary Key should automatically remove the Primary Key
  • DB Support: SQL Server:
  • Add an Instance field in the Connection tab for SQL Server
  • SQL Commander:
  • Key binding to start Execution can not be set to any of the key bindings Java/Swing have assigned to for example the Max Rows textfield, etc.
  • BUG FIXES:
  • Auto Completion:
  • Activating Auto Completion can in some circumstances freeze the GUI
  • DB Support: Mimer SQL:
  • References graph may show duplicate table nodes
  • DB Support: MySQL:
  • An error may occur when generating DDL for a MySQL table, e.g. in Alter Table or the DDL tab
  • DB Support: Oracle:
  • Rename the Session Properties tab to accurately state that it shows database properties and add a new Session NLS Parameters tab
  • DB Support: Oracle:
  • Handle procedure DATE parameters as TIMESTAMP instead of TIME for Oracle 12
  • DB Support: PostgreSQL:
  • Two dimensional arrays no longer render correctly in result sets
  • DB Support: SQL Server:
  • SELECT ... INTO ... will limit number of copied rows by setMaxRows()
  • DB Support: Vertica:
  • The ON COMMIT PRESERVE ROWS clause is always included when creating a temporary table
  • Database Profile: Actions:
  • Using List input in an action should match default value independent of case
  • Database Profile: Actions:
  • A action element without tags around the message will break
  • Export:
  • Date/Time literals are not in the database-specific format unless Format is set to uppercase "SQL"
  • OS Support: Mac OS X:
  • F1-F10 cannot be used as part of a key binding on Mac with Java 7 using the FN key
  • SQL Commander:
  • An exception may be reported if doing a rollback and then reconnect
  • SQL Commander:
  • Possible NPE when highlight execute
  • SQL Editor:
  • Dropping a file in the SQL Editor should load that file using the same encoding as used in the editor

New in version 9.2.2329 Beta (November 26th, 2014)

  • Enhancement:
  • Compare: Allow comparison of two cells in the same grid
  • DB Support: Oracle: Add DDL support for GLOBAL TEMPORARY TABLE
  • DB Support: Oracle: Handle procedure DATE parameters as TIMESTAMP instead of TIME for Oracle 12
  • DB Support: PostgreSQL: Add support for editing HSTORE, JSON and JSONB values in the grid
  • Import: File row numbers in import preview panel
  • OS Support: Windows: Show splash screen when starting second DbVisualizer instance
  • SQL Commander: The Set Auto Commit command in the SQL menu should show on/off based on current mode to make it more intuitive
  • SQL Formatter: Option to format a SQL statement into a single line by removing newlines, tabs, etc.

New in version 9.2.2328 Beta (November 12th, 2014)

  • Bug:
  • SQL Commander - ${...}$ variables without type information are erroneously when executed treated as parameter markers rather than literals
  • Scripts - Rendering of Favorites and Scripts lists are broken

New in version 9.1.11 (October 14th, 2014)

  • Bug:
  • Auto Completion - Auto Completion of column names does not work after linefeed
  • Chart - The value for a point in the chart tool tip is always rounded to one decimal
  • Compare - NullPointerException when closing the Compare window with a cell selected
  • Connection Setup - SSH tunneling does not work with long DNS target server names
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3938]
  • Connection Setup - Disconnecting progress window is displayed even after connection(s) closed
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4975]
  • DB Support: DB2 LUW - Error running explain with DB2 LUW 10.5
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4971]
  • DB Support: Vertica - Move Table to Schema may display an error
  • Database Objects Tree - Vertical scrollbar in the action window appears only after a resize
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18248]
  • Database Profile: Actions - Should be possible to specify other schema for new trigger than the table schema
  • Database Profile: Actions - Exception is raised if there is not static text specified in the element for an action
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18320]
  • Database Profile: Actions - Actions with many fields may take time to open and respond slow when editing
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18280]
  • General - Error when getting columns information using the HIT JDBC driver
  • Grid Component - Unsortable grids should not have sorting entries in header popup menu
  • OS Support: Linux - Double-click on the same file twice in the file chooser results in an exception
  • SQL Commander - Merge result sets doesn't work having Remove Original Result Sets checked
  • SQL Commander - Failing to save a file due to file system exceptions such as permissions still remove the modified indicator for that file
  • SQL Commander - For PostgreSQL, Vertica and H2: Are prompted to commit/rollback transaction(s) even if running only SELECTs
  • Workspace - Exception: AIOOBE when clicking tab

New in version 9.1.10 (August 9th, 2014)

  • ENHANCEMENT:
  • DB Support: Vertica: Add support for Vertica in DbVisualizer Pro
  • SQL Editor: Make it possible to set the caret color in the SQL editor
  • BUG:
  • DB Support: MySQL: YEAR(4) values are not being displayed correctly and cannot be edited in the grid
  • DB Support: NuoDB: The column names in the Index DDL are incorrect
  • DB Support: PostgreSQL: Running a erroneous query in auto-commit off mode will result in a result set never being editable due to the 25P02 error in PostgreSQL
  • Database Objects Tree: Windows: Opening a floating window using key bindings may display the new window behind the main window
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4303 ]
  • Export: Exporting in XmlDataSet and FlatXmlDataSet format adds the unnecessary DbVisualizer-Export tag
  • Import: Preserve import window size and position during session
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4923 ]
  • SQL Commander: Execution error may lead to rare NullPointerException situations
  • SQL Editor: The spacing between characters is incorrect when using a some fonts, like 14 points Menlo Plain, on a Mac with Retina display
  • SQL Editor: The Find/Replace dialog does not use the selected text for "Find what" the first time it is displayed