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;
it is a procedure that populate a database; no front end.
Centos â€“ Kernel [url removed, login to view]
Tomcat: [url removed, login to view]
MySQL -- version(s): [url removed, login to view]
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.
Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.