Wednesday, December 5, 2007

New version 1.10RC2 of SQLTools++ underway

Just a few words on the latest development: I've found some time and motivation again and have already added a lot of new features. I hope that the new version will be out soon (which means within the next couple of weeks), but won't promise anything here.

Here a list of things that have been added/updated resp. currently being worked on:

SQLTools++ Version 1.10RC2

Improvements:
- Tested with Oracle 11g Server and Client, recognizes 11g as server/client version
- 11g session statistics supported
- Filter header bars added to connection dialog and schema browser lists, similar to SQLTools 1.5
- Schema browser supports now Snapshots, Snapshot logs and the Recyclebin in 10g onwards
- Use optionally DBMS_METADATA to extract DDL from database
- Execute a script and halt on errors
- Execute a script or a selected range in an external tool
- Test the connection resp. re-connect in case you've been disconnected from the database, similar to TOAD functionality
- Automatically save your files before a database execution takes place
- Cleanup of Settings dialog: PlusPlus settings are now in a separate page grouped together
- Copy selected rows from schema browser and object viewer separated by newlines using new shortcut Ctrl+Alt+C in addition to the already existing Ctrl+C shortcut
- Handle NULL passwords better by offering a separate dialog to enter the missing password
- DBMS_OUTPUT now allows max. linesize of 32767 beginning with 10g
- Unlimited DBMS_OUTPUT supported on 10g or later
- DBMS_XPLAN.DISPLAY_CURSOR emulation now available for Oracle9i, see "Data\display_cursor_9i.sql"
You may change the contents of the file to meet your needs, or even save the code in a persistent procedure/package and change the file contents to just call this procedure/package.
The file content is re-read each time the DISPLAY_CURSOR functionality is called
- MERGE SQL statement now recognized and appropriate feedback provided (no. of rows merged)
- Popup Editor window can now be closed using the ESC key as shortcut
- Handle Oracle error ORA-28002 ("password expires in next days") more gracefully
- Check for update on web site with a single click. Although not yet automated, you will be redirected to a web page using the default browser of your system that shows you if there is a newer version available for download.
- Installation cleanup, default settings, files and web links updated

Bugfixes:
- Fixed issue with background session connection (timing issue while establishing the connection)
- Explain plan did not adhere to "whitespace line" setting
- Auto-fit columns is now executed even if the column descriptions stay the same (there was a caching active that compared the current columns of the result set with the previous and in case they were the same no resizing took place. I deactivated that comparison because it annoyed me)

0 comments: