Changelog

(2008 05 04) - ART 1.9 beta1

Enhancements:
* (beta1) Art Jobs improvements: it is possible to edit or launch existing Jobs
* (beta1) Jobs Inline HTML E-mails used 7-bit encoding (thanks to Josh W, China)
* (beta1) If you try to go to a page and must log in,
          Art does not take you back to that page
* (beta1) SMTP with authentication (among optional items in Art Properties)
* (beta1) simplified chinese translation (thanks to Josh W, China)
* (beta1) updated wysiwyg editor (tinyMce) to latest version
* (beta1) updated colors and new icons from tangodesktop
* (beta1) code cleanup: restructure of old servlets file in packages
Bug Fixes:
* (beta1) Crosstabs do not display in emails
* (beta1) ArtMessages_en to show EN language if browser is specifically set to it
* (beta1) javascript fix on gridtable.js to sort numeric values
          correclty with separators (thanks to Josh W, China)
* (beta1) only 3 decimals are shown on numeric values columns
* (beta1) null TO field in Jobs causes them to launch an
          exception when attempting to delete
* (beta1) Xml Lov does not parse & and other special chars

(2008 01 30) - ART 1.8

Enhancements:
 * (final) date params and dynamic offset from current date
 * (final) cache setting not properly handled in mobile section
 * (beta3) art_tables.sql contained garbage
 * (beta3) default value in multiple params
 * (beta2/pre1) editable subject and html code body on scheduled jobs email
 * (beta2/pre1) jobs can send results in email body (inline)
 - removed(beta2) support for multiple statements in an object since
   some drivers do not support it and throw exception
 * (beta2) preliminary mobile device support (go to http://your_server/art/mobile)
 * (beta2) logs go on ART_LOGS table
 * (pre1) urls for public_user changed (does not use http redirect)
 * improvements in various classes and code clean up
Bug Fixes:
 * (beta2) tooltips on charts misplaced in firefox (by desand)
 * (beta2) xml was not parsing special charts (by vde75)
 * hyperlinks in Categories and Pie charts (by desand)
 * (beta3) fix: dataSource double definition in ArtDBCP.java prevented
           login if no datasources are defined
 * (beta3) fix for utf-8 (was broken in beta1&2)
 * art date line chart now works
 * (pre1) upgrade to jfreechart 1.0.5 to solve thread issues
 * (pre1) in reportize output, number of line reported was alwasy 0
 * (pre1) fonts size error on reportize output
 * (in IE only) when executing graphs, IE spinning icon stops
 * (pre1) text objects are now non editable in textarea by admin
 * direct access to /user/QueryExecute by appending _public_user
   to be able to direct access pages producing files

(2006 09 06) - ART 1.7

 * Spinning icon when Ajax components run
 * Multi series graphs (Category, Time/Date)
 / (2006 06 22) - ART 1.7 pre release 1
 * PDF output for tabular/crosstab using iText
   (thanks to Marios Timotheou, NY USA)
 * PDF output for charts using iText
 * Stacked graphs, bug fix on time/date axis range 
 * Jdbc url size increased
 * Preliminary Chinese translation
   (thanks to Lorenz Chi, Taiwan)
 / (2006 06 02) - ART 1.7 beta2
 * Portlets Containers can be dynamically driven by parameters
 * New html data grid layout with dhtml sortable table
 * Improved Error Logging
 * Improved Graph (cewolf 1.0+option to hide labels/legend)
 * Removed absolute urls (can deployed with a different path)
 * Improved Excel output (updated poi)
 * Improved layout
 * Trust Servlet Container authentication
   (thanks to David Lafay, ?)
 * Small bug fixes
 / (2006 04 25) - ART 1.7 beta1 
 * Chained parameters
 * Lov params now support dynamic sql/tags
 * Date params improved
 * Support to display params values on result page
 * Improved Encoding Utf-8 support (excel/ajax)
   (thanks to Lorenz Chi, Taiwan)
 * Small SQL code updates for Postresql
   (thanks to Dirk Leser, ?)

(2006 03 10) - ART 1.6 rev3

 * included hsqldb Art repository example
 * minor fixes for IE javascript bug w/ AJAX 
 * resource boundle for html report fixed
 * you can include xls/spreadhseet output in 
   Portlets container

(2006 03 09)

 * hsqldb repository for Art 1.6 available
   from the install page link.

(2006 02 28) - ART 1.6 rev2

 * Small fixes to allow ART to run on
   Jetty - OC4J - Tomcat 4

(2006 02 27) - ART 1.6

 * Refresh/Onload fix for portlets container
 * UTF-8 support improved
 * External Auth support (LDAP, Win Domain, DB)
 * Single login for users and admins
 * Skins and logo
 / (2006 01 28) - ART 1.6-pre2 
 * Enhancement on portlets container (refresh/onload)
 * Cache expire issue in IE fixed
 * Various minor bug fixes
 * art dbcp 2.0
 / (2006 01 16) - ART 1.6-pre1 
 * Portlets Containers
 * Text objects
   (tinymce.moxiecode.com)
 * UTF-8
 * Ajax components
   (ajaxtag.sourceforge.net)
 * Big SQL support (fix)
   (thanks to Giacomo Ferrari, Italy)
 * Allow multiple :TAGS (fix) 
   (thanks to Andrea Mirandola, Italy)
 * French translation - user part
    (thanks to Eric Lemerse, France)
 * Italian translation - user part
 * Major design changes (thanks for the huge code
   contribution to Valentin, Romania)
 * Support for CLOB, DECIMAL
 * Uses ant to compile
 * Minor bug fixes and layout changes

(2005 03 12) - ART 1.5

 * Dynamic SQL support
 * inline parameters
 * html, tsv and xml can be scheduled 
   (in addition to xls and slk)
 * Removed over complex logic to handle sessions
 * i18n support on user part (only english
   available now - ready to host more languages) 
 * Fix to work on Resin AS 
 * Fix on crosstab cast exception 
 * Fix memory leak on class loading 

(2005 01 16) - ART 1.4

 * Fixed result set not properly closed in QueryExecute servlet
   (thanks to Viktor Kleine from Brazil for debug&suggestions) 
 * Non html output can be flushed directly to the browser
   (the mime content type is now declared by the object that
    generates the output - see new artOutputInterface API)
 * Basic XML output available 
 * Crosstab output can display non numeric values
 * Improved Exception logging
 * Fixed the bug "when scheduling a query, the query
   is executed on the target database"

(2004 12 12) - ART 1.3

 * Crosstab output can have an alternate sort option
 * Fix getRealPath() usage and added commons-logging.jar 
   (thanks to Henrik Ring from Denmark for debug&suggestions)
 * Exceptions on job execution are logged and displayed
 * Fixed a bug on date timeseries graph (now it works)
 * Parameters can be sorted
 * jcifs classes are not part of the war file anymore
   go to jcifs.samba.org and include the jcifs-x.y.z.jar
   in the path to use NT authentication
 * mail.jar and activation.jar are now part of the war file

--(2004 11 01) 

 * ART development moved to Tomcat 5 as engine reference
 * Once a bind parameter is deleted, the next ones are
   now re-ordered correctly to match the right '?' char
 * Tested with Jetty servlet engine
 * Fixed exception on servlet Scheduler.destroy()
 * Fixed exception that may arise during in the first 
   connection performed by an administrator (autocommit set
   to false).



--(2004 10 30) - ART 1.2.0

 * New Admin Privileges option from the Admin Console
   to limit datasources and groups and admin can deal with
 * Improved Installation and Scheduling
 * Fixed broken links in Bar graphs



--(2004 09 18)

 * New Time graph (Timestamp)
 * New :DATE (yyyy-mm-dd) and :TIME (yyyy-mm-dd hh:mi:ss) tags
 * Option to have only html view mode



--(2004 09 05) - ART 1.1.0

 * ART schedule option: reports can be scheduled to run
   and be e-mailed, published etc.
 * CrossTab output, new top bar menu
 * One array of pools is shared between all servlets
 * Tested with HSQLDB as ART repository



--(2004 06 20)

 * QueryExecute rewrite
 * Admin Datasource refresh updated
 * Enhancements on admin part



--(2004 02 22) - ART 1.0.0

 * ART can do simple graphs [thanks to jfreechart/cewolf projects]:
   pie 3d, bar 3d, line, xy, timeseries supported
 * Api published for art graphs.
 * Enanched Admin part
 * Small fixes for achieving compatibility with Oracle 10g AS
   on getServletContext() use
 * artdb and artGraph are under LGPL licence 
 * Manual reviewed (thanks to Julian Clamp, UK)



-- (2003 02 04)

 * ART project on sourceforge



--(2004 01 04)

 * Major Rewrite: plugin mechnism for output view
 * Api published for artdb enhanced connection pool
 * Nicer html




--(2003 10 26)
 * ART can be used to Insert/Update data in a database.
   Just create and INSERT statement instead of a SELECT
   one.
 * The string :USERNAME in a statement:
   it will be substituted by the user name it is
   launching the statement
 * tsv and tsv zip nullpointer exception
   with null column is filxed




--(2003 10 18)

 * ART connects to DB2 on AS/400 !
 * Various .css files available to modify
   art colors (art.css)
 * Parsing on tsv output to
   avoid linebreak and other special chars
 * New view mode slk
 * Fixed bug on query creation (allocation)
 * Changed javascript code on query execution
   to avoid some version of IE to stop load page
   (Mozilla was ok, as usual).
 * Fixed a bug that deny admin to edit art params
   if art database is not available
 * Minor html and internal changes



--(2003 07 20)

 * It is possible to execute a public query passing
   the parameters via URL (without parameters page)



-- (2003 07 02)

 * Simil-plugin mechanism for Output handlers (view mode)
 * Query can have a status
 * Users can have a status
 * Fixed a missed commit on parameters update



-- (2003 06 06)

 * Fixed connection pool closing on servlet destroy
 * Responsible Attribute added to query header



-- (2003 05 25)

 * Small html changes, manuals review



-- (2003 04 13)

 * Option to allow users to exec any query in the group
   they as been granted to or to restrict at query level
   (default) 
 * Update Date when creating a new query



-- (2003 03 12)

 * Code clean-up

 * Performance improvments

 * css (customization)



-- (2003 02 26)

 * NT Authentication [thanks to samba.org JCIFS project]

 * Internal users may autochange their password

 * Better exception handling if users has not a rule

 * Small fixes on LOOKUP rule input forms



-- (2003 01 10)

 * Admin part enanched, no more need to edit web.xml
   file for specifying properties (ART repository etc)

 * Admin and Installation manual drafts



-- (2002 12 18)

 * Query creation part enanchment

 * Installation procedure is now well-defined



-- (2002 11 12)

 * Live status of database pool connections

 * User manage part rewritten

 * Security manage part rewritten



-- (2002 10 22)

 * GZIP output available (tsv or xls are stramed in a gzip
   file)



-- (2002 08 20)

 * database connection pool implemented 



-- (2002 08 18)

 * manageQuery beta version 



-- (2002 02 18)

 * Simple Report Layout



-- (2002 02 14)

 * XLS (excel) export available [thanks to apache.org POI project]

 * Scrollable html table available




-- (2002 01 28)

 * Embedded feature to show queries within external web pages

 * One Database connection with timeout and fault recovery in Execute class

 * Multiple database support (idea: each query stores a link to the 
      databse url used to connect to the database. The logic
      dynamically use that URL to perform the connection. This allow
      a user "trasparent" access to several database 

 * Minor html changes



-- (2002 01 12)

 * Smart Rule 0.3 (LOOKUP)

 * View modes: Browser, Browser + SpreadSheet, Spreadsheet only

 * Max 20.000 rows in browser becouse of MSIE hang bug.

 * Log file reports several timings




-- (2002 01 06) 

 * User passwords are stored in an encrypted format (MD5 algorithm).
 * Changed file-StringBuffer size in order to avoid a null pointer exception
   whit big export table and HP java runtime
   Changed java.sql.Date definition to avoid use of the getTimeInMillis()
   protected value that generates errors with HP java runtime.
 * Created a ticket inside a session in order to run multiple
   connection from the same PC and browser.
 * Created JavaScript Code to handle number and date checks (but it
   has some bug)
 * Max number of queries running at time implemented
 * Wrong password reported on art_err.log file
 * Modified QueryParameter in order to build nice html fields
   for date class parameter
 * Modified QueryParameter and Query Execute to handle multiple
   select list of user selectable parameters
 * Access to log file is synchronized to avoid collision
 * Minor html changes
 * Converted varying String to StringBuffer to improve performance