| Feature Area |
Description |
| General |
Major:
- GUI changes
- Restructured the main window menu bar:
- Database menu now contains all operations
that are used to control the database objects tree
- Edit menu contains edit operations for the
current SQL Editor
- SQL contains all SQL related operations
for the current SQL Editor
- View menu contains general appearance
operations
- Key binding editor allowing full customization of all
operations (including the SQL Editor. Several key bindings can be
assigned to a single operation, each key binding can be composed of
multiple key strokes. (Key binding now also appear in tool tips).
Minor:
- Installer now supports Mac OS X on Intel
- Added Connection Properties for Database
Connection Hooks.
Use to specify commands that will be executed at database connect and
disconnect (ex: session inits and database cleanups). - Removed borders for some tabbed panes to make the GUI
less cluttered
- All text fields now have a right click menu with
common operations such as Cut, Copy, Paste, Delete and Select All
- Key bindings now listed in the right click menus
- Main tool bar commands for Execute, Execute
Current, Previous History statement, Next History statement, Commit and
Rollback moved to SQL Editor tool bar
- Main window header now shows the name of the file
loaded in the active SQL editor. (Listing of settings XML file is
removed from main window header and instead listed in the Tool
Properties).
- Main Window and Monitor Window now preserve the window
maximum state between invocations
- Load Recent added to File menu. It lists the
last loaded SQL files. (The limit setting can be modified in Tool
Properties->SQL Editor).
- Recommended file name extensions now listed
in file choosers
- Now possible to set a database connection to be any
of Development, Test or Production. Depending on mode some
features will be rendered differently to caught the attention of the
user
- Reconnect All added to Database main menu
- Size and position of Tool Properties dialog now
preserved between invocations.
- Escape keyboard button can now be used to
close all dialogs and windows that have no menu bar
- Using Ctrl-W in application windows other
then the main window closes the window (was previously Ctrl-Q)
- Database Objects tree filtering feature
re-designed.
- Object tree filter now accepts the "*"
wildcard character in addition to "%"
- Support for drag & drop of nodes from the
object tree to most input fields including the SQL Commander editor
- Added support for "choices=" option in variables
allowing list of choices in parameterized queries and connection
settings. Read more in: http://www.minq.se/forum/thread.jspa?threadID=1461
Bugs:
|
| Database Objects |
Minor:
- Right click menu now only lists those operations
valid for the currently selected node
- Right click menu for table objects now contain Script
Object to SQL Window
- New Selected Object in the Database main
menu now lists the valid operations for the currently selected node
- The objects tree expansion state now preserved
between reconnects
- Fixed Connection Properties->Driver Properties and
the way "Use" worked. "Use" has also been renamed to "Edited".
- New connection property, Object Tree Labels.
It is used to override how nodes will be named in the objects tree.
Bugs:
- Faster scrolling in the objects tree
- Great improvements expanding tree objects
having thousands of childs
- Fixed a bug in the objects tree filter preventing
multiple column filters to work
- Enhanced performance showing object view when
selecting an object in the objects tree
Data Tab - Minor:
- The Script: UPDATE WHERE now shows a
dialog if the table have a primary key or at least one unique index
asking whether the generated SQL should use the keys as the where
clause or all selected values
- Using IN operator in the Where Filter
has changed. Text data is automatically quoted for the individual
elements. Example: red,green,yellow -> 'red','green','yellow'
|
| Data Editing |
Minor:
- Support to display TIFF and BMP image
formats
|
| Export |
Minor:
- Support for export in DbUnit XML formats
- Support for export in Excel format
|
| Import |
Minor:
- Skip Empty Rows now enabled by default
|
| SQL Commander |
Major:
- Restructered the SQL Commander appearance to make it
less cluttered
- SQL Editor tool bar added with related
operations
- New Properties pane for the SQL
Commander is used to control editor and the appearance. These were
earlier available in the SQL Commander status bar.
- New right click menu on the SQL Commander tab
- New right click menu on the Editor tab
- New right click menu on the Editor desktop (windows
mode)
- New right click menu on the Result Set tab
- New right click menu on the Result Set desktop
(windows mode)
- Log properties now moved to right click menu
- Result sets are now presented/managed per
SQL Editor instead of globally for all SQL Editors.
- New editor commands:
- Execute Buffer (sends the complete editor buffer
for execution as one statement)
- SQL Formatter including a collection of properties
used to control the formatter
Minor:
- The log/result set is now automatically restored
after execution if the editor was maximized (View->Show/Hide SQL
Editor Ctrl-8)
- File name of the active SQL Editor now listed in main
window header
- Variable dialog now executes when enter key
is pressed in a field instead of adding a line break in the active
field. (Use Shift-Enter to insert a line break).
- Now possible to use $$ variables in files loaded with
the @run client side command
- The parameterization dialog now ignores
variables with the noshow option
- Number of Result Sets now listed in the Result
Set tab header
- Now possible to run anonymous SQL blocks
in DbVisualizer Free
Bugs:
- Executing update x set y='4----' where
xid=12345; resulted in everything behind the first 4 to appear
as comment.
- The following comment was terminated at the / which
it shouldn't
- /* a b c d e/f
g h i j k
*/
- Quoted data is now in red color
- Issuing @export and then executing a non
result set statement resulted in an error being reported in the log
even though the exec were fine
- It wasn't possible to enter special characters
requiring the ALT key combination on Mac OS X. Some
examples of chars that couldn't be typed were: @#[]{}.
- Enhanced performance during rendering of the Text
result set tab
|
| Charts |
Minor:
- Show Point Labels setting added to chart
settings. It will when enabled show X/Y value when hovering the mouse
on a point in the chart
|
| References Graph |
Minor:
- Enhanced graphing support with referenced columns
being indicated in the graph
- Manual layout adjustments can now auto reroute edges
between nodes
- Enhanced rendering performance
- Find feature added, used to search and
higlight table nodes
- References graph settings now saved
between sessions
- New option Bridge Links. Useful when
links cross each other
- Arcs/Edges renamed to Links in the
references graph
Bugs:
- Nothing happened when pressing Reload
while tables were presented in "List" format
|
| Bookmark Editor |
Minor:
- Added Execute Bookmark in the Bookmarks
menu
- Added Copy to SQL Commander added in
Bookmark Editor.
- Changed behavior of Execute Bookmark. It
now copies the bookmark into the SQL Commander and then executes it
|
| Explain Plan |
Major:
- Explain Plan support for Oracle, DB2 and SQL Server
added
|
| Grid |
Minor:
- Support to browse cell value based on value type
- BMP, GIF, JPG, TIFF, PNG
- XML (as text or document tree)
- ASCII
- HEX
- Formatting Output. Vänta... replaced
with the more universal Formatting Output. Wait... ;-)
Bugs:
- Grid column header size now adjusts its height based
on current font
|
| Oracle |
Major:
- Support for object actions:
- Table
- Create, Drop, Rename, Copy, Comment, Truncate,
Import Table Data, Script Object to SQL Editor
- View
- Drop, Rename, Compile, Comment, Script Object to
SQL Editor
- Synonym
- Index
- Create, Drop, Rename, Rebuild, Compute Statistics
- Sequence
- Materialized View
- Function
- Procedure
- Package
- Package Body
- Trigger
- Drop, Rename, Enable, Disable, Compile
- Recycle Bin (Oracle 10g and later)
- Flashback to Before Drop, Purge from Recycle Bin
- User
- Create, Drop, Lock, Unlock, Change Password,
Expire Password
- Session
Minor:
- New DBMS Output tab in the SQL Commander
that replaces the DBMS output previously being presented in the Log tab.
- "Dependencies" tab added to the object views
- No need to execute "@set serveroutput on" in the same
script as the dbms_output.put_line being executed anymore
- Now possible to see Tablespace Quota for a
user
- Now possible to see what users have Tablespace Quota
for a tablespace
- Now possible to see Database Properties
- Data Files now appear as child objects to
tablespaces
- List of tablespaces now show temp tablespaces +
size
- Tablespaces now appear as child objects to data files
- Oracle 9.2 and later: DATE data type now
handled and presented as Date in DbVisualizer. Former versions of
Oracle handle DATE as TIMESTAMP
- Oracle 10g: Recyle Bin tables now
displayed in the Recycle Bin folder.
- Columns now appear as child objects for tables
in the database objects tree
- Indexes now appear as child objects
for tables in the database objects tree
- Java Source and Java Class objects now
listed in the objects tree
- Roles tab now displayed when looking
at a role in Oracle
- Added Session Roles and Session
Privileges to the Session Properties node in Oracle
- New Database Connection property for Oracle: Handle
DATE as TIMESTAMP
- Selecting a Synonym in Oracle now show views
(tabs) accordingly for the target object instead of only the
generic Info tab
|
| DB2 |
Major:
- Support for object actions:
- Schema
- Table
- Create, Drop, Rename, Comment, Import Table Data,
Script Object to SQL Editor
- View
- Drop, Comment, Script Object to SQL Editor
- Alias
- Nickname
- Drop, Comment, Script Object to SQL Editor
- Index
- Create, Drop, Rename, Comment
- Materialized Query Table
- Drop, Comment, Script Object to SQL Editor
- Function
- Stored Procedure
- Package
- Trigger
Minor:
- Summary Table is now Materialized
Query Table
|
| SQL Server |
Major:
- Support for object actions:
- Database
- Table
- Create, Drop, Rename, Import Table Data, Script
Object to SQL Editor
- View
- Drop, Rename, Script Object to SQL Editor
- Index
- Create, Drop, Rename, Rebuild
- Stored Procedure
- Trigger
Minor:
- Now with support for SQL Server 2005 + the
new driver from Microsoft
Bugs:
- Triggers are now properly displayed for SQL Server
|
| Informix |
Bugs:
- Fixed minor bug in the profile for Informix resulting
in an error if passing DELIMIDENT=Y as a connection property
|
| Sybase ASE |
Minor:
|
| Mimer |
Major:
- Database profile with extended support for Mimer
|
| MySQL |
Major:
- Support for object actions:
- Database
- Table
- Create, Drop, Rename, Import Table Data, Create
Index,
Script Object to SQL Editor
- Process
Minor:
- Now possible to browse the source for
Views (MySQL 5.0+)
|
Feature
Area |
Type |
Description |
| 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 DbVis 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 |
Feature
Area |
Type |
Description |
| General |
MINOR |
Removed the capability to configure what columns to display
in the old meta data tabs i.e Columns, Privileges, Primary Keys, etc.
(Database Objects category in Tool Properties). A new generic
filtering capability will be introduced in a future version.
|
| MINOR |
The Dean S. Jones and Java Graphics icon collections
has been removed. The reason is that these icon collections
are to limited to express all new symbols required in 4.1.
|
| FIX |
Sorting of grid text columns now sorts correctly i.e AaBbCc
instead of ABCabc.
|
| BUG |
Fixed OutOfMemory error when exporting to file
|
| BUG |
Fixed the error when starting DbVisualizer using Java 1.5 beta.
Note: We do not recommend using Java 1.5 beta until
DbVisualizer officially supports the final 1.5 version. |
| BUG |
Changing variable identifier/delimiter sometimes damaged the
SQL templates in Tool Properties.
|
| Database Objects |
MAJOR |
DbVisualizer Personal:
Database Profiles
introduced which enables database specific
objects views in the Database Objects tree for Oracle, DB2, MySQL,
Informix, SQL Server, PostgreSQL and SQL Server.
A generic database profile is used if accesing
any other databases or when using DbVisualizer Free.
|
| MAJOR |
DbVisualizer Personal:
Now possible to search for objects by name in the Database Objects tree
|
| MINOR |
Setting a filter now applied to all places where the filtered
objects are displayed. Filter can now also be controlled
on all levels in the tree and not just only while
the database connection object is selected.
|
| Table Data Editing |
MINOR |
Data tab filter mode now respected when the grid is auto
reloaded in the Data Form Editor
|
| FIX |
Grid is now scrolled to the edited row or next row if
"Auto Reload Grid"
is checked in the Form Editor
|
| BUG |
Edits for SQL Server now commited properly
|
| SQL Commander |
MINOR |
"Insert SQL into Editor" in SQL Commander result tab
menus and output view menu
inserts SQL at caret position
|
| MINOR |
"Get Bookmark", "Execute" (bookmark editor),
"Copy to SQL Commander"
now copies the SQL into the current editor instead of primary editor
|
Minor enhancements
-
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
accidently 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
Bug fixes
-
DbVisualizer Personal: Serialized Java objects viewer were broken
-
A ClassCastException error occured when closing stand alone
frames in the Database Objects tree
(The following list includes both changes for the
DbVisualizer Free and DbVisualizer Personal
editions. Please check the
feature matrix for the content in each edition).
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, "Connect
|
