What's new in DbEdit 1.0.0

Release Notes Version 1.0.0

Driver / Connection Configuration	The Preference Page Window/Preferences/DbEdit/SQL Driver Path has been removed. Now the driver classpath must be configured within the connection configuration dialog. When starting the plugin the first time it imports your complete classpath and attaches the same path to each configured connection. The configuration should work after that, but to be sure, please review your configured connections using Ctrl+Shift+C and remove unnessesary classpath entries from the classpath tab in the connection configuration dialog.

Export/Import Wizards	The export wizard has changed fairly. It now lets you choose if table creation statements should be generated with or without unique or referential constraints.Furthermore it can insert the constraints directly into the creation statement or generate separate alter statements that the import wizard can execute after all creation statements have been processed. You have the option to let the insertion statements been processed before or after altering the tables.

Creation Wizards	The table creation wizard's foreign key handling was improved.

Tables View	Context menu actions: New SQL File is now under the entry New Connection is now a sub menu with new entries: Auto Commit Commit Rollback the Show sub menu has a new entry Row Count that can be turned on/off on a table selection the entry Properties will open a properties dialog to help you with changing DbEdit's handling of tables on selection of a column that is part of a primary key/foreign key the new entries Goto Referrer/Goto Reference can be used to select the column this key is referred by/refers to. Filters: The filter dialog was improved to allow to include and exclude patterns from the view.

Table Property Dialog	If a table element is selected in the Tables View it's properties can now be viewed and changed using the context menu entry Properties. From the properties dialog you can change the select statement that is used to retrieve the table's content when opening a Table Editor on it. For a persisted query it is also possible to change it's name. Furthermore you can associate cell editors to columns. That enables you to support any data type by extending the DbEdit functionality with a custom cell editor. For more information, please see the properties dialog help.

SQL Log View	The properties dialog that shows the log file content of a selected log view entry was improved to be more flexible in handling large log files. Furthermore the view contains a second pane to instantly show the detailed content of the selected log entry. Pressing the Ctrl+F key will let you find specific entries in the logs.

Database Search	You can now search for column names within the selected elements or all configured connections.

TableEditor	The filter condition area now supports completion proposal (Ctrl+Space). It can now be sorted by more than one column by simply selecting the columns' headers in the sequence the content should be sorted by. All columns can be resetted by selecting the row number column header. A new cell editor extension mechanism is provided that is used by the two examples Multiline Editor and External Program Editor. Cell editors can be associated with columns using the table property dialog.

SQLEditor	Ctrl+Shift+F now formats the SQL text.

Compare Tables

Instant SQL View	A new view is the Instant SQL view which is a combination of the SQL Editors edit view and the Table Editors result view. It supports multiple result tabs and completion proposal.