Re: [ Off Topic ] extracting data from a database and converting it into an XML file

From: Chris \( Val \) (chrisval_at_bigpond.com.au)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 22:49:56 +1100

"Toto" <max@nospam.com> wrote in message news:c25dg5$jvp$1@news-reader1.wanadoo.fr...
| hey,
| I need some ideas, suggestions for a task I am working at work these days.
| We want to do that in C or C++.

This is off topic for this group, but I'll give you some hints.

Go to: https://sourceforge.net
...and download the OTL library - There, you will also find
an users forum for the library.

It works great with Oracle and MySQL databases, using C++.

| I have several tables from a database (Oracle).
| I need to extract data from these tables, and then convert
| it into an XML file.

Oracle has built in support for XML already ?

| We are now working on the TAGS that will compose this XML
| file and the mapping, that is the corresponding extracted
| data, associated to the TAGS.

If you stored your data in Oracle XML Database, then all
you need to do is perform simple SQL queries to output the
XML directly.

| Has anyone done that ? How would you do that ?
| Is there an STL class that handles XML ? etc ..

Yes: OTL(Oracle Template Library) and
     DTL(Database Template Library)... look them up.

| Thanks a lot for your help !

No problem, but please make a mental note, not to post
such questions here in the future, as we only discuss
standard 'C' and 'C++', as defined by their respective
standards.

Cheers.
Chris Val

Relevant Pages

  • Re: Databases, Typed Datasets, and Flat Files oh my!
    ... file, get the right characters, and then manually add the rows to the ... This standard consists of a fixed ... dataset gets shoved into database (or vicea ... All of the stuff I see for typed datasets is "XML! ...
    (microsoft.public.dotnet.languages.vb)
  • Creating XML from an Oracle DB
    ... answer to what must be a FAQ when generating XML from Oracle but I cannot ... Oracle 9.2 database using DBMS_XMLQUERY and DBMS_LOB. ... As a result the UK pound sign contained in a VARCHAR2 column on the ...
    (perl.dbi.users)
  • Re: best small database?
    ... This database will likely hold only a few hundred items, ... XML structure. ... well with configuration management systems, backup systems, ... editors, standard search tools, etc. ...
    (comp.lang.python)
  • Re: XML in a Relational Database
    ... But i cannot use oracle because it is expensive, ... a cheap and light database. ... > Recent versions of major DBMS supports XML in a way you save each XML ... >> The focus of this application is the XML documents could be whatever. ...
    (microsoft.public.dotnet.xml)
  • Re: up front designs always useless
    ... >> so if I don't know up front whether I am going to use XML or an Oracle ... You can commit to risky decisions with little impact of changing ... decisions until as late as possible is an up front design decision. ...
    (comp.object)