Hi,
I am working on a project where we have to define database tables and data in XML, have it validated by an XML Schema and have it loaded into the database. We are using our EJBs to load the data into the database so I am not so concerned with that. What I am concerned with is generating a correct XML Schema from the Database tables.
Are there any tools/utilities that I can use to generate an XML Document, XML Schema or both from my Postgres Database?
Reason I ask is that if we can generate the XML Schema automatically from our database schema it will mean that we can have our XML validation rules driven from our database schema. It would also mean that once the database tables change we can change the XML Schema very easily rather then having to manually update the XML schema by hand.
Any information on Database TO XML/XML Schema and XML to Database Utilities would be very useful. I have already used the utilities at http://www.hitsw.com/xml_utilites/index.html. Also, any utilities suggested must be under a GPL license.
I have looked through the archives and have not found any utility, but did find a thread talking about the creation of an XML utility like the one that I am looking for.
Any help much appreciated.
thanks,
Richie.
