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.

Select version

Release Notes

New Features

  • New product packaging DbVisualizer is from 3.0 available in two editions:
    • DbVisualizer Free
      Use free of charge for commercial and non commercial purposes. It contains the exact same functionality as previous versions of DbVisualizer plus an extensive collection of new features added since 3.0.
    • DbVisualizer Personal
      Extends the Free edition with functions for multi SQL statement execution, multi result set management, selection executes and a reliable forms based editing capability. This edition is commercial and is licensed/priced per user.
  • General Added tool icons for main frame, bookmarks editor and tool properties.
  • Path used in the open/save dialogs now saved between invocations (Export result set and Export/Import SQL Statements in the Bookmarks Editor)
  • System Properties info moved from Tool Properties to About
  • Support for the Kunststoff Look and Feel
  • Choice to switch Icon Collection in Tool Properties. Java Graphics or Dean S. Jones.
  • Now possible to select small or large icons in the tool-bar for Java Graphics.
  • Ctrl-1 to 3 shortcuts added to switch between (in order) Database Objects, SQL Commander and Reports
  • "quoted-where-columns" variable now possible to specify in the SQL statements in Tool Properties. This will quote the WHERE columns instead of the variable stuff
  • Database Connection boxes now list entries ordered by connection state. Connected at top.
  • Possible to specify an optional description for HTML exports
  • Possible to specify column and newline delimiters during export
  • "Echo Column Header" moved to column header pop-up menu (copy name).
  • "Edit->Find..." is used to search in the currently active grid
  • New grid pop-up menu option: "Count Bytes" which will do an approximately summary of the number of bytes in the grid.
  • Database Objects Creating a new Database Connection will automatically select the new node
  • Tool-tip for the object header now shows:
    - Database Connection
    - Catalog (might be blank)
    - Schema (might be blank)
  • "select * where not" removed from "Data" pop-up menu
  • Database Connection nodes only hi-lighted if connected
  • Number of rows in a table now optionally displayed in object header
  • Now possible to disable indicate of Primary Key in Data tab
  • System Tables for Sybase and PostgreSQL are now grouped properly in the "System Tables" node instead of "Table"
  • DatabaseMetaData.getTables() now pass "%" for table name instead of null
  • Tool-tip for grid table header. Shows various data type info
  • Default Column Width function in all grid pop-ups
  • Choice to move a database connection node up/down in the tree
  • Copy Selected Cells as HTML tables (to clipboard) in all grid pop-ups
  • Grid Height and Grid Width sliders in Graph Controls panel replaced with a single "Grid Size".
  • Possible to show row count for each table node in the database objects tree
  • New grid pop-up menu choice: "View in form" -> For easy browsing of row values. (Short cut is double click in the grid)
  • Tables and Reference tabs now available for object type nodes
  • Pressing the "Select" action in the tool-bar while the list of Tables is presented is the same as choosing "Generate a Select All Script"
  • New menu option, "Generate a Select All Script" in Tables tab
  • "Copy Name" choice in database object tree pop-up menu will copy the name of the node to the clipboard
  • Number of tables and arcs in References graphs listed on top
  • SQL Commander, References graphs and Reports are now threaded.
  • Now possible to "Stop" execution in SQL Commander, References graphs and Reports. "Esc" button is short cut
  • Zoom of graphs now supported
  • SQL Commander and Reports "Folders" button is now "Tabs" while "Frames" is "Windows" in the SQL Commander and Reports tabs.
  • Entering @ as the first character in the SQL Commander will consider the rest of the statement to be a file name. SQL Commander will load the file (but NOT insert it into the editor) and execute the statement(s) found in it. A log entry is written as usual for each exec.
  • Import operation in File menu will insert the selected file into the SQL Commander editor.
  • New "Get SQL" button in Reports tab will copy the SQL of the current report into the SQL Commander
  • Now possible to set that the "Database Connection" box in the SQL Commander can be sticky. Default is the old behavior. Sticky simply means that its value only can be altered manually.
  • Refresh button in tool bar will re-execute the currently selected result set. No progress or possible to "Stop" this refresh operation is possible. An entry is written in the log.
  • Progress bar in Reports now shows number of seconds left until next reload
  • Possible to specify whether SQL Commander shall stop on error or continue
  • Support for comments in the SQL Commander:
    - Block Comment: /* */ that can spawn several lines.:
    - Single Line: # that ends with a newline character:
    - Single Line: // that ends with a newline character:
    - Everything including comment characters between " and ' pairs are handled as is.
    - ';' is handled as eof of command delimiter if not in a comment or between quotes
    - \ngo\n is considered as ;
  • Support for highlighted SQL execution in SQL Commander
  • Support for multiple SQL execs
  • Support for multiple result sets
  • Support for handling result sets for non SELECT statements (Ex. is MySQL "show" commands or various stored procedures in for example Sybase)
  • Positions of result sets in Reports are now saved between invocations
  • Possible to tile/cascade the windows in SQL Commander and Reports
  • SQL Commander Log which lists all executed commands
  • Support for scrolling of the complete Windows desktop view in SQL Commander and Reports
  • Bookmarks Bookmarks menu now available in the Bookmark Editor
  • "Edit->Change Name" added to the menu-bar in the bookmarks editor
  • Ctrl-Enter in the Bookmark Editor passes the selected bookmark to the SQL Commander and raises the main frame
  • Icons changed for Contain Variables and Multi SQL columns in Bookmark Tree. This were check boxes in previous version which was confusing since they are not actually editable.
  • "Apply" changed label to "Apply Edit" in Bookmark Editor
  • Possible to specify max number of history bookmarks in tool props.
  • Now possible to set name and note of bookmark during add of new bookmark
  • Multi SQL indicator in bookmarks editor
  • Number of SQL bookmarks listed for the root nodes in Bookmark Editor
  • Choosing "Execute" for a folder in Bookmark editor creates and passes a script of all included SQL statements to the SQL Commander. The SQL commands for these are "select".
  • JDBC Driver Manager Non-existent driver paths now appears in red color
  • Drivers in the driver manager are now bold
  • The "Find JDBC Drivers" operation now searches for drivers in all locations and not just in the selected location

Bugs Fixed

  • Po-pup menu in Database Objects tree now selects the node at the pop-up position.
  • All tool-tips checked and some changed
  • Last column in grid was sometimes to wide which caused the horizontal scrollbar to appear. Last column in grid are now never stretched to the right edge
  • The vertical splitter position in SQL Commander saved between invocations
  • Procedures were earlier reported as Functions and vice versas
  • On JDK 1.4 there was no cursor in the SQL Commander editor. Caret changed to block style instead of vertical line.
  • Now supports Date and Time columns for DB2 properly
  • Shuffle of columns in the "Data" tab do not effect the ordering of columns during insert/update/delete, etc.
  • Microsoft driver is now found in the driver manager
  • as first part of a cell value caused all grids to format the visible value as HTML. Serious errors could also happen if the HTML was incorrect in its syntax. We have filed a bug (4652898) that has been accepted by Sun regarding the current impossibility to disable HTML rendering. A temporary workaround works as expected
  • Disconnecting a broken hsqldb connection did not work in previous versions
  • JTable noncontiguous selections fixed (workaround implemented for a bug in Swing)
  • Format date and times in the substitute dialog according to the current tool properties format
  • Electric scroll of text area in SQL commander removed.

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