Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Migrating data from XML file to Sybase tables

 
arnav prateek
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • 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
 
Clifton Craig
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
  • 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
  • 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
 
Balaji Loganathan
author and deputy
Bartender
Posts: 3150
  • Mark post as helpful
  • send pies
  • 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
  • Quote
  • Report post to moderator
Thanks Balaji
 
Clifton Craig
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic