looking for db2xml

Article View: comp.text.xml

Article #36

#36

From: Peter Millington
Date: Fri, 29 Jun 2001 18:16

26 lines
1983 bytes

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: <o2hih9.v91.ln@avatar.prayer.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!grolier!btnet-peer0!btnet-peer1!btnet-feed5!btnet!mendelevium.btinternet.com!avatar.prayer.com!nobody

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10fec3,e34058f04325662b,start
X-Google-Attributes: gid10fec3,public
X-Google-Thread: fbe9c,e34058f04325662b,start
X-Google-Attributes: gidfbe9c,public
X-Google-Thread: 10cf80,e34058f04325662b,start
X-Google-Attributes: gid10cf80,public
X-Google-Thread: 10259a,e34058f04325662b,start
X-Google-Attributes: gid10259a,public
X-Google-ArrivalTime: 2001-06-29 11:22:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!grolier!btnet-peer0!btnet-peer1!btnet-feed5!btnet!mendelevium.btinternet.com!avatar.prayer.com!nobody
From: "Peter Millington" <peter_millington@iname.com>
Newsgroups: comp.text.xml,borland.public.jbuilder.java,comp.databases.oracle,comp.lang.perl
Subject: looking for db2xml
Date: Fri, 29 Jun 2001 19:16:50 +0100
Organization: BT Internet
Lines: 29
Message-ID: <o2hih9.v91.ln@avatar.prayer.com>
NNTP-Posting-Host: host213-122-183-39.btinternet.com
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700