Resultset to Xml File?

hai friends,

Now I got a requirement to produce XML files dynamically from the
RESULTSET I am getting by executing some queries.

But I have no idea about XML.
I found some codes which is helpful to me in xml generation.But they are all static.ie predefining the required tags.

Any one have some idea or sample codes.
waiting for fast response.

Ram Mohan.

You can use JDom for this. It will be vert simple to create an XML file form result set, use ResultSetMetaData to get the column name and use those names for tags, then iterate thru resultSet and create the XML file. I don't think this will take more than one hour..!!

Thank you Sanju

I will try.

Ram Mohan.

Still I couldn't overcome the hurdles.
Does anyone have some sample codes.

Ram Mohan.

Which database are you using? Some (such as SQL server) support returning results as XML.

This page has the JDBCSAXParser and JDBCInputSource code examples, which show how generate SAX events from a ResultSet. You can use those as starting points to build an XML document, either as a DOM tree in memory, or by writing directly to a file.

First of all thankx for caring

ans 1: I am using Sql Server database.
ans 2: Iwill look through the link.Thank you

Ram Mohan.

If you append "FOR XML RAW" to your sql query your results will be returned as an XML String. Creating a Document from this is trivial. However, if you need more control over the structure of the XML you produce look at the link Ulf has posted (which is worth doing anyway, regardless of how you decide to create your XML document)

Paul,
Its a new idea over sql I ever got.
It will make some sense.
Thank you.

Ram Mohan.

Hi Ram mohan!
You could use Rowset Objects instead of Result set for that u need "rowset.jar" file in ur class path. It can solve ur problem very easily in the RowsetObjects u can find one of the type is Webrowset Object it will automatically generate XML file for ur resultent Resultset.

Enjoy the java world
Ganga raju.

I have an open source project called the FormattedDataSet that creates text (including html, csv, xml,...) from any tabular data (including ResultSets, arrays, Collections). In general it is flexible and easy to work with. You have total control of what text is generated.

Look at www.fdsapi.com. From here you can see sample code and look at the live demo.

Here is some sample code. Note you can pass queries or ResultSets or arrays and all will generate the text.

import com.fdsapi.*;
 
ResultSet rs = ...;
ResultSetMetaData rsmd = rs.getMetaData();
String[]header = ..;
Object[][] data = ...;
 
FormattedDataSet fds = new FormattedDataSet();
 
// The FormattedDataSet works on the simple concept that you pass in 'data' 
// and 'formatting' (templates).  Data can be formatted with different
// templates, and templates can be reused with different data.
 
String html = fds.getFormattedDataSet(rs.getMetaData(), rs, "htmlTable");
html = fds.getFormattedDataSet("select * from table", "htmlTable");
html = fds.getFormattedDataSet(header,data, "htmlTable");
 
String xml = fds.getFormattedDataSet(rs.getMetaData(), rs, "xml");
xml = fds.getFormattedDataSet("select * from table", "xml");
xml = fds.getFormattedDataSet(header,data, "xml");
 
String csv = fds.getFormattedDataSet(rs.getMetaData(), rs, "csv");
csv = fds.getFormattedDataSet("select * from table", "csv");
csv = fds.getFormattedDataSet(header,data, "csv");
 
String yourFormatting = fds.getFormattedDataSet(rs.getMetaData(), rs, "yourFormatting");
yourFormatting = fds.getFormattedDataSet("select * from table", "yourFormatting");
yourFormatting = fds.getFormattedDataSet(header,data, "yourFormatting");

[ December 22, 2005: Message edited by: steve souza ]

Thank You STEVE,
Surely I will look through it.

Ram Mohan.