Meisam,
You're welcome. I agree, you're 1st and biggest task will be to
figure out the mapping. This may or may not be at all
straight-forward, depending on the particular DOM and the RDBMS
involved and whether or not you are free to design/redesign one or
the other for your purposes.
Once you've solved this puzzle, you can then employ XMLBeans to
implement whatever mapping approach you come up with, and it'll
probably be a piece of cake next to what you've already done!
Cheers, Albert
At 02:25 PM 10/22/2007, meisam.sarabadani wrote:
Dear Albert
thank you for your tips, I think I have to come up with the way to map my
DOM tree to Relational tables first, using XMLBeans or writting the code
myself does not make much of differences to me about solving the mapping
problem, my problem is the way of mapping the DTD element or DOM tree into
RDBMS.
Albert Bupp wrote:
>
> If I may jump in, I think what Gustavo means is you could use the
> scomp utility included in the XMLBeans package to generate Java
> classes representing the XML data that you want to populate your
> RDBMS. This utility generates and compiles (and jars) a set of Java
> class files which correspond to the schema (an XSD or DTD file)
> defining the XML structure you're using. Based on, and accessible via
> the XMLBeans library, they allow you to easily and naturally iterate
> through the XML data in Java.
>
> Then using the interfaces provided by the generated lib, you can
> write Java code which inserts the data into an RDBMS using JDBC or
> some other framework such as Hibernate. You will still have to do the
> work of figuring out how you want to map the XML data model to the
> relational one. There are tools libraries which specifically address
> the issues of moving data from one model to the other, but they are,
> I believe, separate from and outside the scope of XMLBeans proper.
>
> Regards, Albert
>
> At 03:35 PM 10/21/2007, you wrote:
>
>>would you mind explaining more a bit ? what do you mena by generating xml
?
>>xml is there already, I mean I am going to insert a valid xml into rdbms,
>>what do you mean by saying generating the xml ?
>>persistence framework like hibernate ? is that easy to use the hibernate ?
>>or any other frmaworks ?
>>
>>can you please explain more ?
>>
>>
>>Gustavo Aquino wrote:
>> >
>> > Xmlbeans generate a xml to you based on classes , to put this in rdbms
>> > you can use any persistance framework or direct under jdbc
>> >
>> > Gustavo de Aquino
>> >
>> > On Oct 21, 2007, at 4:08 PM, meisam4910 <[EMAIL PROTECTED]>
>> > wrote:
>> >
>> >>
>> >> Hi guys,
>> >> I am new to XMLBean, does XMLBean help to insert XML document into
>> >> RDBMS ?
>> >> I need to insert an XML Document into RDBMS, and put the nodes of
>> >> the XML
>> >> Documents into the tuples and relational tables, is this work
>> >> possible with
>> >> XML Bean ? is tere any sample code something like I am looking for ?
>> >> please
>> >> help me if you know anything about it, I really appreciate it.
>> >> --
>> >> View this message in context:
>> >>
>>
http://www.nabble.com/Inserting-XML-Document-into-Relational-Tables-of-RDBMS-tf4666896.html#a13331532
>> >> Sent from the Xml Beans - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >> ---------------------------------------------------------------------
>> >> 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]
>> >
>> >
>> >
>>
>>--
>>View this message in context:
>>http://www.nabble.com/Inserting-XML-Document-into-Relational-Table
s-of-RDBMS-tf4666896.html#a13332429
>>Sent from the Xml Beans - User mailing list archive at Nabble.com.
>>
>>
>>---------------------------------------------------------------------
>>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]
>
>
>
--
View this message in context:
http://www.nabble.com/Inserting-XML-Document-into-Relational-Tables-of-RDBMS-tf4666896.html#a13349697
Sent from the Xml Beans - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
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]
