DbVisualizer Changelog

New in version 9.1.6

January 28th, 2014
  • Enhancement:
  • DB Support: Sybase ASE: Add support for UNICHAR/UNIVARCHAR size in DDL
  • General: Support user.vmoptions and modifying Java properties in Tool Properties for all installer types
  • Grid Component: Should be possible to copy/paste external files to binary/BLOB and CLOB grid cells
  • Grid Component: Should be possible to copy/paste binary/BLOB and CLOB data between grids
  • SQL Commander: Clicking on an icon for an error in the Log tab should move the caret to the error instead of selecting the statement
  • Workspace: Adjust active tab stripe color based on current look and feel. Allow override it in tool properties
  • Bug:
  • Connection Setup: Set Database Type to Auto Detect by default when using the Connection Wizard
  • Connection Setup: Pressing Tab in the Database Userid field in the Connection Wizard selects the value instead of moving to the next field
  • Database Objects Tree: Using any of the "Script..." or "Open in..." right-click options in the Tables grid with the Generic database type will result in an exception if TABLE_SCHEM is null
  • General: Occasional "Comparison method violates its general contract" error may be reported
  • Grid Component: Right double-click in the row number field without having a grid selection results in an exception
  • OS Support: Mac OS X: com.jidesoft.plaf.aqua.AquaPreferences loadGlobalPreferences may be listed in the debug window on OS X
  • SQL Commander: Highlighting errors for huge statements takes a very long time
  • SQL Commander: Sometimes the Elapsed Time field in the Log tab shows an incorrect value and the script may be executed multiple times
  • SQL Commander: Connection drops while executing in the SQL Commander require a manual reconnect rather than automatically at next execute
  • SQL Editor: Occasionally an error (NullPointerException in AttributedString) is triggered by various editor operations, e.g. the Find and Replace dialogs or simply double-clicking
  • Table Data Editor: Null cells should be preserved when copy/paste between grids independent what "Show Null As" is set to
  • Workspace: Exception: IndexOutOfBoundsException while closing or move tab
  • Workspace: Tab text color is too bright and "Show Tab Title in Bold" doesn't work with Metal L&F

New in version 9.1.5 (December 17th, 2013)

  • Enhancement:
  • SQL Commander - Present a Reconnect dialog when detecting a dropped connection at Execute
  • Bug:
  • SQL Commander - Having "Process Parameter Markers in SQL" enabled may consume cursors and cause following SQLs to fail during execution
  • Table Data Editor - Result set is not editable if using a sub query in the select statement

New in version 9.1.4 (December 9th, 2013)

  • Enhancement:
  • SQL Commander: SQL Commander->Strip Comments when Executing should be unchecked by default (for new users. Existing users need to uncheck manually)
  • SQL Commander: Add key binding to move focus between SQL editor and the result sets (View menu)
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4705 ]
  • Tool Properties: Don't insert "save at" timestamp in the settings XML files
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4731 ]
  • Workspace: Add key binding to activate and focus current workspace tab (Object View or SQL Commander)
  • Workspace: Focus is not set when using key binding to switch to Database, Scripts and Favorite tabs
  • Bug:
  • Connection Setup: Clicking the Ping button may result in an IndexOutOfBoundsException
  • DB Support - Other: Indexes doesn't show in the Indexes tab for a table for Progress databases
  • Data tab: While Data tab is being loaded (or saved) some controls are enabled that may result in an error due to the processing state
  • Database Objects Tree: Using keyboard to paste into the Databases tab list show an exception
  • General: An error may occur when connecting with the bundled Java VM: "Unsupported ccsid, encoding, or locale: "Cpxxx""
  • SQL Commander: Getting column information for unqualified tables fails for some databases, affecting Auto Complete and enabling of editing controls for result sets
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4729 ]
  • Table Data Editor: Saving table data may give an error if saving to a table in non default schema
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17324 ]
  • Table Data Editor: Pressing tab or enter key in a cell that contain newline or tab characters should not start the inline editor

New in version 9.1.3 (November 23rd, 2013)

  • Enhancement:
  • Check for Update: Show underlying error message when not being able to connect
  • Data tab: Should be possible to assign key binding to the "Show in Navigator" action in the Data tab
  • General: Show underlying error message when not being able to connect for Pro evaluation
  • General: It should be possible to modify vmoptions per user and not only for the installation which may be shared by many users
  • Import: Dropping a file on a Tables or Table object should open the Table Data Import feature
  • Installation/Update Installation: Changes in the vmoptions file should survive when installing new versions
  • Workspace: Add option to set that "Open in Tab" should switch to the already open object tab first, otherwise open a new tab
  • Bug:
  • Check for Update: Use System Proxy Settings does not work on Windows if an automatic configuration script is used for system setting
  • Connection Setup: Disconnect All may take a while if having a lot (100+) of database connections
  • DB Support: Oracle: Max Size is not summarized correctly (DBA Views->Storage->Tablespaces) if having multiple data file for a tablespace
  • DB Support: SQL Server: Size parameter is not included in DDL for VARBINARY column and the MAX value is not supported for VARBINARY in Create/Alter Table
  • Database Objects Tree: Using the pre 9.0 scripting features doesn't honor the scripting settings in connection properties
  • Database Objects Tree: It is not possible to connect (using the node expand handle) a database connection in the Databases tab if it is in an error state
  • Database Profile: Actions: The Drop Table action doesn't generate good SQL for MaxDB
  • Driver Manager: De-selecting a driver jar file doesn't disable the command buttons. Invoking these without an active selection may result in an error
  • Grid Component: Clicking 'Reset Columns' button in the Grid Column Chooser while the underlying resultset is being loaded results in an error
  • Monitor: Reloading monitor scripts will reset the current results of any active monitors
  • Monitor: Re-displaying the monitor window with monitors running may display an empty dialog in front of it
  • Query Builder: Missing whitespace between an operator and its expression cause an error when loading a SELECT statement
  • SQL Commander: Getting column info for a result set fails if the table identifier is qualified with a different database than the default
  • SQL Commander: Executing queries for large tables with Sybase IQ may be dramatically slower than versions older than 9.0.5
  • SQL Commander: NullPointerException when executing a script containing an error with Preprocess Script disabled for databases that support error highlighting
  • SQL Commander: When executing a script for a connection that has dropped, an error is reported for the first statement but a new connection is acquired and the rest are executed, possibly with the default database/schema instead of the selected
  • SQL Formatter: Formatting a "WITH tableName -- comment AS (SELECT ..." statement does not work as intended
  • SQL Formatter: Variables for non-literal strings are mangled when using the Add One Space whitespace setting for the SQL Formatter
  • Table Data Editor: Paste in row form editor doesn't work
  • Tool Properties: Setting the "Show Null Value as" to en empty string in Tool Properties->Data Formats will break the scripting and table data editing features

New in version 9.1 (September 13th, 2013)

  • The ability to locate SQL script errors was added. Java 7 is now supported on Mac OS X,.
  • Database type is now auto-detected.
  • Native explain plan support was provided for PostgreSQL.
  • The on-line documentation is now organized after how you work, not how DbVisualizer is structured.
  • Version control and upgrading is done from inside DbVisualizer - you request trial licenses, get prompted when new versions are available, and are notified when your license is about to run out.

New in version 9.0.4 (February 19th, 2013)

  • ENHANCEMENTS:
  • Compare: Allow comparison of similar data types, e.g. Integer and BigDecimal
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4336 ]
  • Compare: Center the current difference vertically when navigating between them
  • Create/Alter Table: Create/Alter Table window need to be larger and optimize column sizes
  • DB Support: MySQL: Order procedures and triggers by name in the objects tree
  • DB Support: SQL Server: Remove dependency on SQL Server 2000 compatibility views in the DDL generator and the profile queries
  • Database Objects Tree: Support re-arranging multiple database connections and folders using drag and drop
  • Database Profile: Actions: The Create Trigger action should support setting multiple trigger events (INSERT, UPDATE, DELETE)
  • Favorites: Favorites editor and the favorites bar should support adding multiple objects at once
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4350 ]
  • Favorites: Support re-arranging multiple favorites and folders using drag and drop
  • Grid Component: Add an entry for the Column Chooser in the grid header right-click menu (is currently only available as a button above the vertical scrollbar)
  • Grid Component: Add "Inverse Selection" action in grid right-click menu
  • [http://www.dbvis.com/forum/thread.jspa?messageID=15826 ]
  • Performance/Stability: Improve performance for getting column information in most cases, e.g. when deciding if a result set should be editable
  • Query Builder: Should be possible to remove all joins for a specific table (i.e. right-click in table node and select "Remove All Joins")
  • SQL Commander: Add a "Load SQL in New Editor" to result set tab right-click menu and log icon
  • [http://www.dbvis.com/forum/post!reply.jspa?messageID=15852 ]
  • SQL Editor: Do not move the caret and scroll positions when doing Replace All
  • SQL Editor: Up and Down arrow keys should move caret to beginning/end when on first/last line
  • SQL History: Opening a history entry from the SQL History editor should make the main window active
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4273 ]
  • BUGS:
  • Compare: Flip may cause an error (NullPointerException)
  • DB Support: PostgreSQL: Data types with "WITH/WITHOUT TIME ZONE" and declared precision are not handled correctly in Create/Alter Table
  • Favorites: The "Add to Favorites" window should only display folder objects in the Favorites list
  • Grid Component: The coloring of XML data in the XML Viewer makes it difficult to read when rows are selected
  • Monitor: Changing series while auto reloader is running may clear all active series
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4349 ]
  • SQL Commander: Passing both -connection and -sqlfile arguments doesn't set the connection in the SQL Commander loaded with the file
  • [http://www.dbvis.com/forum/thread.jspa?messageID=15854 ]
  • SQL Commander: Recognize WITH as a SELECT in the execution permission control

New in version 9.0 (December 4th, 2012)

  • This version has a revised user interface with a cleaner design and a more flexible and productive way of working, as well as more room to work.
  • It is easier to work with multiple database objects.
  • Customized layouts are saved between sessions.
  • Compare editors and grids, a new look and feel, minimized risk of lost edits, minimized problems with slow or dropped connections, and much more.

New in version 8.0.2 (August 8th, 2011)

  • Navigator
  • Handle large list of Related Tables in a better way, e.g. make the list scrollable
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3594 ]
  • SQL Editor
  • Restore the 7.1 behavior for Insertion Point to End of Line
  • [http://www.dbvis.com/forum/thread.jspa?messageID=12788 ]
  • SQL Editor
  • Add option to show non-printable characters (tab, whitespace, etc) in the editor
  • [http://www.dbvis.com/forum/thread.jspa?messageID=12581 ]
  • Table Data Editor
  • Table data editor need to save edits in the following order: 1) deletes, 2) updates, 3) inserts to prevent triggering constraint rules
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3588 ]
  • Bug
  • Chart
  • Range of Y-axis is erroneous if the max value in a serie is negative
  • Database Objects Tree
  • The objects tree right click menu may render some actions as disabled
  • [http://www.dbvis.com/forum/thread.jspa?messageID=12868 ]
  • DB Support: PostgreSQL
  • Select composite type column gives exception
  • DB Support: PostgreSQL
  • Exception or incomplete info when getting column info for DDL
  • DB Support: SQL Server
  • The default schema cannot be determined for some database configurations
  • [http://www.dbvis.com/forum/thread.jspa?messageID=12827 ]
  • References
  • Not possible to open references graph GML files in yED
  • References
  • A NullPointerException occur when exporting references graph in SVG or PDF formats
  • SQL Editor
  • Selection not cleared by Move Caret o Next/Previous Word
  • [http://www.dbvis.com/forum/thread.jspa?messageID=12563 ]
  • SQL Editor
  • Triple-clicking a line to select it and then extending the selection by dragging the mouse down deselects the first line
  • SQL Editor
  • Delete Line clears all text but does not remove the line break
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3564 ]
  • SQL Editor
  • The action for moving/selecting to the previous word places the caret at the end of the target word instead of at the beginning
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3487 ]
  • SQL Editor
  • The statement parsing is off if a file containing CR linefeeds is loaded in to the editor
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3420 ]
  • SQL Editor
  • "Invalid location" warning when deleting all text as the first edit action
  • SQL Editor
  • The caret placement may be off when the font specified in the settings file does not exist on the current platform
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3585 ]
  • SQL Editor
  • Copy of multiple lines and pasting them over the selection may lose indentation
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3493 ]
  • SQL Editor
  • Horizontal scroll with wheel/trackpad scrolls vertically
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3468 ]
  • SQL Editor
  • Extending the selection by dragging the mouse up in the row number area stops suddenly
  • SQL Editor
  • The action for moving/selecting to the previous word places the caret one character to the left of the target when caret is at the beginning of a line
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3462 ]
  • Table Data Editor
  • After saving in data editor, edited cells may still show old value
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
  • Table Data Editor
  • While saving in the data editor, edited cells flicker and show the old value
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
  • Table Data Editor
  • Fix so that when editing a cell value (for duplicated rows) to the same value it currently have, should preserve the edited state
  • [http://www.dbvis.com/forum/thread.jspa?messageID=12961 ]

New in version 8.0 (June 19th, 2011)

  • This version added support for the popular SQLite and H2 databases, integrated SSH tunneling, a new SQL editor with extended style configuration and database specific keyword support, enhanced chart support with pre-defined color schemes and easy setup, and the ability to export results in Excel 2007 and column formats.