GeeCON Prague 2014*
The moose likes XML and Related Technologies and the fly likes making XML Doc from JDBC Results Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "making XML Doc from JDBC Results" Watch "making XML Doc from JDBC Results" New topic
Author

making XML Doc from JDBC Results

Sivaraman Lakshmanan
Ranch Hand

Joined: Aug 02, 2003
Posts: 231
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
Rancher

Joined: Mar 06, 2001
Posts: 13459

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
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

Moving to XML.


GenRocket - Experts at Building Test Data
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: making XML Doc from JDBC Results