DataBrowser Release Notes Copyright 1999-2005, J Enterprise Technologies, Inc. 1579F Monroe Drive, Suite 611 Atlanta, GA 30324 Web: http://jmatrix.net/content/databrowser_home.jsp Contact: support@jmatrix.net ------------------------------------------------------------------------- 3.4.4 Released 15 Feb 2007 * Fixed a small bug that affected re-setting the schema util's current schema or catalog back to 'null'. * further, fixed the TreePanelModel to avoid settig SchemaUtil's state to 'All' - caused problems with export wizard. * DataEditor support for HSQLDB. (date and time formatting in the database.properties file) * Small fix to remove stack trace from log on the expected condition of QueryTimer.interrupt(). * Cleanup in TableEditor UI. 3.4.3 Released 20 Dec 2006 * Fixed a (potentially huge) perforamnce problem with making calls to DatabaseMetaData.getIndexInfo() call. By making this call 'approximate' it prevents a server side ANALYZE and really snaps things up. 3.4.2 Released 17 Dec 2006 * Removed the modRC data before query refresh. This will change the rows/columns potentially modified from blue back to their normal color when we refresh the query. * Don't close data editor if there is an error executing SQL. * Added Ctrl-T keylistener to create a new editor pane. * Created the ScreenshotRobot to automate creation of screenshots. * Converted all exception warnings to ExceptionDebugger 3.4.1 Released 11 Dec 2006 * Added an opt-out property on the oracle connector. * Made the default schema on Oracle equal to the username uppercased. * Refactored the DataEditor completely. Much more OO design now. * Added 'now' popup menu to the DateEditorField so you can right click and populate the data with the current time. * Created DatabaseUtil similar to SchemaUtil to move some of the database interaction out of the view/controller classes. * Finally fixed oracle date and timestamp bugs reported by Steve Ger 3.4.0 Released 3 Dec 2006 * Fixed a row deletion bug - the UI was updated, but the row was not actually deleted. Reported by wigginz! * Added the NestedJarClassLoader - this allows for the bundling of driver jars within the databrowser.jar. This causes the file to bloat a bit, and startup time on my laptop is hit for about 6 seconds. But there is a lot of upside - the user does not have to explicity download and install jars for drivers that can be distributed. 3.3.5 Released 10 Nov 2006 * Added support for HSQLDB * Fixed oracle timestamp * Added Add/Save connection information as a file 3.3.4 Released 11 Aug 2006 * Moved DataEditor buttons to bottom right of dialog, for a more intuitive interface * FIX: Ticket #1157: ArrayIndexOutOfBoundsException is thrown if no row was selected - show warning dialog. * Fixed Oracle timestamp issue (see DBUtils.getRows for further info) 3.3.3 * FIX: Ticket #1063 - Alphabetise TreeView name order * Added the longed-for collapsible scratch pane. * Added System Properties dialog box, accessible through 'Help > About' * minor bugs: - Fixed nightly build error in FindReplaceAction. - Spelling mistake in Connect Thread status display. - EProperties bug, that prevented a single '"' value. 3.3.2 * Added Unix copy-from and paste-to selection, available in previous releases. This was requested by users. Middle mouse button should also work on most current versions of linux+X+JVM. * Added Alt-Q and Alt-U keyboard shortcuts for Query and Update respectively. * Fixed bug in application preferences that prevented saving of max recent files preference. * Added mouseovers for recent files, copy, cut, paste, undo. * Fixed a race condition in DataEditor when using the max+1 primary key chooser, and 'add and continue'. Submitted by tdye. 3.3.1 Released 19.jan.2005 * Updates to editor panes: open, save, close actions. * Fixed execute selection as update and batch (didn't work in beta) * Fixed the way file open, save and saveas work * Fixed recent files * Added preference for the number of recent files to be saved 3.3.0beta Released 17.nov.2004 * Removed JEdit component, and replaced with custom JEditorPane. * This facilitates a number of things: more standard interface, undo/redo functionality, multiple editors. * As the editor is a central component, I've incremented the minor version number to 3.3. * Tightened UI a bit to make better use of screen real-estate. * Updated to a java standard Icon set. * Changed implicit execution of selected text in editor to explicit execution of selected text via a right click. * Changed closable tab UI. * Removed references to old license code. 3.2.6 unreleased * Fixed oracle schema prefixing -- only a problem when schema is chosen after initial connection. 3.2.5 Released 9/29/2004 * Added select all bound to ctrl-a per ticket 1064. * Fixed csv export, adding enclosing quotes, and escaping internal quotes. Per ticket 1071. * Added UNIX copy to selection from editor pane. * Fixed export to CSV, adding row headers to the export. per dsteeve, ticket 1069 3.2.4 Released 7/21/2004 * Fixed code for row delete from table model -- needed to map to sorted model for deletion if the table had been sorted. * Added sort feature for Oracle TNS Names list. (Dave Witherspoon) * Tried to fix view table in MS SQL Server, pending confirmation (Dave Witherspoon) * Fixed Help->View Release Notes. (Richard Barnes-Webb) * removed the 1 space hack for JEdit Pane scrolling that didn't work anyway. * Added unix 'Paste From Selection' available in 1.4, tried to keep things 1.3 backwards compatable. 1.3 compatability may not last. 3.2.3 Released 11/24/2003 * Fixed schema util bug preventing DataEditor use on Oracle. 3.2.2 Released 11/15/2003 * Fixed problem with All selections in treeview limitation -- couln't change back to 'All' from something else. * Fixed DataEditor delete -- it just wasn't executing the sql it created * Fixed SaveAs action to put the file into the recent files list. * Fixed Save and SaveAs to load all the text from the editor window rather than just selected text. * Fixed Schema navigation on Oracle with schema selected. 3.2.1 Released 8/25/2003 * SchemaUtil was sending 'All' to catalog or schema in Database MetaData which was causing failures on mysql. Now SchemaUtil explicitly disallows a catalog or schema called 'All' * Fixed oracle date format miss-match that was breaking date insertion when attached to an Oracle database. * Added rudimentary comment parser to BatchSQLAction. Lines begining with # are now considered comments and not parsed into statements. * Fixed autocommit functionality. * Improvements to code editor for Save. Allowing comments in SQL -- they are parsed out before tokenizeing sql by semicolons. 3.2.0 Released 6/13/2003 * Initial Free release * sybase support 3.1.3 unreleased * Retrieve BLOBs with configurable character encoding. * Fixing some more cross-database typing quirks with data import. * Added Support for Sybase JConnect 5.5 * Removed Licensing restrictions. After 4 years, DataBrowser is FREE. Support is not free, however. 3.1.2 Beta 01/14/03 * Added GUID Primary Key to DataEditor. * Changed Timestamp date mask to nano (9) decimal places * Extensive beta level work on DataImport functionality. 3.1.1 Beta 01/02/03 * Added data character escaping in the DataEditor. Converting ' to '' in data editor SQL. * Tweaking DataEditor, SQLFormatter for DB2 3.1.0 Beta 12/31/2002 * First release of modular build version. Converted from monolithic source tree to modular build. This is an 'internal' administrative change, however it could introduce some problems, especially with fringe features -- JBuilder integration, etc. * Added log level to application preferences * Better abstraction of database SQL formatting -- driven by DB2 timestamp quirks. New class attempts formats based on properties, and defaults back to datetimeFormat if Date, Time, or Timestamp are not defined. * Added timestamp mask including nanoseconds for Timestamps. * Re-enabled data import and export. Import is still quirky, expecially for large datasets, however it is included because it could be very useful in some situations (especially with small datasets). 3.0.10 Released 11/15/2002 * Fixed data editing of sorted rows in the result set. Which is not as easy as it may sound. 3.0.9 Released 10/21/2002 * Added size to the column data panel. * Fixed XML Export 3.0.8 Released 09/19/2002 * Made connector menu listen to properties so there is no need to restart after adding new drivers via the driver loader properties. * Fixed PostgreSQL connector frame to remember previous connect. * Fixed result set popup window which had insert/update/delete disabled regardless of the canEdit property. 3.0.7 Unreleased * Fixed history. New elements were not being added to the list. * Made generic connector row toolbar unfloatable. 3.0.6 Released 08/06/2002 * Fixed intermittent NPE due to null event being fired to RSTablePanel. * Fixed 'unknown database' in forward results as email. * Fixed execute update to ignore the ';' char at the end of sql. * Re-instated command line connection code... Now that 3.x supports a background connection thread. Interesting to note that this single feature was the initial driver behind the entire 3.x GUI model re-write. This was required for the click-and-connect feature for Java Web Start based deployment. * Fixed bug causing all open results tabs not to be closed on disconnect. 3.0.5 Released 5/21/2002 Bugs: * Fixed potential NPE in DBUtils! Thanks Todd. 3.0.4 Released 5/21/2002 Features: * Added LOB support as an option, under Preferences->Data Retrieval * Added ABS Max row size. This is important for MySQL, as if you do a select * from a large table, it will attempt to pull the whole thing (under Mark Matthew's JDBC driver). Bugs: * Fixed connector menu 'Why is my connector disabled?' * Fixed execute selected sql. 3.0.3 Released 5/4/2002 Features: * Created inital plugin architecture. This will allow coding modules that are specific to databases or drivers. Such as a user manager for postgres or mysql, or a trigger editor for Oracle. * reworking some icons. This will likely take a couple releases because I hate doing these little graphics. * Disabling gui elements that require a connection while it is in use. Bugs: * removing results windows when a query fails due to SQLExcpetion * Turned off mouseover for disabled buttons. * Added a label to namepattern. * Centered lower status text. * Setting status text to database name while idle. * fixed auto/normal size columns bug. 3.0.2 Released 5/2/2002 * Limited UPA to superuser. 3.0.1 Released 5/2/2002 * Inital beta release of the 3.0 functionality. 3.x delta is measured from this baseline. 3.0.0b1 Unreleased * Working copy, massive refactoring of packages and internal data structures. --> 3.x.x <--------------------------------------------------------------- 2.8.3 Unreleased * Still working with Fred Hart on java.sql.Clob * Rollover buttons * Changed Core, BuildID, and IconFactory to use their current classes' classloader to load resources, rather than the system classloader. This is important for Java Web Start functionality. Bugs * Fixed tab pane titles where there was no where clause but there was a group by and/or order by. 2.8.2 Released 03/30/2002 * Added support for java.sql.Clob datatype at request of Fred Hart. * Recent connections are now re-ordered so that the most recent connection is always at the top of the list. TID * Changed to InstallAnywhere NOW 4.5.3 for building installers Bugs: * Fixed typo on purchase info page. TID * Enhanced syntax highlighting with operators and data types. TID * Fixed copy when colums have been re-ordered. TID * Made ToolTipText for tab panes based on HTML for multi-line. TID * Fixed bug in postgres connectors. 2.8.1 Released 03/17/2002 Features: * Added support for new Microsoft SQLServer 2000 driver * Added adhocWhereClause to data editor. This will help when primary key information is not available for a table when editing. Bugs: * Fixed row removal on data editor.delete(). Paging interface does not include headers in row count. * Fixed unlikely null pointer in sql table expansion for treeview. * Changed history from connection specific to global. 2.8.0 Released 03/13/2002 Focusig on text editor features, multi-line statement execution. Features: * Added find/replace * Added recent files menu Bugs: * Fixed bug that caused dialog buttons to fail on batch sql execution. * tweaks to editorpane.setText() for usability. 2.7.11 Released 03/03/2002 * Fixes/Features for Tim Bjorkman * Fix the hotkeys for query, update, etc. * Added support to execute only the selected query * Forced a SchemaUtil cache refresh when you press the refresh button on the treeview gui. 2.7.10 Released 10/31/2001 * Fixed html export which was still broken. * Added windows style ctrl c, x, v to the editor pane * Tweaked JBuilder integration to prevent shutdown hangups. ComboBox UI is still screwed up, but it is not a JBuilder specific issue. 2.7.9 Released 10/30/2001 * Changed icons for email, xml, html, and csv exports. * Added xml export. * Fixed a serious bug introduced in 2.7.6 which broke all of the result set export functionality. * JBuilder integration. Copy databrowser.jar into /lib/ext to integrate DB with JB. Tested with JBuilder 5 and 6 beta. * Tweak to configuration wizard run rule 2.7.8 Released 10/20/2001 * Added initial configuration wizard to help first time users get things configured. 2.7.7p Not publicly released, changes available in next version. * Fixed small bug for table editing on Sybase... 2.7.7 Released 10/11/2001 * Un-bolded font due to Linux gaudiness(sp?) * Added driver specific feature for DB2 HiT driver to remove CRLF chars * Added a memory monitor to the system log window. * Working with JBuilder integration. 2.7.6 Released as beta 10/9/2001 * De-coupling TreePanel from Tree Model. * Bug fixes from 2.7.5 paging interface. Should be fully functional, however not fully tested. 2.7.5 Unreleased * De-coupling RSTablePanel from RSTableModel. * Added paging interface for viewing multiple pages of results. 2.7.4 Relseased 9/6/01 * Replaced JEextArea based editor with JEdit text area. JEdit provides _real_ syntax highlighting. * Updated the DriverLoader to DriverManager * Changed from custom class loader to a the java.net.URLClassLoader, with a wrapper. * Added a drivers directory. This will become useful if future versions of the installer come bundled with some JDBC drivers. It works similar to the jre/ext directory. * Some Help files are still missing: * Preferences help * Classpath help * import/export help. These files are in the pipeline. 2.7.3 Released 9/3/01 * Fixed several minor UI bugs reported by Todd Delaune. Still working on a couple of them. * UPA 2.7.2 Released 8/26/01 * Fixed encryption password bug that would not allow the user to change from default password to non-default password * Fixed table sorter to deal with Null class * Fixed some help references. 2.7.1 Released 8/15/01 * fixed a some exception handling to more gracefully handle some errors in the mysql-odbc driver pointed out by justin@blowouts.co.uk. * updated some exception handling in TreePanel. 2.7 Unreleased * Changed distributed JRE from SUN 1.2.2_007 to SUN 1.3.1. This only applies to Windows users who download an installer with a bundled VM. DataBrowser will continue to work under the 1.2.2 JRE for the forseeable future. * Added code for multi-line editing in DataEditor. * Changed default type in table editor to VARCHAR * Made max col width in RSTablePanel 80. * Added icons for each supported database in both the connector and the recent connections. * Updated RSTablePanel UI. null values are now rendered as disabled JLabels. Values updated in the DataEditor are updated in the UI in Blue. * DataEditor should now be bug free and ready to go. * SchemaUtil now supports date conversion for MySQL. * Put some code being executed on swing objects into the AWT event queue. This will prevent random deadlocks. 2.7 b1 Released 7/31/01 This is a semi-major version upgrade. The two key features are: 1) Single (default) or multiple window operation 2) Data insert/update/delete capabilities. These features are currently in a beta state. Other upgrades: * A number of icon improvements. * Changed Preferences to a modal dialog. * Log window should scroll to visible. * Added Show Connection Code so you can copy/paste the necessary java code for connection to the database. * SQLExceptionDebugger now shows SQL if it is available. 2.3.5 Unreleased. Completed 6/24/01 Changed the display icon on the results windows to a table from a database icon. Changed Icon on table editor to table with a pen. This makes it easier to navigate the multiple open windows with the task bar. Removed the Core environment initialization stuff, and changed log to use the java.io.File.getTempFile() call instead of the hack that was being used. This should speed startup because we don't need to spawn that process. 2.3.3 Released 6/5/01 Bugs: * Fixed the password -> default_password migration path * Changed the min size of the editor pane to be 4x the height of one row. Features: Updated the splash screen, help about. Updated End-User License Agreement 2.3.3b2 Released 5/20/01 Bugs: Fixed refreshed query table model. Features: * Added code for auto resizing of the result window column widths. 2.3.3b1 Released 5/11/01 Features: * Added support for password encryption of passwords in the properties file Bugs: * Fixed bug in the driver class loader preventing loading of Resource Bundles. This was causeing NullPointerException for ANY SQLException under pgsql, because the ResourceBundle was null. 2.3.2 Released 4/19/01 * Added support for PostgreSQL 6.5 and 7.0. The driver class name changed from postgresql.Driver to org.postgresql.Driver. * Updated the refresh query function to display the new RxC data. 2.3.1 Released 3/15/01 The only major change between 2.3b1 and 2.3.1 is several performance and memory improvements based on an OptimizeIT demo, and conversations with Rob Henry regarding swing frame disposal. Memory: Memory usage should be much more efficient, because past versions were not garbage collecting result set windows when they were closed. CPU: * Startup should be ~30% faster (JDK 1.3 on Win2k) due to lazy initialization of QuickHelp GUI component * App should be quicker overall because of a StringBuffer optimization in the low level logging mechanism that was eating lots of CPU. Also, the packaging of all com.jet.* code was changed to eliminate distribution of non-essential class files with any given project. The jet_all.jar still exists, however not for public distribution. This reduces the size of the new jar (databrowser.jar) from ~700k to ~500k. 2.3 beta 1 Released 3/3/01 with new web site This version contained numerous small improvements and fixes since the 5/30/00 release of 2.1. There had been 7 individual patch releases distributed to various users in that time. Features: * InstantDB Connector * PostgreSQL Connector * Disconnect menu item on the file menu * App now remembers the state of combo boxes for treeview from session to session. Bug Fixes: * Data import and export upgrades. * session properties are now written more often, and NOT written at shutdown. This should prevent people from losing their session information. 2.1.1 Working version. Features: * Quick Help * Driver class loader Bug Fixes: * Null pointer on linux/unix startup. 2.1 RC 1 First DataManager release. Released 5/30/00 First pre-release for 2.1. 2.0.3 was a development release, not publicly available. The import/export part of this release is weak, but I want to get out the bug fixes, enhancements, and MySQL support. Features: * Added configurable property to turn syntax highlighting on and off. The syntax highlighter is not very efficient right now, especially for large or multiple statements. * Cleaned up some of the more "beta" features * Added classpath display gui. * Added gui for deleting bookmarks. * Added "deadly" features when right clicking on table view -- Delete all rows and Drop table. USE AT YOUR PERIL. Bug Fixes: * Increased max recent connections to 20 from 10 at the behest of Todd Delaune * No longer erasing history when opening a new connection. 2.0.3 beta Beta release, gradually adding features for data manager. Features: * New connector for MySQL (Mark Mathews Driver) * File menu options to save and open SQL * Adding new features for DataManager * Vast improvements to table editor, combo for types, check boxes for booleans, etc. * Initial work on data import/export * Adding batch execute to execute multiple commands in the editor window Bug Fixes: * Fixed bugs in table sorting and copying 2.0.1 Released Feb 27, 2000 Bug fix release driven primarily by response to user input. Thanks: Charlie Kotan, Thomas Gunzelmann Features: * Added a connector for DB2 net database connections Bug Fixes: * Changed from EPropertes to Properties for connections because DB2 Driver enumerates and casts to string * Changed Preferences validation so that if you don't have a tnsnames.ora, or odbc.ini the preferences will still function * Fixed bug in Core that prevented startup on OS/2 systems. 2.0 Released Feb 14, 2000 Major improvements in stability and support for multiple databases and multiple VMs. Features: * SplitPane Main window * Support for 1.1, 1.2, and 1.3 VMs * Icon improvements in treeview * ResultSet window improvement: save as html, csv; send as email Bug Fixes: * Fixed Oracle Thin connector. Oracle has a bug in their thin JDBC Driver 1.0.1 Released N/A I Don't think this was ever released. Features Added: * Added status bar to results window. Status bar shows row and column count, and query elapsed time. Bugs: * Added references from MainWin to License to prevent class gc when the noclassgc parm is not passed in. This was causing licensing info to be lost. * Added maxRows to QueryThread for long data views. This prevents OutOfMemory errors on some drivers. 1.0 Released Dec 23, 1999 Initial production relase Features: * Initial production release