Đã Hủy

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;

it is a procedure that populate a database; no front end.

Centos – Kernel [url removed, login to view]

Apache: 2.2.3

Tomcat: [url removed, login to view]

Java: 6u26

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.

Kỹ năng: Apache, Java, MySQL, Kiến trúc phần mềm, Thiết kế trang web

Xem thêm: database import xml java, java xml, java import database xml, website design procedures, website design procedure, steps to write a report, populate xml from database, mapping document, centos website, care connection, word for not obvious, xml to word, sql import, sql database report, procedure of create website, kernel, java debug, import XML, import sql, import mysql, find an url from a website, document database, database queries, database no, front end database design

Về Bên Thuê:
( 91 nhận xét ) Cairo, Egypt

Mã Dự Án: #1682328

12 freelancer đang chào giá trung bình $236 cho công việc này

samitXI

Please check your inbox. Thanks

$500 USD trong 5 ngày
(84 Đánh Giá)
6.1
buzzcoder

Hi, kindly check your pm for more enquiries, thanks.

$250 USD trong 7 ngày
(44 Đánh Giá)
5.5
poornachand

Understood. Please check PM.

$225 USD trong 7 ngày
(26 Đánh Giá)
5.1
Celoks

Please check pm. Thanks

$300 USD trong 7 ngày
(16 Đánh Giá)
5.1
huzaifaatlancer

hi, Please check you pm!

$200 USD trong 5 ngày
(2 Đánh Giá)
2.5
santoshsoftware

Hi, I have understood your requirement and I can develop this component including testing and free future bug fixing service within 9 days.

$50 USD trong 9 ngày
(2 Đánh Giá)
2.5
iLikeOOP

Understood. Looks like a interesting project. Here are my considerations. You could make a simple servlet in WAR that runs under Tomcat. For each request, you could read the XML with XPath and perform the required Thêm

$250 USD trong 8 ngày
(0 Đánh Giá)
0.0
himanshu2703

Hello Sir, I have gone through your requirement and find that my profile is best suitable for this project. I have done a lot of work on XML parsing using JAXP and JAXB java apis. I have also good knowledge of Mysql Thêm

$180 USD trong 10 ngày
(0 Đánh Giá)
0.0
sivainf

Greetings! I have good exposure in java development, handled many projects similar to this batch process. Please check my private message.

$250 USD trong 6 ngày
(0 Đánh Giá)
0.0
nileshkumbhar

"Understood". I have got more than 5 years of experience in Java/J2EE development. can handle this effectively. Please check PMB.

$200 USD trong 5 ngày
(0 Đánh Giá)
1.0
ssureshkesavan

Hi, I am Suresh from India,Chennai and having 10 years of experience in Java/J2EE,Spring and Web Services Technologies I have worked in several reputed organization such as Paypal , IBM etc,. Currently I am working Thêm

$250 USD trong 5 ngày
(0 Đánh Giá)
0.0
sivprasad81

I have around 6 years of Java development experience worked with Washington National Insurance Company (CNO Financial Group.) Worked on similar projects, synchronized ACORD standard XML files into DB using SAX Parse Thêm

$180 USD trong 6 ngày
(0 Đánh Giá)
0.0