Release Notes 7.1

You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 23.2.5 version.

7.1.5 - Released 2011-02-24

Bugs Fixed
Area Details
Data tab Decimal number precision may be cleared if using another Decimal Format than "Unformatted" and the formatting rules for the current locale use a "," as decimal separator
Export Exception thrown when exporting table data with a driver that does not provide schema/catalog info, such as the Transoft driver
General Having Tool Properties->General->Table Data->Show Table Row Count enabled may lock the GUI if two or more main windows are displayed
Grid Component The auto column width formatter sometimes truncate columns showing "..." at the end cell
SQL Editor SQL editors may lose sync with what file is being loaded and what file is reported in the editor title

7.1.4 - Released 2020-11-23

Area Details
Connection Setup Change the variable delimiters in Connection setup details from $$...$$ to the same used in SQL Commander (default ${...}$)
SQL Commander Format the numbers in execution result counters in the progress information area
Bugs Fixed
Area Details
Connection Setup Jumping between two database connections with the same URL may accidentally modify the second connections URL if editing the URL in the first connection
DB Support: DB2 LUW Explain plan can only be performed with EXPLAIN_xxx tables being stored in the login schema even if using "set current sqlid = "<anotherschema>" as connection hook
DB Support: Informix The DBA keyword is missing in the source loaded into the source editor for procedures and functions
DB Support: JavaDB/Derby Exporting indexes for a table fails with Derby 10.6
DB Support: Oracle Explain Plan in Oracle present less information than in versions prior to 7.1
DB Support: SQL Server Opening the Groups node with SQL Server 2008 or newer gives an error
DB Support: Sybase ASE The DDL shown or exported for a large view declaration may have text segments out of order
DB Support: Sybase ASE Procedure is shown twice in the Object Type list in the Object Filter section
DDL Generator Precision and scale are not included in DDL type declaration for decimal data types when using the Generic profile
DDL Generator The DROP INDEX syntax is incorrect for some databases
Export DROP statements should not be generated for indexes, since they are dropped when the table is dropped
Export When exporting a table with BIT data, the BIT values are quoted in the INSERT statement
Export The exportsettings.xml/exportschemasettings.xml files may be empty resulting in an XML error when exporting
Installation The 64-bit Windows installer may download a 32-bit Java VM which will result in errors
Key Bindings Control+S may switch to Database Search if using the key binding to save an already saved SQL editor
References Showing table references for a specific table results in an error if doing a Reload
SQL Commander Preprocessing of a script larger than 5 MB fails
SQL Commander Whitespace should be ignored after the block end delimiter
SQL Commander The Elapsed Time counter is not running when parsing and executing large scripts without preprocessing
Workspace Default file encoding is not considered when opening a SQL file in the OS environment (with for ex. Windows Explorer or OS X Finder)

7.1.3 - Released 2010-09-10

Area Details
DB Support: DB2 LUW Add support for dropping columns in Alter Table for database version 9 or later
References Reload in References graph should reload from the database rather than just layout the cached tables in the graph
Bugs Fixed
Area Details
DB Support: Sybase ASE Calling sp_procxmode to preserve the mode in versions prior to 15 cause various problems, so do not try to preserve the mode in older versions
Import NullPointerException may occur if selecting "Map by Column Name" or "Map File Data Type = Table Data Type"
References Press "All Tables" or "Specified Tables" in the References graph after doing reload in the objects tree results in an error
SQL Commander Copy in the SQL Commander log should only copy the selected text rather than all of the log

7.1.2 - Released 2010-08-18

Area Details
DB Support: Oracle Improve the support for Program, Replication, ASM, AWR, Scheduler, Resource Groups, DataGuard and Streams object types
Procedure Editor Show the same error message for a lost connection when selecting a procedure as is shown when selecting a table
Tool Properties The Permission confirmation window should show number of SQLs that are affected for each permission level
Bugs Fixed
Area Details
Connection Setup Connection variables may be lost if DbVisualizer is abruptly exited
DB Support: DB2 LUW The "Empty Table" action to truncate a table don't work if not using DB2 9.7 and later
DB Support: MySQL Data type names are converted to uppercase in DDL, including the parameters for ENUM and SET types
DB Support: PostgreSQL The COMMENT statements in the DDL for a PostgreSQL table may reference incorrect columns if a column has been dropped
DDL Generator Incorrect table reference in FK constraint when the referenced table is in another catalog/schema than the referencing table
Explain Plan Oracle/DB2 LUW: Changing schema with the Schema drop down and then run Execute Explain will not set the new schema in the database
Export DROP statements are not generated for code objects (procedures, functions, etc.) for some databases when Create DROP Statements is enabled
Export Using multiple "@export set" commands in a script resets the Filename
General The "You need to re-connect..." error window may appear while exiting DbVisualizer
Navigator Incorrect grid data shown when sorting the source table before navigating to the target table
SQL Commander When using Anonymous SQL Blocks in a script executed with the @run command, the end delimiter is included in the statement
SQL Commander Clicking Stop may result in a stack trace in the Debug window
SQL Commander Client-side command syntax errors displayed as generic exceptions with stack trace in log
SQL Editor Must be possible to turn of the "save changes" confirmation when jumping in the history

7.1.1 - Released 2010-06-23

Bugs Fixed
Area Details
Check for Update Check for Update shows that Free Upgrade is available when it is really not a free upgrade
Data tab An error may appear when viewing the Data tab containing BLOB/Binary data
OS Support: Windows Error starting second instance of DbVisualizer on Windows, "Cannot run program "dbvis-multi.exe": CreateProcess error=2, The system cannot find the file specified"

7.1 - Released 2010-06-16

New Features
Area Details
DB Support: Informix Verify DbVisualizer with Informix 11.5
DB Support: MySQL Add Create and Drop User actions
DB Support: Oracle Add Create and Drop Role actions
DB Support: Sybase ASE Add Create Function action
DB Support: Sybase ASE Add Drop and Script CALL to Editor actions for Function objects
DB Support: Sybase ASE Add support for User Defined Functions
Driver Manager The Driver Finder should always run when launching a new DbVisualizer version
Driver Manager When upgrading DbVisualizer version then automatically upgrade all bundled JDBC drivers
Grid Component Add "Find Column" feature which will automatically scroll horizontally to next column that match by name
Grid Component Add "Reload with Column Sorting as Sorting Filter" right click menu command in the Data tab
Grid Component Add a viewer for PDF documents
Grid Component Add option to treat number values in text data types as numbers in the "Aggregation Data for Selection" feature
Grid Component Allow custom colors for quick filter match, nulls, notifications and editing in the grid component
SQL Commander New client side command: @run <script> <var1> <var2>
SQL Commander Add a File->Revert to Saved command to revert all changes made to a SQL file
SQL Commander Add audio notification capability in the SQL Commander
Workspace When opening an SQL file in for Windows Explorer or the Finder in OS X it should load the file in the currently running DbVisualizer instance rather than opening a new
Area Details
Connection Setup Select new database connection in the objects tree when created with the Connection Wizard
Create/Alter Table Add support for IDENTITY columns options (ALWAYS/BY DEFAULT, START WITH and INCREMENT BY)
Create/Alter Table Add support for the ENUM and SET data types in the Create/Alter Table dialogs
Create/Alter Table Allow auto completion in the Data Type column
Data tab "Script: DELETE WHERE" should accept a multi row selection
Data tab Make it possible to set number of max table data filters
Data tab The "Filter & Sort" right click menu should have an option to also consider current column sorting in the generated filter
Database Profile: View Make the Row Count tab "stoppable"
DB Support: DB2 LUW Add support for START WITH and INCREMENT BY for IDENTITY columns in DDL
DB Support: DB2 LUW Add "Indexes" child node for Materialized Query Tables
DB Support: JavaDB/Derby Add support for IDENTITY columns in DDL
DB Support: MySQL Add support for the "FULLTEXT" option in Create/Alter Table and Create Index dialogs
DB Support: Oracle Change the process for updating a CLOB/BLOB column via the data grid for 10g and later to stop UPDATE triggers from firing twice
DB Support: Oracle Show execute permissions for stored procedures
DB Support: PostgreSQL Enable changing column data type in the Alter Table dialog for PostgreSQL 8
DB Support: SQL Server Add support for seed and increment parameters for IDENTITY columns in DDL
DB Support: Sybase ASE Add sp_procxmode call for procedure export DDL and maintain transaction mode in Procedure Editor
DB Support: Sybase ASE Show table indexes in the objects tree for each database
Driver Manager An invalid driver definition (JAR file not found) should not have the same visible state as a driver that has not yet been configured
Driver Manager Drivers marked as invalid due to non existing driver jar files should be cleared when loading new jar files in the connection wizard
Export It should be possible to specify whether to qualify object names and use delimiters for Export
Favorites Favorite Editor: Add ALT+Double Click key binding for opening database object favorite in new window
Grid Component Add "Reset Sorting" command in the right click column header menu
Grid Component Copy/paste of binary data should be supported
Grid Component Preserve selection when sorting grid
Grid Component Preserve sorting in grid when quick filter is activated
Grid Component Should be possible to configure whether the Max Rows warning should appear automatically or not
Procedure Editor Keep cursor position when clicking Save
SQL Commander Add "Create New SQL Editor" button in the main toolbar
SQL Commander Add new "Default Display Mode" setting used to determine default display for result sets in the SQL Commander (one of Grid, Text, Chart)
SQL Commander File->Open should default to "Open in New Editor" rather in the current editor
SQL Commander If numbers are set to include thousand separators (,) in Tool Properties then these are also part of the generated SCRIPT: xxx SQLs
SQL Commander Preserve scroll position in the SQL Preview while editing values
SQL History Add setting to control whether failed SQLs should be saved in the SQL history
SQL History Don't save duplicate entries in the SQL history for statements being executed in sequence
Tool Properties Export User Settings: Add option to convert all paths to be relative rather than absolute
Bugs Fixed
Area Details
Database Objects Tree Long object filter pattern requires resizing of Objects Tree pane to access buttons for adding and removing filters
General An error may occur in various places when a SELECT with a sub query is used, such as when exporting the result of the query
General Opening a web browser from DbVisualizer may result in an error
SQL Commander Unexpected JDBC driver errors may freeze DbVisualizer while executing in SQL Commander

Change Version

[old] Change Version
View all versions ->
Cookie policy

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. Please find our cookie policy here ↗