Release Notes 8.0

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

8.0.12 - Released 2012-11-27

Improvements
Area Details
DB Support: DB2 LUW Show Grants for Views
DB Support: Informix Add support for Informix 11 data types BIGINTEGER and BIGSERIAL in Create/Alter Table and DDL
Bugs Fixed
Area Details
Auto Completion Typing a character hides the list rather than narrowing the list
Auto Completion Triggering auto-completion within a string literal like '..A' may cause a NullPointerException
DB Support: DB2 LUW Error showing DDL for tables in DB2 LUW version 10
DB Support: Oracle Random exception may occur while browsing certain database synonyms
DB Support: PostgreSQL Columns of type MONEY can not be shown or edited in a grid
DB Support: SQL Server Large triggers are listed multiple times under the table node and in the table -> Triggers view
DB Support: SQL Server Invoking a function returning a table with the @call command results in a syntax error
Export Exception when exporting result set after database connection has been disconnected
General The settings file (dbvis.xml) can sometimes be damaged when exiting DbVisualizer
SQL Editor Column auto-completion after a single period causes a StringIndexOutOfBoundsException
SQL Formatter DbVisualizer Variables should be left as-is by the formatter
Table Data Editor Table data editing fail if schema, catalog, table or column name contain $$

8.0.11 - Released 2012-09-27

Improvements
Area Details
DB Support: DB2 LUW Add support for index DDL with INCLUDE columns and ALLOW REVERSE SCANS
DDL Generator Include precision and scale for NUMERIC types for Generic databases
Explain Plan Should be possible to specify a target schema for the explain plan tables in DB2 LUW
OS Support: Mac OS X Add support for high resolution Retina displays
Bugs Fixed
Area Details
DB Support: DB2 LUW Multiple columns in the "Columns" tab for a DB2 table are labelled "NAME" instead of "TABLE_NAME" and "COLUMN_NAME"
DB Support: DB2 LUW DB2 LUW 9.7.6 with the 4.13 and 4.14 versions of the IBM JDBC driver gives erroneous top level objects in the Databases list which results in empty object details for other object types
Export @set maxrows have no effect when used in a @export on command
General A broken Java installation may result in an error while loading DbVisualizer (in sun.util.calendar.ZoneInfoFile.getZoneIDs)
OS Support: Mac OS X If DbVisualizer closed while the main window is maximized, it is impossible in following sessions to have DbVisualizer start-up in non maximized mode
References Exception may occur while the references graph is rendered with Java 7
SQL Commander The JDBC Connection#prepareStatement() is called with CRLF linefeeds when parsing for parameter markers
SQL Editor Incorrect caret position after selecting by double-clicking on second to last line

8.0.10 - Released 2012-07-10

Improvements
Area Details
DB Support: PostgreSQL Sequences should be sorted by name
General Updated bundled JDBC drivers to latest versions for DB2, PostgreSQL, SQLite, H2, MySQL and JavaDB/Derby
OS Support: Mac OS X Digitally sign DbVisualizer with Apple for the new Gatekeeper feature introduced in Mac OS X Mountain Lion
OS Support: Windows Digitally sign DbVisualizer on Windows to guarantee that the software is produced by DbVis Software AB and to prevent unnecessary warnings at installation
Bugs Fixed
Area Details
Auto Completion Column completion does not work if a quoted table name is used as a qualifier
DB Support: DB2 LUW If Explain Plan tables already exist and there is a case mismatch between login user name and the explain plan tables schema an error is reported
DB Support: DB2 LUW The size for columns of type GRAPHIC and DBCLOB is not included in the DDL
DB Support: DB2 z/OS Displaying the source for VIEWS don't work with DB2 z/OS v10
DB Support: Oracle The DDL for VARCHAR2 columns lack the size information
DB Support: PostgreSQL Default schema is not determined correctly if search_path contain "$user"
DDL Generator Invalid syntax for column default values containing function calls, e.g. to_char(sysdate, 'HH24:MI:SS')
Export NPE when including indexes in Table Export with Generic Database Type
Grid Component The Aggregation Data for Selection is not updated when extending selection with cells on the same row
Grid Component If moving a grid column and then show column header tooltip, information about another column is displayed
Key Bindings Cut, copy and paste key bindings in text fields on Mac OS X should follow the currently used key map rather than always require the CMD key
Navigator Deleting a table in the navigator pane may result in an exception
Query Builder IN and NOT IN operators with a single value cause an exception
Scripts The height of the lower details pane in the Script tab is reset between DbVisualizer sessions
SQL Commander Using the ~ operator in a SELECT statement results in a read-only result set
SQL Editor An exception is logged when typing some chinese characters
SQL Editor The syntax coloring is not properly updated after Comment Block and requires a scroll to fix

8.0.9 - Released 2012-04-30

Improvements
Area Details
Chart Make it possible saving default chart settings between sessions
General Increase default max Java memory for DbVisualizer from 256MB to 512MB
Bugs Fixed
Area Details
Database Objects Tree Show Table Row Count does not work for tables with mixed case names or names containing reserved characters
DB Support: DB2 LUW Source for Procedures, Functions etc. not available when created with CREATE AND REPLACE
DB Support: SQLite Need to always treat non-decimal numbers as BIGINT and decimal numbers as DOUBLE to handle large values
DB Support: SQLite Export Schema is not available for SQLite
DB Support: SQLite Tables are not listed in alphabetic order under the Tables node
Export Empty CLOB/BLOB values are represented as NULL when exporting as Value
General Using a single right parenthesis as the variable prefix leads to invalid generated SQL
Import When importing very large files (more than 2,147,483,647 bytes), the progress indication is incorrect
Navigator No warning about pending edits when reloading the graph or deleting a selected node
Navigator Reloading the graph eats memory
Procedure Editor Ctrl+Enter in the procedure editor results in exception
SQL Commander Load and execute of a bookmark or monitor script don't load its visual layout between sessions
SQL Commander Stopping a query in the SQL Commander for Sybase IQ erroneously clears any partially retrieved result set
SQL Commander NullPointerException when using Execute Current with the caret in a comment on the first line

8.0.8 - Released 2012-02-14

Improvements
Area Details
Database Profile: Commands Add new continueonerror="true" attribute for the <Command> element
DB Support: DB2 LUW Missing "Schema Index" field in the Create Index action
DB Support: MySQL Include DEFINER attribute in CREATE PROCEDURE/FUNCTION/TRIGGER statement for Procedure Editor
DB Support: PostgreSQL Add Cascade option for the Drop Schema action
SQL Editor Use keybindings for Find Next/Previous also for Quick Find
SQL Editor Make the line highlight color configurable
Bugs Fixed
Area Details
Chart An error occur when displaying a chart when all values in a serie is 0
Connection Setup Right-click on category labels in the Connection tab gives ClassCastException
Database Objects Tree Java 1.7: Reconnecting database connections may show an error
DB Support: PostgreSQL Support for the UUID data type is missing in the Create Table action
DB Support: Sybase ASE Show Default Database/Schema doesn't work with Sybase
DB Support: Sybase ASE Auto completion doesn't work for Sybase
Driver Manager Cannot load directory of driver classes in the Driver Manager
Import Colors indicating skipped rows in the import preview are not visible
SQL Commander Clicking in the Log to select the corresponding statement in the editor selects the wrong statement when it has been executed with Execute Current or Execute Selected
SQL Commander Pinned result set produced by procedures are not properly cleared at next execute or remove
SQL Editor An empty debug window is displayed (if auto popup is enabled) when pasting text copied from IntelliJ IDEA
SQL Editor Horizontal scrollbar disappears when moving the caret to the beginning of a single long line
SQL Editor Caret position is moved horizontally after a find and then press down keyboard button
SQL Editor Drag-n-drop database objects from another instance of DbVisualizer into the SQL editor results in an error

8.0.7 - Released 2011-12-22

Improvements
Area Details
DB Support: DB2 iSeries Support multiple result sets generated by stored procedure for DB2 iSeries
SQL Commander Should be possible to force presentation of the real column name even if column alias is used in queries
SQL Editor Make it possible to have Find scroll match to center of editor rather than just enough to show the match
SQL Editor Make it possible to turn off the caret blinking
Bugs Fixed
Area Details
DB Support: Informix Default value is missing in the DDL for NOT NULL character type columns
DB Support: SQL Server An NVARCHAR(MAX) column is generated as NVARCHAR(0) in DDL
DB Support: SQL Server No code is shown for procedures, functions and triggers if the database name contains a space or other special character
DB Support: SQLite Column nullability and default value should be disabled in Alter Table
DDL Generator The primary key column order may be incorrect when using the Generic, H2, SQLite, Oracle or Mimer database types
Export Excel OOXML export may output special characters in wrong encoding
Navigator Related Table is not enabled when using Show in Navigator in the Data tab even when cells are selected
OS Support: Mac OS X Add workaround for the memory leak introduced in Java 1.6.0_29 on Mac OS X
SQL Commander Opening a non-existing file with File->Open Recent show truncated error and the file is then kept in the recent files list
SQL Editor Find All does not scroll to make the first match visible
SQL Editor Find Next does not use criteria set up by Find All
SQL Editor When pasting really fast after typing, Undo undoes both the typing and the pasting
SQL Editor Find does not reset highlighted matches made by Find All
SQL Editor Problem with special characters in the search string for Quick File Load
Table Data Editor Mime type for ZIP archives is wrong
Table Data Editor Unrecognized binary data is marked as modified just by opening it in the cell editing window
Table Data Editor Using column alias in selects may disable data editing for some databases

8.0.6 - Released 2011-11-22

Improvements
Area Details
DB Support: H2 Add support for linked tables in H2
DB Support: SQL Server Add enable/disable actions for triggers
DB Support: SQL Server Disabled triggers for SQL Server should be indicated with different icon in objects list
SQL Commander Column aliases in SELECT column list for MySQL 5.1+ don't appear in result grid
SQL Editor Text on the system clipboard is not included in the Paste Dialog
Bugs Fixed
Area Details
DB Support: SQL Server Exception when switching to "Columns" tab with the SQL Server JDBC driver
SQL Commander Filtering log entries with "Show SQL" enabled will always display the SQL even if the entry doesn't match the enabled result categories (success/warning/error)
SQL Commander Very slow to convert a large result set to text
SQL Editor Unindent (Delete Tab) doesn't work for an unselected line with the caret at the beginning of the line
SQL Editor Comments are not highlighted if starting immediately after a statement delimiter

8.0.5 - Released 2011-11-03

Improvements
Area Details
Scripts Add "Open Enclosing Directory" command for script, history and favorite files
SQL Commander Redefine "Execute Current" to mean "Execute statement containing the caret or ending on line with caret"
SQL History Show file encoding in the SQL History feature
Bugs Fixed
Area Details
Auto Completion Auto-completed names may contain whitespace
Command Line Support (dbviscmd) Variables used in the export file name retain the delimiters after substitution when executed via the command line interface
Connection Setup Changing some options, e.g. Authentication Method, does not add/remove related fields immediately
DB Support: HP Neoview If data format for numbers or decimal numbers in Tool Properties include thousand separator it may result in errors while walking the objects tree
DB Support: MySQL The SQL used internally to get a list if users does not work when sql_mode is set to ANSI_QUOTES
DB Support: PostgreSQL Exception when expanding Triggers node or opening Trigger Editor with PostgreSQL 9.1
Export Export to XLSX doesn't drop column headings when column data is dropped
Grid Component Quick filter doesn't work in the Variable Replacor window
Import Import doesn't properly handle embedded escaped quotes in quoted data i.e. 'smith''s'
Navigator Switching tabs with pending grid edits cause a NullPointerException
SQL Commander History file entries created by the SQL Commander are not using the encoding as specified in Tool Properties->Encoding
SQL Commander Clicking on the Locate Error Statement icon in the log when the script has been executed with Execute Buffer results in an exception
SQL Commander Disabling "Process Variables in SQL" or "Process Parameter Markers in SQL" have not effect and variables and markers are always processed
SQL Editor Caret position is misleading for CRLF line break, counted as two positions

8.0.4 - Released 2011-09-16

Improvements
Area Details
Grid Component Allow adding/removing non-adjacent rows in selection by ctrl+click in the grid row header
SQL Commander Show any chained errors when executing in the SQL Commander
Bugs Fixed
Area Details
Data tab Memory leak while reload in a SQL Commander result set or in the table Data tab
DB Support: Mimer SQL User Defined types are not expressed properly in the CREATE TABLE DDL
Grid Component Exception is raised if opening the cell editor with a (null) value
Query Builder Expressions containing operations (e.g. "a - b + c") are corrupted when loaded into the Query Builder
SQL Commander Showing result sets in the SQL Commander will generate an OutOfMemoryError with Alloy L&F and having the "Automatically Show Grid Warnings" enabled
SQL Editor Delete to Word Start/End only works once if the caret is in the middle of a word
SQL Editor The Insertion Point to End of Line shortcut moves the caret to a position one column beyond the end of line for scripts with CRLF (Windows) line terminators

8.0.3 - Released 2011-08-30

Improvements
Area Details
DB Support: Mimer SQL Show error position in the SQL log when running a statement in SQL Commander
Explain Plan The node tooltip should be disabled while in the magnifying mode
Grid Component Allow using the SPACE key to select entries in editable cell lists
Grid Component Enable the hex viewer for any data type and not only binary/BLOB
Grid Component The read-only only cell viewer window should include the button to convert XML (and any other formatted views) to plain text
Key Bindings Command-W should close tab/internal windows rather than Commands-F4 when using OS X key map
Table Data Editor Column names specified in different case may result in table data editing being disabled
Bugs Fixed
Area Details
Auto Completion If a TAB precedes the completion list, the selection replaces all content on the line
Database Profile: Actions Actions with password data appear in clear text in the preview area
DB Support: DB2 LUW Explain plan don't work properly if setting the currentSchema driver property
DB Support: DB2 LUW VARGRAPHIC size is not included in DDL
Grid Component Java VM error may occur when using copy in grid or export
Grid Component Scrollbars are not reset when loading a smaller CLOB in the Data Cell Editor
Navigator Selecting a Related Table with the mouse picks the currently selected entry and not the entry under the mouse
SQL Commander When passing a variable to the @run command, a "file does not exist" message is erroneously logged
SQL Editor Expand All does not adjust the horizontal scroll bar size appropriately
SQL Editor With Expand Tab to Whitespace enabled, the TAB key always inserts a fixed number of spaces instead of aligning at tab positions
SQL Editor The Comment Line/Block features comment only the visible region in the editor
SQL Editor The Comment Line feature comments the row where the caret is even if that row is not part of the selection
SQL Editor Caret is invisible or is not blinking while executing a script
SQL Editor The radio button in the Target section in the Find/Replace dialog can not be set by clicking on the labels
SQL History Details pane may not show in the Scripts and History features
Workspace Double-click a .sql file in the finder, DbVisualizer starts but the file is not loaded. (Works fine on Windows)

8.0.2 - Released 2011-08-07

Improvements
Area Details
Navigator Handle large list of Related Tables in a better way, e.g. make the list scrollable
SQL Editor Restore the 7.1 behavior for Insertion Point to End of Line
SQL Editor Add option to show non-printable characters (tab, whitespace, etc) in the editor
Table Data Editor Table data editor need to save edits in the following order: 1) deletes, 2) updates, 3) inserts to prevent triggering constraint rules
Bugs Fixed
Area Details
Chart Range of Y-axis is erroneous if the max value in a serie is negative
Database Objects Tree The objects tree right click menu may render some actions as disabled
DB Support: PostgreSQL Select composite type column gives exception
DB Support: PostgreSQL Exception or incomplete info when getting column info for DDL
DB Support: SQL Server The default schema cannot be determined for some database configurations
References Not possible to open references graph GML files in yED
References A NullPointerException occur when exporting references graph in SVG or PDF formats
SQL Editor Selection not cleared by Move Caret o Next/Previous Word
SQL Editor Triple-clicking a line to select it and then extending the selection by dragging the mouse down deselects the first line
SQL Editor Delete Line clears all text but does not remove the line break
SQL Editor The action for moving/selecting to the previous word places the caret at the end of the target word instead of at the beginning
SQL Editor The statement parsing is off if a file containing CR linefeeds is loaded in to the editor
SQL Editor "Invalid location" warning when deleting all text as the first edit action
SQL Editor The caret placement may be off when the font specified in the settings file does not exist on the current platform
SQL Editor Copy of multiple lines and pasting them over the selection may lose indentation
SQL Editor Horizontal scroll with wheel/trackpad scrolls vertically
SQL Editor Extending the selection by dragging the mouse up in the row number area stops suddenly
SQL Editor The action for moving/selecting to the previous word places the caret one character to the left of the target when caret is at the beginning of a line
Table Data Editor After saving in data editor, edited cells may still show old value
Table Data Editor While saving in the data editor, edited cells flicker and show the old value
Table Data Editor Fix so that when editing a cell value (for duplicated rows) to the same value it currently have, should preserve the edited state

8.0.1 - Released 2011-06-29

Improvements
Area Details
Connection Setup Embedded databases taking filename as part of the database URL should offer a file chooser in the connection setup (Server Info only)
Bugs Fixed
Area Details
Data tab The "Max Rows at First Display" setting have effect only for the very first table data being displayed
DB Support: PostgreSQL Exception or incomplete info when getting column info for DDL
Export Export in XLS/XLSX format occasionally leave the exported file locked by DbVisualizer
General Browsing the online documentation from the Help->Users Guide in DbVisualizer results in a 404 (Page not found) error
Import Changing Decimal Number Format in Tool Properties from Unformatted may lead to data truncation during import
Performance/Stability Occasional exceptions may appear at startup
SQL Commander Running SQL blocks may result in error
SQL Editor Changing SQL Editor font is not preserved for the primary editor when re-starting DbVisualizer
SQL Editor When dropping a name into the SQL editor the position of the cursor is not moved after the name but stay at the drop position
SQL Formatter The Format SQL->Paste Formatted clear the editor and reset undo buffer while it should just paste at caret position and keep undo buffer
SQL Formatter Format SQL->Copy Formatted should operate on selection rather than whole buffer

8.0 - Released 2011-06-16

New Features
Area Details
Chart Replace the outdated charting component with a modern one (see related improvements below)
Connection Setup Add support for SSH tunneling
Connection Setup Redesign the Connect tab to enable SSH tunneling, more prominent placement of common properties, etc.
DB Support: H2 Add extended support for the H2 database
DB Support: JavaDB/Derby Add Sequence support for JavaDB/Derby
DB Support: Mimer SQL Add Explain Plan support for Mimer SQL
DB Support: SQLite Add extended support for the SQLite database
DDL Generator Add DDL generator and application support for CREATE INDEX
Export Add Export actions for individual object, i.e. View, Procedure, Function, Package, Package Body, and Trigger
Export Add support for export in OOXML (xlsx) format. Enables export of more than 65K rows in a single sheet
Export Add TXT export format used to export fixed width columns output (grid export only)
General Add support for the -connection, -userid and -password arguments for the DbVisualizer GUI. When passed as arguments then automatically connect the database connection at startup
General Adapt DbVisualizer for the upcoming Java 1.7 version
Grid Component Add "Copy Selection as Text (With Column Header)" in the grid right-click menu
Navigator Allow editing in the Navigator grid
Navigator Add Quick Filter for the Navigator grid
SQL Commander Add "Show Object at Cursor" feature that will locate the object at the cursor position and show its details in window
SQL Editor Replace the SQL/text editor component to allow for various improvements (see below)
Workspace Optimize screen estate usage. Allow for configuring visibility of certain components
Improvements
Area Details
Auto Completion Auto completion doesn't work if command is "WITH"
Auto Completion Add the supported client side commands to the auto completion popup
Auto Completion Auto Completion should show database specific reserved words
Chart Support date/time/timestamp columns in X axis with proper scaling
Chart A monitor script with manually adjusted chart settings are not used if re-executing the monitor in the SQL Commander
Chart Chart setting changes made in the SQL Commander should be used automatically for new charts
Chart Make more chart settings persistent
Chart Automatically setup serie in chart at first display
Chart Support GIF export format for Charts
Chart A bookmark in SQL Commander should apply any chart settings from the bookmark
Command Line Support (dbviscmd) Use a better error message when the specified connection does not exist
Connection Setup Using the connection wizard to create a connection should insert the new connection based on the current object tree selection
Connection Setup Change the controls to make it clear that Save Password and Clear Password at Disconnect are mutually exclusive
Create/Alter Table Include table name in constraint name suggestions
Data tab The data filtering feature automatically add WHERE first making it impossible to manually add for example "with (NOLOCK)". Fix by allowing !WHERE to be specified first in the filter
Database Objects Tree The cache with primary keys and unique indexes need to be reset when reloading the objects tree (and also implicitly at reconnect)
Database Profile: Actions The object action window need to be bigger for some actions such as "Create Tablespace" in Oracle
Database Profile: Actions Unsaved edits in the object action window should be confirmed when user request canceling the action
DB Support: Oracle The list of TNS names for Oracle should be sorted
DB Support: Oracle Use the temporary table SYS.PLAN_TABLE$ for explain plan in Oracle 9+
DB Support: Oracle Better support for "Object Type" objects in Oracle
DB Support: Oracle Add "resize datafile" and "add datafile" actions for UNDO and TEMP tablespaces
DB Support: Oracle ASM updates for Oracle
DB Support: Oracle Support for Oracle rules, /*+rule */, without need for special configuration
DB Support: PostgreSQL Support for array types in DDL
DB Support: SQL Server Show computed column expression in DDL
DB Support: Sybase ASE Order objects based on schema and name, as opposed to just name without regard for the schema
Explain Plan Add copy to clipboard functionality for explain plan result set
Explain Plan The tree view in explain plan should be exportable
Explain Plan Copy Selection as Text and Export Grid (TXT and HTML formats) in Explain Plan grid should indent the tree column accordingly
Export Make it possible to select how to delimit SQL blocks for procedure DDL
Export Option to control position of SQL statement in export output (above/below result set)
Favorites Add Replace action for a favorite that references a database object. This should replace the information for the favorite with the data for the selected database object
General Quitting DbVisualizer should wait for all active connections to properly disconnect
General Menubar items are not anti aliased when running DbVisualizer in Linux
Import Optionally drop an existing table with the same name when using Import to New Table
Import Add copy/paste support in "New Database Table" and in the "Map Table Columns with File Columns" import table data grids
Installation Allow command line flag to the installer that disable file associations when installing in silent mode
Monitor Should be possible to hide the toolbar for each monitor window/tab
Monitor Save chart font, colors and other settings with monitor
Monitor Auto started monitors need to run the connect prompter
Navigator Add possibility to select a row in the Data tab grid and use it as start for the Data Navigator
OS Support: Mac OS X Mac OS X: Option to add newly installed version in the Dock
Print Print text in the SQL Editor as text instead of as a screenshot
Query Builder Improve the support for CASE clauses in a query
References Add option to control whether compound references should be rendered only with one link
References Add an option to control auto zooming when searching in the references graph
Scripts Loading a file from the Scripts tab should use the Default File Encoding in Tool Properties if encoding for the file is not set
Scripts Minimize file access operations to increase performance when accessing files on remote hard drives
SQL Commander Should be possible to open a .sql file and load it into a running instance of DbVisualizer
SQL Commander Connections with same alias aren't visibly differentiated in for example the Connection drop down in the SQL Editor
SQL Commander Path errors in the @run and @cd command should be handled just like other errors instead of showing an alert dialog and stopping the execution
SQL Commander Allow for relative paths to be used with the @cd command
SQL Commander Caret position and focus in SQL editors should be preserved when jumping between editor tabs using mouse
SQL Commander Add support for ${dbvis-pwd} that will be replaced with the current directory
SQL Commander Add new setting to control whether result sets produced in the SQL Commander always should be read-only
SQL Editor Allow change of background color in the SQL editor and foreground color for text
SQL Editor Support for code folding in the SQL editor
SQL Editor Must be possible to change colors in the editor
SQL Editor Color-coding should not interpret backslash as an escape character other than for MySQL databases
SQL Editor Underline should not be considered a separator between two words on double click i.e. both words and the underline should be selected
SQL Editor When opening a new SQL Editor the settings for Max Rows/Max Chars should pick their values from the previously displayed editor
SQL Editor Should be possible to disable bold for keywords in the SQL Editor
SQL Editor Add database specific highlighting of reserved words
SQL Editor Insertion "Point to Next/Previous Word" should ignore underscore characters
SQL Editor Add a "Search Scope" in the SQL Editor Find feature
SQL Editor Support regular expression in Find
SQL Editor SQL Editor shall have focus when going to SQL Commander directly after start-up of DbVisualizer
SQL Editor SQL editor should support anti-aliased fonts
SQL Editor Make it possible to change the selection color
SQL Editor Show position of caret based on current statement
SQL Editor Add support for editing macro recording and playback
SQL Editor Add support for Paste from previous clipboard content
SQL History Quick filter in the SQL History should support searching the SQL script content
Table Data Editor Table data editor should keep focus when saving or reloading the data
Table Data Editor Save and undo buttons in table data editor are not activated when editing a single cell or when using functions to fill a single cell
Table Data Editor Add Enable/Disable All buttons in the key column chooser
Table Data Editor Table Data editing should not rely on the variable identifier/delimiter specified in Tool Properties
Tool Properties The settings for proxy should automatically be picked from the system
Workspace Support drag and drop of bookmark, monitor and favorite files between DbVisualizer and external tools such as Windows Explorer, Finder (Mac) and File Browser (Linux)
Workspace Adjust all windows so that they are no bigger than 1280x800
Bugs Fixed
Area Details
Auto Completion Manually specified qualifier is removed when using auto completion
Auto Completion Auto completion doesn't show if name is immediately preceded with a slash
Auto Completion Table hint for SQL Server is treated as alias in the auto completion feature
Auto Completion Auto completion should use the database/catalog qualifier when looking for matching tables and columns
Database Profile: Actions The SQL Formatter spins forever when formatting the action SQL for Create Synonym
DB Support: Oracle Cannot use a plan_table referenced with a public synonym
General Copy text from IntelliJ IDEA results in a low level warning message being printed in the debug window
Performance/Stability Memory leak while running a lot of actions
Performance/Stability Memory leak
SQL Editor Color highlighting for comments in the SQL editor doesn't match the settings of comment identifiers
SQL Editor Syntax coloring doesn't render properly if certain character combinations are in the editor buffer
SQL Editor Netbeans editor suddenly disappear on Windows
SQL Editor The warning "The file has been modified externally after it was originally loaded" in the SQL editor may appear erroneously if the file is stored on a network drive
SQL Editor Extend Selection to Beginning of Line (or Beginning of Text on Line) should not restart selection
SQL Formatter Formatter breaks erroneously on "TIMESTAMP<BR>WITH<BR>TIME ZONE..."
Table Data Editor If selecting a cell directly start edit the value no cursor appear

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 ↗