🚀 go-pugleaf

http://www.informatik.fh-wiesbaden.de/~turau/DB2XML/


"Peter Millington" <peter_millington@iname.com> wrote in message
news:o2hih9.v91.ln@avatar.prayer.com...
> 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.
>
>
>

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.

Hi.

> 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,

You missed the elephant. Oracle has very good XML SDK with XSQL servlet
which does what you need and much more. It is very powerful and native to
oracle, but is also open to other JDBC-enabled sources.

Bye.
/lexi

EZSQL can quickly export tables from Oracle to XML (among many other formats)
It can export them from a GUI or from a command line.

It can also do lots of other stuff with Oracle...pretty much everything
a developer or DBA would want to do!  There is a full featured 60 day 
trial period and after that the cost is only $150 per license.  Try it!

www.ezsql.net

-John