making XML Doc from JDBC Results

[Sivaraman Lakshmanan]

HAi all,
How to make a XML Document from the data got by a SQL Query using JDBC.
I have heard people saying that once the data got is converted in to a XML Doc it is esaily portable to various applications.
Thanks
siva.

[David O'Meara]

First of all it sounds like you're heading towards an XML solution without a clear need for it. Make sure you need it before you use it!
There are probably multiple ways to do it, but for ease of use I like castor. It is object-centric, but provides both object to database and object to xml mappings. Therefore you need to load data as objects then convert to XML rather than going directly to XML, but it's easy to use and maintain.
Dave

[Gregg Bolinger]

Moving to XML.