Release Notes 9.5Release Notes 9.5

DbVisualizer 9.5 - Change Log

[ Change Log | What's New ]


Auto Completion Add delay for Display Automatically
Chart Show Date/Time values as text in tooltip regardless of chart settings
Connection Setup When choosing Oracle Thin or Oracle OCI drivers in the Connection tab or in the wizard, show a dialog with information about these drivers
Connection Setup Verify what transaction isolation levels are supported by the supported DBs and override in connection properties if needed
Connection Setup Database connections created with the Connection Wizard should be opened in a new tab
Connection Setup Add a Notes/Comment field for a database connection
Connection Setup Make the Ping button always enabled and show a dialog if it cannot run
Connection Setup Show an icon next to the Database Type field if the type is not recommended with the selected driver
Create/Alter Table Set Data Type to a reasonable type by default
Create/Alter Table Create/Alter Table should generate delimited identifiers for all read-only identifiers
DB Support: DB2 LUW The Create Index action should not allow choosing schema for index
DB Support: DB2 LUW Add Columns node for View objects
DB Support: DB2 LUW Add support for more CREATE INDEX and ALTER TABLE options
DB Support: DB2 LUW Add support for the DBMS_OUTPUT module in the SQL Commander
DB Support: DB2 LUW Add support for roles
DB Support: DB2 z/OS Integrate new DB2 z/OS profile contributed by community
DB Support: H2 Add Columns subnode for Views
DB Support: H2 Add support for Functions (ALIAS) and Triggers
DB Support: JavaDB/Derby Add table maintenance actions: Check, Compress, Inplace Compress
DB Support: JavaDB/Derby Add explain plan support
DB Support: MySQL Add replication information support (Slave Status, Slave Hosts)
DB Support: MySQL Add table maintenance actions: Check, Repair, Checksum, Analyze, and Optimize
DB Support: MySQL Allow setting comments for tables
DB Support: MySQL Add new viewer for the Database node that shows the DDL
DB Support: MySQL Rename Table Engine node to Storage Engines and show storage engines as sub nodes
DB Support: MySQL Add Collation and Character Set information to the Status node
DB Support: MySQL Add support for administration of Events
DB Support: Netezza Add extended support for Netezza
DB Support: Oracle Add view for files of an ASM Disk group
DB Support: Oracle Improve the performance when showing "Data Files" and "Tablespace Usage" object viewers
DB Support: Oracle Add support for a functional index in DDL
DB Support: Oracle Add support for dbms_xplan.build_plan_xml starting from Oracle
DB Support: Other Add driver and database type entries for Presto
DB Support: PostgreSQL Make it possible to edit array values in a Data or Result Set tab
DB Support: PostgreSQL Verify DbVisualizer with PostgreSQL 9.5
DB Support: PostgreSQL Add support for User Defined Types in DDL generation
DB Support: PostgreSQL Add support for renaming constraints in Alter Table
DB Support: PostgreSQL Show columns in the tree for View nodes
DB Support: PostgreSQL Include index method in Index DDL
DB Support: PostgreSQL Add support for Tablespace as a DBA Views node
DB Support: PostgreSQL Add a Create Database and Drop Database actions
DB Support: PostgreSQL Add Column COLLATE clause in DDL and Create/Alter Table
DB Support: PostgreSQL Make it possible to edit the System Settings
DB Support: PostgreSQL Add support for Event Triggers
DB Support: PostgreSQL Add support for Foreign Tables
DB Support: PostgreSQL Add support for SERIAL, BIGSERIAL and SMALLSERIAL in table DDL
DB Support: PostgreSQL Make the return type and sample body editable in the Create Function dialog
DB Support: PostgreSQL Add a Grants tab for View
DB Support: PostgreSQL Add support for export of sequences
DB Support: PostgreSQL Add support for PostgreSQL jobs scheduler (pgAgent)
DB Support: PostgreSQL Make it possible have full access to all databases and not only the default within a single database connection
DB Support: PostgreSQL
DB Support: SQL Server
DB Support: SQLite
Add support for filtered/partial index in DDL generation
DB Support: Redshift Add extended support for Redshift
DB Support: SQL Server Add support for extended properties
DB Support: SQL Server Introduce the "schema" level for SQL Server in the database objects list
DB Support: SQL Server Show column and table comments and allow editing them
DB Support: SQL Server Add support for SQL Server Agent Jobs
DB Support: SQL Server Support for browsing and managing SQL Server Agent Jobs
DB Support: SQL Server
DB Support: Sybase ASE
Add Rename actions for tables, columns, views, indexes, procedures, functions, and triggers
DB Support: SQLite Add trigger support for SQLite
DB Support: SQLite Add explain plan support for SQLite
DB Support: Sybase ASE Show computed column expression in DDL
DB Support: Sybase ASE Add support for "Instead of Triggers"
DB Support: Sybase ASE Add a Grants tab for View
Database Objects Tree Extract column info, with data types, also for views
Database Objects Tree Any connection/SQL errors that are raised while expanding the database objects tree should be reported per node rather than as an unhandled exception
Database Objects Tree Split database objects names in a "label" and "label1" attributes. The label is the node label while label1 shows additional information about the object
Database Objects Tree Indicate primary key columns in the Table->Columns subtree with an icon
Database Objects Tree Should be possible to search collapsed folders and visited database objects as you type
Database Profile: Actions Make it possible for lists in actions to be refreshed when values in other inputs are changed
Database Profile: Actions Should not be possible to select another schema than current in for example Create Procedure and Create Function
Database Profile: Actions Actions should support running same scripts as supported by the SQL Commander
Database Profile: Actions Support forced execution of any <Default> elements in actions as a result of value changed in another <Input> component
Database Profile: Actions Allow value for both checked and unchecked to be specified for an Input check style element
Database Profile: Actions Add new "check-list" input style used for zero-to-many selections
Database Profile: Actions Improve the use of linebreak="false" attribute in actions
Database Profile: Commands Support returning the result in an SQLWarning for a <Command>
Database Profile: Tree List more data type info for each column in the objects tree e.g instead of "c1 VARCHAR" show: "c1 VARCHAR(212)"
Driver Manager Upgrade JDBC drivers for 9.5
Explain Plan Formatting of values in the result grid of explain plan should not be controlled by general properties
Explain Plan Wrap long lines in the graph explain plan output
Filtering/Filter Sets Add a "Duplicate Filter Set" action
General Change to new icon collection
Key Bindings
SQL Commander
Enable key binding for Stop Execution
OS Support: Mac OS X Use scaled icons for Retina displays
Performance/Stability Display OutOfMemoryError when loading a large file more user friendly
SQL Commander Stopping script with @sleep commands does not result in indication that the script was stopped in the log
SQL Commander Change from label "Enable Parameterized SQL" to "Parameterized SQL" since it is a checkbox toggle
SQL Commander Change Stop on Warning (which mean an empty result set or 0 affected rows) to Stop on SQL Warning (which looks at any SQLWarning produced by the execution)
SQL Commander Use grayscale icon color in the SQL Commander tab header to indicate if the currently selected database is disconnected
SQL Commander Add option to "Insert Empty Row Between Result Sets" in the Merge Result Sets dialog
SQL Commander Add option to "Include Result Set Header" in the Merge Result Sets dialog
SQL Commander When loading a very large sql file, prompt whether to really load it or insert @run file.sql in the editor
Table Data Editor Having a quick filter and adding a new row into the table data editor, may also filter out the new row


Create/Alter Table Remove Column fails in Sybase
Create/Alter Table Do not generate ALTER statements for columns with unsupported data types
DB Support: DB2 LUW Indexes belonging to another schema than the table are not shown under the Indexes node
DB Support: H2 Create Function does not handle Source consistently with how it's done for other databases
DB Support: Informix Changing database for a connection resets transaction isolation and hook settings
DB Support: MySQL Invalid DEFAULT clause in DDL for BIT column
DB Support: MySQL The size for a BIT column is missing in the DDL
DB Support: Netezza Schema and catalog mix up resulting in tables not being presented with proper owners in the objects tree
DB Support: NuoDB RowId TAB for table does not work for NuoDB
DB Support: NuoDB Databases tab doesn't reload to show new or dropped tables and indexes
DB Support: Oracle Not possible to delete multiple schedule jobs
DB Support: Oracle Action "Create Scheduler Job" fails when using a "schedule_name"
DB Support: Oracle Setting attribute program_name for action "Modify Scheduler Program" fails
DB Support: Oracle SYS.JAVASNM table does not exist in some installations of Oracle
DB Support: PostgreSQL DDL for tables inheriting from tables in another schema is not generated correctly
DB Support: SQL Server Schema drop-down is changed when executing script even if the database doesn't supports changing schema
DB Support: SQL Server An FK pointing to a column backed by a UNIQUE INDEX is not included in the DDL
DB Support: SQLite The generated DDL for a table with foreign key gives error when executing
DB Support: SQLite DDL Tab of Table gives syntax error when run
DB Support: Sybase ASE Running action Create Device fails
DB Support: Sybase ASE Renaming a Trigger, Procedure or Functions makes it impossible to edit source code or export
DB Support: Sybase ASE Triggers not handled correctly in sybase profile for SYBASE 16
DB Support: Sybase ASE Creating a single compound index is shown as two nodes
DB Support: Sybase ASE Both NULL and NOT NULL column constraints should be generated since the default is server dependent
DB Support: TeraData A DDL statement must be followed by commit in Teradata
DDL Generator DDL statements may rarely include empty qualifiers
Database Objects Tree
DB Support: HSQLDB
Refresh/reconnect may not properly restore the expansion state in the database objects tree
Database Profile: Tree Objects shown in the schema tree owned by a different schema must have a label including the owning schema
Grid Component Pasting a single value to multiple cells in the create/alter table columns grid may paste an error message in some of the cells
OS Support: Windows Exception: java.lang.IllegalArgumentException: URI has an authority component
Query Builder Type cast info is removed when importing a SELECT statement
References An exception is raised if doing Reload in the Tables References graph when the database connection is closed
SQL Commander Out of memory running with Strip Comments
SQL Commander Transaction counters are not updated for a "WITH xxx AS (SELECT ...) UPDATE ..." statement
SQL Commander The Schema drop-down in the SQL Commander shows different schemas for DB2 z/OS than those in the Databases tab
SQL Commander The modified indicator (*) in the tab header is not updated if save/edit file while script is running
SQL Commander Internal query to check result set editablity fails if the upper/lower case used in the select does not match the case for the table name
SQL Commander Running with @run gives exception when clicking on result set tab
SQL Commander The Schema list does not reflect the selected database
SQL Editor Line/Block Comment doesn't handle the last line correctly if selecting the whole line
SQL Formatter DbVisualizer may hang if SQL formatter detects a sequence of characters
Workspace Potential NPE if closing a window with SQL Editors during startup

Who Uses DbVisualizer


Customer Testimonial:
BTW: Great product!!!!
Rick Gibbs