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

  • DB Support: Oracle Add support for domain index type clause in DDL for Index

Bugs Fixed

  • Auto Completion Column names must never be qualified within a USING clause
  • Database Objects Tree A NullPointerException may appear when opening a new database object
    See the discussion here
  • Import Load custom import settings may result in an error if referenced CSV file doesn't exist
    See the discussion here
  • Query Builder When the Query Builder overwrites text in the SQL editor, the change cannot be undone
  • References Triple-click on a table in the references graph may result in an error
    See the discussion here
  • Table in References not highlighted when clicked in search result list and if already selected
    See the discussion here
  • A NullPointerException is thrown if a JDBC driver returns null for the KEY_SEQ column in a ResultSet for exported/imported keys
  • There is a regex error when finding table nodes in the references graph and the search string contain parenthesis
    See the discussion here
  • Zoom status bar information is not updated when zooming with mouse wheel
    See the discussion here
  • SQL Editor Highlight DATETIME as a keyword in the SQL Editor for SQL Server, Sybase ASE, Informix and MySQL
    See the discussion here
  • Setting background color for SQL editors doesn't affect the DDL viewer or Procedure Editor
    See the discussion here
  • SQL History Setting Max Entries to a negative number causes the GUI to freeze when executing a statement in the SQL Commander
  • Table Data Editor "Cannot launch run() while processing" message may occur during save

Improvements

  • Auto Completion Auto completion should support the USING keyword
  • General Allow the dbviscmd.sh and dbvisgui.sh scripts to use a preset DBVIS_HOME value
  • Grid Component Make it possible hiding a grid column by right-click its label
  • Performance/Stability Add a Shutdown DbVisualizer button to Memory Monitor dialog
    See the discussion here

Bugs Fixed

  • Compare Icons missing for the compare windows
    See the discussion here
  • Create/Alter Table Alter Table window don't get focus when displayed or react to ESC button
    See the discussion here
  • DB Support: DB2 LUW The TRUNCATE option is missing in the Empty Table action for DB2 LUW 10.x versions
  • DB Support: Informix Significant whitespace may be missing in the code retrieved by the Trigger Editor
  • DB Support: PostgreSQL Saving changes in the Data tab when the table has UUID columns results in an error
    See the discussion here
  • Saving changes in the Data tab when the table has INTERVAL columns results in an error
  • Data tab Loading and saving CLOB data from/to a file in the Cell Editor ignores the specified encoding
    See the discussion here
  • Database Profile: Actions Default values are not handled by type="grid" actions (ex. Create Index for Tables)
  • Export Exporting binary columns may fail when running @export in the SQL Commander if the table name is not qualified with the schema
  • General User settings may not be stored properly
    See the discussion here
  • The following error may appear randomly "WARNING: Could not open/create prefs root node Software\JavaSoft\Prefs ..."
    See the discussion here
  • Locale handling changed in Java 7 potentially showing data (numbers, date, time, etc.) in wrong format. Introduce backwards compatibility fix
    See the discussion here
  • Grid Component Invoking some actions in a grid doesn't grab focus
  • Installation/Update Installation Selecting an entry in the "Select Directory" dialog during install may scroll the list of directories
    See the discussion here
  • Query Builder Loading a SELECT statement with <tableName>.* or operations (e.g. col1 || col2) in the select list leads to an error
  • SQL Commander An exception may appear when creating a new SQL commander tab or when merging result sets
    See the discussion here
  • @run on an empty script file gives a "null" error
  • Tool Properties Some of the predefined patterns for Date and Timestamp data formats incorrectly use "mm" for month instead of "MM"

Improvements

  • DB Support: DB2 LUW Include index partition info in the Indexes tab for DB2 LUW 9.7 or later
    See the discussion here
  • DB Support: Oracle Add ELSIF as a keyword for highlighting in the editor
  • Database Objects Tree Show any border icon for each database connection in the Connections overview
  • Grid Component Introduce "Hide Column" in the grid column header right-click menu
  • Java Pre-support (unofficial) for Java 8 (preview versions) in DbVisualizer on Windows and Linux
  • SQL Commander Add "Select in Databases Tab" action in the SQL Commander tab right-click menu (will locate the current database connection)
  • SQL Editor The caret should not blink when typing or pressing control keys to move it
    See the discussion here

Bugs Fixed

  • DB Support: Oracle The error position information in the Trigger Editor is off; it should be interpreted as relative to the start of the PL/SQL block
  • The Session->Plan Data is empty if the child number for the SQL Statement > 0
  • Data tab Table filters (data tab) is not saved if database connection have the same name as one of the objects in the path for the table
  • Favorites Right-click a favorite bar item now work with Java 7
  • Grid Component Left-click a grid cell and then immediately right-click to show the menu will not only show the menu but also the cell viewer window
    See the discussion here
  • SQL Commander An error may occur if trying to save an auto-saved file that originates from an existing file
  • Comments with single quotes within an SQL Block may cause parsing errors when Strip Comments When Executing is disabled

Improvements

  • Auto Completion Auto Complete should not look for tables/columns when the caret is at word separated from the name by space
    See the discussion here
  • Ignore underscore when looking for matching table and column names
    See the discussion here
  • Connection Setup Add instructional message for how to resolve the "Malformed reply from SOCKS server" problem
    See the discussion here
  • DB Support: PostgreSQL Add support for functions with RETURNS TABLE
    See the discussion here
  • DB Support: SQL Server Include required DLLs in the path so that windows authentication works out of the box with the jTDS driver
  • Grid Component Make it possible always showing the Cell Editor when double-clicking a cell for editing that contains special character
    See the discussion here
  • Import Save the source file with the other settings at Save as Default
  • SQL Commander The menu choice for "New SQL Commander" should also be available in the SQL Commander top-level menu and not only in the File menu
    See the discussion here
  • The File->Open Recent menu should be extended to show saved SQL files in addition to loaded files
  • SQL Editor Improve horizontal caret placement when moving then caret up or down
    See the discussion here
  • Scripts F2 doesn't work to start editing selected name in Scripts and Favorites lists
    See the discussion here
  • Workspace Add "Modify Default Tab Labelling" in the tab right-click menu for Object View, SQL Commander and Result Set tabs

Bugs Fixed

  • Compare The cell background color for all cells disappear when a cell in a block of changed cells is selected
  • Connection Setup Driver properties are not retrieved for some drivers
  • DB Support: MySQL Scale and precision are not included in the DDL for a DECIMAL column if scale is 10 or precision is 0
  • DB Support: Oracle Qualify Object with Schema/Database must be enabled to qualify a Function/Procedure with package name when executing from the Package Body Editor
  • DB Support: SQLite Generating DDL gives a "column 23 out of bounds [1,22]" error
  • Data tab Creating a new row count monitor in the Data tab may show an error if there are folders in the Scripts feature
    See the discussion here
  • Import Settings->Load Default Settings on the first wizard page may result in an NullPointerException
  • SQL Commander The result set may be read-only if the table name is not qualified by a schema and no schema is specified via the Schema list
    See the discussion here
  • SQL Editor To Uppercase/Lowercase does not work with a rectangular selection when CRLF linefeeds are used
    See the discussion here

Improvements

  • Compare Allow column mapping between the two grids, so that tables with different column names can be compared
    See the discussion here
  • Make it possible to specify which columns are key columns and which columns to ignore
  • Data tab Show full filter (WHERE and ORDER BY) in tooltip for filter under mouse
    See the discussion here
  • SQL Editor Shift-Up and Shift-Down arrow keys should move caret and select to beginning/end when on first/last line
  • Scripts Assign the F2 keybinding for editing selected name in Scripts and Favorites lists
    See the discussion here

Bugs Fixed

  • DB Support: DB2 z/OS Changing auto commit or requesting commit or rollback in the SQL Commander may result in DB2 threads being occupied in DB2 server on z/OS
  • DB Support: Sybase ASE Showing object details for a Sybase Function results in an error
  • Database Profile: Actions The "Preparing xxx" dialog is displayed indefinitely and the action window is never displayed with Java 7 on Linux
    See the discussion here
  • General Creating a new folder in the file chooser using Synthetica L&F will not highlight or enable the newly created folder name in edit mode
    See the discussion here
  • SQL Commander Using file chooser to drill-down into a directory using keyboard is not possible (double-click is required)
  • The result set for a SELECT FOR UPDATE statement may be read-only in some cases
  • SQL Formatter The "lower" keyword is not formatted to uppercase when requested

Improvements

  • Compare Allow comparison of similar data types, e.g. Integer and BigDecimal
    See the discussion here
  • 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
    See the discussion here
  • 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)
  • Add "Inverse Selection" action in grid right-click menu
    See the discussion here
  • 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
    See the discussion here
  • SQL Editor Do not move the caret and scroll positions when doing Replace All
  • 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
    See the discussion here

Bugs Fixed

  • 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
    See the discussion here
  • SQL Commander Passing both -connection and -sqlfile arguments doesn't set the connection in the SQL Commander loaded with the file
    See the discussion here
  • Recognize WITH as a SELECT in the execution permission control

Improvements

  • Connection Setup Allow (null) to be specified as the value for Database Userid and Password
    See the discussion here
  • DB Support: Oracle Add enhancements for the Oracle Scheduler and Resource Manager
  • Add Session Wait and Session Event view for DBA Views->Sessions->Session
  • Add views for Oracle Direct NFS (dNFS) in DBA Views->Storage
  • DB Support: PostgreSQL Add support for refcursor OUT parameters and return values
  • Database Objects Tree Should be possible to configure in Tool Properties which of Open In Tab, Open in New Tab or Open in Floating Tab should run when double-click a database object
    See the discussion here
  • Database Profile: View Would be great if the tables list (and other lists) have the "Open in New Tab" and "Open in Floating Tab" right-click commands
    See the discussion here
  • Performance/Stability Add a "Don't show this again" checkbox to the "still not enough memory" dialog for the Memory Monitor window
    See the discussion here
  • SQL Commander File->Save (Ctrl+S) should be active even if no file is loaded and in that case show the "Save As" window
  • Should be possible to configure if the database object scripting feature should be launched or simply insert object name when dropping object in SQL editor
    See the discussion here
  • Workspace Remove "Do you want to close the tab or restore it in the main window" question when closing floating window

Bugs Fixed

  • DB Support: DB2 LUW The Data Type list for Create Table includes BOOLEAN and other types that cannot be used as a column data type
    See the discussion here
  • DB Support: SQL Server An exception may appear when displaying column information for a table
  • Database Profile: Actions Related list field(s) are not updated when changing the list selection of another field. Example: Oracle->Statistics->AWR->Run Report
  • Statements executed via Actions are not committed if auto-commit is not enabled for the connection
    See the discussion here
  • Import Schema is missing in INSERT statements for some databases (e.g. SQL Server) when importing to new table
  • Key Bindings Cmd-W doesn't close SQL History, Monitor and Driver Manager windows when using Mac OS X key map
    See the discussion here
  • SQL Commander The "Confirm Close of Unsaved Editors" tool property have no effect in some situations
    See the discussion here
  • Workspace UI may flicker and focus may move to another component while DbVisualizer is auto saving editors and layout
    See the discussion here
  • Using key binding to close floating tab, doesn't close the window but rather the active tab in the main window

Bugs Fixed

  • Connection Setup A NullPointerException is reported when connecting with my custom driver definition
  • Installation Add a Windows 64-bit zip installer

Improvements

  • DB Support: Mimer SQL Optimize SQL for getting metadata in v10 and later
  • Performance/Stability Closing tabs and stopping jobs in the Memory Monitor window does not always release memory
    See the discussion here
  • Query Builder Columns should be sorted in the table windows
  • SQL Commander Show warnings, if any, even when an exception is thrown
    See the discussion here
  • Tool Properties Make it configurable to set that active tabs are rendered with a bold title font
    See the discussion here
  • Workspace Add a "Open in Floating Tab" action for database objects
    See the discussion here
  • Floating windows should be possible to maximize, minimize and not always be in front of main window
    See the discussion here

Bugs Fixed

  • Connection Setup Pressing the explain properties button in the explain plan feature sometimes render the Explain Plan properties pane (in Connection Properties) twice (on top of each other)
  • The Connection Properties pane is not updated if changing for example Database Type or Driver in the Connections tab
  • Error message is incomplete if connect fail due to unexpected problem in the JDBC driver
  • Driver Properties is empty unless setting the Database URL in the Settings Format->Database URL
  • Create/Alter Table The Referenced Column cannot be selected
    See the discussion here
  • The Referenced Catalog and Schema defaults in the Create Table Foreign Key tab do not match the current Tables node
  • DB Support: Oracle Role names with special characters need to be quoted in the Clone User action
  • Database Objects Tree Not possible to dock floating Databases, Scripts or Favorites windows using standard close window button
    See the discussion here
  • Disabling object tree filtering does not remove the Filtered label for entries
  • Object tree filtering don't work properly with Sybase ASE, DB2 z/OS and DB2 LUW
  • Press Enter key while there is no selection in the Databases list generates an error
  • (Default) and Filtered labels in the databases objects tree are not colored properly if appearing for the same entry
  • Favorites Hide/display of the favorite and main tool bars have no effect on new windows created with File->New Window
    See the discussion here
  • General Problem starting DbVisualizer if using the Turkish locale
  • OS Support: Windows Open a .sql file on Windows starts DbVisualizer but doesn't load file
  • SQL Commander Execute Current with the caret on a line with a comment executes the wrong statement
    See the discussion here
  • Partial result sets are not shown when the query is stopped
  • SQL Editor Replace with parenthesis in "what" does not work
    See the discussion here
  • SQL Formatter DbVisualizer variables should be kept as-is instead of expanded to their full format
    See the discussion here
  • Scripts Saving bookmark script may not save database connection, schema and catalog
  • Table Data Editor Saving table data changes always save to default database in Informix
    See the discussion here

Improvements

  • Chart The point value popup (displayed when hovering a chart point) should appear even when not exactly over the point and remain active if moving cursor to another point
    See the discussion here
  • Connection Setup Add support for custom component borders
  • Remove the "Single Physical Connection" feature and tool property
  • Give focus to the Database Userid field when entering the Database Setup page in the wizard
  • Create/Alter Table Make the Create/Alter Table dialog non-modal
    See the discussion here
  • DB Support: Informix The database qualifier should be recognized in various features, e.g. for auto-completion when looking for matching tables and columns
    See the discussion here
  • DB Support: Oracle Choosing Connection Type = TNS for Oracle should show an instruction how TNS names are loaded if the list of names is empty
  • Bundle the Oracle JDBC driver with DbVisualizer
  • DB Support: PostgreSQL Add visual Explain Plan support for PostgreSQL version 9 and later
    See the discussion here
  • Data tab Auto completed column names in the table data filter should respect the "Case for Completed Names" and "Delimited Identifiers" in Tool Properties
    See the discussion here
  • Database Objects Tree Need to visually show that child nodes has been filtered in the objects tree
  • While browsing database objects and the connection is lost with the database, preserve the currently visible tab at re-connect
    See the discussion here
  • Don't use the SHIFT modifier in the objects tree zx
    See the discussion here
  • Add feature for multi deletion of Database Connections
    See the discussion here
  • Add a way to insert "Script Object to Editor" results at the caret position in the current editor
  • Double-click an object in the Databases tab should open the object and not expand any child objects
  • Allow for multiple "object view" tabs opened at the same time
    See the discussion here
  • Allow rename of object view tabs
    See the discussion here
  • Database Profile: Actions Support multiple action windows without locking the rest of the user interface (Ex: Create Table, Rename Table, Create Trigger, etc).
    See the discussion here
  • Copy in SQL Preview in Object Action window and Variable substitution window should copy selected text and not all of the text
    See the discussion here
  • Database Profile: View Add support to load a database object in a specific object view tab using drag from databases tab to the target object view tab
    See the discussion here
  • Add support to save and reset the layout of sub tabs for object view top-level tabs (bound to database type and object type)
  • Export Add support for export in "json" format
    See the discussion here
  • Favorites Support drag and drop of the favorites toolbar so that it can be positioned after the main toolbar buttons
  • Add "Select Target Object" in Favorites tab list right-click menu and in the favorites bar right-click menu for a favorite
  • avorites Show path of target object as tooltip
  • Favorites Add sort capability in the Favorites tab (right-click menu)
    See the discussion here
  • General Improve the database access strategy, e.g. to minimize or remove the need to ever lock the GUI, prevent freezes when a connection is down, etc.
  • Replace the multi row tab component with a single row tab solution (for object view, SQL commander, result set and monitor tabs)
    See the discussion here
  • eneral Change name of "DbVisualizer Personal" to "DbVisualizer Pro"
  • General Improve the management of the commit/rollback prompt window at disconnect
  • Grid Component Add support for comparing result sets
  • rid Component The grid column auto resizer may truncate data
    See the discussion here
  • mport Add a way to Save and Restore the import settings
  • Add control for disabling the use of delimited identifiers when importing to a new table
  • Make the Import Table Data dialog non-modal
  • Import The file filter in the import file chooser should default to .csv file extension
    See the discussion here
  • S Support: Mac OS X Add full screen support for Lion/Mountain Lion
  • erformance/Stability Get Table Row Count data in a background thread
  • Performance/Stability Better handling of high memory usage
  • Procedure Editor Add keyboard shortcut for hide/show errors
    See the discussion here
  • Execute a procedure/function within the context of the Procedure Editor instead of the current SQL Commander
    See the discussion here
  • References Add support to script CREATE, DROP, DELETE and INSERT statements for tables in the References graph
  • Keep "Specified Tables" enabled after reload in the References graph
  • SQL Commander Make it possible to disable preprocessing for scripts of any size
  • Make it possible to detach any result set in SQL Commander and Monitor in own window
  • Add support for compare of SQL Commander editors and editor with file
  • Auto-save SQL Commander editor buffer between sessions
    See the discussion here
  • Add a "Connect and Execute" button to the establish connection dialog
    See the discussion here
  • The database connection lists should support showing any color and/or border defined for the database connection
    See the discussion here
  • SQL Commander - unify the transaction management for non result set commands in the SQL editor and edits made in result sets for the same editor
  • Add support for loading multiple SQL files
  • Move the SQL Commander properties (right pane when visible) into Tool Properties
  • Support merging multiple result sets in a single text view
    See the discussion here
  • Add a "Save no SQL Commander editors" option when closing editors and quitting DbVisualizer
    See the discussion here
  • Opening a file that is already open in a SQL Commander should switch to that tab rather than opening a new
  • The vertical splitter in a newly created SQL Commander should have the same position as the previously active SQL Commander
    See the discussion here
  • Database Connection setting in a new SQL Commander tab should be set based on if the focus is in the databases tab, if not then the same settings as previously used editor should be applied
    See the discussion here
  • QL Commander Make stripping of comments configurable
    See the discussion here
  • QL Editor Support regular expressions in the SQL editor
    See the discussion here
  • SQL History Don't put focus in the Max Entries input field at first display
  • Scripts Sort scripts by organizing directories first and then regular files
    See the discussion here
  • Workspace Add support to show any tab in a separate window (float)
  • Drag a tab outside the window boundaries should float the tab in a separate window (same as Floating)
  • orkspace Add support for setting tab background color based on database connection
    See the discussion here
  • Add support for re-arranging tabs
    See the discussion here
  • Workspace A list of all unsaved editors at exit should show those that are unsaved and allow all/some to be saved at once instead of a query per editor.
  • Should be possible to set a custom label for the result set tabs
    See the discussion here
  • orkspace Verify main and sub tab locations
    See the discussion here
  • Workspace Should be possible to label SQL editor tabs regardless of any file being loaded
    See the discussion here
  • Double-click on Databases, Scripts and Favorites tabs should minimize these
  • Make it configurable whether the (gray) object view header should be visible in object view tabs
  • Remove the Alloy look and feel
  • Add support for preserving open SQL Commander (with content) and Object View tabs between DbVisualizer sessions
    See the discussion here
  • orkspace Introduce a close button in SQL Commander, Object View, Result Set and Monitor tabs
    See the discussion here
  • Workspace Allow using middle mouse button (alt+click) to close a tab
    See the discussion here
  • Maximize tab by double click tab header

Bugs Fixed

  • DB Support: SQL Server Source for a procedure is not available after rename with other tools
    See the discussion here
  • Database Objects Tree Add search by typing in the databases objects list and support for down/up keyboard buttons to move forward/backward
    See the discussion here
  • Explain Plan Fix explain plan for DB2 LUW version 10
  • Any variable values in the SQL are not passed with the SQL when Explain Plan
    See the discussion here
  • Favorites Renaming the database connection or changing its folder structure or folder names will break a database object favorite
    See the discussion here
  • General Commit/Rollback dialog freezes application upon network disruption
  • Grid Component The Grid Warnings popup should be closed on window move
    See the discussion here
  • Focus is lost from result set when using for example Ctrl+R (reload)
  • Query Builder Extremely slow to add or remove columns in complex/large query
  • SQL Commander Warning when using Execute Current with a line comment on the first line and caret on first line
    See the discussion here
  • Scripts Should be possible to assign key bindings to the Open and Execute right click commands in the scripts tree
  • Table Data Editor An error is displayed if applying table data filter while grid is being reloaded
    See the discussion here

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