Thanks Jose, as far as I know Jakarta`s digester, which packs with Struts distribution, allows to fill Java Objects from an XML source. Howevere I found the syntax quite cumbersome. For this task I find easier to use JAXB from Sun or Castor, even Quick.
My focus would be to save the time working out the database from myself and, taking advantage of some tool to create the DDL scripts which creates the DB themselves. My XSD bunch is pretty pretty large so it would be a long time consuming task put my hands on the database creation myself. I am looking for a process automathisms. I know the option that you comment but it is the one that I would like to skip. Neither doing the XSLT for my self. I wonder: must be SOMETHING that from the XSD or DTD creates the database, is no it? Both has info with same structure. Or we could make up the database to hold the data in the same structure that in the XML, we have the freedom. Does not the Open Source community offers any product or combination to handle this issue? As I tool before WSAD 5.0 does it, (over any XSD -> right mouse -> create DDL) but I can not make it work properly, probably because some bug. �? It hangs. :-( Advantages: as the XML that I want to generate reproduces database structure would be easy to fill DB from any XML or extract XML from DB without almost handling. You could say, ok use an XML DB, but I have already a relational one. Thanks, Adolfo Rodriguez. > -----Mensaje original----- > De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Enviado el: mi�rcoles 20 de agosto de 2003 13:55 > Para: [EMAIL PROTECTED] > Asunto: Re: creating DB from an XSD or XML > > Hi, Adolfo > > I�dont know any tool to make a DDL from a DTD. I�ve do itby hand. > Usuarlly, > a dtd maps against a unique table and it doesn�t so difficult. > > For extract xml we use digister (jakarta.apache.org/commons). It has a > good > works to map xml/object. > > My database has a table with the data, I use ojb to make persistence and > digister to map the xml. It�s easy. > > > Greetings > > Jose Galiana > Director de proyectos > Recursos en la Red, S.L.U. > > > From time ago I am loooking fo a way to do the following. > > > > Assuming that I have some kind of DTD or XSD for XMLs. I would like to > > create, a database, or DDL, to reproduce the DTD or XSD estructure in > > my database schema. Could be this done with an automathic procedure. In > > other words, is currently possible to create a database schema > > reproducing the structure of an XSD or DTD? Such a DTD or XSD would not > > be database aware at all. > > > > I am developing a web application focused for a kind of business which > > already has very well defined XML schemas and I would like to create > > the database following the same estructure, if possible, as an > > authomatic procedure, maybe with OJB, or OJB plus something.... It > > would easy me to receive XMLs from an external web service an > > automathically store them in DB, or the opposite make a valid XML > > conforming the DTD or XSD from my database assuming that both have same > > strutucture. > > > > TIA, > > > > Adolfo > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
