DbVisualizer Changelog

New in version 9.2.2328 Beta

November 12th, 2014
  • Bug:
  • SQL Commander - ${...}$ variables without type information are erroneously when executed treated as parameter markers rather than literals
  • Scripts - Rendering of Favorites and Scripts lists are broken

New in version 9.1.11 (October 14th, 2014)

  • Bug:
  • Auto Completion - Auto Completion of column names does not work after linefeed
  • Chart - The value for a point in the chart tool tip is always rounded to one decimal
  • Compare - NullPointerException when closing the Compare window with a cell selected
  • Connection Setup - SSH tunneling does not work with long DNS target server names
  • [http://www.dbvis.com/forum/thread.jspa?threadID=3938]
  • Connection Setup - Disconnecting progress window is displayed even after connection(s) closed
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4975]
  • DB Support: DB2 LUW - Error running explain with DB2 LUW 10.5
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4971]
  • DB Support: Vertica - Move Table to Schema may display an error
  • Database Objects Tree - Vertical scrollbar in the action window appears only after a resize
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18248]
  • Database Profile: Actions - Should be possible to specify other schema for new trigger than the table schema
  • Database Profile: Actions - Exception is raised if there is not static text specified in the element for an action
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18320]
  • Database Profile: Actions - Actions with many fields may take time to open and respond slow when editing
  • [http://www.dbvis.com/forum/thread.jspa?messageID=18280]
  • General - Error when getting columns information using the HIT JDBC driver
  • Grid Component - Unsortable grids should not have sorting entries in header popup menu
  • OS Support: Linux - Double-click on the same file twice in the file chooser results in an exception
  • SQL Commander - Merge result sets doesn't work having Remove Original Result Sets checked
  • SQL Commander - Failing to save a file due to file system exceptions such as permissions still remove the modified indicator for that file
  • SQL Commander - For PostgreSQL, Vertica and H2: Are prompted to commit/rollback transaction(s) even if running only SELECTs
  • Workspace - Exception: AIOOBE when clicking tab

New in version 9.1.10 (August 9th, 2014)

  • ENHANCEMENT:
  • DB Support: Vertica: Add support for Vertica in DbVisualizer Pro
  • SQL Editor: Make it possible to set the caret color in the SQL editor
  • BUG:
  • DB Support: MySQL: YEAR(4) values are not being displayed correctly and cannot be edited in the grid
  • DB Support: NuoDB: The column names in the Index DDL are incorrect
  • DB Support: PostgreSQL: Running a erroneous query in auto-commit off mode will result in a result set never being editable due to the 25P02 error in PostgreSQL
  • Database Objects Tree: Windows: Opening a floating window using key bindings may display the new window behind the main window
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4303 ]
  • Export: Exporting in XmlDataSet and FlatXmlDataSet format adds the unnecessary DbVisualizer-Export tag
  • Import: Preserve import window size and position during session
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4923 ]
  • SQL Commander: Execution error may lead to rare NullPointerException situations
  • SQL Editor: The spacing between characters is incorrect when using a some fonts, like 14 points Menlo Plain, on a Mac with Retina display
  • SQL Editor: The Find/Replace dialog does not use the selected text for "Find what" the first time it is displayed

New in version 9.1.9 (June 11th, 2014)

  • Enhancement:
  • Grid Component - Tool tip for long filenames in Scripts and Favorites tabs
  • Performance/Stability - Enhance detection of high memory usage
  • Performance/Stability - Provide more meaningful info about memory usage by ignoring memory for short-lived objects
  • Bug:
  • Compare - Memory may not be released when closing the Compare window
  • Compare - Compare Grids dialog is not closed when one of the compared result set grids is closed
  • DB Support: DB2 z/OS - Indexes listing doesn't show correct information
  • DB Support: NuoDB - The Types node does not show any content and cause an error when clicked
  • DB Support: Oracle - TNS connections fails when used with the command line interface
  • DB Support: Oracle - For very large views, the DDL may be incomplete
  • DB Support: SQL Server - List Stored Procedures and Functions ordered by schema and then name
  • DB Support: SQL Server - Expanding the Sequences node gives an exception if the MS JDBC driver is used
  • Database Objects Tree - JDBC drivers returning null for getCatalog() fail in later steps
  • Import - Import into new table with a DECIMAL column should suggest size,scale for the DECIMAL data type
  • Performance/Stability - Memory is not always released when closing result set tabs from the High Memory Usage dialog
  • SQL Commander - With a driver that throws UnsupportedOperationException for cancel(), queries cannot be stopped
  • SQL Commander - Error when executing @run command with "Log to GUI"
  • SQL Formatter - NATURAL JOIN is not formatted correctly
  • SQL Formatter - Formatting a Mimer statement call gives an error
  • Tool Properties - The Application (Rest of UI) font size setting have no effect when using one of the Synthetica L&Fs

New in version 9.1.8 (April 16th, 2014)

  • Enhancement:
  • Command Line Support (dbviscmd): Make it possible to execute a large script specified by -sqlfile
  • DB Support: NuoDB: Add support for NuoDB domains and sequences
  • DB Support: Sybase ASE: Add support for CLUSTERED keyword in CREATE INDEX DDL
  • Database Search: Add button to select target database objects in the Databases tab from the Database Search result list
  • Key Bindings: Add Alt-Backspace as binding for Delete to Word Start and Cmd-Backspace as binding for Delete Preceding Characters in Line for Mac OS X. Also add Meta+Shift+A for Select None in SQL editors for all platforms
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4826 ]
  • Query Builder: Automatically set a table alias if a table is added multiple times
  • Bug:
  • Chart: Bar/Stacked Bar charts doesn't display
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17810 ]
  • Create/Alter Table: Regression in copy/paste of column details (paste does nothing)
  • DB Support: DB2 LUW: The "Empty Table" action to truncate a table doesn't work with DB2 10 and later
  • DB Support: DB2 LUW: DDL generation fails for a View if there is no whitespace between the AS keyword and the left parenthesis
  • DB Support: Informix: Synonyms cannot be dropped in Query Builder
  • DB Support: Oracle: Column order is not preserved in DDL for UNIQUE constraints
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4811 ]
  • DB Support: SQL Server: DATETIME2, UNIQUEIDENTIFIER, GEOGRAPHY and GEOMETRY types are not handled correctly in DDL and Alter Table
  • DB Support: SQL Server: Add support for synonyms
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4774 ]
  • DB Support: Sybase ASE: Columns tab for System Table shows columns for all tables in the schema
  • DB Support: Vertica: Vertica: Loosing DB connection while working in the SQL Commander doesn't prompt for reconnect at next execute
  • Database Search: Database Search list should show object paths of found objects by default
  • Export: Exporting to XLSX with appendFile="clear/true" may result in errors on Mac OS X
  • Grid Component: Incorrect handling of database when saving grid updates for a query with a fully qualified table for Informix, Sybase ASE and SQL Server
  • Monitor: Settings in a monitor may be cleared or lost from the Monitors window
  • Monitor: An IllegalStateException may be reported while reloading monitors
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17796 ]
  • Monitor: Series and category drop-down menus may not reflect the columns in the underlying result set
  • [http://www.dbvis.com/forum/thread.jspa?messageID=17804 ]
  • Performance/Stability: Clicking Create Heap Dump in the High Memory Usage dialog when one exists causes an error
  • SQL Commander: Script files executed with the @run command should be closed directly at the end of execution
  • SQL Commander: File->Revert to Saved and Compare with Saved should always be available when file is loaded
  • [http://www.dbvis.com/forum/thread.jspa?threadID=4866 ]

New in version 9.1.7 (March 8th, 2014)

  • Bug:
  • Connection Setup: Connecting to OpenEdge with Server Info checked in Connection tab results in an error
  • Create/Alter Table: Incorrect handling of data types with more than one parenthesis pair, e.g. INTERVAL DAY(2) TO SECOND(9)
  • DB Support: H2: Filtering schemas in H2 doesn't work
  • Favorites: Hovering a database object in the favorite bar or favorites editor that has been removed may result in an exception
  • Grid Component: Exception when launching the Form Editor by double-clicking in the margin for an empty grid
  • SQL Editor: Replace All may cause an error if the Find What string contains a hashmark
  • SQL Editor: Quick Find does not honor blanks for the first match
  • 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
  • Tool Properties: DbVisualizer on Linux won't start if overridden Java Properties have no trailing newline
  • Tool Properties: User Java VM Properties cannot be edited using Java 7 on OS X
  • Workspace: Exception may occur when floating a tab

New in version 9.1.6 (January 27th, 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 version 9.1.5 (December 16th, 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 version 9.1.4 (December 7th, 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)
  • Tool Properties - Don't insert "save at" timestamp in the settings XML files
  • 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
  • Table Data Editor - Saving table data may give an error if saving to a table in non default schema
  • Table Data Editor - Pressing tab or enter key in a cell that contain newline or tab characters should not start the inline editor