Release NotesRelease Notes

Version Date
7.1.2 2010-08-18
7.1.1 2010-06-23
7.1 2010-06-16 W
7.0.8 2010-06-16
7.0.7 2010-05-25
7.0.6 2010-04-21
7.0.5 2010-03-16
7.0.4 2010-02-24
7.0.3 2010-02-23
7.0.2 2010-02-03
7.0.1 2010-01-29
7.0 2010-01-15 W P
6.5.12 2009-12-22
6.5.11 2009-12-05
6.5.10 2009-10-23
6.5.9 2009-08-29
6.5.8 2009-08-27
6.5.7 2009-06-19
6.5.6 2009-05-15
6.5.5 2009-04-06
6.5.4 2009-02-06
6.5.3 2009-01-12
6.5.2 2009-01-09
6.5.1 2008-11-23
6.5 2008-10-23 W P
6.0.15 2008-10-20
6.0.14 2008-09-22
6.0.13 2008-08-19
6.0.12 2008-06-26
6.0.11 2008-05-28
6.0.10 2008-04-10
6.0.9 2008-03-17
6.0.8 2008-02-24
6.0.7 2007-12-06
6.0.6 2007-10-15
6.0.5 2007-10-08
6.0.4 2007-09-25
6.0.3 2007-09-17
6.0.2 2007-07-25
6.0.1 2007-07-16
6.0 2007-07-09 W P
5.1.1 2006-10-16
5.1 2006-10-05 W P
5.0 2006-04-03 W P
4.3.6 2006-01-08
4.3.5 2005-10-06
4.3.4 2005-09-07
4.3.3 2005-08-19
4.3.2 2005-07-23
4.3.1 2005-07-05
4.3 2005-07-03 W P
4.2.2 2005-02-19
4.2.1 2005-02-11
4.2 2005-01-12 W P
4.1.1 2004-06-16
4.1 2004-04-06 W P
4.0.4 2004-01-20
4.0.3 2004-01-15
4.0.2 2003-11-07
4.0.1 2003-10-24
4.0 2003-10-22 W
3.3.1 2003-07-05
3.3 2003-06-07 W
3.2 2003-02-12 W
3.1.1 2002-12-09
3.1 2002-10-20 W
3.0 2002-07-01 W
2.1 2001-10-30
2.0.1 2001-05-18
2.0 2001-04-20
1.2.1 2000-12-23
1.2 2000-11-11
1.1 2000-06-05
1.0 1999-12-06

DbVisualizer 4.2 - Change Log

[ Change Log | What's New | Press Release ]


General MAJOR
 Redesign of the main window. Database Objects Tree now always visible. (Monitor tab has been moved).
MAJOR
 Java 1.5 now supported
MINOR
 License key file for DbVisualizer Personal now installed using Help->License menu.
MINOR
 The user preferences file, dbvis.xml, was located in the HOME directory in previous versions. From 4.2 it is located in HOME/.dbvis/config/dbvis.xml. (The file is automatically moved to the new location when DbVisualizer 4.2 is started).
MINOR
 The Kunststoff Look and Feel has been removed. (Vendor have stopped supporting it).
MINOR
 The position of vertical and horizontal splitters are automatically reset at start of DbVisualizer if these are in their minimum or maximum positions.
MINOR
 Added "Show/Hide Objects Tree" to Window menu
Added "Show/Hide SQL Editor" to Window menu
Added "Show/Hide Output View" to Window menu
BUG
 The infamous JdbcOdbc error -> "Connection not open" finally solved
BUG
 Focused component now preserved when switching beteen Database Object and SQL Commander tabs.
BUG
 Fixed the problem that locks DbVisualizer and shows the following error:
   java.lang.NullPointerException
      at com.onseven.dbvis.sql.ColumnInfo.getJavaDataTypeClass(Unknown Source)
      at com.onseven.dbvis.sql.JDBCModel.getColumnClass(Unknown Source)
      at javax.swing.JTable.getColumnClass(Unknown Source)
BUG
 Mac OS X specific initializations were not executed if starting DbVisualizer for the first time or with an empty XML file. One obvious effect was that the Mac Look and Feel was not used
Grids MAJOR
 All grid viewer columns (ex. Columns, Primary Key, Tables, etc) can now be configured grouped per type of viewer and database. These changes are saved between invocations of DbVisualizer:
  • Visible state
  • Order of each column in grid
In addition, doing a Reload will keep the following:
  • Column widths (if width size has been changing by dragging header)
  • Sorting
  • Selection
MAJOR
 "Quick Filter" added to right click menu. Use it to limit the number of rows in the grid by showing only the rows containing the specified text. (Matching cells are bold).
MINOR
 When dragging a column in any grid, if getting to the edge of the grid then the grid is automatically scrolled
MINOR
 Added "Select Column" to grid column header right click menu
MINOR
 Added "Select Row" to grid right click menu
MINOR
 Added "Sort Column Ascending" and "Sort Column Descending" to grid column header right click menu
MINOR
 Doing a "Reload" in the Data tab or in the SQL Commander now preserves the current column sorting, current selection and scroll position
MINOR
 Now keeps current selection if removing a column
MINOR
 Added "Calculate Selection" to grid right click menu. It will perform various calculations on the selected values. This is primarly useful for numeric values
MINOR UDT values (Types.STRUCT) are now displayed properly in grids
MINOR "Copy Selection (With Column Headers)" added to all right click menu in all grids.
MINOR Default behavior for "Copy Selection" (Ctrl-C) changed as it now do not copy column headers
MINOR Sort indicator is now preserved if moving or resizing a column. (It disappeared in previous versions leaving any column sorted ).
Chart MINOR Re-arranged the Chart pane. Moved the control buttons to the chart toolbar
Table Creator Assistant
 BUG
 The Data types in the Table Creator Assistant were incomplete for PostgreSQL
Driver Manager MINOR
 All driver info links now points to web page at http://www.dbvis.com instead of each vendors web
SQL Commander MAJOR
 Auto Completion support in the SQL Editor. Use it to complete table and column names for SELECT, INSERT, UPDATE and DELETE SQL commands. Default key binding is Ctrl-Space.
MAJOR
 "Execute Current" added to Database menu and toolbar. Used to execute the statement at the cursor position. Shortcut is Ctrl-. (Ctrl-Period)
MINOR
 Progress text in SQL commander now stretch as wide as the progress bar. Progress pane now also report success and error counts
MINOR
 New right click menu in the Log with "Copy" and "Save" operations.
MINOR
 SQL Preview dialog in DbVisualizer Personal now always displays the SQL and not some obscure internal format
BUG
 The Log text is now selectable (again) and can be copied to clipboard using right click menu or Ctrl-C key binding
BUG
 Choosing "Text" output view without being connected resulted in an error
BUG
 The use of "@cd path" that was not followed by a "@file" statement resulted in that the "@cd path" command was sent to the actual database and with a SQL error as result
BUG
 Changing Max Rows/Max Chars in SQL Commander did not affect any existing results when later doing a reload.
BUG
 Vertical splitter in the SQL Commander could not be moved on Windows
Monitor
 MAJOR
 Monitor main tab is now in its own window. Launch it via the Tools->Monitor menu or new button in the main window toolbar.
MINOR
 All monitors are now executed directly when "Start Auto Reload" is pressed.
MINOR
 New tool property: "Monitor->Auto Start Monitors" controls whether any monitors should be automatically started once at least one database connection is live
MINOR
 Display mode in the Monitors tab (Tabs or Windows) now preserved between invocations of DbVisualizer
MINOR
 Display type in the Monitors tab (Grid, Text or Chart) now preserved between invocations of DbVisualizer
Data Editor
 MINOR
 New "Confirm Edits" data tab tool bar button which when enabled will display a confirmation dialog when an edit has been done in the inline editor
MINOR
 New property "dbvis.disabledataedit" is used to disable the inline and form editors in the Personal edition. (Set this property in the DBVIS-HOME/resources/dbvis-custom.prefs)
MINOR
 Closing the form editor now scrolls to the row that was edited in the grid
MINOR
 Any column sorting is now preserved if inserting a new row in the inline editor. Previous version simply reset the sort.
BUG
 Any "Where Filter" was not respected if closing the form editor i.e all rows was displayed even if there was a filter defined prior to the display of the form editor.
BUG
 Pressing "Reload" in the data tab did not use filter if one was set
BUG
 Form editor now scrolls automatically when tabbing between input fields
Tool Properties
 MINOR
 New tool property "General->Confirm Exit of DbVisualizer"
MINOR
 Now possible to set that BLOB/binary data should be presented as hex
MINOR
 New property "Max Rows at First Display". Controls the max number of rows to fetch when the data tab for a table is first displayed.
MINOR
 Now possible to set foreground and background colors per even and odd numbered rows in the grids. (Tool Properties->Grid->Colors)
BUG
 Choosing "Defaults" in Tool Properties did not revert any key bindings
BUG
 Fixed an erroneous date format that contained mmm instead of mm
Database Objects
(Tree and Views)
 MINOR
 Re-arranged the tree filtering functionality. Filter definitions are now expressed in the database profile i.e it is now possible to express filter definitions on any type in the tree and not only catalog/schema/table.
Note: Old filter definitions in the tree are not moved into the new format as of 4.2. This must be done manually
MINOR
 Changing filter will now not affect the expanded state of the tree. Previous versions collapsed the tree
MINOR
 The database objects tree now keeps the expanded state between "Reload" operations. New objects are indicated with an icon
MINOR
 Menubar/toolbar added to "Show in Frame" window. Contains command to Print, Export, Reload, etc.
BUG
 The busy cursor flickered a lot when scrolling in the database objects tree and the "Show Table Row Count" was enabled
BUG
 "Wrap lines" mode in for ex. Oracle DDL viewers now wraps correctly
BUG
 An error occured if creating a new database connection and then not directly configuring it
Connection tab
 MINOR
 New tool/database connection property, "Require Password". Defines whether a connection requires a password. If enabled and no password is supplied at connect then a dialog will ask for password.
MINOR
 New tool/database connection property, "Require Userid". Defines whether a connection requires a userid. If enabled and no userid is supplied at connect then a dialog will ask for userid.
MINOR
 Now possible to use variables in the Connection tab input fields. Ex:
   URL: jdbc:oracle:thin:@$$Database Host$$:1521:$$SID$$
A dialog will be displayed asking for replacement values once connect of the database is requested. Default values can be specified as: $$Database Host||192.168.0.0$$
Database specific
 DB2
 Profile for DB2 on z/OS (not automatically detected)
MySQL
 Profile for MySQL 5.0.1+
Oracle
  • Now displays "Object Types" per schema
  • Oracle XMLType values now displayed properly.
    Note: In addition to the Oracle JDBC driver this also requires that xdb.jar and xmlparserv2.jar are loaded in the driver manager. (These are part of the Oracle XML Developers Kit)
  • Fixed columns containing "#" in the Oracle profile
MaxDB
 boolean values are now not quoted in the various "Script: xxx" operations
SQL Server
 DbVisualizer Personal users of the open source jTDS JDBC driver now automatically use the SQL Server profile i.e with the extended viewing capabilities