DbVisualizer Changelog

New in version 9.1.12

November 27th, 2014
  • ENHANCEMENTS:
  • Create/Alter Table:
  • Removing the last column in a Primary Key should automatically remove the Primary Key
  • DB Support: SQL Server:
  • Add an Instance field in the Connection tab for SQL Server
  • SQL Commander:
  • Key binding to start Execution can not be set to any of the key bindings Java/Swing have assigned to for example the Max Rows textfield, etc.
  • BUG FIXES:
  • Auto Completion:
  • Activating Auto Completion can in some circumstances freeze the GUI
  • DB Support: Mimer SQL:
  • References graph may show duplicate table nodes
  • DB Support: MySQL:
  • An error may occur when generating DDL for a MySQL table, e.g. in Alter Table or the DDL tab
  • DB Support: Oracle:
  • Rename the Session Properties tab to accurately state that it shows database properties and add a new Session NLS Parameters tab
  • DB Support: Oracle:
  • Handle procedure DATE parameters as TIMESTAMP instead of TIME for Oracle 12
  • DB Support: PostgreSQL:
  • Two dimensional arrays no longer render correctly in result sets
  • DB Support: SQL Server:
  • SELECT ... INTO ... will limit number of copied rows by setMaxRows()
  • DB Support: Vertica:
  • The ON COMMIT PRESERVE ROWS clause is always included when creating a temporary table
  • Database Profile: Actions:
  • Using List input in an action should match default value independent of case
  • Database Profile: Actions:
  • A action element without tags around the message will break
  • Export:
  • Date/Time literals are not in the database-specific format unless Format is set to uppercase "SQL"
  • OS Support: Mac OS X:
  • F1-F10 cannot be used as part of a key binding on Mac with Java 7 using the FN key
  • SQL Commander:
  • An exception may be reported if doing a rollback and then reconnect
  • SQL Commander:
  • Possible NPE when highlight execute
  • SQL Editor:
  • Dropping a file in the SQL Editor should load that file using the same encoding as used in the editor

New in version 9.2.2329 Beta (November 26th, 2014)

  • Enhancement:
  • Compare: Allow comparison of two cells in the same grid
  • DB Support: Oracle: Add DDL support for GLOBAL TEMPORARY TABLE
  • DB Support: Oracle: Handle procedure DATE parameters as TIMESTAMP instead of TIME for Oracle 12
  • DB Support: PostgreSQL: Add support for editing HSTORE, JSON and JSONB values in the grid
  • Import: File row numbers in import preview panel
  • OS Support: Windows: Show splash screen when starting second DbVisualizer instance
  • SQL Commander: The Set Auto Commit command in the SQL menu should show on/off based on current mode to make it more intuitive
  • SQL Formatter: Option to format a SQL statement into a single line by removing newlines, tabs, etc.

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