Re: [xml-dev] XML to Oracle
by Jurgen other posts by this author
Mar 5 2002 7:58AM messages near this date
RE: [xml-dev] XML to Oracle
|
RE: [xml-dev] A good case for namespace URIs
--------------8BDDA30512284FD3ADA11E59
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Have a look at the Oracle Technology Network to find a suitable solution
using the Java XDK. You could use XSU or XSQL Servlet to load XML data into
your Oracle db.
Dipankar Chakrabarti wrote:
> We also had such requirement. We had parsed the XML
> file to create a loadable text file and used loader
> via simple Java program.
>
> Regards,
>
> Dipankar
> --- "Anderson, John" <John@[...].com> wrote:
> > Anand,
> >
> > You could try XSU, which comes free with Oracle.
> > We've successfully used it
> > for fetching data using a servlet which takes the
> > SELECT statement as a
> > parameter, but I don't know how well it works for
> > loading (ie, whether it
> > takes care of decisions like UPDATE vs INSERT.
> >
> > John
> >
> > -----Original Message-----
> > From: Anand M [mailto:anand_msm@[...].in]
> > Sent: 04 March 2002 18:01
> > To: xml-dev@[...].org
> > Subject: [xml-dev] XML to Oracle
> >
> >
> > Hi All,
> >
> > I have a customer requirement to get the data from
> > XML
> > formatted data file and load it into an Oracle 8
> > database. SQL*Loader doesn't support
> > this format and I'm not aware of any other means of
> > accomplishing this task. Does anyody have any
> > knowledge about the above issue? Please help me in
> > this regard.
> >
> > Thanks and Regards
> > Anand M
> >
> >
> >
> ________________________________________________________________________
> > Looking for a job? Visit Yahoo! India Careers
> > Visit http://in.careers.yahoo.com
> >
> >
> -----------------------------------------------------------------
> > The xml-dev list is sponsored by XML.org
> > <http://www.xml.org>, an
> > initiative of OASIS <http://www.oasis-open.org>
> >
> > The list archives are at
> > http://lists.xml.org/archives/xml-dev/
> >
> > To subscribe or unsubscribe from this list use the
> > subscription
> > manager: <http://lists.xml.org/ob/adm.pl>
> >
> > The information transmitted by this e-mail message
> > is intended solely for
> > the use of the person to whom or entity to which it
> > is addressed. The
> > message may contain information that is privileged
> > and confidential.
> > Disclosure, dissemination, distribution, review,
> > retransmission to, other
> > use of or taking any action in reliance upon this
> > information by anyone
> > other than the intended recipient is prohibited. If
> > you are not the intended
> > recipient, please do not disseminate, distribute or
> > copy this communication,
> > by e-mail or otherwise. Instead, please notify us
> > immediately by return
> > e-mail (including the original message with your
> > reply) and then delete and
> > discard all copies of the message.
> >
> > Although we have taken precautions to minimize the
> > risk of transmitting
> > viruses we nevertheless advise you to carry out your
> > own virus checks on any
> > attachment to this message. We accept no liability
> > for any loss or damage
> > caused by viruses.
> >
>
> =====
> DIPANKAR CHAKRABARTI
> My Home Page: www.geocities.com/dipanc
> Net-union homepage: www.geocities.com/dipanc/ScCollege1987.html
>
> __________________________________________________
> Do You Yahoo!?
> Try FREE Yahoo! Mail - the world's greatest free email!
> http://mail.yahoo.com/
>
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
>
> The list archives are at http://lists.xml.org/archives/xml-dev/
>
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://lists.xml.org/ob/adm.pl>
--------------8BDDA30512284FD3ADA11E59
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<br> Have a look at the <a href="http://otn.oracle.com/tech/xml/xdk_java/content.html">Oracle
Technology Network</a> to find a suitable solution using the Java XDK.
You could use XSU or XSQL Servlet to load XML data into your Oracle db.
<p> Dipankar Chakrabarti wrote:
<blockquote TYPE=CITE> We also had such requirement. We had parsed
the XML
<br> file to create a loadable text file and used loader
<br> via simple Java program.
<p> Regards,
<p> Dipankar
<br> --- "Anderson, John" <John@[...].com> wrote:
<br> > Anand,
<br> >
<br> > You could try XSU, which comes free with Oracle.
<br> > We've successfully used it
<br> > for fetching data using a servlet which takes the
<br> > SELECT statement as a
<br> > parameter, but I don't know how well it works for
<br> > loading (ie, whether it
<br> > takes care of decisions like UPDATE vs INSERT.
<br> >
<br> > John
<br> >
<br> > -----Original Message-----
<br> > From: Anand M [<a href="mailto:anand_msm@yahoo.co.in">mailto:anand_msm@[...].in</a>]
<br> > Sent: 04 March 2002 18:01
<br> > To: xml-dev@[...].org
<br> > Subject: [xml-dev] XML to Oracle
<br> >
<br> >
<br> > Hi All,
<br> >
<br> > I have a customer requirement to get the data from
<br> > XML
<br> > formatted data file and load it into an Oracle 8
<br> > database. SQL*Loader doesn't support
<br> > this format and I'm not aware of any other means of
<br> > accomplishing this task. Does anyody have any
<br> > knowledge about the above issue? Please help me in
<br> > this regard.
<br> >
<br> > Thanks and Regards
<br> > Anand M
<br> >
<br> >
<br> >
<br> ________________________________________________________________________
<br> > Looking for a job? Visit Yahoo! India Careers
<br> > Visit <a href="http://in.careers.yahoo.com">http:/
/in.careers.yahoo.com</a>
<br> >
<br> >
<br> -----------------------------------------------------------------
<br> > The xml-dev list is sponsored by XML.org
<br> > <<a href="http://www.xml.org">http://www.xml.org</a>>, an
<br> > initiative of OASIS <<a href="http://www.oasis-open.org">http://www.oasis-open.org<
/a> >
<br> >
<br> > The list archives are at
<br> > <a href="http://lists.xml.org/archives/xml-dev/">http://lists.xml.org/archives/xml-dev
/</a>
<br> >
<br> > To subscribe or unsubscribe from this list use the
<br> > subscription
<br> > manager: <<a href="http://lists.xml.org/ob/adm.pl">http://lists.xml.org/ob/adm.pl</
a> >
<br> >
<br> > The information transmitted by this e-mail message
<br> > is intended solely for
<br> > the use of the person to whom or entity to which it
<br> > is addressed. The
<br> > message may contain information that is privileged
<br> > and confidential.
<br> > Disclosure, dissemination, distribution, review,
<br> > retransmission to, other
<br> > use of or taking any action in reliance upon this
<br> > information by anyone
<br> > other than the intended recipient is prohibited. If
<br> > you are not the intended
<br> > recipient, please do not disseminate, distribute or
<br> > copy this communication,
<br> > by e-mail or otherwise. Instead, please notify us
<br> > immediately by return
<br> > e-mail (including the original message with your
<br> > reply) and then delete and
<br> > discard all copies of the message.
<br> >
<br> > Although we have taken precautions to minimize the
<br> > risk of transmitting
<br> > viruses we nevertheless advise you to carry out your
<br> > own virus checks on any
<br> > attachment to this message. We accept no liability
<br> > for any loss or damage
<br> > caused by viruses.
<br> >
<p> =====
<br> DIPANKAR CHAKRABARTI
<br> My Home Page: www.geocities.com/dipanc
<br> Net-union homepage: www.geocities.com/dipanc/ScCollege1987.html
<p> __________________________________________________
<br> Do You Yahoo!?
<br> Try FREE Yahoo! Mail - the world's greatest free email!
<br> <a href="http://mail.yahoo.com/">http://mail.yahoo.com/</a>
<p> -----------------------------------------------------------------
<br> The xml-dev list is sponsored by XML.org <<a href="http://www.xml.org">http://www.xml
.org</a> >,
an
<br> initiative of OASIS <<a href="http://www.oasis-open.org">http://www.oasis-open.org</a
> >
<p> The list archives are at <a href="http://lists.xml.org/archives/xml-dev/">http://lists.xm
l.org/archives/xml-dev/</a>
<p> To subscribe or unsubscribe from this list use the subscription
<br> manager: <<a href="http://lists.xml.org/ob/adm.pl">http://lists.xml.org/ob/adm.pl</a>
> </blockquote>
</html>
--------------8BDDA30512284FD3ADA11E59--
Attachments:
jurgen.moortgat.vcf
unknown2
Thread:
Anderson, John
Dipankar Chakrabarti
Jurgen
|
