DbVisualizer Changelog

What's new in DbVisualizer 9.1.6

Jan 28, 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 DbVisualizer 9.1.5 (Dec 17, 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 DbVisualizer 9.1.4 (Dec 9, 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 DbVisualizer 9.1.3 (Nov 23, 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 DbVisualizer 9.1 (Sep 13, 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 DbVisualizer 9.0.4 (Feb 19, 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 DbVisualizer 9.0 (Dec 4, 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 DbVisualizer 8.0.2 (Aug 8, 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 DbVisualizer 8.0 (Jun 19, 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.

New in DbVisualizer 7.1.4 (Nov 24, 2010)

  • Improvement:
  • Change the variable delimiters in Connection setup details from $$...$$ to the same used in SQL Commander (default ${...}$)
  • Format the numbers in execution result counters in the progress information area
  • Connection Setup - Jumping between two database connections with the same URL may accidentally modify the second connections URL if editing the URL in the first connection
  • DB Support: DB2 LUW - Explain plan can only be performed with EXPLAIN_xxx tables being stored in the login schema even if using "set current sqlid = "" as connection hook
  • DB Support: Informix - The DBA keyword is missing in the source loaded into the source editor for procedures and functions
  • DB Support: JavaDB/Derby - Exporting indexes for a table fails with Derby 10.6
  • DB Support: Oracle - Explain Plan in Oracle present less information than in versions prior to 7.1
  • DB Support: SQL Server - Opening the Groups node with SQL Server 2008 or newer gives an error
  • DB Support: Sybase ASE - The DDL shown or exported for a large view declaration may have text segments out of order
  • DB Support: Sybase ASE - Procedure is shown twice in the Object Type list in the Object Filter section
  • DDL Generator - Precision and scale are not included in DDL type declaration for decimal data types when using the Generic profile
  • DDL Generator - The DROP INDEX syntax is incorrect for some databases
  • Export - DROP statements should not be generated for indexes, since they are dropped when the table is dropped
  • Export - When exporting a table with BIT data, the BIT values are quoted in the INSERT statement [http://www.dbvis.com/forum/thread.jspa?messageID=11501]
  • Export - The exportsettings.xml/exportschemasettings.xml files may be empty resulting in an XML error when exporting [http://www.dbvis.com/forum/thread.jspa?messageID=11702]
  • Key Bindings - Control+S may switch to Database Search if using the key binding to save an already saved SQL editor
  • References - Showing table references for a specific table results in an error if doing a Reload
  • SQL Commander - Preprocessing of a script larger than 5 MB fails
  • SQL Commander - Whitespace should be ignored after the block end delimiter
  • SQL Commander - The Elapsed Time counter is not running when parsing and executing large scripts without preprocessing
  • Workspace - Default file encoding is not considered when opening a SQL file in the OS environment (with for ex. Windows Explorer or OS X Finder)

New in DbVisualizer 7.1.3 (Sep 13, 2010)

  • Improvement:
  • DB Support: DB2 LUW
  • Add support for dropping columns in Alter Table for database version 9 or later
  • [http://www.dbvis.com/forum/thread.jspa?messageID=11522]
  • References
  • Reload in References graph should reload from the database rather than just layout the cached tables in the graph
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3263]
  • Bug:
  • DB Support: Sybase ASE
  • Calling sp_procxmode to preserve the mode in versions prior to 15 cause various problems, so do not try to preserve the mode in older versions
  • Import
  • NullPointerException may occur if selecting "Map by Column Name" or "Map File Data Type = Table Data Type"
  • References
  • Press "All Tables" or "Specified Tables" in the References graph after doing reload in the objects tree results in an error
  • SQL Commander
  • Copy in the SQL Commander log should only copy the selected text rather than all of the log

New in DbVisualizer 7.1.2 (Aug 22, 2010)

  • Improvement:
  • DB Support: Oracle
  • Improve the support for Program, Replication, ASM, AWR, Scheduler, Resource Groups, DataGuard and Streams object types
  • Procedure Editor
  • Show the same error message for a lost connection when selecting a procedure as is shown when selecting a table
  • Tool Properties
  • The Permission confirmation window should show number of SQLs that are affected for each permission level
  • Bug:
  • Connection Setup
  • Connection variables may be lost if DbVisualizer is abruptly exited
  • DB Support: DB2 LUW
  • The "Empty Table" action to truncate a table don't work if not using DB2 9.7 and later
  • [http://www.dbvis.com/forum/thread.jspa?messageID=11435]
  • DB Support: MySQL
  • Data type names are converted to uppercase in DDL, including the parameters for ENUM and SET types
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3225]
  • DB Support: PostgreSQL
  • The COMMENT statements in the DDL for a PostgreSQL table may reference incorrect columns if a column has been dropped
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3224]
  • DDL Generator
  • Incorrect table reference in FK constraint when the referenced table is in another catalog/schema than the referencing table
  • Explain Plan
  • Oracle/DB2 LUW: Changing schema with the Schema drop down and then run Execute Explain will not set the new schema in the database
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3215]
  • Export
  • DROP statements are not generated for code objects (procedures, functions, etc.) for some databases when Create DROP Statements is enabled
  • Export
  • Using multiple "@export set" commands in a script resets the Filename
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3226]
  • General
  • The "You need to re-connect..." error window may appear while exiting DbVisualizer
  • [http://www.dbvis.com/forum/thread.jspa?messageID=11446]
  • Navigator
  • Incorrect grid data shown when sorting the source table before navigating to the target table
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3222]
  • SQL Commander
  • When using Anonymous SQL Blocks in a script executed with the @run command, the end delimiter is included in the statement
  • SQL Commander
  • Clicking Stop may result in a stack trace in the Debug window
  • SQL Commander
  • Client-side command syntax errors displayed as generic exceptions with stack trace in log
  • SQL Editor
  • Must be possible to turn of the "save changes" confirmation when jumping in the history
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3227]

New in DbVisualizer 7.1.1 (Jun 29, 2010)

  • Check for Update - Check for Update shows that Free Upgrade is available when it is really not a free upgrade
  • Data tab - An error may appear when viewing the Data tab containing BLOB/Binary data

New in DbVisualizer 7.1 (Jun 22, 2010)

  • General:
  • Improved integration with Windows and Mac OS X enable opening SQL files in new DbVisualizer editors rather than opening new instances of DbVisualizer
  • Database Support:
  • Support for Informix 11.5
  • Support for IDENTITY columns and ENUM and SET in Create/Alter Table
  • Driver Management:
  • Automatic upgrade of bundled JDBC drivers when installing new DbVisualizer version
  • Grid:
  • New PDF viewer for Binary/BLOB data types
  • Configurable grid colors allows changing all colors that are used to highlight various states
  • Copy/Paste and Drag & Drop of Binary/BLOB data
  • Find Column feature which will scroll to the matched column name
  • Sorting improvements such as keep sorting when quick filtering, reload result set from database with current grid sorting as ORDER BY
  • SQL Commander:
  • New @run client side command for execution of script file (supports parameters as arguments)
  • New @beep client side command
  • Default display mode can now be set to any of Grid (default), Text or Chart