File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes XML and Related Technologies and the fly likes Migrating data from XML file to Sybase tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "Migrating data from XML file to Sybase tables" Watch "Migrating data from XML file to Sybase tables" New topic
Author

Migrating data from XML file to Sybase tables

arnav prateek
Greenhorn

Joined: Apr 06, 2006
Posts: 17
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

Joined: May 26, 2006
Posts: 103
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 ]

Holla at me...<br /><a href="http://codeforfun.wordpress.com" target="_blank" rel="nofollow">http://codeforfun.wordpress.com</a>
arnav prateek
Greenhorn

Joined: Apr 06, 2006
Posts: 17
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

Joined: Jul 13, 2001
Posts: 3150
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/


Spritle Software Blogs
arnav prateek
Greenhorn

Joined: Apr 06, 2006
Posts: 17
Thanks Balaji
Clifton Craig
Ranch Hand

Joined: May 26, 2006
Posts: 103
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Migrating data from XML file to Sybase tables
 
Similar Threads
Oracle very slow than sybase when there is multiple joins among tables
Sybase Database to XML
XML/XSD to Database using Java
Extract db data into a XML
Inserting XML to mysql