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: 1135

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.
 
Consider Paul's rocket mass heater.
 
subject: How to convert a resultset to XML file