Article View: comp.text.xml
Article #38Re: looking for db2xml
From: Cory Casanave
Date: Thu, 05 Jul 2001 15:53
Date: Thu, 05 Jul 2001 15:53
33 lines
2460 bytes
2460 bytes
There is a standard Component-X component (datasource) that maps XML to any SQL DBMS through JDBC. This component supports nested documents with table joins and has full read & write to all levels. You can then use other components for document transformation and integration with web services. Check out : www.enterprise-component.com Peter Millington wrote: > I am looking for a program which can be used to simply generate XML from > database sources with child tables included, i.e. of the nature of the > following - > > <order> > <client_name> XYZ </clientname> > <lines> > <line id=1> > <product> 123 </product> > etc > > I have looked at http://www.intsysr.com/ and their odbc2xml which seems to > most closely fit my needs, but this runs on a PC and I want to be able to > run this on Unix/Linux, so wanted something similar in C/C++, Java or Perl. > > The program http://www.rpbourret.com/xmldbms approaches what I want, but is > perhaps too complex, as I do not need the complexity of internal DOM trees > etc. > > My preferred database is Oracle, but the ability to connect to other > databases (JDBC or DBI) would be useful. > > Thanks in advance, > > Peter.
Technical Details
Message-ID:
<3B448D70.4015AF38@dataaccess.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-xfer.siscom.net!easynews!e420r-sjo4.usenetserver.com!newsfeed.usenetserver.com!newsfeeder.randori.com!news.randori.com!not-for-mailReferences:
<o2hih9.v91.ln@avatar.prayer.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10259a,e34058f04325662b X-Google-Attributes: gid10259a,public X-Google-Thread: 10fec3,e34058f04325662b X-Google-Attributes: gid10fec3,public X-Google-Thread: fbe9c,e34058f04325662b X-Google-Attributes: gidfbe9c,public X-Google-Thread: 10cf80,e34058f04325662b X-Google-Attributes: gid10cf80,public X-Google-ArrivalTime: 2001-07-05 08:56:59 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-xfer.siscom.net!easynews!e420r-sjo4.usenetserver.com!newsfeed.usenetserver.com!newsfeeder.randori.com!news.randori.com!not-for-mail Message-ID: <3B448D70.4015AF38@dataaccess.com> From: Cory Casanave <cory-c@dataaccess.com> X-Mailer: Mozilla 4.61 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.text.xml,borland.public.jbuilder.java,comp.databases.oracle,comp.lang.perl Subject: Re: looking for db2xml References: <o2hih9.v91.ln@avatar.prayer.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 34 Organization: Randori News - Now Web Capable! - http://www.randori.com - Get Free News! Date: Thu, 05 Jul 2001 15:53:48 GMT