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

4.3.6 - Released 2006-01-08

Improvements
General
New End-User License Agreement
Bugs Fixed
General
Sometimes there were problems getting CLOB data
Data Editing
There was a precision loss when editing really large numbers in DbVisualizer Personal.
Note: The fix requires Java 1.5 and later
Import
Importing a file with a row that have less columns then in the first row gave error and the import stopped. Now these will be set to null and import continues
Informix
List of tables when connected to Informix was sometimes empty

4.3.5 - Released 2005-10-06

Improvements
Mimer SQL
Presentation of CLOB values did not work for null CLOBs
Empty CLOBs were not properly handled
Bugs Fixed
General
Selecting Copy in the Connection Message right click menu failed if database was not connected
Setting the dbvis.savedatacolumns property in the dbvis-custom.prefs file didn't always result in Data tab columns being saved properly
SQL Commander
Execute current sometimes executed the statement before the actual one
A ";" was accidently added last in editor buffer causing some database operations to fail
Text output always presented binary/blob data as "(binary data)" instead of the format specified in Tool Properties
Export using the @export command did not honor the CsvRowDelimiter setting
Chart
Was not possible to control Z order of series in Area charts. Now the order is defined by the same order series are enabled.
Grid
Copying binary grid cell data always copied by value instead of honoring the settings made in Tool Properties
The inline editor accidently removed any new line sequences (CR/LF).
In edit mode are these now indicated with \n (line) \r (carriage return) and \t (tab). To insert for example \n as a text sequence then escape it with an extra \ i.e \\n
Size of CLOBs were sometimes wrong
Sybase ASE
The sybase-ase profile (and facade) was not always loaded properly since some ASE servers returns different "database product names".
PostgreSQL
TIMESTAMP WITH TIME ZONE data appeared as (null) even if a value was there.
Informix
Viewing Procedure source failed for Informix 7.31

4.3.4 - Released 2005-09-07

Improvements
General
Conditional processing now supported in the database profiles
( Default ) indicator and row count presentation now colored in the database objects tree.
Oracle
Object View DBA->Statistics->Up Time replaced with Instance Info
Table Comments now displayed for "Tables" object
Informix
Now possible to filter on Views in the database objects tree
MySQL
mysql5 profile removed and replaced with the mysql profile
Triggers are now displayed for MySQL 5+
Bugs Fixed
General
Enabling Show only default database/schema and no matching databases/schemas were found then these objects were not visible in the tree. Now if no matches are found and databases/schemas exist all of them are visible in the tree.
If having a tree filter that filters all databases/schemas then the filter is invalidated and not processed
Copying a grid cells that were in a single row added a new line which it shouldn't
Bookmarks are now(...) being saved on Mac OS X
Oracle
The Constraint tab for a table now works for Oracle 8
The Object Types object now shows types for Oracle 8
The DDL tabs are now removed if using Oracle 8 or earlier
DB2
Setting the "currentSchema" driver property for DB2 now works
PostgreSQL
Schema will not appear in the database objects tree for for PostgreSQL versions older then 7.3
Informix
Filtering in the Database Objects tree did not work for Tables
Function, Data Type and Sequence objects will not be displayed in the objects tree if accessing a pre Infomix 9 version
Procedure source and Trigger source now displayed properly for pre version 9 versions

4.3.3 - Released 2005-08-19

Improvements
General
Form/Inline editors: NOT NULL Timestamp fields now accept a blank entry which will automatically insert the current timestamp. Entering partial timestamps will be overlayed (completed) with the current timestamp
Added Allow Auto Configured Database Connection Properties tool property. When checked it will automatically set things such as table name prefix/suffix, column name prefix/suffix based on what database it is
Layout changes in Tool Properties and Connection Properties
Installer for Mac OS X now in dmg format instead of sit
Oracle
Added support for Oracle types TIMESTAMP WITH LOCAL TIME ZONE and TIMESTAMP WITH TIME ZONE
Bugs Fixed
General
Bookmarks were not saved when exiting DbVisualizer on Mac OS X
Windows XP with Java 1.5: Using the tab key to move between fields in the form editor sometimes stopped working
DbVisualizer Free: exporting binary data was always By Value i.e Hex did not work
Oracle
NOT NULL BLOBs could not be inserted properly
MySQL 5
Multiple result sets produced by MySQL stored procedures are now presented properly

4.3.2 - Released 2005-07-23

Improvements
General
Layout changes in the Database Info and Data Type tabs
The Database Info tab was sometimes empty
Bugs Fixed
General
Binary/BLOB values were not exported in DbVisualizer Free
Oracle
Creating triggers containing a colon (:) resulted in an error and the trigger was not created
Creating stored procedures sometimes resulted in:
PLS-00103: Encountered the symbol "" when expecting one of the following:

4.3.1 - Released 2005-07-05

Bugs Fixed
Windows
An OutOfMemory error may occur on Windows as the default memory for Java was accidentally 65MB instead of 256MB
Oracle
Errors occurred when looking at the Sessions and Locks in the database objects tree and having "#" set as a single line comment identifier in Tool Properties
Problems editing BLOBS/CLOBS in Oracle resulted in:
Could not load OracleLobHandler: com.onseven.dbvis.wrapper.OracleLobHandler
java.lang.NoClassDefFoundError: com/onseven/dbvis/sql/LobHandler
DB2
current_schema errors were reported in the debug window for DB2 v7

4.3 - Released 2005-07-03

New Features
General
Tools->Table Data Import added
Tools->Connection Wizard added 
The Export feature changed to a Wizard
Export settings can now be saved between sessions
New section in the users guide: Plug-in Framework
Improvements
General
Improved performance at startup
Support for SOCKS (currently only with Java 1.4)
(Select the actual database connection and goto the connection properties tab. In the category tree choose "Driver Properties" and then add these to control the SOCKS connection: socksProxyHost, socksProxyPort)
The unsaved edits dialog that may be display when exiting DbVisualizer now also have the choice to "Cancel" the exit process
Errors that appear as a result of database requests are now more detailed
Set Quick Filter for Selection added to grid right click menu
JDBC SQLWarnings are now taken care of in the SQL Commander
Table Editors
Form Editor now accepts editing BLOB data types in a regular text editor
Images such as PNG, JPEG, GIF can now be zoomed in the Form Editor
A warning is now displayed in the form editor if importing a file that is bigger then the size of the actual column
A warning is now displayed in the form editor if performing an insert or update without no values being selected. (This previously resulted in an error being displayed).
Disabled so that "not null" fields are not automatically "checked" in the form and inline editors (or check if there is a default value for the column and if so do not check these columns)
Driver Manager
Added driver definitions and wizard support for Derby embedded and server
Driver Manager now automatically switch to either Dynamic or System tab depending on Default Class.
Driver Manager now automatically detects the JDBC/ODBC bridge
Tool Properties
Now possible to set font size for all of the UI (Fonts->Application Font Size in Tool Properties)
Decimal Number Format added to the Data Formats tool properties category.
Tool Properties->Copy settings changed from \t, \r, \r\n to textual representation
Unformatted - Strip Zero Fraction added to decimal number format list in Tool Properties
Database Objects Tree
Now accept a blank as NULL string representation
Added "Reload Objects Tree" to View menu
Removal of a database connection must now be confirmed
SQL Commander
New client side commands in the SQL Commander:
  • @window iconify
  • @window restore
  • @exit [nocheck]
@export on/@export set/@export off
  • These are used to redirect result sets from SQL commands to file(s) instead of being presented in the GUI
@set serveroutput on/off; now supported in the SQL Commander
  • This will cause Oracle DBMS_OUTPUT results to be displayed in the log
New command line arguments: -execute and -invisible. These can be used with the new @export command to launch DbVisualizer, perform one or several SQL selects, export their results and then quit DbVisualizer
Output from set showplan on now appear in the SQL Commander log
Having use xxx or use database xxx in a script did not have any effect if there was a database selected in the Database drop down i.e the following statements would operate in the Database selected by the drop down
Bugs Fixed
General
There were situations when establishing a connection failed and DbVisualizer just stayed at "Connecting. Wait..."
Fixed(?) problem with large papers and print preview for graphs
The direction of the arrows in the References Graph has been flipped
Fixed bug that sometimes caused a grid to be completely empty
Fixed NullPointerException when starting with no XML file
The splitter between the database objects tree and the SQL Commander either could not be moved at all or only allowed small changes
Table Editors
Numbers were not properly formatted in the inline editor when using a localle that did not handle "." as a decimal separator
Starting the inline editor did not select all the data in the cell being edited
Database Objects Tree
Fixed bug resulting in (default) not appearing for default schema in the tree if extra spaces were accidently added to userid in Connection tab
SQL Commander
Using the previous/next operations in the SQL Commander now preserve any changes made in the current editor before load the previous or next SQL statements from the history
"select * from table1 with nolock where <AC>" did not work properly when popping column names
DB2 UDB
nicknames are now displayed in DbVisualizer Personal
Executing select statements in the SQL Commander sometimes took very long time
DB2 z/OS
Filtering Views did not work in the Objects Tree
Decimal numbers was not properly handled
Oracle
Now possible to filter the names for Synonyms and Views in the database objects tree
PointBase
The (default) marker and management for "Show only default schema" now works
MySQL 5
Table and View objects did not appear in the tree
Change version
View all versions ->