• 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
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Bear Bibeault
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh

Migrating data from XML file to Sybase tables

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

I have data in XML format, I have to migrate all these data into Sybase table. XML structure is very simple.
IS there any way to directly upload these data from XML file to Sybase tables?

Thanks in advance.

Regards
 
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Check out my post here on a Groovy way to go from XML to SQL inserts. All you need to do is download the Groovy package and use the 4 or 5 lines of code from my topic, slightly modified for your own use and you'll have an easy solution to parse and load data. Learn Groovy in the process. It's what I believe to be one of the strongest scripting languages available for Java.

*Edited 6/6/06 to fix broken link.
[ June 06, 2006: Message edited by: Clifton Craig ]
 
arnav prateek
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Craig,

Thanks for your advice but I am unable to access Hyperlink 'my post' and where I can get this Groovy package..
Looking to hear from you ASAP.

Regards
 
author and deputy
Posts: 3150
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by arnav prateek:
Hi Craig,

Thanks for your advice but I am unable to access Hyperlink 'my post'



Here is the link http://codeforfun.wordpress.com/2006/06/05/groovy-xml-and-sql/
 
arnav prateek
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Balaji
 
Clifton Craig
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
My apologies for the broken link, and thanx Balaji for pointing him in the right direction. For what it's worth I fixed the broken link.
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic