DbVisualizer

DbVisualizer project is a comercial and cross-platform database software designed for all major relational databases.

DbVisualizer enables simultaneous connections to many different databases through JDBC drivers.

What is new in this release:

• 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

What is new in version 9.1.5:

• 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

What is new in version 9.1.4:

• 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

What is new in version 9.1.3:

• 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

What is new in version 9.1:

• 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.

What is new in version 9.0.4:

• 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

What is new in version 9.0:

• 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.

What is new in version 8.0.2:

• 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 ]

What is new in version 8.0:

• 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.

Requirements:

• Java 2 Standard Edition Runtime Environment