JDBC resultset to XML

Originally Posted by chella

Hi All,

Is it possible to convert the JDBC resultset to XML format?

If it is possible can please help me as how I have to proceed in doing it in java?

Thanks in advance,
Chella

Originally Posted by dmjpro

You can do it using Simply using XML file specification and "File I/O".
You know XML buddy?
If you don't know then you need to have "Third Party Jar".
If you are using Oracle Application Server then use "OracleXMLQuery".

Debasis Jana

Originally Posted by chella

Thank you very much for the reply

After googling I found the following link...

http://www.developer.com/db/article.php/3329001

I have planned to proceed in the same way as given in the link. Is there any problem in doing it so?

Thanks in advance,
Chella.

Originally Posted by dmjpro

Check it yourself buddy.
Come with another problem if you have it in future ...
But you should need that "Third Party Jar".
Happy to see that you find your solution.

Debasis Jana

Originally Posted by chella

Hi,

I managed to obtain the XML file from the JDBC resultset. But I want to convert it into HTML through XSL.

I have the XML file in hand. Can you please suggest me the ways in converting the XML file to XSL and then to HTML?

Thanks in advance,
Chella