Link to home
Start Free TrialLog in
Avatar of Robinsonx6
Robinsonx6Flag for Mauritius

asked on

XML to SQL sychronisation

we have xml data being used within our java desktop application and what i need to know is the best way to sychronise this data with a live SQL server within a function.

i am creating my xml files ok from the sql datasource its just the xml to sql im stuck with

What is the best methodoligy please?

The most informative answer with code samples will get the points

Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of contactkarthi
contactkarthi
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Robinsonx6

ASKER

i have a class which holds my org.jdom.Document(s) throughout the lifesycle of the application

sample xml (simple)

<?xml version="1.0" encoding="UTF-8" ?>
  <!DOCTYPE xml (View Source for full doctype...)>
- <Regions>
- <Region>
  <CountyID>2</CountyID>
  <CountyName>County Antrim</CountyName>
  <CountryID>2</CountryID>
  </Region>
- <Region>
</Regions>
And what is your table structure like?
i have solved this question allready but thanks for your efforts