[iSQL-Viewer Release] Version 2.1.4 Released

[<isq...@li...>]

Hello all, I apologize for the unusually large gap between this release 
and 2.1.2
which in hind sight has so many issues I am not sure why i released it 
at that point.
this particular release notice is rather lengthy but lots of good info 
on iSQL-Viewer
as it is part of my new years resolution to have as much documentation 
available as
i can muster

However this release I promise to be very good, in fact if all goes 
well the next release
will be considered stable and replace the now 1 year old version 2.1.0

As always a full list of things changed in this release can be viewed 
at the following
location : http://isql.sourceforge.net/errata_v2_1_4.shtml

TWO MAJOR WARNINGS !!!!!

    I must express here before i talk about anything else.
** The properties file is not i18n compliant meaning all of the 
preferences keys have changed
    for this reason as well as to have more uniformity in them. This 
will pretty much break all
    your existing preferences I highly suggest you simply remove your 
old preferences file and
    start new.

** Services are now detected at startup instead of relying on the 
property inside the
    preferences file, as of now the order will generally be alphabetical 
so the ordering
    gimmick in the service manager doesn't have much effect at this 
time. So all files
    in the designated "isql.home" directory that match "*.service" will 
be used as available
    services.

This releases addresses many internal issues that I have been dealing 
with for quite some
time now. This release marks the end of the confusing package structure 
i have been using.
Here is a quick rundown of the new packages and what each one means.

- [+] org
     - [+] isqlviewer
         - [+] swing        Basic Reusable Components, most or non isql 
specific
             - [+] print    Print oriented classes, including the 
preview dialog.
         - [+] util         basic utility class that may or may not have 
isql dependancies
         - [+] sql          SQL Oriented classes most do not have any 
isql dependancies
         - [+] event        Generic event classes used in isql, no 
dependancies
         - [+] core         Core system like classes for isql e.g 
HistoryItem, and SQLBookmark are here
             - [+] filters  A collection of table filters
             - [+] model    All the Data models for Trees and tables 
resides here.
         - [+] ui           User interface related object mostly isql 
specific screens
         - [+] resource     Main ResourcesBundles and html files are here
             - [+] icons    isql icons reside here
     - [+] jedit            Jedit Syntax package
         - [+] syntax

This hopefully will help some of you who wish to develop with 
iSQL-Viewer.

There is a new interface for using bookmarks i have created a Drawer 
like component
for those of you who do not know what this is (* mostly non-mac users 
*) there are
some new screenshots showing this drawer component for getting to and 
using bookmarks.
along with that Drag and Drop of bookmarks is much more consistent on 
all platforms and
actually works this time :-D

On the subject of bookmarks there is a new features for executing SQL 
command in general
in iSQL-Viewer now. You can now have parameters in queries. What this 
means is you can
set variables to be prompted for values to superimpose into your 
command string before
it is executed. This will be a great asset for SQLBookmarks but 
executing a normal query
will still have this feature. For example...
	if you execute "SELECT * FROM USERS WHERE USER_NAME=&USER_NAME" you 
will be prompted to
	enter a value for USER_NAME and that value will replace the &USER_NAME 
text, so if you
      enter ""BOB"" the SQL executed will look like "SELECT * FROM USERS 
WHERE USERNAME="BOB""

This release will also introduce new HistoryManager for help keeping 
track of history items.
history items are now referred in respect to time, such as new, newer, 
old, and older. The
History viewer has also gotten a MUCH MUCH needed facelift. You will 
want to check out the
preferences editor and see the new History preferences you can set.

Another big change with this release is that the TableFilter API has 
gotten a serious
overhaul it is now much more practical and useful to those wish to make 
custom import
and or export filters. With this new API the respective wizards have 
new more platform
neutral interfaces.




--Markus
--http://isqlviewer.com