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

Bugs Fixed

  • Connection Setup "There's no Command with idref: getCatalogs" error and ConcurrentModificationException may occur during connect
  • DB Support: MySQL ON UPDATE clause missing in DDL for TIMESTAMP columns
    See the discussion here
  • The UNSIGNED keyword is missing in the DDL
    See the discussion here
  • DB Support: SQL Server Remove the Rename action for View, Procedure, Function and Trigger objects, because there is no safe way to rename these object types
  • DB Support: Sybase ASE Check constraints larger than 255 characters are not shown correctly in the DDL
  • Remove the Rename action for View, Procedure, Function and Trigger objects, because there is no safe way to rename these object types
  • Grid Component Exiting DbVisualizer first disconnects all database connections then asks whether unsaved edits in the Data tab should be saved or not. Selecting Save at this stage have no effect.
  • OS Support: Windows Unexpected error may appear if using Java 1.6.0_19+ on Windows (java.lang.NullPointerException at sun.awt.shell.Win32ShellFolder2.pidlsEqual...)
    See the discussion here
  • Query Builder If a large chunk of an imported SELECT statement cannot be recognized, the error window gets very wide
  • SQL Commander Comments are not preserved in anonymous SQL blocks
  • Running large scripts with the @run command may result in an IndexOutOfBoundsException error

Improvements

  • DB Support: MySQL Add support for declaring Procedure/Function characteristics in the Create Procedure/Function dialogs
    See the discussion here
  • SQL Commander Show an error message if the path specified for the @cd command doesn't exist or isn't a directory
    See the discussion here

Bugs Fixed

  • Create/Alter Table Open Create Table and add a new column, if the database connection is lost then an NPE is displayed
  • Size information is declared in the wrong position for FOR BIT DATA data types
  • DB Support: DB2 LUW CHAR/VARCHAR FOR BIT DATA are shown as CHAR/VARCHAR in DDL
  • DB Support: MySQL Key constraint treated as a separate index in DDL for Export
    See the discussion here
  • DB Support: Oracle Explain Plan doesn't work with Oracle 11.2
    See the discussion here
  • DB Support: Sybase ASE Problem browsing database objects if quoted_identifier is off
    See the discussion here
  • Export The AppendFile="clear" option does not clear an existing file when exporting to XLS files
  • Grid Component There is a newline after last copied cell
  • Wrong HEX representation in the Cell Viewer
  • SQL Commander The @delimiter command does not work when used in a script called with the @run command
    See the discussion here
  • Variable values for variables with option "nobind" are not quoted when needed
  • "Processing Command" message should show SQL with any control characters (newline, tab) and multiple white spaces replaced with single white space

Improvements

  • DB Support: DB2 z/OS Enable using the schema selected in the SQL Commander as the default schema for the connection
  • Import Clear the log after import
    See the discussion here
  • SQL Commander Fix progress message by splitting "Acquiring connection..." into "Acquiring connection..." and "Executing..."
  • The Max Rows/Max Chars warning should be made more visible than it is currently
    See the discussion here

Bugs Fixed

  • DB Support: Firebird The generated CREATE INDEX statement does not work with Firebird
  • DB Support: Informix BOOLEAN and BLOB columns are shown to be included in all indexes in the Indexes tab and subnode for a table node
    See the discussion here
  • DB Support: JavaDB/Derby Various errors accessing a database created with TERRITORY_BASED collation
  • DB Support: Oracle Clone a user and then clone the new user don't work properly
  • DB Support: PostgreSQL NOT NULL constraints are shown in the Check Constraints tab in the Alter Table dialog
    See the discussion here
  • Export Export in CSV should add a newline on last row
    See the discussion here
  • Export to clipboard results in an error
  • General Opening the browser for Online Resources or Users Guide doesn't work if the default browser is Opera
  • SQL Commander Executing just a single client side command, e.g. "@export on", results in an error dialog
    See the discussion here
  • Stopping the SQL Commander while the database connection has been interrupted may result in an unrecoverable error
  • Table Data Editor Sub queries in table filters (Data tab) may be corrupted
  • The object path delimiter was changed in 7.0 from " | " to "/". Any table filters are not updated to reflect this change resulting in no filters will appear in the Data tab
    See the discussion here
  • Tool Properties Max SQL history entries limit is not migrated when upgrading from pre 7.0 versions
    See the discussion here

Improvements

  • Connection Tab DbVisualizer should stay connected even if the driver cannot handle setting auto commit while initializing the connection
    See the discussion here
  • DB Support: MySQL Fail to navigate the objects tree if "show databases" privilege is missing
    See the discussion here
  • DB Support: Oracle Add new view for DBA->Session->Plan Data that show the plan information along with the SQL for the current session
    See the discussion here
  • Import In the Import Destination->Database Table pane add column for "File Data Type" and make it editable
  • Round estimated character column sizes for new table up to closest multiple of 10
  • Monitor Add an Auto Adjust setting in the Monitor window to control whether the timer should be adjusted automatically (default) or not
    See the discussion here
  • SQL Commander Add new property to control whether the "Auto Commit is OFF" confirmation window should be displayed for any statement (except SELECTs)
  • SQL Editor New setting to control upper/lower-case of auto completed names
  • Table Data Editor Add "Key Columns" button in the data editing result window (used to re-define WHERE columns in case old table row cannot be identified)
    See the discussion here
  • Web Describe workaround how to disable so that the MySQL Connector/J driver should not cache all result set data in memory leading to OutOfMemory in DbVisualizer
    See the discussion here

Bugs Fixed

  • Chart Specifying a directory as the destination for export grid, graph or chart gives an error
  • Database Objects Tree "Clear Visited State" should also clear the state for any child objects
  • Reload objects tree action should reload all objects one level up and not only the selected object
  • DB Support: Informix Invalid CHECK constraints in DDL with long column names
    See the discussion here
  • DB Support: PostgreSQL Invalid quoting of character default values in DDL
  • DDL Generator Showing DDL for a View causes an exception if the AS keyword is not immediately preceded by a blank
  • Monitor Chart series may not be saved between DbVisualizer sessions
  • Using column values from the previous execution of a monitor doesn't work properly
    See the discussion here
  • References Specifying a directory as the destination for export grid, graph or chart gives an error
  • SQL Commander "Pin New Result Sets" doesn't work for second editor even if it is the default between sessions
    See the discussion here
  • A line comment before a "go" statement delimiter causes "go" to be appended to the preceding statement
    See the discussion here
  • SQL Editor Using Save As in SQL Commander should automatically add the ".sql" extension
    See the discussion here

Bugs Fixed

  • Database Objects Tree Reload in Objects Tree or Reconnect a database connection may result in an error

Improvements

  • Database Profile: Actions The Actions dialog should show the Connection Mode border to hilight production, test or production mode
  • Database Objects Tree Bind Shift+Double-click in object tree to show selected object in separate window
  • DB Support: SQL Server Setting Max Rows limits not only the number of rows returned from a query but also affected rows by updates, deletes, etc.
  • DB Support: Sybase ASE Setting Max Rows limits not only the number of rows returned from a query but also affected rows by updates, deletes, etc.
  • Docs: Users Guide Add new users guide document specifically for the command line interface with usage examples
  • Favorites Opening a database object favorite should also change the tab in the Object View
  • Grid Component Add "Copy to Clipboard" for inline filter
  • Add support for "ORDER BY xxx" in the Data tab "Inline Filter" field
  • Import Import log should show finished time
    See the discussion here
  • Procedure Editor Minimize impact of a lost connection, so that edits can be saved before reconnecting
  • Query Builder Add a way to include a table by typing its name
    See the discussion here
  • Scripts Allow newline characters in a @call statement
  • SQL Commander Clean up the Execute processing so that a disconnected database cannot temporarily cause the GUI to freeze
  • Add a "@set maxrows nn" and "@set maxchars nn" client-side commands to control Max Rows and Max Chars from scripts

Bugs Fixed

  • Command Line Support (dbviscmd) Can't launch the dbviscmd/dbvisgui bat scripts in other directories than the installation directory for DbVisualizer
    See the discussion here
  • Check for Update Opening "Check for Update" may result in an error
  • Create/Alter Table Adding a column in the Create Table dialog adds it at the end, not after the selected column
  • Database Objects Tree Shift+Click in the database tree switches to the Object View tab but details for selected node is not updated
    See the discussion here
  • DB Support: SQL Server Invalid SQL used for extracting table DDL info for SQL Server 2000
  • Grid Component Copying data from the Aggregation for Selection window to clipboard may result in weird formatting due to floating point error
  • Fix so that the "Inline Filter" preserve any "ORDER BY" that has been specified in the "FIlter & Sort" window
  • OS Support: Mac OS X On Mac OS X with Mac OS Look and Feel sometimes the right click menu is unresponsive in the Databases tree
  • SQL Commander A hang may occur if having two separate instances of DbVisualizer open at the same time and executing SQL in one of them
    See the discussion here
  • User Settings Importing user settings creates any bookmark and monitor folders in the PREFSDIR root directory rather than in PREFSDIR/Bookmarks and PREFSDIR/Monitors

Bugs Fixed

  • Database Profile: View Re-introduce the debugging feature of viewers i.e Ctrl+Click tab
    See the discussion here
  • Import Filename don't appear in grid window title when doing import to Grid
  • SQL Commander Massive resource usage (threads and memory) when running a large script
    See the discussion here
  • SQL History Entering an invalid value in the History Max Entries field results in an error on next start-up
    See the discussion here

Improvements

  • General Show full text of entries that don't fit in a list as tooltips
  • DB Support: Cache Add support for T-SQL style join WHERE clause operators ("=*" and "*=")
  • DB Support: Oracle Optimize query used to get Tablespace Files
    See the discussion here

Bugs Fixed

  • Check for Update Check for Update window is truncated
    See the discussion here
  • DB Support: SQL Server ClassCastException when generating DDL
  • DB Support: Sybase ASE ClassCastException when generating DDL
  • General Stop in the Data tab or SQL Commander does not stop long running statement
  • Grid Component Copying and pasting a CLOB value results in "CLOB, xxx Bytes" instead of the value
    See the discussion here
  • Double click below the data in a grid results in an error
  • Query Builder Group By is not set when loading a SELECT statement that use table name aliases
  • SQL Commander Current database connection, database and schema are cleared when loading new file into editor
    See the discussion here
  • Quick File Open may when invoked result in a NullPointerException
  • Recent Files menu is slow to show if any file is located on a network disk
    See the discussion here
  • The Log in SQL Commander keeps only the log entries for the last execution even if Auto Clear is disabled
    See the discussion here
  • SQL Editor Dragging an object from the databases tree into the SQL editor visually indicates the focus is in the editor but it isn't
    See the discussion here
  • SQL History Execution in SQL Commander gets slower and slower with increasing number of SQL history files
    See the discussion here
  • Tool Properties Daylight savings time adjustments may occur even when default timezone is set to UTC

New Features

  • Bookmarks Redesign the old bookmark management into new features for SQL History, Bookmark and Monitor scripts
  • Command Line Support (dbviscmd) Add command line support for executing SQLs
  • Connection Wizard Add a "database ping" feature which will test on TCP level whether there is a server responding on the specified host/port
  • Database Profile: Actions Add action dialogs for setting comments on columns and other database object types
  • DB Support: Oracle Add new "TNS" connection mode for Oracle. DbVisualizer will then show a list with all connections defined in tnsnames.ora
  • Export Add an Export Table feature
  • Allow BLOB/CLOB data to be exported and imported
  • Favorites Add new Favorites Editor and Favorites Toolbar feature for database objects and script files
  • General Require a minimum of Java 1.6
  • Grid Component Add a "Aggregation Data for Selection" feature with aggregate functions for Date, Time, String, Number, etc.
  • Import Allow BLOB/CLOB data to be exported and imported
  • Make it possible to create a new table while importing table data
    See the discussion here
  • Procedure Editor Add support for execution of functions/procedure
  • References Support export of graphs in SVG, PNG and PDF format
  • SQL Commander Add a "Quick File Open" feature to search and load Recent Files, Bookmarks, SQL History and Monitor files into the SQL editor (mimic IntelliJ Ctrl+N popup)
    See the discussion here
  • Add support for parameter markers representing OUT/INOUT parameters
  • Make it possible controlling statement DELIMITER via a client side command
    See the discussion here

Improvements

  • Bookmarks Add multi bookmark (script file) deletion
  • Add option to insert selected bookmark in the SQL Editor and not only replace everything in it
    See the discussion here
  • Check for Update Add "Proxy Settings" link in the Check for Update feature
  • Show optional "Comment" in Check for Update feature + minor fixes
  • Connection Properties The auto commit/rollback feature at disconnect need to be revised as it may block the GUI
  • Database Profile: Tree Add a "Copy Database URL" and a "Copy Object Path" action in the objects tree right click menu
  • DB Support: Other Remove support for PointBase and DaffodilDB
  • Export Allow Export Schema to export objects to separate files
    See the discussion here
  • Make it possible to export to new destination: SQL Commander->New Editor
    See the discussion here
  • Allow use of ${dbvis-object}$ (former ${table}$) variable in other fields than just the filename
  • Possible to use ${dbvis-date/dbvis-time/dbvis-timestamp}$ variables in filename for @export commands
  • General Add capability to open multiple main windows (File->New Window)
  • Upgrade to new icon collection
  • Disable client/server capability in the DbVisualizer GUI (via command line arguments)
  • Make command line argument "-up" deprecated and replace it with new "-prefsdir" argument
  • Remove the command line arguments for the DbVisualizer GUI used to control connection setup and execution control. These are now managed by the new command line interface
  • Grid Component Save column widths when dbvis.savedatacolumns=true
    See the discussion here
  • Use the "Execute" key binding to start filtering in the Data tab inline filter field and filtering window
  • Monitor Reload of a result set that was produced by a procedure call may give a warning that result set cannot be re-executed since it is part of a multi statement execution
    See the discussion here
  • Navigator Allow for multiple selections in the Table Navigator grid and equal number of target nodes will show in the diagram
  • Performance/Stability Various operations, such as Reload of a tab in the Object view, hangs the GUI if the database connection has dropped
  • References Add magnifying glass zoom
  • Do not show the member list for ENUM and SET column types, since it can be very long
  • Add capability to pan the references graph with the mouse instead of scrollbars only
  • Enhance the "Specified Tables" feature so that it is easier to choose what tables to show in the references graph
  • The data types presented for a table are sometimes too verbose
    See the discussion here
  • Scripts Should be possible to define default target editor when exporting or double-click a bookmark and history entry
    See the discussion here
  • SQL Commander If @ is used as the anonymous block begin delimiter, no client-side commands are recognized
  • Extend the Permission feature with controls for Commit/Rollback/Set Autocommit
  • Loading a file with File->Open Recent should not show file chooser but instead load file directly
  • Make it possible to run scripts of unlimited size with the @run command
  • SQL History Show "bytes" column in the History feature for each history file
  • Table Data Editor Activate Table Data Filter with same key binding as execute in SQL Commander (Ctrl+Enter, Cmd+Enter, etc).

Bugs Fixed

  • Table Data Editor Mac OS X: The first character is removed when editing in the grid and form data editors
  • SQL Commander Initiating SQL->Execute using key binding may execute in a non visible editor
  • General Dock icons for minimized windows are represented by a badly scaled image (these should not appear on OS X)
  • Performance/Stability UI locking up on database lock
  • Tool Properties TimeZone info in Connection tab status bar is empty on Windows 7

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