Try out DbVisualizer Pro for 21 days

Start the trial by running the latest version and then open the Evaluate Pro Edition under the Help menu.

Select version

Release Notes

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

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

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

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

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:

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

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

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings.

Close