Release notes

You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 23.2.5 version.
23.2 Quick links
What's new  -> Release notes  -> User guide HTML -> User guide PDF ->

6.5.12 - Released 2009-12-22

Bugs Fixed
DB Support: Informix
BOOLEAN columns are shown as BLOB in DDL
See the discussion here
Import
Setting "Commit Batch Size" for the Import Table Data feature doesn't work
See the discussion here
OS Support: Mac OS X
At startup a window display "You need to restart to see the new look and feel". This is due to changes in the Java 1.6.0_17 version
SQL Commander
Execute Current may in some cases execute the preceding statement instead on Windows platforms
See the discussion here

6.5.11 - Released 2009-12-05

Improvements
DB Support: SQL Server
Add key sort order for Primary Key in DDL
Export
Export objects selected in the Export Schema dialog in alphabetic order per object type
Bugs Fixed
DB Support: Oracle
Foreign Key constraints are duplicated in the DDL when the same FK target is used in another table in another schema
DB Support: PostgreSQL
The column order in a PK constraint in the generated DDL is incorrect for some tables
DB Support: SQL Server
Index order (DESC vs ASC) missing in the DDL
DB Support: Sybase ASE
Problem with database names having special characters in them (ex "-")
Export
All values are exported as 0 for a BIT column is a format other than "true/false" is selected
Grid Component
Script options (SELECT and DROP) are missing in the Tables grid popup
See the discussion here
SQL Commander
"invalid statement type: 0" error when executing a statement in an anonymous block
SQL Editor
Auto completion popup for column names not displayed if having "KEY JOIN" in the SQL
See the discussion here
SQL Formatter
Format Buffer incorrectly adds a partial statement at the end (only on the Windows platform)

6.5.10 - Released 2009-10-23

Improvements
OS Support: Windows
Support for Windows 7
Add installer for Windows x64
Bugs Fixed
DB Support: DB2 z/OS
Some DB object types are displayed for all schemas instead of the selected
DB Support: MySQL
An explicitly declared 0 default for a not-nullable int column is not preserved in the generated DDL
DB Support: Oracle
(null) appear as table space name in "Remove Datafile" action
Incorrect index column order in objects tree
DB Support: PostgreSQL
Incorrect FK declarations generated in DDL when multiple FKs to/from the same table has the same name
The Table and Column lists for the Referenced Table FK constraints in the Create/Alter Table dialog contains too many entries
Explain Plan
Explain plan feature for Oracle doesn't properly quote the schema and PLAN_TABLE names
General
Fix regression problem with connection being timed out
SQL Commander
Java 1.6: Focused component is not restored when jumping between the Object View and SQL Commander tabs
SQL Formatter
Comments after the last statement are removed when formatting
See the discussion here
Table Data Editor
An error occur in the form data editor and if selecting another object in the objects tree or disconnect/refresh

6.5.9 - Released 2009-08-29

Bugs Fixed
DB Support: PostgreSQL
The "Databases" object in the objects tree is empty

6.5.8 - Released 2009-08-27

Improvements
Database Profile
Add <InitCommands> section in Database Profile
DB Support: HP Neoview
Add object type actions such as Create Trigger, Rename Table, Create View, Create Materialized View, etc
Auto determine the value of the METACAT driver property for HP Neoview 2.4+ (user should not need to specify it)
Default Delimited Identifiers for HP Neoview should be (")
Enhance HP Neoview support so it handles ISO & UCS2 systems properly
Schema drop down list in SQL Commander isn't sorted
DB Support: PostgreSQL
Add support for the INHERITS clause in the DDL generator
See the discussion here
Add object actions for Create and Drop Schema for PostgreSQL 8
Bugs Fixed
Database Profile: Tree
Stopping a database search may not stop at once
DB Support: MySQL
An explicitly declared 0 default for a nullable int column is not preserved in the generated DDL
DB Support: Oracle
Fix the issue with "No <Command> sub element for ObjectActionType: oracle-schedulerjobs-create" being displayed in the debug window
See the discussion here
ORGANIZATION INDEX is not included in DDL
General
Some operations may hang the GUI if the database connection has been dropped or is unresponsive
Grid Component
(null) values are rendered with a gray background color which is fine but when using the quick filter sometimes this gray color appear in non null fields
See the discussion here
Procedure Editor
NullPointerException when saving if the editor is used as a separate window
See the discussion here
Format Buffer incorrectly formats the code as multiple statements

6.5.7 - Released 2009-06-19

Improvements
Database Profile: Actions
<Default> value must not match the list of values for the "list" style if the input field is editable
Add support for "hideif" attribute for <Action> and <Input> elements controlling whether action should be hidden for an object and whether an input field for an action should be hidden
DB Support: Oracle
Add more support for Oracle Scheduler
Bugs Fixed
Database Objects Tree
Must be possible to use the objects tree filter for compound object names such as schema.table
See the discussion here
Database Profile: Actions
Database and Schema lists in the SQL Commander are not updated when executing action that create/removes database/schema
DB Support: Informix
Problem with delimited identifiers in Informix
See the discussion here
The Grants tab for a table in Informix doesn't show correct information
DB Support: PostgreSQL
Auto completion popup lists index and constraints while it should only show tables and views
Browsing tables in PostgreSQL 8.4 gives an error
Export
Error using Export Schema when block delimiters are set to "@" due to conflict with command identifier character
OS Support: Mac OS X
Cannot launch DbVisualizer on Mac OS X with the Java 1.6.0_13 version
See the discussion here
References
References are not correct for Mimer SQL
SQL Commander
Applying Connection Properties changes the selected Database in the SQL Editor
Executing a "{ call <xxx> }" statement will fail for Oracle if there is a newline before the first "{"

6.5.6 - Released 2009-05-15

Bugs Fixed
Database Profile: Actions
Stopping a long running action may result in a NullPointerException
See the discussion here
DB Support: Oracle
Error when using Create Index dialog for a table that is not in the default schema
Export
Export in Excel with append mode results in the document being cleared if a result set has no data
Grid Editor
Pasting a value into a single cell in a sorted editable grid may result in a flickering of other cells
Start edit of a "(null)" value will mark it as edited and set the value to a space even if not really editing the value

6.5.5 - Released 2009-04-06

Improvements
Database Profile: Actions
Support execution of procedure in an action which generates DBMS_OUTPUT
Bugs Fixed
Database Profile: Tree
Can't "Show in Window" if the node in the objects tree have an overlay icon (representing new, error, warning state) on top of the normal object icon
Focus is lost when traversing the objects tree with the keyboard
See the discussion here
Database Profile: View
An error may appear when clicking in the "Database Info" grid
DB Support: Oracle
Source code lines for a routine may occasionally be reordered when read from the database
Trigger source is not viewable when logged in as SYS
DB Support: SQL Server
Viewing a the code for a function with no read access gives an exception rather than a detailed message
See the discussion here
DDL Generator
An empty column list is shown when the column list for a View is unavailable
Export
NullPointerException when format is not specified for @export
Import
java.io.IOException: Pushback buffer overflow if using "Nothing" as Quote Character in "Import Table Data"
StackOverflowError if importing a file that contain only a single row
Procedure Editor
Exception when the source for a stored procedure is not available
See the discussion here
SQL Commander
Execute Current with the cursor after the last statement in a script executes the complete script
See the discussion here
Pressing "Stop" in the SQL Commander clear any partially fetched result set while pre-6.5.3 versions did not
SQL Formatter
Invalid formatting when MySQL delimited identifiers contain special characters (e.g. "-") or keywords (e.g. "from")

6.5.4 - Released 2009-02-06

Improvements
DB Support: MySQL
Add a Table DDL tab that shows constraint names even when they are system generated
Collation should be shown in the Columns tab for a table
Import
The table data import feature should allow multi character column separators
See the discussion here
Bugs Fixed
Database Profile: Actions
Cannot type in text fields in some dialogs (ex. "create table", "rename table" and so on)
See the discussion here
Database Profile: View
The "Show in Window" window may appear behind the main window on Windows
See the discussion here
Window displayed by "Show in Window" command don't get focus
DB Support: MySQL
Collation is not shown in DDL for columns with non-default collation
DDL Generator
Single quotes in comments are not duplicated
Export
BigInteger numbers may appear as 0 in exported Excel file
Export in Excel format may result in an error if result set was not created by executing SQL
Should be possible to specify that embedded double quote in text data should be escaped (duplicated) and not just single quotes
See the discussion here
The ExcelIncludeSQLCommand="true" option with @export didn't have any effect
The exported XML document lacks a root element and may contain illegal characters
General
Bookmarks containing SQL with CDATA identifiers results in an error
Import
Import to grid may result in a NPE
The String type is suggested for a column with a mixture of integer and decimal number values
SQL Commander
The "go" string should only be recognized as a delimiter when it is on its own line
Manually selected catalog/schema may be reset to the default after execution of a script

6.5.3 - Released 2009-01-12

Improvements
Grid Component
Show column number in grid column header tooltip
Extend Calculation feature in grid right click menu with metrics for string lengths
Bugs Fixed
Grid Component
Selection mode in grid may erroneously be set to complete rows only
See the discussion here

6.5.2 - Released 2009-01-09

Improvements
SQL Formatter
Do not add blank lines around UNION, INTERSECT, etc., restoring the previous formatting behavior
Bugs Fixed
Connection Tab
Use of variables ($$...$$) in connection data may not properly revert to variable notation after exiting DbVisualizer while still connected with the database
Create/Alter Table
The size value cannot be reset
DB Support: DB2 z/OS
Listing triggers results in a database error
DB Support: Informix
Getting the DDL for a stored procedure fails with Informix 7
DB Support: PostgreSQL
Incorrect source shown in the Procedure Editor for procedures with the same name and number of arguments, differing only in parameter types
Procedure parameter list in Procedure Editor does not include parameter names when all parameters are IN parameters
Export
Erroneous ALTER TABLE ADD statements generated for system generated CHECK NOT NULL constraints for some databases
@export in XLS format may result in a 0 byte file
General
Maximize Window doesn't work correctly on a dual monitor setup
See the discussion here
Window sizes, positions and splitter positions fail to save between sessions if using dual monitors
Grid Component
"Copy Name" in the column header right click menu doesn't work
GUI is blocked (how long depends on amount of data in grid) and CPU peaks if modifying what grid columns should be visible while there is a quick filter active
Grid Editor
EditingNotStoppedException may occur if entering an invalid value and click outside the data editor grid
Error dialog may show if there is a DB error getting unique indices or primary keys when saving table data edits
See the discussion here
OS Support: Mac OS X
Application icon on Mac OS X is scrambled
Grid column header have white background on Mac OS X with the Aqua L&F
SQL Commander
A block end identifier (e.g. "/") should only be recognized as such when it is on its own line
The "go" string should only be recognized as a delimiter when it is on its own line
An NPE error may occur when using @export with a SELECT statement
The "Copy SQL" command in the variable substitution window results in the SQL being executed

6.5.1 - Released 2008-11-23

Improvements
Bookmarks
Add a size limit for History Bookmarks
Database Objects Tree
The window that appear when requesting "Show in Window" in the objects tree can not be maximized or iconified
See the discussion here
DB Support: MySQL
Use SHOW TABLES to populate the Tables and Views trees instead of SELECT on INFORMATION_SCHEMA for better performance
See the discussion here
SQL Commander
Disable SQL Preview in the Variable prompt dialog when there is not enough memory available to show it
Bugs Fixed
Database Search
A NullPointerException may occur at start
DB Support: Informix
Error when opening a Function node if the code was created with CREATE PROCEDURE
See the discussion here
Saving a Function/Procedure with explicitly declared IN, INOUT or OUT parameter directions in the Procedure Editor fails
DB Support: Mimer SQL
The View DDL content is incorrect for some Views in 9.3
DB Support: MySQL
National characters (e.g. umlaut o) in a procedure or function are corrupted by the source editor
UNSIGNED types are duplicated in the Data Type lists
DB Support: Neoview
A character set error may occur if displaying column information for a table
DB Support: PostgreSQL
Error when opening function in PostgreSQL 8.3
DB Support: SQL Server
The Triggers node for a Table node lists all triggers in the database rather than only those for the table
With "set quoted_identifier off" as a Connection Hook, selecting a Function/Procedure node results in an error
See the discussion here
DB Support: Sybase ASE
With "set quoted_identifier off" as a Connection Hook, selecting a Function/Procedure node results in an error
See the discussion here
Export
NullPointerException when a SELECT statement that is part of an @export fails
Installation
A trojan is erroneously reported by eTrust during installation
Procedure Editor
The Execute button gets disabled when all content is deleted
SQL Commander
Executing a SELECT in the SQL Commander may take long time if using INNER JOIN clauses
Using JDBC escape features, {d 'xxx'}, {fn 'xxx'}, {ts 'xxx'} and so on doesn't work in the SQL Commander
SQL Formatter
Indentation size hardcoded to 4 when indentation set to "Use Tab"
See the discussion here
Tool Properties
An error occur if setting "Whitespace(s) per tab" = 0 in Tool Properties->SQL Editor category
See the discussion here

6.5 - Released 2008-10-23

New Features
DB Support: DB2 for LUW
Add support for creating and editing triggers
Add support to edit and compile of procedures and functions
DB Support: Informix
Add support for creating and editing triggers
Add support to create, edit and compile procedures and functions
DB Support: JavaDB/Derby
Add support for creating and editing triggers
Add support to create, edit, compile and drop of procedures and functions
DB Support: Mimer SQL
Add support for creating and editing triggers
Add support to edit and compile procedures, functions and modules
DB Support: MySQL
Add support for creating and editing triggers
Add support to edit and compile procedures and functions
DB Support: Oracle
Add support for creating and editing triggers
DB Support: PostgreSQL
Add support for creating and editing triggers
Add support to edit and compile functions
DB Support: SQL Server
Add support for creating and editing triggers
Add support to create, edit and compile procedures and functions
DB Support: Sybase ASE
Add support for creating and editing triggers
Add support to create, edit and compile procedures
Export
Export DDL and data for all or selected objects in a schema/database. (This is available for Oracle, DB2 for LUW, Mimer SQL, PostgreSQL, Sybase ASE, SQL Server, MySQL, JavaDB/Derby and Informix)
General
Add "Check for update" feature to check if there's a new version available
See the discussion here
SQL Commander
Add support for executing SQL with IN parameter markers, ex: WHERE ID = ? AND NAME LIKE ?
Tool Properties
Add feature to export/import user settings (properties, database connections, bookmarks, ...)
See the discussion here
Improvements
Database Profile: Actions
Add support for an action to prompt/handle parameter markers (i.e a "processmarkers" attribute for the <Action> tag)
Database Profile: Tree
<SetVar> variables in the <ObjectsTreeDef> section should not appear in the GUI unless visible="true" is added as attribute
DB Support: Oracle
Add new views for the Oracle Scheduler
Add support for enabling and disabling Oracle trace
Update the database profile for Oracle with support for viewing Redo Logs, Objects per Datafile/Tablespace, new actions, etc.
DB Support: Other
Add Netezza database type
Export
Provide support for user-defined export setting defaults
See the discussion here
General
Make it possible to log to file instead of to the window
Move debug tool properties to debug window + add new debug window controls for save, copy, etc.
Upgrade all bundled JDBC drivers
Grid Component
"Select Row" in grid component should be "Select Row(s)"
See the discussion here
Add "Match Exactly" in the Quick Filter popup menu
See the discussion here
Import
Import should set data types of columns based on analyzing the data
Query Builder
Add an Execute Directly button in the Query Builder
See the discussion here
SQL Commander
Clicking the log icon should select the corresponding statement in the editor, not replace the editor content with the statement
See the discussion here
Setting the database/catalog or schema in the SQL Commander should be reflected in the corresponding GUI elements
See the discussion here
Add option to easily format the SQL "FROM <format>" and "TO <format>"
See the discussion here
Copy/script to SQL Commander should ask what editor is target
Re-design the variable dialog feature and allow for sorting, multi line editing, etc.
SQL preview in substitution dialog shoud appear below the entry area and update instantly
SQL Formatter
Add additional SQL formatting options
Add option to format the current statement (at the cursor)
SQL formatting enhancements
See the discussion here
Tool Properties
Make it possible to set a default file encoding via Tool Properties
Change version
View all versions ->