This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 1121

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
 
Similar Threads
Database to XML convertion
Database to XML
ResultSet into XML-File ?
Resultset to Xml File?
Rowcount in Resultset