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

Improvements

  • General Now possible to specify the enclosing characters for table and columns names in Database Connection Properties and Tool Properties.

Bugs Fixed

  • General java.lang.NoSuchMethodError when using "Browse Row in Form" operation.
  • Too many open cursors error when accessing Oracle databases.

New Features

  • General Users Guide now accessible in the Help main menu

Improvements

  • Database Objects "Remove Database Connection" added in the database objects tree right click menu
  • "Show selected object in Frame" now also lists the database connection name, catalog and schema in the frame header
  • Database Connection objects are automatically expanded one level when the connection is established
  • Editing the name of a database connection or folder in the tree previously required that the enter key was pressed to finish editing
  • Setting of Max Rows and Max Columns in Data tab now saved between invocations without needing to press the enter key while in the fields
  • Tool Properties Added "General" category which lists the location of the original preferences (XML) file and the backup copy
  • Added preview of the icon collections
  • Added format "dd-mmm-yyyy" to Date Formats list
  • Removed the SQL->Pre-Processing->New Line->Remove New Lines property since new line characters now are always removed from the SQL before execution
  • SQL Commander File->Close Current SQL Editor operation is used to close the current editor. If only one editor is active then it will cause any file that is currently loaded to be closed
  • All settings that controls the SQL Log are now saved in the preferences file between invocations
  • Setting of Max Rows and Max Columns in now saved between invocations without needing to press the enter key while in the fields
  • Monitor Auto Reload interval now adjusts automatically if the execution of all monitors is not ready within the auto reload interval
  • "Auto Reload" interval now saved between invocations
  • The Monitor tab icon now show an hourglass when monitors are executing in Auto Reload mode
  • New field "Label" in the Data setup for a chart. Use it to set an optional label for columns that are marked as Series
  • Form Editor "Wrap Lines" setting added which when checked will wrap long text values

Bugs Fixed

  • General Export to the SQL Commander destination sometimes caused DbVisualizer to freeze
  • Exporting only one row in a grid accidentally exported one extra blank row. (This happened also when doing Ctrl-C to copy the data)
  • "File->Export Selection" was sometimes disabled when it shouldn't
  • Copy or export of a non contiguous block resulted in error
  • Changing Font in Tool Properties did not set the new font in the Form or Inline editors
  • SQL Commander Enabling the old property "Remove New Lines" removed the new lines not just in the SQL that is executed but also in the SQL that is fetched using the Output View->Copy SQL into Editor operation
  • Monitor SQL statements containing client side comments can now be executed in the Monitor tab
  • Form Editor Entering the text representation for null in a CLOB did not cause the value to be set to null
  • Inserting a file into a CLOB that was null failed (nothing happened)

Improvements

  • DbVisualizer Personal: The red X icon used to close an SQL Editor tab now replaced with the Close operation in the tab's right click menu
  • DbVisualizer Personal: "Remove All SQL Editors" now in the File menu
  • Load of an SQL file now inserted into the current editor instead of a new editor being created
  • Name of loaded file now listed in the editor status bar

Bug Fixes

  • DbVisualizer Free: Loading an SQL file into the SQL Commander accidentally created a new editor
  • JdbcOdbc connections returned duplicates of the table types in the Database Objects tree
  • DbVisualizer Free: Controls for SQL Commander removed that are not valid in the DbVisualizer Free edition (they were inactive anyway).
  • Tab header removed from the SQL Commander if only one editor
  • Export of references graph with an active selection removed the selection both from the exported image and the graph view
  • Significant performance enhancements during for example connect and exit of DbVisualizer when using Java 1.4.1 on Mac OS X and Linux
  • Startup time enhancements when using any Java 1.4 version
  • DbVisualizer Personal: Inline editor silently ignored any errors that was caused by a column text value larger then its max size
  • DbVisualizer now have more RAM to play with. 128M instead of 64M in previous versions

Bugs Fixed

  • DbVisualizer Personal: Serialized Java objects viewer were broken
  • A ClassCastException error occurred when closing stand alone frames in the Database Objects tree

New Features

  • General DbVisualizer 4.0 requires at least Java 1.4
  • New Icon Collection
  • Database Objects Tool bar added to Database Objects tree
  • New sub tab "Properties" in the Connection tab for a Database Connection node. Used to specify connection specific values for some of the tool properties:
    • SQL Statements, Auto Commit, Transaction Isolation, etc.
    • "Extra Options" dialog moved into the "Driver Properties" tab
    • Now possible to show only default database and/or schema
  • Now possible to filter what objects to see in the tree based on their names. Up to 5 patterns can be set per Database Connection. These are saved between invocations
  • "Connect All" operation now only connects enabled database connections (with the "Connect when Connect All" property enabled)
  • New root node, "Connections", selecting it will show an overview of all Database Connections and various state information
  • Now possible to folder connections in an unlimited number of levels. Useful to group connections
  • The tree can now be organized using Drag and Drop
  • Replaced the following operations in the Database menu:
    • Remove Database Connection with Cut
    • Duplicate Database Connection with Cut/Paste
  • Alias for a Database Connection can now be edited in the tree by selecting the node and then single click on its name
  • Reload Tree operation can now be performed on any node in the tree.
  • "Reconnect" operation added to:
    • The Database Objects menu
    • Database menu in the menu bar
    • "Connect" button in Connection tab will switch to "Reconnect" once a connection is established
  • Support to create Tables and Indexes
  • Table Data Editing Added support for management of BLOBs and CLOBs.
  • Added BLOB content viewers in the Form Editor for
    • GIF, JPG, PNG
    • Serialized Java Objects
    • Hex Viewer
  • SQL Commander "Pin New Results Sets" choice added to the Output View menu
  • Now possible to edit the result sets in the SQL Commander if the result set
    • is a result set as returned from a SELECT command
    • is fetched from only one table
    • is composed of columns that exist in the table
  • Primary Keys are now indicated in the result set panes
  • Support for the @ include control directive
    • Path is relative to the directory from which DbVisualizer is launched
    • If a file is loaded into the editor then is the path for any @ included files relative to the path for the loaded file
    • The new @cd command can be used to set the location for any succeeding @ include directives
  • New right click menu choices in Clear, Find, Find/Replace and Goto.
  • SQL Commander now supports multiple editors organized as tabs or internal windows.
  • Unsaved edits in a script file loaded from file is now asked whether to save or not save at exit of DbVis.
  • Support to execute anonymous SQL blocks
  • SQL Commander now supports multiple results from a single SQL statement. (Ex: sp_who, sp_help in Sybase and SQL Server)
  • Export New output Formats in XML and SQL INSERT statements
  • Output Columns can now be customized:
    • Select which columns to output
    • Select data format
    • Edit column name
  • Test Data Generator can be used to generate random test data:
    • Generate random number
    • Generate random string of random size
    • Generate random value from a list of values
    • Generate sequential number
  • Now possible to specify how text data shall be quoted (No Quotes, Single Quotes or Double Quotes)
  • Zoomed references graphs are now exported properly
  • File extensions now determined based on export format
  • Tool Properties Saved passwords are now encrypted
  • New property: "Confirm Disconnect All". Specifies whether a confirmation dialog shall appear when "Disconnect All" operation is requested.
  • New property: "Pending Transactions at Disconnect". Specifies what to do with any pending transactions at disconnect.
  • Changed property: "Connect at Startup" to "Run Connect All at Startup"
  • Font can now be defined for SQL editors and all grids
  • Configurable short cuts for the SQL Commander editor
  • References Graph The layout can now be saved using the Save and Load operations

Bugs Fixed

  • Support for IBM JVM
  • Some components had wrong dimension on Mac OS X
  • added tool icon for Mac OS X
  • Bug fix when using Mac OS X and Java 1.4. A dialog was always displayed at startup saying that L&F has changed and re-start is recommended
  • "Data Type" column info in the Form Editor now show SQL type rather the internal DbVisualizer Java type
  • SQL Commander editor is now focused when it gets an SQL statement from some other location in the application

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