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

4.0.4 - Released 2004-01-20

Improvements
General
Now possible to specify the enclosing characters for table and columns names in Database Connection Properties and Tool Properties.
Bugs Fixed
General
java.lang.NoSuchMethodError when using "Browse Row in Form" operation.
Too many open cursors error when accessing Oracle databases.

4.0.3 - Released 2004-01-15

New Features
General
Users Guide now accessible in the Help main menu
Improvements
Database Objects
"Remove Database Connection" added in the database objects tree right click menu
"Show selected object in Frame" now also lists the database connection name, catalog and schema in the frame header
Database Connection objects are automatically expanded one level when the connection is established
Editing the name of a database connection or folder in the tree previously required that the enter key was pressed to finish editing
Setting of Max Rows and Max Columns in Data tab now saved between invocations without needing to press the enter key while in the fields
Tool Properties
Added "General" category which lists the location of the original preferences (XML) file and the backup copy
Added preview of the icon collections
Added format "dd-mmm-yyyy" to Date Formats list
Removed the SQL->Pre-Processing->New Line->Remove New Lines property since new line characters now are always removed from the SQL before execution
SQL Commander
File->Close Current SQL Editor operation is used to close the current editor. If only one editor is active then it will cause any file that is currently loaded to be closed
All settings that controls the SQL Log are now saved in the preferences file between invocations
Setting of Max Rows and Max Columns in now saved between invocations without needing to press the enter key while in the fields
Monitor
Auto Reload interval now adjusts automatically if the execution of all monitors is not ready within the auto reload interval
"Auto Reload" interval now saved between invocations
The Monitor tab icon now show an hourglass when monitors are executing in Auto Reload mode
New field "Label" in the Data setup for a chart. Use it to set an optional label for columns that are marked as Series
Form Editor
"Wrap Lines" setting added which when checked will wrap long text values
Bugs Fixed
General
Export to the SQL Commander destination sometimes caused DbVisualizer to freeze
Exporting only one row in a grid accidentally exported one extra blank row. (This happened also when doing Ctrl-C to copy the data)
"File->Export Selection" was sometimes disabled when it shouldn't
Copy or export of a non contiguous block resulted in error
Changing Font in Tool Properties did not set the new font in the Form or Inline editors
SQL Commander
Enabling the old property "Remove New Lines" removed the new lines not just in the SQL that is executed but also in the SQL that is fetched using the Output View->Copy SQL into Editor operation
Monitor
SQL statements containing client side comments can now be executed in the Monitor tab
Form Editor
Entering the text representation for null in a CLOB did not cause the value to be set to null
Inserting a file into a CLOB that was null failed (nothing happened)

4.0.2 - Released 2003-11-07

Improvements
DbVisualizer Personal: The red X icon used to close an SQL Editor tab now replaced with the Close operation in the tab's right click menu
DbVisualizer Personal: "Remove All SQL Editors" now in the File menu
Load of an SQL file now inserted into the current editor instead of a new editor being created
Name of loaded file now listed in the editor status bar
Bug Fixes
DbVisualizer Free: Loading an SQL file into the SQL Commander accidentally created a new editor
JdbcOdbc connections returned duplicates of the table types in the Database Objects tree
DbVisualizer Free: Controls for SQL Commander removed that are not valid in the DbVisualizer Free edition (they were inactive anyway).
Tab header removed from the SQL Commander if only one editor
Export of references graph with an active selection removed the selection both from the exported image and the graph view
Significant performance enhancements during for example connect and exit of DbVisualizer when using Java 1.4.1 on Mac OS X and Linux
Startup time enhancements when using any Java 1.4 version
DbVisualizer Personal: Inline editor silently ignored any errors that was caused by a column text value larger then its max size
DbVisualizer now have more RAM to play with. 128M instead of 64M in previous versions

4.0.1 - Released 2003-10-24

Bugs Fixed
DbVisualizer Personal: Serialized Java objects viewer were broken
A ClassCastException error occurred when closing stand alone frames in the Database Objects tree

4.0 - Released 2003-10-22

New Features
General
DbVisualizer 4.0 requires at least Java 1.4
New Icon Collection
Database Objects
Tool bar added to Database Objects tree
New sub tab "Properties" in the Connection tab for a Database Connection node. Used to specify connection specific values for some of the tool properties:
  • SQL Statements, Auto Commit, Transaction Isolation, etc.
  • "Extra Options" dialog moved into the "Driver Properties" tab
  • Now possible to show only default database and/or schema
Now possible to filter what objects to see in the tree based on their names. Up to 5 patterns can be set per Database Connection. These are saved between invocations
"Connect All" operation now only connects enabled database connections (with the "Connect when Connect All" property enabled)
New root node, "Connections", selecting it will show an overview of all Database Connections and various state information
Now possible to folder connections in an unlimited number of levels. Useful to group connections
The tree can now be organized using Drag and Drop
Replaced the following operations in the Database menu:
  • Remove Database Connection with Cut
  • Duplicate Database Connection with Cut/Paste
Alias for a Database Connection can now be edited in the tree by selecting the node and then single click on its name
Reload Tree operation can now be performed on any node in the tree.
"Reconnect" operation added to:
  • The Database Objects menu
  • Database menu in the menu bar
  • "Connect" button in Connection tab will switch to "Reconnect" once a connection is established
Support to create Tables and Indexes
Table Data Editing
Added support for management of BLOBs and CLOBs.
Added BLOB content viewers in the Form Editor for
  • GIF, JPG, PNG
  • Serialized Java Objects
  • Hex Viewer
SQL Commander
"Pin New Results Sets" choice added to the Output View menu
Now possible to edit the result sets in the SQL Commander if the result set
  • is a result set as returned from a SELECT command
  • is fetched from only one table
  • is composed of columns that exist in the table
Primary Keys are now indicated in the result set panes
Support for the @ include control directive
  • Path is relative to the directory from which DbVisualizer is launched
  • If a file is loaded into the editor then is the path for any @ included files relative to the path for the loaded file
  • The new @cd command can be used to set the location for any succeeding @ include directives
New right click menu choices in Clear, Find, Find/Replace and Goto.
SQL Commander now supports multiple editors organized as tabs or internal windows.
Unsaved edits in a script file loaded from file is now asked whether to save or not save at exit of DbVis.
Support to execute anonymous SQL blocks
SQL Commander now supports multiple results from a single SQL statement. (Ex: sp_who, sp_help in Sybase and SQL Server)
Export
New output Formats in XML and SQL INSERT statements
Output Columns can now be customized:
  • Select which columns to output
  • Select data format
  • Edit column name
Test Data Generator can be used to generate random test data:
  • Generate random number
  • Generate random string of random size
  • Generate random value from a list of values
  • Generate sequential number
Now possible to specify how text data shall be quoted (No Quotes, Single Quotes or Double Quotes)
Zoomed references graphs are now exported properly
File extensions now determined based on export format
Tool Properties
Saved passwords are now encrypted
New property: "Confirm Disconnect All". Specifies whether a confirmation dialog shall appear when "Disconnect All" operation is requested.
New property: "Pending Transactions at Disconnect". Specifies what to do with any pending transactions at disconnect.
Changed property: "Connect at Startup" to "Run Connect All at Startup"
Font can now be defined for SQL editors and all grids
Configurable short cuts for the SQL Commander editor
References Graph
The layout can now be saved using the Save and Load operations
Bugs Fixed
Support for IBM JVM
Some components had wrong dimension on Mac OS X
added tool icon for Mac OS X
Bug fix when using Mac OS X and Java 1.4. A dialog was always displayed at startup saying that L&F has changed and re-start is recommended
"Data Type" column info in the Form Editor now show SQL type rather the internal DbVisualizer Java type
SQL Commander editor is now focused when it gets an SQL statement from some other location in the application
Change version
View all versions ->