aspose file tools*
The moose likes JDBC and the fly likes How to convert a resultset to XML file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to convert a resultset to XML file" Watch "How to convert a resultset to XML file" New topic
Author

How to convert a resultset to XML file

Kiran Baratam
Greenhorn

Joined: Sep 03, 2003
Posts: 27
Hello All
I am trying to convert the data retrived from a result set object to an XML file.
One way i can think is to get the column names.Then loop through with column names as xml tags with a start tag and end tag.
I wanted to know is there any other way where we can pass the resultset object and get an xml file.
Regards
Kiran
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1134

Hi Kiran,
Although I have no experience with them, myself, I believe that Oracle has some products/utilities with this functionality. Have you looked around their Technet Web site?
(Even though you may not be using Oracle, you may find some helpful ideas, no?)
Good Luck,
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to convert a resultset to XML file