Try out DbVisualizer Pro for 21 days

Start the trial by running the latest version and then open the Evaluate Pro Edition under the Help menu.

Select version

Release Notes

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

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

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

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

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

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

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

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

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

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 '

Improvements

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

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

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

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

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

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

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.

Close