Inserting XML Document into Relational Tables of RDBMS

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: user-unsubscribexmlbeans.apache.org
For additional commands, e-mail: user-helpxmlbeans.apache.org

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
<meisam.sarabadanigmail.com>  
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: user-unsubscribexmlbeans.apache.org
> For additional commands, e-mail: user-helpxmlbeans.apache.org
>

------------------------------------------------------------
---------
To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
For additional commands, e-mail: user-helpxmlbeans.apache.org

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
<meisam.sarabadanigmail.com>  
> 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: user-unsubscribexmlbeans.apache.org
>> For additional commands, e-mail: user-helpxmlbeans.apache.org
>>
> 
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
> For additional commands, e-mail: user-helpxmlbeans.apache.org
> 
> 
> 

-- 
View this message in context: http://www.
nabble.com/Inserting-XML-Document-into-Relational-Tables-of-
RDBMS-tf4666896.html#a13332429
Sent from the Xml Beans - User mailing list archive at
Nabble.com.


------------------------------------------------------------
---------
To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
For additional commands, e-mail: user-helpxmlbeans.apache.org

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
<meisam.sarabadanigmail.com>
> > 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: user-unsubscribexmlbeans.apache.org
> >> For additional commands, e-mail: user-helpxmlbeans.apache.org
> >>
> >
> >
------------------------------------------------------------
---------
> > To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
> > For additional commands, e-mail: user-helpxmlbeans.apache.org
> >
> >
> >
>
>--
>View this message in context: 
>http://www.
nabble.com/Inserting-XML-Document-into-Relational-Tables-of-
RDBMS-tf4666896.html#a13332429
>Sent from the Xml Beans - User mailing list archive at
Nabble.com.
>
>
>--------------------------------------------------------
-------------
>To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
>For additional commands, e-mail: user-helpxmlbeans.apache.org



------------------------------------------------------------
---------
To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
For additional commands, e-mail: user-helpxmlbeans.apache.org

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
<meisam.sarabadanigmail.com>
>> > 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:
user-unsubscribexmlbeans.apache.org
>> >> For additional commands, e-mail:
user-helpxmlbeans.apache.org
>> >>
>> >
>> >
------------------------------------------------------------
---------
>> > To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
>> > For additional commands, e-mail: user-helpxmlbeans.apache.org
>> >
>> >
>> >
>>
>>--
>>View this message in context: 
>>http://www.
nabble.com/Inserting-XML-Document-into-Relational-Tables-of-
RDBMS-tf4666896.html#a13332429
>>Sent from the Xml Beans - User mailing list archive
at Nabble.com.
>>
>>
>>----------------------------------------------------
-----------------
>>To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
>>For additional commands, e-mail: user-helpxmlbeans.apache.org
> 
> 
> 
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
> For additional commands, e-mail: user-helpxmlbeans.apache.org
> 
> 
> 

-- 
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: user-unsubscribexmlbeans.apache.org
For additional commands, e-mail: user-helpxmlbeans.apache.org

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
<meisam.sarabadanigmail.com>
> >> > 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:
user-unsubscribexmlbeans.apache.org
> >> >> For additional commands, e-mail:
user-helpxmlbeans.apache.org
> >> >>
> >> >
> >> >
------------------------------------------------------------
---------
> >> > To unsubscribe, e-mail:
user-unsubscribexmlbeans.apache.org
> >> > For additional commands, e-mail:
user-helpxmlbeans.apache.org
> >> >
> >> >
> >> >
> >>
> >>--
> >>View this message in context:
> >>http://www.nabble.com/Inserting-XML-Document-i
nto-Relational-Table 
> s-of-RDBMS-tf4666896.html#a13332429
> >>Sent from the Xml Beans - User mailing list
archive at Nabble.com.
> >>
> >>
>
>>----------------------------------------------------
-----------------
> >>To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
> >>For additional commands, e-mail: user-helpxmlbeans.apache.org
> >
> >
> >
> >
------------------------------------------------------------
---------
> > To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
> > For additional commands, e-mail: user-helpxmlbeans.apache.org
> >
> >
> >
>
>--
>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: user-unsubscribexmlbeans.apache.org
>For additional commands, e-mail: user-helpxmlbeans.apache.org



------------------------------------------------------------
---------
To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
For additional commands, e-mail: user-helpxmlbeans.apache.org

yeah

I agree too. 
anyways, thank you

Albert Bupp wrote:
> 
> 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
>> <meisam.sarabadanigmail.com>
>> >> > 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:
user-unsubscribexmlbeans.apache.org
>> >> >> For additional commands, e-mail:
user-helpxmlbeans.apache.org
>> >> >>
>> >> >
>> >> >
>>
------------------------------------------------------------
---------
>> >> > To unsubscribe, e-mail:
user-unsubscribexmlbeans.apache.org
>> >> > For additional commands, e-mail:
user-helpxmlbeans.apache.org
>> >> >
>> >> >
>> >> >
>> >>
>> >>--
>> >>View this message in context:
>> >>http://www.nabble.com/Inserting-XML-Document-i
nto-Relational-Table 
>> s-of-RDBMS-tf4666896.html#a13332429
>> >>Sent from the Xml Beans - User mailing list
archive at Nabble.com.
>> >>
>> >>
>>
>>----------------------------------------------------
-----------------
>> >>To unsubscribe, e-mail:
user-unsubscribexmlbeans.apache.org
>> >>For additional commands, e-mail:
user-helpxmlbeans.apache.org
>> >
>> >
>> >
>> >
------------------------------------------------------------
---------
>> > To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
>> > For additional commands, e-mail: user-helpxmlbeans.apache.org
>> >
>> >
>> >
>>
>>--
>>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: user-unsubscribexmlbeans.apache.org
>>For additional commands, e-mail: user-helpxmlbeans.apache.org
> 
> 
> 
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
> For additional commands, e-mail: user-helpxmlbeans.apache.org
> 
> 
> 

-- 
View this message in context: http://www.
nabble.com/Inserting-XML-Document-into-Relational-Tables-of-
RDBMS-tf4666896.html#a13350649
Sent from the Xml Beans - User mailing list archive at
Nabble.com.


------------------------------------------------------------
---------
To unsubscribe, e-mail: user-unsubscribexmlbeans.apache.org
For additional commands, e-mail: user-helpxmlbeans.apache.org