SQLTools++ on Sourceforge.net

I was thinking about offering users the opportunity to provide feedback, submit bugs, ask for help, request new features etc. Therefore I had to decide how to do that. The straightforward solution would have been to add a forum and a bug tracker (e.g. bugzilla) to my already existing SQLTools++ homepage.

But then I thought there are already sites out there that offer these functions and more. So I opted for an Sourceforge.net project... Back to the roots, the original SQLTools is also hosted there, although no longer maintained.

The project request was approved very quickly, so here we are:

http://sourceforge.net/projects/sqlt-pp/

Still the Sourceforge team has not managed yet to upload the existing CVS archive to the sourceforge CVS system but apart from that one already can do a lot of things there:

- Of course download all the available stuff
- Use the "Tracker" feature to submit bugs, request features etc.
- Discuss in forums (Currently "Help" and "Open discussion" are available)

I think this is quite useful and hope the users out there (are there any? :-)) will be able to benefit from it as well.

Best Regards,
Randolf

SQLTools++ 1.20 RC3 is out

A new release SQLTools++ 1.20 RC3 is out.

You can download it from the SQLTools++ homepage.

Here's a summary of the changes for SQLTools++ Version 1.20RC3:

New features:

- New major feature: Enhanced editor highlighting
* Match braces
* Highlight too long identifiers exceeding threshold length (default 30 chars but can be changed in "PlusPlus" settings)
* Highlight known user objects for current connection
* Show extended information about selected text in status bar
Since this is quite beta, all the related new code paths can be disabled in the "PlusPlus" section of the settings ("Enhanced Visuals")
- New feature: Auto resize columns after each fetch (analyses only the newly fetched array of rows)
- New feature: Added external tool placeholder which can be empty, " AS SYSOPER" or " AS SYSDBA" to support
privileged connections in external tools
- New feature: Order columns in Object Viewer for tables by column name, can be selected in PlusPlus Settings dialog
or toggled by using second keyboard shortcut (F12 / Shift+F12 by default)

Improvements:

- Improvement: Reading NCLOBs is now supported, no longer ORA-24806 error message when attempting to fetch them
- Improvement: Double-Click on column header border in Grid autofits column (similar to other windows lists)
- Improvement: Appropriate message when not connected to database and attempting to expand a node in Object Viewer
- Improvement: Use environment variable ORACLE_HOME if set in environment
- Improvement: Use environment variable TNS_ADMIN if set in environment
- Improvement: Support TNS entries having multiple aliases assigned delimited by comma
- Improvement: Support both synonyms SNAPSHOT (LOG) and MATERIALIZED VIEW (LOG)
- Improvement: Do not report ORA-28002 twice if using background connection for statistics or DBMS_XPLAN.DISPLAY_CURSOR
- Improvement: More precise information about various data types in Object Viewer: NUMBER, FLOAT, *LOB
- Improvement: Set filter to "N/A" if none of the QuickFilters "VALID/INVALID" are selected. This should filter on
objects like partitioned indexes that do not have a global status but an individual status for each partition object
- Improvement: "Refresh All" in Object List now actually does a "refresh all" resp. marks all tabs for refresh the next time
they are used (It didn't do it before, it just did a "refresh" of the current tab).
Note that this "Refresh All" also refreshes the "Known object" cache used by the enhanced editor highlighting, so in case
you've added/dropped objects you can use this option to refresh the cache used for highlighting
- Improvement: All kinds of reverse indexes and function-based bitmap indexes are handled correctly
- Improvement: Optionally disable cell selection wraparound in Grid

Changes:

- Change: No longer set focus to "Plan" pane when performing "Explain plan", use "Switch pane" (default: F6) to set focus
if needed
- Change: Show execution times that are less than one second as milliseconds

Bugfixes:

- Fix: Materialized view log handling (drop) fixed in Object List
- Fix: Re-enabled "Allow remember manually changed column width" which was broken due to my misunderstanding
- Fix: Get DBMS_METADATA DDL for MATERIALIZED VIEW LOG fixed
- Fix: If unlimited DBMS_OUTPUT size is selected in settings, apply the changed setting to current connection
- Fix: Consistent handling of statistics setting in current session if changing the setting in Settings dialog or in GUI
via button
- Fix: 9i emulation of DBMS_XPLAN.DISPLAY_CURSOR now also enables the "Refresh" context menu entry
- Fix: If "Connection lost" related error is thrown from remote do not close local connection
- Fix: Exception no longer raised when clicking in the row header of an empty result set
- Fix: Changing VALID/INVALID filters in Object List now invalidates all tabs so that changed filter is applied when
activated
- Fix: Setting a filter in an Object list tab no longer invalidates all other tabs
- Fix: Opening a non-existing document from the most recently used file list no longer raises an Exception
- Fix: Re-enabled TAB key in Grid
- Fix: "Find in Files" should work again. Correct "GREP.EXE" is now part of the installation package again
- Documentation bug: 9i unfortunately does not populate the V$SQL_PLAN_STATISTICS_ALL view if statistics_level is set
to default value TYPICAL, therefore you don't get the basic plan info. You only get the view populated if statistics_level
is set to ALL. Whereas 10g already mirrors basic plan information from V$SQL_PLAN into V$SQL_PLAN_STATISTICS_ALL in
TYPICAL mode

Known Issues:

- Known Issue: Quoted identifiers (using "") potentially are not correctly recognized by new "Known objects"
hightlighting since the current tokenizer does treat them as "normal" identifiers and therefore breaks them apart in
case of any special character encountered