Software Details:
Version: 9.1.6
Upload Date: 17 Feb 15
Distribution Type: Shareware
Price: 79.00 $
Downloads: 13
DbVisualizer project is a comercial and cross-platform database software designed for all major relational databases.
DbVisualizer enables simultaneous connections to many different databases through JDBC drivers.
What is new in this release:
- Enhancement:
- DB Support: Sybase ASE: Add support for UNICHAR/UNIVARCHAR size in DDL
- General: Support user.vmoptions and modifying Java properties in Tool Properties for all installer types
- Grid Component: Should be possible to copy/paste external files to binary/BLOB and CLOB grid cells
- Grid Component: Should be possible to copy/paste binary/BLOB and CLOB data between grids
- SQL Commander: Clicking on an icon for an error in the Log tab should move the caret to the error instead of selecting the statement
- Workspace: Adjust active tab stripe color based on current look and feel. Allow override it in tool properties
- Bug:
- Connection Setup: Set Database Type to Auto Detect by default when using the Connection Wizard
- Connection Setup: Pressing Tab in the Database Userid field in the Connection Wizard selects the value instead of moving to the next field
- Database Objects Tree: Using any of the "Script..." or "Open in..." right-click options in the Tables grid with the Generic database type will result in an exception if TABLE_SCHEM is null
- General: Occasional "Comparison method violates its general contract" error may be reported
- Grid Component: Right double-click in the row number field without having a grid selection results in an exception
- OS Support: Mac OS X: com.jidesoft.plaf.aqua.AquaPreferences loadGlobalPreferences may be listed in the debug window on OS X
- SQL Commander: Highlighting errors for huge statements takes a very long time
- SQL Commander: Sometimes the Elapsed Time field in the Log tab shows an incorrect value and the script may be executed multiple times
- SQL Commander: Connection drops while executing in the SQL Commander require a manual reconnect rather than automatically at next execute
- SQL Editor: Occasionally an error (NullPointerException in AttributedString) is triggered by various editor operations, e.g. the Find and Replace dialogs or simply double-clicking
- Table Data Editor: Null cells should be preserved when copy/paste between grids independent what "Show Null As" is set to
- Workspace: Exception: IndexOutOfBoundsException while closing or move tab
- Workspace: Tab text color is too bright and "Show Tab Title in Bold" doesn't work with Metal L&F
What is new in version 9.1.5:
- Enhancement:
- SQL Commander - Present a Reconnect dialog when detecting a dropped connection at Execute
- Bug:
- SQL Commander - Having "Process Parameter Markers in SQL" enabled may consume cursors and cause following SQLs to fail during execution
- Table Data Editor - Result set is not editable if using a sub query in the select statement
What is new in version 9.1.4:
- Enhancement:
- SQL Commander: SQL Commander->Strip Comments when Executing should be unchecked by default (for new users. Existing users need to uncheck manually)
- SQL Commander: Add key binding to move focus between SQL editor and the result sets (View menu)
- [http://www.dbvis.com/forum/thread.jspa?threadID=4705 ]
- Tool Properties: Don't insert "save at" timestamp in the settings XML files
- [http://www.dbvis.com/forum/thread.jspa?threadID=4731 ]
- Workspace: Add key binding to activate and focus current workspace tab (Object View or SQL Commander)
- Workspace: Focus is not set when using key binding to switch to Database, Scripts and Favorite tabs
- Bug:
- Connection Setup: Clicking the Ping button may result in an IndexOutOfBoundsException
- DB Support - Other: Indexes doesn't show in the Indexes tab for a table for Progress databases
- Data tab: While Data tab is being loaded (or saved) some controls are enabled that may result in an error due to the processing state
- Database Objects Tree: Using keyboard to paste into the Databases tab list show an exception
- General: An error may occur when connecting with the bundled Java VM: "Unsupported ccsid, encoding, or locale: "Cpxxx""
- SQL Commander: Getting column information for unqualified tables fails for some databases, affecting Auto Complete and enabling of editing controls for result sets
- [http://www.dbvis.com/forum/thread.jspa?threadID=4729 ]
- Table Data Editor: Saving table data may give an error if saving to a table in non default schema
- [http://www.dbvis.com/forum/thread.jspa?messageID=17324 ]
- Table Data Editor: Pressing tab or enter key in a cell that contain newline or tab characters should not start the inline editor
What is new in version 9.1.3:
- Enhancement:
- Check for Update: Show underlying error message when not being able to connect
- Data tab: Should be possible to assign key binding to the "Show in Navigator" action in the Data tab
- General: Show underlying error message when not being able to connect for Pro evaluation
- General: It should be possible to modify vmoptions per user and not only for the installation which may be shared by many users
- Import: Dropping a file on a Tables or Table object should open the Table Data Import feature
- Installation/Update Installation: Changes in the vmoptions file should survive when installing new versions
- Workspace: Add option to set that "Open in Tab" should switch to the already open object tab first, otherwise open a new tab
- Bug:
- Check for Update: Use System Proxy Settings does not work on Windows if an automatic configuration script is used for system setting
- Connection Setup: Disconnect All may take a while if having a lot (100+) of database connections
- DB Support: Oracle: Max Size is not summarized correctly (DBA Views->Storage->Tablespaces) if having multiple data file for a tablespace
- DB Support: SQL Server: Size parameter is not included in DDL for VARBINARY column and the MAX value is not supported for VARBINARY in Create/Alter Table
- Database Objects Tree: Using the pre 9.0 scripting features doesn't honor the scripting settings in connection properties
- Database Objects Tree: It is not possible to connect (using the node expand handle) a database connection in the Databases tab if it is in an error state
- Database Profile: Actions: The Drop Table action doesn't generate good SQL for MaxDB
- Driver Manager: De-selecting a driver jar file doesn't disable the command buttons. Invoking these without an active selection may result in an error
- Grid Component: Clicking 'Reset Columns' button in the Grid Column Chooser while the underlying resultset is being loaded results in an error
- Monitor: Reloading monitor scripts will reset the current results of any active monitors
- Monitor: Re-displaying the monitor window with monitors running may display an empty dialog in front of it
- Query Builder: Missing whitespace between an operator and its expression cause an error when loading a SELECT statement
- SQL Commander: Getting column info for a result set fails if the table identifier is qualified with a different database than the default
- SQL Commander: Executing queries for large tables with Sybase IQ may be dramatically slower than versions older than 9.0.5
- SQL Commander: NullPointerException when executing a script containing an error with Preprocess Script disabled for databases that support error highlighting
- SQL Commander: When executing a script for a connection that has dropped, an error is reported for the first statement but a new connection is acquired and the rest are executed, possibly with the default database/schema instead of the selected
- SQL Formatter: Formatting a "WITH tableName -- comment AS (SELECT ..." statement does not work as intended
- SQL Formatter: Variables for non-literal strings are mangled when using the Add One Space whitespace setting for the SQL Formatter
- Table Data Editor: Paste in row form editor doesn't work
- Tool Properties: Setting the "Show Null Value as" to en empty string in Tool Properties->Data Formats will break the scripting and table data editing features
What is new in version 9.1:
- The ability to locate SQL script errors was added. Java 7 is now supported on Mac OS X,.
- Database type is now auto-detected.
- Native explain plan support was provided for PostgreSQL.
- The on-line documentation is now organized after how you work, not how DbVisualizer is structured.
- Version control and upgrading is done from inside DbVisualizer - you request trial licenses, get prompted when new versions are available, and are notified when your license is about to run out.
What is new in version 9.0.4:
- ENHANCEMENTS:
- Compare: Allow comparison of similar data types, e.g. Integer and BigDecimal
- [http://www.dbvis.com/forum/thread.jspa?threadID=4336 ]
- Compare: Center the current difference vertically when navigating between them
- Create/Alter Table: Create/Alter Table window need to be larger and optimize column sizes
- DB Support: MySQL: Order procedures and triggers by name in the objects tree
- DB Support: SQL Server: Remove dependency on SQL Server 2000 compatibility views in the DDL generator and the profile queries
- Database Objects Tree: Support re-arranging multiple database connections and folders using drag and drop
- Database Profile: Actions: The Create Trigger action should support setting multiple trigger events (INSERT, UPDATE, DELETE)
- Favorites: Favorites editor and the favorites bar should support adding multiple objects at once
- [http://www.dbvis.com/forum/thread.jspa?threadID=4350 ]
- Favorites: Support re-arranging multiple favorites and folders using drag and drop
- Grid Component: Add an entry for the Column Chooser in the grid header right-click menu (is currently only available as a button above the vertical scrollbar)
- Grid Component: Add "Inverse Selection" action in grid right-click menu
- [http://www.dbvis.com/forum/thread.jspa?messageID=15826 ]
- Performance/Stability: Improve performance for getting column information in most cases, e.g. when deciding if a result set should be editable
- Query Builder: Should be possible to remove all joins for a specific table (i.e. right-click in table node and select "Remove All Joins")
- SQL Commander: Add a "Load SQL in New Editor" to result set tab right-click menu and log icon
- [http://www.dbvis.com/forum/post!reply.jspa?messageID=15852 ]
- SQL Editor: Do not move the caret and scroll positions when doing Replace All
- SQL Editor: Up and Down arrow keys should move caret to beginning/end when on first/last line
- SQL History: Opening a history entry from the SQL History editor should make the main window active
- [http://www.dbvis.com/forum/thread.jspa?threadID=4273 ]
- BUGS:
- Compare: Flip may cause an error (NullPointerException)
- DB Support: PostgreSQL: Data types with "WITH/WITHOUT TIME ZONE" and declared precision are not handled correctly in Create/Alter Table
- Favorites: The "Add to Favorites" window should only display folder objects in the Favorites list
- Grid Component: The coloring of XML data in the XML Viewer makes it difficult to read when rows are selected
- Monitor: Changing series while auto reloader is running may clear all active series
- [http://www.dbvis.com/forum/thread.jspa?threadID=4349 ]
- SQL Commander: Passing both -connection and -sqlfile arguments doesn't set the connection in the SQL Commander loaded with the file
- [http://www.dbvis.com/forum/thread.jspa?messageID=15854 ]
- SQL Commander: Recognize WITH as a SELECT in the execution permission control
What is new in version 9.0:
- This version has a revised user interface with a cleaner design and a more flexible and productive way of working, as well as more room to work.
- It is easier to work with multiple database objects.
- Customized layouts are saved between sessions.
- Compare editors and grids, a new look and feel, minimized risk of lost edits, minimized problems with slow or dropped connections, and much more.
What is new in version 8.0.2:
- Navigator
- Handle large list of Related Tables in a better way, e.g. make the list scrollable
- [http://www.dbvis.com/forum/thread.jspa?threadID=3594 ]
- SQL Editor
- Restore the 7.1 behavior for Insertion Point to End of Line
- [http://www.dbvis.com/forum/thread.jspa?messageID=12788 ]
- SQL Editor
- Add option to show non-printable characters (tab, whitespace, etc) in the editor
- [http://www.dbvis.com/forum/thread.jspa?messageID=12581 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?threadID=3588 ]
- Bug
- 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
- [http://www.dbvis.com/forum/thread.jspa?messageID=12868 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?messageID=12827 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?messageID=12563 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?threadID=3564 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?threadID=3487 ]
- SQL Editor
- The statement parsing is off if a file containing CR linefeeds is loaded in to the editor
- [http://www.dbvis.com/forum/thread.jspa?threadID=3420 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?threadID=3585 ]
- SQL Editor
- Copy of multiple lines and pasting them over the selection may lose indentation
- [http://www.dbvis.com/forum/thread.jspa?threadID=3493 ]
- SQL Editor
- Horizontal scroll with wheel/trackpad scrolls vertically
- [http://www.dbvis.com/forum/thread.jspa?threadID=3468 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?threadID=3462 ]
- Table Data Editor
- After saving in data editor, edited cells may still show old value
- [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
- Table Data Editor
- While saving in the data editor, edited cells flicker and show the old value
- [http://www.dbvis.com/forum/thread.jspa?threadID=3574 ]
- 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
- [http://www.dbvis.com/forum/thread.jspa?messageID=12961 ]
What is new in version 8.0:
- This version added support for the popular SQLite and H2 databases, integrated SSH tunneling, a new SQL editor with extended style configuration and database specific keyword support, enhanced chart support with pre-defined color schemes and easy setup, and the ability to export results in Excel 2007 and column formats.
Requirements:
- Java 2 Standard Edition Runtime Environment
Comments not found