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 -> User guide PDF ->

6.0.15 - Released 2008-10-20

Bugs Fixed
DB Support: DB2
DDL tab for View nodes may give error for some database/driver versions
DB Support: PostgreSQL
Index name presented as a child node for a Table in the objects tree is displayed as (null) ((null:(null))
DB Support: Sybase ASE
With the Decimal Format "Unformatted - Strip Zero Fraction", FLOAT column values over 10 million are truncated when displayed
Query Builder
No table names are shown in the condition field popup menu when Qualify Columns is disabled

6.0.14 - Released 2008-09-22

Bugs Fixed
Database Profile: Actions
Opening the action dialog doesn't put focus in first editable field
DB Support: Oracle
Error "isEditable Error: ORA-01219: database not open: queries allowed on fixed tables/views only" is displayed if unmount Oracle instance
See the discussion here
General
An exception is displayed if starting DbVisualizer with 2 identical command line arguments
Grid Component
An extra row is inserted when pasting data from Excel into the table data grid
See the discussion here
Import
Import into Grid doesn't show or keep the grid window visible after import window is closed
Monitor
Error appear in the Monitor if switching database connection for an existing monitor
See the discussion here
SQL Commander
Auto Completion doesn't work if the EXPLAIN keyword is first
Table data editor is not enabled if the WHERE clause is composed of a "IN/NOT IN (SELECT ...) clause
See the discussion here

6.0.13 - Released 2008-08-19

Bugs Fixed
DB Support: Informix
Index information in the objects tree for a specific table display erroneous or no information
See the discussion here
DB Support: JavaDB/Derby
Default delimited identifier characters missing for JavaDB/Derby
DB Support: Oracle
DbVisualizer is not compatible with the JDBC 11.x (JDBC4) driver
See the discussion here
DB Support: SQL Server
"user" shown instead of "schema" for Stored Procedures, Functions and Triggers with SQL Server 2005
See the discussion here
General
Help->Users Guide not showing
Loading user settings from version 4 may result in an error
Grid Component
Configuring a table data filter as a BETWEEN clause don't output the second value in the final filter
SQL Commander
SQL Commander is associated with the previous connection after selecting "[Choose Connection]"
See the discussion here
The output buffer taking care of SQL warnings is limited to handle a maximum of 500 rows
See the discussion here
With multiple SQL Commander tabs open, the database connection controls are disabled in all of them when disconnecting one of the connections
See the discussion here
Execute a SQL that doesn't query a database table may take very long time to complete

6.0.12 - Released 2008-06-26

Improvements
DB Support: Informix
Separate system procedures and functions from user created procedures and functions in the objects tree
See the discussion here
Export
Default format for numeric types in Export should be "Unformatted"
See the discussion here
General
Re-introduce the pre 4.2 backward compatibility support so that old user settings files is loaded properly
Bugs Fixed
DB Support: DB2
NullPointerException when executing SQL if the database connection is lost
DB Support: PostgreSQL
Invalid FK clause in DDL for some tables
DB Support: Sybase ASE
The DDL tab results in an error for Sybase versions prior to 12
General
String auto-quoting truncates values for "[NOT] IN" conditions when quoted values contain delimiter characters (e.g., space)
See the discussion here
Navigator
Delete Selected Node is enabled even when no node is selected, and gives NullPointerException if clicked
See the discussion here
The grid for a related table show incorrect values if the source table has been sorted
SQL Commander
Any string starting with "go" is interpreted as the "go" delimiter

6.0.11 - Released 2008-05-28

Improvements
Connection Properties
Delimited identifiers for database/schema
The use of delimited identifiers with schema/database must be consistent
DB Support: JavaDB/Derby
The Alter Table dialog should allow columns to be dropped in Derby 10.3 and later
General
Always use delimited object names for all SQL issued automatically by DbVisualizer, regardless of property settings
Bugs Fixed
Create/Alter Table
When adding a new column in the Alter Table dialog, the Auto Increment checkbox is always disabled
Database Profile: Actions
Add automatic scrollbars in the action dialog
See the discussion here
DB Support: MySQL
Default values for NOT NULL columns are not included in DDL
The NULL declaration for a timestamp column (NOT NULL by default) is not shown in the DDL
DB Support: Oracle
Information about synonym objects is empty when looking at for example Info, Columns, Indexes, etc. for a Table
Export
Date, Time and Timestamp settings from Tool Properties are not used by Export in DbVisualizer Free
Error occur when exporting data in a grid when the connection has been disconnected
See the discussion here
Table and column names are not delimited when export in SQL format. This may result in an erroneously generated SQL if these contain special characters or spaces
Form Editor
Error occur when using find/replace in the table data cell editor
See the discussion here
Undoing a table data change in the Cell editor doesn't undo visually
Grid Component
Edit/browse cell in window don't work if value is null
See the discussion here
The Data Type cells in the Create/Alter Table, Import and Import Column Mapper are empty while selected with the Aqua L&F on Mac OS X
Import
Import table data and the lists of data types are occasionally erroneous
OS Support: Mac OS X
The menu bar is always located in the DbVisualizer window instead of the standard top screen location in Mac OS X
See the discussion here
Query Builder
Date literals are not automatically quoted in SQL
See the discussion here
Strings containing character sequences also used as operators can cause problems when loading SQL into the Query Builder
See the discussion here
The ignored comments/keywords warning dialog may truncate comments containing special characters, like ""
See the discussion here

6.0.10 - Released 2008-04-10

Improvements
SQL Commander
@spool log should output the complete log if auto clear is disabled and not the last execution
Bugs Fixed
DB Support: DB2
Invalid DDL generated for View with "SELECT" as part of the name
DB Support: Informix
Connecting with a URL that does not specify a database results in an error
See the discussion here
The Schema list in the SQL Commander should be set to "no schema" by default
See the discussion here
DB Support: Oracle
Invalid SQL used for Alter Table and DDL tab for Oracle versions older than 9
An Oracle error occur if scripting for example the SELECT SQL for a VIEW
See the discussion here
DDL can not be displayed for foreign keys
See the discussion here
DB Support: Other
Error populating Catalog/Schema lists when connecting with a JDBC driver that does not support getCatalogs() or getSchemas()
General
Identifier Delimiters are not used for schema/catalog in generated SQL even when enabled in Tools Properties
Import
Error when importing table data with blank date, time and timestamp
See the discussion here
SQL Commander
Max Rows/Columns in SQL Commander are ignored until changed
See the discussion here
Reconnecting occasionally causes a ClassCastException

6.0.9 - Released 2008-03-17

Improvements
Database Profile: Actions
Make it possible to cancel the Action dialogs during initialization
Import
Add option to map columns by name in an imported file with columns in the target database table
See the discussion here
Bugs Fixed
DB Support: Informix
Schemas that do not correspond to a user are not included in the Schema List
See the discussion here
DB Support: Oracle
Synonyms sometimes not listed even if they do exist
See the discussion here
Export
Format Date, Time and Timestamp data as appropriate for the selected database at export
See the discussion here
SQL Commander
Opening a new SQL Commander tab freezes the GUI if the database is unresponsive
See the discussion here

6.0.8 - Released 2008-02-24

Improvements
Grid Component
The quick search feature must support searching for nulls
See the discussion here
References
Add an option controlling if tables names should be qualified in the References and Navigator graph
See the discussion here
SQL Commander
Allow selection of current schema in the SQL Commander for DbVisualizer Free
See the discussion here
Show "Elapsed Time" in the SQL Commander progress pane
Bugs Fixed
Database Objects Tree
Issuing a "Reload" in the objects tree don't mark new objects with an overlay icon
See the discussion here
The object tree filtering and "Show Only Default Database/Schema" results in an error if the object name contain a backslash
DB Support: DB2
DDL tab gives exception for Views where "AS" is not immediately followed by "SELECT"
DB Support: MySQL
Invalid ALTER statements generated by Alter Table for tables with ENUM or SET columns
See the discussion here
DB Support: Oracle
There is a problem looking at synonymed objects located in another Oracle instance
See the discussion here
DB Support: PostgreSQL
An error occur when the connection is interrupted with PostgreSQL
See the discussion here
Only tables and views should be listed in the auto completion popup for PostgreSQL
See the discussion here
DB Support: SQL Server
Exception for Alter Table and DDL tab when IDENTIFIER_CASE = SENSITIVE
Export
If Variable Identifier is changed in Tool Properties then export in SQL format won't work
See the discussion here
Form Editor
Show JPG thumbnails in the image viewer is very slow
The XML viewer fail to show the XML tree for any data type other than CLOB
Grid Component
Trailing and leading spaces not displayed in the Data tab grid
See the discussion here
Grid Editor
Spaces and newline characters are removed from the beginning and the end of data that is pasted into the table data grid editor
See the discussion here
The inline table data editor may corrupt any control character(s) such as newline (\n), tab (\t) or carriage return (\r)
Navigator
NullPointerException in Navigator when navigating with a FK column with a null value selected
See the discussion here
NullPointerException when reloading graph after refresh of the object tree
Related Tables list is incorrect when multiple FKs link the same table
SQL Commander
Requesting Stop in the SQL Commander doesn't always stop execution
See the discussion here

6.0.7 - Released 2007-12-06

Improvements
Connection Properties
Add setting to control whether any connect/disconnect hooks should be executed
Create/Alter Table
Extend the space available for the lists in the FK and Unique Constraints tabs
Database Profile: Actions
Save the setting of "Format SQL" in the actions dialog between sessions
The DDL tab and Alter Table dialog are slow to display
DB Support: Oracle
Add new support for: Clone User, File IO view, Enhanced Tablespace usage, Resize Datafile, View Trigges
Add support for the following objects: Job, Database Links, Directories, Table and Index Partitions
Grid Component
In grids with row header, highlight the text for selected row(s)
See the discussion here
Tool Properties
Make it possible to define how boolean/bit data should be presented
Bugs Fixed
Database Objects Tree
Having a filter on a non text column in the objects tree results in an error when entering a filter value in DbVisualizer
See the discussion here
The "( Default )" label in the objects tree is not visually moved when changing default database/schema with a connection hook
See the discussion here
Database Profile: View
Using non text data in the grid right click "menuItems" results in an error
See the discussion here
DB Support: DB2 z/OS
Schema name filtering doesn't work
See the discussion here
The generic Create Table feature doesn't display
DB Support: Firebird
Connection wizard produce an erroneous URL for the Firebird database
DB Support: Informix
Invalid DDL generated for View with "SELECT" as part of the name
SELECT from unqualified table name may result in read-only result set in the SQL Commander
See the discussion here
DB Support: MySQL
Browsing table or view DDLs in MySQL with JDBC driver version 5.0.8 or later results in an error
Export
Using @export with Excel output format may result in error if empty result set
Grid Component
Creating a filter via the grid right click "Filter" menu options may refer wrong column if a column is not visible
See the discussion here
Grid Editor
Data tab filtering doesn't quote text data with special characters in it
See the discussion here
Editing table data in form editor with a quick filter active results in a NPE
ESC key doesn't close the Filter window
See the discussion here
If the physical database connection is dropped and then save result set data edits a NPE error occur
Inserting a new row in an empty table that is sorted via the column header results in an error
Import
Import preview is not updated when changing for example "Header in First Row"
See the discussion here
Importing an empty number field is not converted to null
See the discussion here
OS Support: Mac OS X
Mac OS X 10.5 (Leopard): Help menu take ages to show and main menus are slow in general
Mac OS X 10.5 (Leopard): NullPointerException when clicking in the query builder diagram pane
Mac OS X 10.5 (Leopard): Row number and editing icons don't show in the Data tab or in result sets
Mac OS X 10.5 (Leopard): Table nodes in the Query Builder cannot be resized
Query Builder
Load to Query Builder fails to find a table if the name in the SELECT does not match the name in the database in a case-sensitive manner
SQL Commander
"No rows were affected" is always logged even though table rows were affected (ex: commit/rollback)
@spool log client side command never executed if @stop on error/warning enabled and an error/warning occur
See the discussion here
The SQL Commander leaks memory

6.0.6 - Released 2007-10-15

Bugs Fixed
Connection Tab
An exception error may be reported when connecting
Export
Apostrophe is exported as ' in HTML exports and are not rendered properly by all browsers. Should be '

6.0.5 - Released 2007-10-08

Improvements
DB Support: Oracle
indexes of table are only shown when the index is in table owner's schema
See the discussion here
List all objects stored in tablespaces
See the discussion here
Bugs Fixed
Connection Tab
If database connection cannot be established in "invisible" mode then DbVisualizer hang and never finish
Create/Alter Table
Alter Table and DDL tab do not work for SQL Server 7 and 2000
DB Support: MySQL
UNSIGNED data types not supported in Create/Alter Table dialogs
DB Support: Oracle
Running a query for Oracle may be slow if not qualifying table name with the schema
See the discussion here
Export
Export to clipboard doesn't work
See the discussion here
SQL Editor
Syntax coloring doesn't handle strings with escaped double quotes properly

6.0.4 - Released 2007-09-25

Improvements
Connection Tab
Allow editing the database URL in a multi line editor
It should be possible to launch the URL Builder in the Connection tab
DB Support: Oracle
Show active sessions and their SQLs
See the discussion here
DB Support: Mimer SQL
Add support for databank in the Create Table dialog
Bugs Fixed
Create/Alter Table
Alter Table and DDL tab do not work for SQL Server 7 and 2000
Database Profile: Actions
The Create Index action generates an erroneous SQL in the generic profile
DB Support: SQL Server
Size not recognized for VARCHAR(MAX) columns in Alter Table
Navigator
The Navigator doesn't show the data for selected table
See the discussion here

6.0.3 - Released 2007-09-17

Improvements
DB Support: Mimer SQL
Add support for databank in the Create Table dialog
DB Support: Oracle
Add actions for Datafile management (Add, Remove)
Add actions for Rollback Segment management (Create, Remove, etc)
DB Support: Other
Add actions for Tablespace management (Create, Remove, Offline, Online, etc)
Improvements
Database Profile: Actions
Convert the "Create Index" feature to be based on the actions framework + add delimited identifier support
DB Support: DB2
Add support for Sequences in DB2
See the discussion here
IDENTITY columns not supported in DDL generation and Create/Alter Table dialogs
Show columns for tables in the objects tree
DB Support: JavaDB/Derby
Show columns for tables in the objects tree
DB Support: MySQL
Show columns for tables in the objects tree
DB Support: Oracle
Add action to compile all invalid objects
Add connection property to control whether schema list should show empty schemas or ignore them
DB Support: PostgreSQL
Show columns for tables in the objects tree
DB Support: SQL Server
IDENTITY columns not supported in DDL generation and Create/Alter Table dialogs
Show columns for tables in the objects tree
DB Support: Sybase ASE
IDENTITY columns not supported in DDL generation and Create/Alter Table dialogs
See the discussion here
Show columns for tables in the objects tree
Export
Excel export doesn't handle Unicode properly
SQL Commander
Show database connection name in result set tab tip
See the discussion here
Bugs Fixed
DB Support: DB2 z/OS
Table name filtering for DB2 on z/OS doesn't work
See the discussion here
DB Support: Informix
Drop and Empty Table actions doesn't work for Informix
See the discussion here
DB Support: JavaDB/Derby
Problem showing BLOB data in Derby 10.3.1.4
DB Support: MySQL
DDL for ENUM and SET with just one element gives NumberFormatException
Table name object filter doesn't work with MySQL version 4 and older
DB Support: SQL Server
Table DDL functions (Alter Table, DDL tab) does not work for SQL Server 7
Export
Excel export fail if the result set table name is longer then 31 characters or include special characters
Nothing happen when moving rows up and down in the export columns setup
The export preview pane clears the system clipboard
Grid Editor
"Mark Selected Cells as Edited" reverts any cells to their original values in the table data editor
See the discussion here
Import
Cannot select a file column name for mapping to table column name
See the discussion here
Navigator
Label show incorrect values for sorted source tables
Query Builder
Loading SQL from the SQL Editor into the Query Builder sometimes results in wrong tables with similar name being loaded in the Query Builder
With more than one instance of the same table, joins can only be made to one of them

6.0.2 - Released 2007-07-25

Improvements
Connection Tab
Ask to re-connect when the physical database connection has been closed/interrupted outside DbVIsualizer
DB Support: Oracle
Show DDL for tables in Oracle 8
Bugs Fixed
Create/Alter Table
Create Table fails with MySQL if the connection has dropped
Opening Alter Table for SQL Server with Database Type being generic results in error
Opening Create Table dialog gives an exception for databases without extended support
Database Objects Tree
The generated SQL produced by "Script object to SQL Editor" should be formatted as in previous versions
Database Profile
Some DBA Views for Oracle may result in "ORA-00907 Missing right parenthesis" depending on the SQL Delimiter setting(s) in Tool Properties
DB Support: Oracle
Alter Table for Oracle 8 cause NullPointerException
See the discussion here
Problem displaying TIMESTAMP WITH TIME ZONE data types
Import
List of fields for imported file is not updated properly if importing from several files during one DbVis session
Installation
Running DbVisualizer installed via RPM on Linux sometimes fail to start
Query Builder
Query Builder sometimes show an exception trace when loading SQL into it
References
Column information is not saved in the GML file when saving references graph
See the discussion here
Cannot select non-adjacent rows while in the "Specified Tables" grid in the References graph
SQL Editor
The colors in the auto completion list are too dark on Windows
See the discussion here

6.0.1 - Released 2007-07-16

Improvements
DB Support: Oracle
The Object Types tree node should list COLLECTION types in addition to OBJECT
References
When saving to GML, links should only be labeled if Show Link Name is enabled
See the discussion here
Bugs Fixed
DB Support: Oracle
DBMS Output tab for Oracle doesn't show any output
SQL Commander
The set auto commit on/off, rollback and commit buttons should not clear any result sets or the log when pressed

6.0 - Released 2007-07-09

New Features
Create/Alter Table
Add an ALTER TABLE feature
Add new CREATE TABLE feature
DB Support: DB2
Verify DbVisualizer with DB2 version 9
See the discussion here
Driver Manager
Bundle and auto configure JDBC drivers for Mimer SQL, PostgreSQL, Sybase, DB2, SQL Server and JavaDB/Derby
Export
Should be possible to include "create table" DDL when exporting result set rows in SQL format
General
Add support for Java 1.6
Need capability to set time zone for the DbVisualizer process
Grid Component
Add: "Script: SELECT ALL WITH FILTER" in the data tab right click menu
Installation
Add support for Windows Vista
Make it possible to choose whether bundled JDBC drivers should be installed or not (only with GUI installers)
Navigator
Add a foreign key navigator feature
Print
Enhance the print support to allow printing SQL Editor, text viewers, images, etc.
Support for print selection in grids
Query Builder
Should be possible to load query builder from SQL
SQL Commander
Add support for non shared physical database connections
Improvements
Connection Properties
Make it easier to toggle the "Show only default database/schema" connection property
See the discussion here
Make it possible to run arbitrary set method(s) in java.sql.Connection and java.sql.Statement
Replace right click menu in Connections grid with a toolbar
Connection Tab
GUI hangs if pressing disconnect while a connection is being established
Improve responsiveness while "Connect All" has been requested
Connection Wizard
Show Connection Wizard automatically for new users
Create/Alter Table
The new CREATE TABLE feature should only be used for databases with profiles while the old CREATE TABLE should be used for the rest
Database Objects Tree
"Reconnect" right click menu choice should be available for all nodes in the objects tree
Improve the Objects Tree Search capability
Move "Show Table Row Count" to objects tree right click menu
Reload in Database Objects Tree should reload childs objects for the selected node only and not all objects for the connection
See the discussion here
Database Profile: Actions
Add a "Format SQL" button in the object action dialog
Database Profile: View
Accept "columnWidth" input paramter for "form" and "node-form" viewers
DB Support: DB2
xxx FOR BIT DATA in DB2 need to be presented natively in addition to text style
See the discussion here
DB Support: Informix
Show "Columns" as child objects for tables in the objects tree
Having auto commit off gives the error "Must terminate transaction before closing database" while navigating the database
DB Support: Mimer SQL
Update database profile for Mimer SQL 9.3
DB Support: MySQL
Distribute MySQL JDBC driver
DB Support: Oracle
Show column objects as child nodes for Table->Constraints, Table->Indexes and Views
See the discussion here
Need to show non table associated triggers in the objects tree for Oracle
See the discussion here
Oracle 10gr2 supports 32k in dbms_output.put() calls while DbVisualizer only show 255 bytes
See the discussion here
Show grants for views in Oracle
See the discussion here
Show indexes for Materialized Views
See the discussion here
DB Support: PostgreSQL
Add actions to set COMMENT for tables, views, etc.
See the discussion here
DB Support: Sybase ASE
Having auto commit off gives the error "xxx is not allowed within a multi-statement transaction in the 'tempdb' database" while navigating the database
Add sorting and objects tree filtering capability for Triggers
See the discussion here
Driver Manager
Add "Remove not Ready Drivers" in the Driver Manager
Load JDBC drivers automatically from pre-defined paths
Add sorting capability in the driver manager
Always merge with any new default drivers if version change i.e. don't show "merge new drivers?" dialog
Driver Manager should set Driver Class automatically as the Connecton Wizard does
Export
Add a "Remove New Lines" setting for CSV exports
Form Editor
Grid Cell Browser/Editor window should remember position and size
Grid Form Browser/Editor window should remember position and size
Add "Stop" capability in the table data editor
See the discussion here
Grid Form Browser/Editor should not be modal
Make it configurable if numbers in form viewer/editor should be left or right aligned
Possible to sort the fields in the form editor
Should be possible to load/save BLOB/CLOB and TEXT values to file in the row form editor
Tab and Enter keys should jump to the Value column in the next row and not to the Key or Name columns
General
Must be possible to specify -encoding when loading files via the -sqlfile command line argument
See the discussion here
There should be no icons in menus with Mac OS X and the Aqua Look and Feel (according to OS X guidelines)
Disable CDE/Motif look and feel
Make it possible to set application font in addition to font size
See the discussion here
Partial Windows 2003 look & feel should not be used
Show nested SQLExceptions when SQL errors occur and not only the top level exception
See the discussion here
Support for anti aliased fonts
Grid Component
"Fit" improvements in grid
"Where Filter" history now listed based on time when last used (latest first)
Add a lightweight filtering capability in the Data tab in addition to the where filter dialog
See the discussion here
Add setting to control if grid row header should appear in table Data tab, Result Set and Monitor grids
Allow "Script: INSERT COPY INTO" for multiple rows in the Data tab grid
See the discussion here
Allow multi columns sort in grids
Grid Cell Browser/Editor window should not be modal
Improve "Set Where Filter for Selection" by allowing multi line selection and additional operators (<>, >, <, like, etc)
Improve the WHERE filter feature by making sure filters are kept when selecting other tables
Load and rendering of a 50,000 row table is now approx. 50% faster (with "Auto Resize Column widths" enabled)
Make grid color configurable in Tool Properties
Make it possible to define whether column header should be considered when auto resize of column widths in grids
Must be possible to specify sort (ORDER BY) clause in the Data tab
See the discussion here
Possible to choose what columns the quick filter should operate on
Possible to sort in the column visibility dialog
Possible to sort on primary key in the column visibility dialog
Setting a Data tab WHERE filter should escape any quotes in the text values
See the discussion here
Should be possible to save BLOB/CLOB and TEXT values to file from any grid
Support for non contiguous selections in grids
The Data tab should support multiple WHERE filters. These should be saved between sessions
Grid Editor
Add capability for duplicating multiple rows in the inline editor
Add capability for multi deletes in inline editor
Inline editing is started when pressing key binding
Inline table data editor should support pasting block of cell values from for example Excel, OpenOffice Calc, etc.
Pasting rows into inline editor grid should add new rows automatically if needed
See the discussion here
Monitor
Enable the "Close Window" button for Monitors to remove it
Print
Printing enhancements using Java 1.5 capabilities
Procedure Editor
Add split panes in the Oracle procedure editor
Query Builder
Add feature in Query Builder that automatically will add joins based on primary/foreign keys and based on match by column name
Auto enabling of Group By if at least 1 aggregate
Query Builder should qoute text data in the conditions settings
See the discussion here
The "Grouping" tab in query builder should be disabled if no Group By enabled columns
References
Column information is not saved in the GML file when saving references graph
See the discussion here
Double clicking a table in the references graph is extremely slow if many database objects
Save "Referenced Only" setting between DbVisualizer sessions
See the discussion here
Saving graph in GML doesn't save info about primary key or columns
See the discussion here
Row Form Browser
Add "Copy to Clipboard" in Browse Row in Form window
Add Find/Find Next in Row Form Browser
Row Form Browser should properly display BLOB/CLOB data
SQL Commander
The UI should not be locked while executing a query in the SQL Commander
Add an option for blank lines between exported result sets when using @export
See the discussion here
Add support for @echo client side command in SQL Commander
Inconsistency between CatalogList and SchemaList
Make it possible setting Auto Commit state in the SQL Commander
Should be possible to echo any text in the @export output
Show progress indicator that SQL Commander is currently executing
The Schema list in the SQL Editor should really change the current schema for Oracle, DB2 and JavaDB/Derby
SQL Editor
Using "Find" in the Replace dialog should leave the cursor at the current position when closing the Replace dialog
See the discussion here
Tool Properties
Make it possible to define platform specific default look and feels
Change default look and feel on Windows to the "Windows Look and Feel"
Remove "Connection Timeout" property setting
Bugs Fixed
Connection Tab
"There are unsaved Database Profiles settings" dialog is displayed randomly in the Connection tab
Selecting Connect/Disconnect from the objects tree right click menu doesn't always work
Database Profile: Actions
Action does not work properly if action is launched while the object view is displayed in a window
See the discussion here
DB Support: Informix
Alter Table for Informix doesn't handle DATETIME/INTERVAL and non-nullable VARCHAR columns correctly
Constraint names are used instead of column names for PK/FK declarations in DDL tab
DDL generation fails for FKs when the referenced PK constraint index name is not "tabid_idxseq"
See the discussion here
Invalid or incomplete DDL for VARCHAR(len, bytes), DATETIME/INTERVAL, and MONEY columns for Informix
Only one FK declaration is included in DDL tab for a table with multiple FKs
DB Support: JavaDB/Derby
Creating new database connection witht the Connection Wizard for "JavaDB/Derby Server" produce an erroneous database URL
DB Support: Oracle
"Refresh Materialized View" doesn't work if "Method" is not explicitly selected
See the discussion here
Exploring the objects tree results in error for Oracle 7 since sys.all_all_tables doesn't exist
Question mark(s) are replaced with Oracle bind variables when used in PL/SQL
See the discussion here
The DBA Views->Storage->Tablespaces listing may fail
DB Support: PostgreSQL
Show DDL for a Table in PostgreSQL 8 some time result in an error
DB Support: SQL Server
Explain plan error on MSSQL 2005
See the discussion here
Showing index information for SQL Server sometimes fail with a SQL error
DB Support: Sybase ASE
Using column aliases for Sybase ASE did not have any effect for non aggregate columns
See the discussion here
DDL Generator
DDL extraction code uses JOIN syntax, which fails for Oracle 8
DDL tab empty for some views
See the discussion here
KEY/INDEX constraints missing in DDL tab for MySQL
See the discussion here
Script Object to SQL Editor --> Create Table gives "ORDER BY column (colno) must be in SELECT list" for Informix 7.3
See the discussion here
SQL formatting for the DDL tab, Query Builder SQL, etc. should ignore the SQL is Between and Target SQL Format settings
No precision and scale info available for DECIMAL in Informix table DDL
Documentation
Description doesn't match figure in "Parameterized Queries"
The "settings" attribute for @export client side is erroneously refered as "settingsfile" in the users guide
See the discussion here
Driver Manager
If driver file(s) was removed outside DbVisualizer then the driver was marked as not ready even if re-installing the files properly
Export
Table name cannot be determined for complex SQLs in @export
See the discussion here
Form Editor
The "Commit Transaction" dialog is displayed at exit after have been editing table data
General
User settings file (dbvis.xml) doesn't reflect latest changes in DbVisualizer if session is killed
See the discussion here
Window icons in MS WIndows are blurry (not correct size)
Grid Component
Column delimiters doesn't work properly for Grid Copy via Ctrl-C, menu choice and DnD
Errors occur if opening for example the "Text" cell for a DB2 stored procedure
See the discussion here
Selecting Reload in grid right click menu reset any column visibility settings
Wrong rows are exported or copied when grid is sorted and then run copy selection or export selection
Import
NullPointerException error when importing into two different tables
Some non readable characters are replaced with whitespace at import
Print
Using print setup and set to landscape is not respected when print
Procedure Editor
Problem compiling procedure/function/package containing ":"
Query Builder
All columns should be available for sorting, regardless of if they are included in the select list or not
Proprietary Oracle join syntax reversed
Query Builder does not support self references
Setting a condition field with the columns menu takes seconds the first time
Setting a condition field with the columns menu takes seconds the first time
See the discussion here
Table alias not used as qualifier for columns in WHERE clause join conditions
Conditions relating to a table remains when the table is removed
See the discussion here
Conditions relating to a table remains when the table is removed
Join right click menu shows disabled items for Join Properties and Remove Join
Not possible to use Synonym objects in the Query Builder
See the discussion here
Windows: Cannot open right click menu on a join in the query builder diagram
References
Having "Specified Tables" enabled in References tab and doing a "Reload" loads all tables and not just specified
See the discussion here
References graph show erroneous table nodes if tables are in different schema/databases
See the discussion here
SQL Commander
Cannot use key bindings to jump between SQL editors when displayed as windows
See the discussion here
Client side commands starting with "@" need to be less restrivtive and accept whitespaces, new lines, etc.
See the discussion here
If there are multiple database connections with the same alias always the first is selected when scripting objects
Page UP/DOWN scroll visually but caret stays at the position where scrolling started
See the discussion here
Position of vertical divider in the SQL Commander is not saved if moved while in full screen mode
Primary keys are listed in auto completion even though primary key display has been turned off
See the discussion here
Single and double quotes confusion in editor
Statements generating multiple result sets only show the result from the first result set in each tab
See the discussion here
When Permissions are setup to ask for confirmation in SQL Commander keyboard focus is lost from the editor
SQL Editor
SQL editor does not process replace operation correctly
SQL Formatter
Error occur when formatting really large SQL statement
See the discussion here
Tool Properties
Text tool properties should be saved as entered including any leading/trailing white spaces
See the discussion here
Change version
View all versions ->