General
License key file for DbVisualizer
Personal
now installed using Help->License menu.
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)
The Kunststoff Look and Feel
has
been removed. (Vendor have stopped supporting it).
The position of
vertical and
horizontal splitters are automatically reset at start of DbVisualizer
if these are in their minimum or maximum positions.
Added "Show/Hide
Objects
Tree" to Window menu
Added "Show/Hide SQL Editor" to Window menu
Added "Show/Hide Output View" to Window menu
Grids
When dragging
a column
in any grid, if getting to the edge of the grid then the grid is automatically
scrolled
Added "Select
Column"
to grid column header right click menu
Added "Select
Row" to
grid right click menu
Added "Sort
Column
Ascending" and "Sort Column Descending"
to grid column
header right click menu
Doing a "Reload"
in
the Data tab or in the SQL Commander
now preserves the
current column sorting, current selection and scroll position
Now keeps current
selection if
removing a column
Added "Calculate
Selection"
to grid right click menu. It will perform various calculations on the
selected values. This is primarly useful for numeric values
UDT
values
(Types.STRUCT) are now displayed properly in grids
"Copy
Selection (With
Column Headers)" added to all right click menu in all grids.
Default behavior
for "Copy
Selection" (Ctrl-C) changed as it now do not copy column
headers
Sort
indicator is now
preserved if moving or resizing a column. (It disappeared in previous
versions leaving any column sorted ).
Chart
Re-arranged the Chart
pane.
Moved the control buttons to the chart toolbar
Driver Manager
All driver info links now points to
web
page at http://www.dbvis.com<
instead of each vendors web
SQL Commander
Progress text in SQL commander now
stretch
as wide as the progress bar. Progress pane now also report success and
error counts
New right click menu in the Log with "Copy"
and "Save" operations.
SQL
Preview dialog in
DbVisualizer Personal now always displays the SQL and not some obscure
internal format
Monitor
All monitors are
now executed
directly when "Start Auto Reload" is pressed.
New tool
property: "Monitor->Auto
Start Monitors" controls whether any monitors should be
automatically started once at least one database connection is live
Display mode in
the Monitors
tab (Tabs or Windows) now preserved between invocations of DbVisualizer
Display type in
the Monitors
tab (Grid, Text or Chart) now preserved between invocations of
DbVisualizer
Data Editor
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
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)
Closing the form
editor now
scrolls to the row that was edited in the grid
Any column
sorting is now
preserved if inserting a new row in the inline editor. Previous version
simply reset the sort.
Tool Properties
New tool property "General->Confirm
Exit of DbVisualizer"
Now possible to
set that BLOB/binary
data should be presented as hex
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.
Now possible to
set foreground
and background colors per even and odd numbered rows in the grids. (Tool
Properties->Grid->Colors)
Database Objects (Tree and Views)
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
Changing filter
will now not
affect the expanded state of the tree. Previous versions
collapsed
the tree
The database
objects tree
now keeps the expanded state between "Reload"
operations. New objects are indicated with an icon
Menubar/toolbar
added to "Show
in Frame" window. Contains command to Print,
Export, Reload,
etc.
Connection Tab
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.
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.
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$$
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
General
The infamous JdbcOdbc
error -> "Connection not open" finally solved
Focused component
now
preserved when switching beteen Database Object and SQL Commander tabs.
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)
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
Table Creator Assistant
The Data types in the Table Creator
Assistant were incomplete for PostgreSQL
SQL Commander
The Log
text is now
selectable (again) and can be copied to clipboard using right click
menu or Ctrl-C key binding
Choosing "Text"
output view
without being connected resulted in an error
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
Changing Max
Rows/Max Chars in
SQL Commander did not affect any existing results when later doing a
reload.
Vertical splitter in the SQL
Commander
could not be moved on Windows
Data Editor
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.
Pressing "Reload"
in the data
tab did not use filter if one was set
Form editor now
scrolls
automatically when tabbing between input fields
Tool Properties
Choosing "Defaults"
in
Tool Properties did not revert any key bindings
Fixed an
erroneous date format
that contained mmm instead of mm
Fixed an
erroneous date format
that contained mmm instead of mm
Database Objects (Tree and Views)
The busy cursor
flickered a
lot when scrolling in the database objects tree and the "Show
Table
Row Count" was enabled
"Wrap
lines" mode in
for ex. Oracle DDL viewers now wraps correctly
An error occured
if creating a
new database connection and then not directly configuring it
An error occured
if creating a
new database connection and then not directly configuring it