Release Notes 4.0

You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 24.1.4 version.

4.0.4 - Released 2004-01-20

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

4.0.3 - Released 2004-01-15

New Features
Area Details
General Users Guide now accessible in the Help main menu
Improvements
Area Details
Database Objects "Remove Database Connection" added in the database objects tree right click menu
Database Objects "Show selected object in Frame" now also lists the database connection name, catalog and schema in the frame header
Database Objects Database Connection objects are automatically expanded one level when the connection is established
Database Objects Editing the name of a database connection or folder in the tree previously required that the enter key was pressed to finish editing
Database Objects 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
Tool Properties Added preview of the icon collections
Tool Properties Added format "dd-mmm-yyyy" to Date Formats list
Tool Properties 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
SQL Commander All settings that controls the SQL Log are now saved in the preferences file between invocations
SQL Commander 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
Monitor "Auto Reload" interval now saved between invocations
Monitor The Monitor tab icon now show an hourglass when monitors are executing in Auto Reload mode
Monitor 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
Area Details
General Export to the SQL Commander destination sometimes caused DbVisualizer to freeze
General Exporting only one row in a grid accidentally exported one extra blank row. (This happened also when doing Ctrl-C to copy the data)
General "File->Export Selection" was sometimes disabled when it shouldn't
General Copy or export of a non contiguous block resulted in error
General 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
Form Editor Inserting a file into a CLOB that was null failed (nothing happened)

4.0.2 - Released 2003-11-07

Improvements
Area Details
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

4.0.1 - Released 2003-10-24

Bugs Fixed
Area Details
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
Area Details
General DbVisualizer 4.0 requires at least Java 1.4
General New Icon Collection
Database Objects Tool bar added to Database Objects tree
Database Objects 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
Database Objects 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
Database Objects "Connect All" operation now only connects enabled database connections (with the "Connect when Connect All" property enabled)
Database Objects New root node, "Connections", selecting it will show an overview of all Database Connections and various state information
Database Objects Now possible to folder connections in an unlimited number of levels. Useful to group connections
Database Objects The tree can now be organized using Drag and Drop
Database Objects Replaced the following operations in the Database menu:
  • Remove Database Connection with Cut
  • Duplicate Database Connection with Cut/Paste
Database Objects Alias for a Database Connection can now be edited in the tree by selecting the node and then single click on its name
Database Objects Reload Tree operation can now be performed on any node in the tree.
Database Objects "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
Database Objects Support to create Tables and Indexes
Table Data Editing Added support for management of BLOBs and CLOBs.
Table Data Editing 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
SQL Commander 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
SQL Commander Primary Keys are now indicated in the result set panes
SQL Commander 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
SQL Commander New right click menu choices in Clear, Find, Find/Replace and Goto.
SQL Commander SQL Commander now supports multiple editors organized as tabs or internal windows.
SQL Commander Unsaved edits in a script file loaded from file is now asked whether to save or not save at exit of DbVis.
SQL Commander Support to execute anonymous SQL blocks
SQL Commander 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
Export Output Columns can now be customized:
  • Select which columns to output
  • Select data format
  • Edit column name
Export 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
Export Now possible to specify how text data shall be quoted (No Quotes, Single Quotes or Double Quotes)
Export Zoomed references graphs are now exported properly
Export File extensions now determined based on export format
Tool Properties Saved passwords are now encrypted
Tool Properties New property: "Confirm Disconnect All". Specifies whether a confirmation dialog shall appear when "Disconnect All" operation is requested.
Tool Properties New property: "Pending Transactions at Disconnect". Specifies what to do with any pending transactions at disconnect.
Tool Properties Changed property: "Connect at Startup" to "Run Connect All at Startup"
Tool Properties Font can now be defined for SQL editors and all grids
Tool Properties Configurable short cuts for the SQL Commander editor
References Graph The layout can now be saved using the Save and Load operations
Bugs Fixed
Area Details
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

[old] Change Version
View all versions ->
Cookie policy

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. Please find our cookie policy here ↗