🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.text.xml
Article #38

Re: looking for db2xml

#38
From: Cory Casanave
Date: Thu, 05 Jul 2001 15:53
33 lines
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-mail
References: <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