XSD Generation in Java using data available in the database.

[Dilip H Pashupathi]

Hi,

I have a scenario were we need to generate XSD using the data in the database. The need is I have table were the tags are stored as row. From them i need to generate an XSD. Each row in the data base table represents a xml tag consisting of tag type as simple or complex, their occurence, data type, length and all. From these tags a generalized XSD need to be created.

Please tell me is there any way of doing this without using the JAXB as the application is not going support JAXB operations. I need a simple java program for this.



Thanks and regards
Dilip H Pashupathi

[Ulf Dittmer]

Why do you need a "simple" program for this? Trying to reverse-engineer a schema is not an easy task, particularly if the data isn't even XML, but is structured in a completely different way. I'm not aware of a tool that does this, but searching for "xml schema reverse engineer database" brings up a number of results.

[Dilip H Pashupathi]

Hi Sir,

That is my exact requirement. I have a data base that needs be created in terms of xml schema definition. This i have to do with the help of java code. I want to know is there a way. I have searched as you suggested and found one result. But I have a tight schedule so I was looking for a solution that would help me in generating xsd out of database.

Thanks and Regards
Dilip H Pashupathi