How to create xml file using servlets from database data?

[kkji]

hi all,
How to create xml file using servlets from database data?

Please guide how can I create xml file which is based on dtd to create database item using Java program.

[Tolls]

That is so short on information as to be next to useless.

What are you trying to do?
Where is the data you are turning into XML?
What does "create database item" mean?

[kkji]

=> I have to create a xml fiel
=> data is database from their data has to be populated in xml file.
=> database field value is mean by database item.

[kkji]

=> I have to create a xml file
=> data is database from their data has to be populated in xml file.
=> database field value is mean by database item.

[Tolls]

I have a feeling this is too large (or vague) a thing for someone to deal with here.

All I can say is, get the data from the database and build your XML based on that and the DTD.
Oracle underdtands XML, so if you were using Oracle you might be able to do almost all this in that rather than Java.

[kkji]

I have ms-sql server.

[Tolls]

Then either see if MS-SQL does it, or hand craft it based on your DTD.

[kkji]

Thanks, do we have any good package for xml (like dom or sax). Please suggest?