File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

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.
David O'Meara

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

Joined: Jul 11, 2001
Posts: 15302

Moving to XML.

GenRocket - Experts at Building Test Data
I agree. Here's the link:
subject: making XML Doc from JDBC Results
It's not a secret anymore!