Yet Another Query Tool Files

1.1 Nightly Build (file gets replaced till starting on 1.2)
- Rewrote the code that shows the database in a tree structure
- Program remembers last connected database
- Added partial support for jTDS, the program uses the driver present, either jTDS (default) or the MS one (for MSSQL servers).
  -> Added jTDS 1.2.5 driver to the package (hence the bigger size)
- The column type can now be shown and toggled on and off

1.0
- Replaced MySQL connector 5.1.15 with 5.1.18.
- Fixed sorting columns with numbers in them, TimeStamps sorted as strings for now.
- Fixed a bug in querytable.java
- The show Info Column was missing some ' in the made query.
- [MSSQL] Removing/renaming columns, renaming/removing/cloning tables verified working (was built in since 0.9.7 but never tested)
- [MSSQL] Exec commands now work (fe. EXEC sp_databases)
- [MYSQL] Connecting to a database on the non-default port now works

TODO:
- Improve chart lib
- Improve map lib
- Figure out why é and è etc are displayed as '?'
- An abort button
- Maybe add a tree that gives a bit more info? (about the columns and currently active database)
- Add MOTD to point out lesser known features

0.9.9
- Redone the generator
- Fixed a bug that prevented trees from being saved.
- Added a short 'How To' for the generator to the package

0.9.8
- Changed the source to use Java7, so JRE7 installed is a requirement!
- Added undo/redo to the input field
- Added KML support to the maplib, still work in progress
- Fixed a bug in the query generator
- Fixed a bug in the querytable class

0.9.7
- Added 'Clear All Links' and 'Clear Dead Links' to the Database menu.
- Rewrote most of the MapLib not all old functionality present yet. Not sure
  if it's faster or less memory intensive, but the code is alot easier.
- Improved the query generator
- Additions/changes to the table overview:
    -> Root of the table tree now is the name of the database.
    -> Added a popupmenu, this allows:
        - Renaming tables
            *MySQL: works
            *MSACCES: disabled, because i couldn't find a command for it
            *MSSQL: enabled but can't test it
        - Renaming columns
            *MySQL: works
            *MSACCES: disabled, because i couldn't find a command for it
            *MSSQL: enabled but can't test it
        - Removing tables and columns
            *MYSQL,MSACCES: works
            *MSSQL: enabled but can't test it
        - Clone table
            *MYSQL,MSACCES: works
            *MSSQL: enabled but can't test it
        - Fields Info: retrieves the information of a single column or all columns
          in the table
            *MYSQL: works
            *MSSQL: not tested yet
            *MSACCES: disabled, because i couldn't find a command for it

    -> Renamed the toggle 'Insert' to 'Append' because insert might be confusing
       because it could refer to INSERT statement.

- Bugs Fixed:
    -> A selected * isn't remembered anymore.
    -> First vertical axis on left side is default again
    -> Valueaxis on bottom now rotates label according to  vertical axis
    -> Other minor bugs in the chartlib    

0.9.6
- Using a newer version of the sqljdbc4.jar
- Added support for MySQL databases (reason the package is about 770kb bigger)
- Changed the advanced chart window
- Added 'Clear Selection' to the query result table popup, this clears the
  selection...
- Selection now also looks at selected columns
- Limiting the amount of queries which are stored in the log. The amount can be
  changed in the ini-file, the default is 100.
- Table tree models are cached to .tree files. By default the cache is loaded.
  Use the 'Get Overview Table' in the dropdown to refresh the cache. Should be done
  automatically after a 'drop' or 'create' query.
- Added a copy/paste rightclick popup to the query input areas
- Added a '*' to every column list in the table overview. This allows you to make
  SELECT * FROM <table> when double clicking it.
- Bugs Fixed:
    -> If connecting to a DB fails, the program will no longer ask if it needs
       to add that db to the shortcuts.
    -> When switching databases, the former connection is now closed properly.
    -> Some more possible exceptions caught or prevented.
    -> Empty tables with headers (fe after UPDATE) now get resized to.
    -> Fixed the 'Save' button
    -> Fixed the empty dialog if an Acces file cant be found.
    -> Fixed a situation in which errors were not added to the log.

0.9.5
- Added a menu item to the 'Help' menu that can open email program for feedback.
- 'CREATE','ALTER','DROP' statements are possible now.
- Changed a few lines to support Access 2007 .accdb files. (not fully tested yet)
- Program no longer uses the error log to notify about succesfull updates,inserts
  or deletes. Statusbar and result table are used instead (might remove usage of
  result table again).
- When opening a access file and adding the link in the menu, the program now
  asks for a name for the database, it will suggest the filename without extension.
- Couple of small changes to the chart lib
- Used to read in the result as a string by default, now as an Object.
  Because of this columns containing numbers are now properly sortable.
  But the program is used to working with string, so not sure if everything still
  works properly.
- The autoretrieve for the table overview, now also retrieves if you change db.
    ToDo: cache the tree for the duration of the program
- Fixed Bugs:
    -> When opening a chart twice the headers no long vanish (adv chart panel).
    -> When the overview is refreshed to clickhistory is forgotten.


0.9.4
- Several performance improvements to the maplib, not sure if difference will be
  noticable given that the program shows static maps only and improvements are for
  dynamic maps.
- Changed query code a bit which should speed queries that return large resultsets
- Fixed Bugs:
    -> Error log should work properly again.
    -> Did some trimming on the inserts
    -> Queries that failed are no longer added to the log

0.9.3
- The 'mode' of the overview at startup can be set in the ini file
- Additions to query log now go to the top of the list
- Added an option to retrieve an overview tree of the tables in the db with
  the columns.
    -> Ini determines if this is usable
    -> Ini determines where the overview is shown
    -> This also works for MDB files
    -> Includes 3 togglebuttons
        -> First one 'Insert' inserts the element on which you doubleclick in
           the query at the caret
        -> Select, this builds a select query which creates an inner join if
           columns from two tables are selected
           -> The columns are added in the order that they are selected.
        -> 'On' used to select the items that are compared in the ON part of the
           inner join query
    -> Reset buttons undo's the selections    

- Fixed a typo that caused queries to be added to the list eventhough they
  are duplicates.
- Improved performance of the map tool in certain situations...
- Added some options to the ini:
    -> allowmap=yes/no => if no then the 'Map' button is invisible
    -> allowchart=yes/no => if no then the 'chart' button is invisible
- Program now creates a dbs.xml file if none exists.
- Some bugs fixed
    -> If a line is missing in the ini file, default is used.
    -> The query log now scrolls properly on a new addition.
    -> Some more exceptions handled properly

0.9.1b
- Adjusted the code that reads the querylog, shouldn't slow down the program
  anymore at startup.
- Minor changes to utillib

0.9.1
Bug Fixes
- Changed it so the status bar message doesn't start with an ',' anymore.
-

Features added/changed
- Added support for changing a couple of settings with an ini file
    > The amount of io tabs
    > Show an errorlog or not
    > Show a querylog or not
    > show the map, chart short help
- Added File > Connect to DB, which opens a dialog to connect to a db...
  The program then asks if you wish to save said connection.

Other
- When using the 'map' or 'chart' button a short help will be displayed.
- Program remembers choices made in the settings menu.
- Changed handling of mdb read errors.