Database import from XML documents (database synchronization)

We need java classes that, once a day , uses XML documents to populate a MYSQL database. The XML documents are created by other procedures outside this project. Every XML file contains N records; the classes must insert/update/delete the right records on the Mysql tables; Please read advanced project options. ## Deliverables The classes must : * Be written in JAVA6; installed on a TOMCAT enviroment * Use a TOMCAT pool connection provided * Use XML documents found in a specific location (on local filesystem or to be downloaded from spedific URL) * Elaborate the XML document, one XML object = one table record. * Download images set in XML fields from specific URLS, resize images, save them in specific BLOB fields * Delete records present in database tables but not present in XML file any more. XML documents have 'last modified date and time' information * Check if the XML document has to be elaborated (i.e. has an 'account' record on a specific table); not all file must be elaborated. * Move XML documents in safe location after elaboration * Create a log for every operation (to easily debug) * Send an email on completion with a report * Use a file to set all the obvious parameters (directories, timeouts etc.) * Take care of specific (and obviously ) situations (records not found, filenames incorrected etc. etc.) * Every XML documents has a filename the contains the key to find the right records on the database. * There can be a maximum number of records, related to a specific 'account', that can be inserted in the tables We provide : * Help to fields mapping between XML fields and table fields. * SQL queries to create destination tables.