This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "How to convert a resultset to XML file" Watch "How to convert a resultset to XML file" New topic

How to convert a resultset to XML file

Kiran Baratam

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.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1138

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,
Have you checked out Aspose?
subject: How to convert a resultset to XML file
It's not a secret anymore!