Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Tim Moores
  • Carey Brown
  • Mikalai Zaikin
Bartenders:
  • Lou Hamers
  • Piet Souris
  • Frits Walraven

xml conversion

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I need a help on XML parsing. My requirement is 1. read an XML file and has to create a database(MYSQL) table, based on the XML structure. 2. Need to insert the parsed XML file data into that table. XML file size will be 1+ MB. 3. XML file structure will be changed thoroughly, So, Table should be created programmatically. No manual changes again. Could anyone help me on this.
The XML structure will be like this.

Thanks,
Raj
raj786_bangalore@yahoo.co.in
 
Author and all-around good cowpoke
Posts: 13078
6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How far have you gotten in this project? Do you know how to parse an XML document with DOM or SAX methods? If not you should find a tutorial and start simply. Worry about the database side after you are comfortable with parsing.

Harold's VERY complete book is available online for free.

Bill
I see that you have asked this question several times - WHY? Are you expecting somebody to hand you a complete solution?
[ June 07, 2008: Message edited by: William Brogden ]
 
reply
    Bookmark Topic Watch Topic
  • New Topic