473,385 Members | 1,907 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

extracting data from a database and converting it into an XML file

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++.

I have several tables from a database (Oracle).
I need to extract data from these tables, and then convert it into an XML
file.
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.

Has anyone done that ? How would you do that ?
Is there an STL class that handles XML ? etc ..
Thanks a lot for your help !
Jul 22 '05 #1
5 2319
There is no STL that handles XML. There is however a free software package
called "xerces" to parse and extract XML data.

"Toto" <ma*@nospam.com> wrote in message
news:c2**********@news-reader4.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++.

I have several tables from a database (Oracle).
I need to extract data from these tables, and then convert it into an XML
file.
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.

Has anyone done that ? How would you do that ?
Is there an STL class that handles XML ? etc ..
Thanks a lot for your help !

Jul 22 '05 #2
"Toto" <ma*@nospam.com> writes:
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++.

I have several tables from a database (Oracle).
I need to extract data from these tables, and then convert it into an XML
file.
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.

Has anyone done that ? How would you do that ?


completely OT, but what the hell:
Why use C++ at all? Oracle brings extensive XML functionality inside the
database - you can export tables directly as XML without the need for
external programming languages. afterwards, you can transform this
XML file into another by using XSLT.
(recommended reading: "Building Oracle XML applications")

HTH & kind regards
frank

--
Frank Schmitt
quattro research GmbH
e-mail: schmitt NO at SPAM quattro-research !@! dot com
Jul 22 '05 #3
it's not OUT OF TOPIC,
We have to use C or C++ for functional reasons.
So don't lecture me with any functionality that comes with Oracle.

what the hell yourself

"Frank Schmitt" <in*****@see-signature.info> a écrit dans le message de
news: 4c************@scxw21.4sc...
"Toto" <ma*@nospam.com> writes:
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++.

I have several tables from a database (Oracle).
I need to extract data from these tables, and then convert it into an XML file.
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.
Has anyone done that ? How would you do that ?


completely OT, but what the hell:
Why use C++ at all? Oracle brings extensive XML functionality inside the
database - you can export tables directly as XML without the need for
external programming languages. afterwards, you can transform this
XML file into another by using XSLT.
(recommended reading: "Building Oracle XML applications")

HTH & kind regards
frank

--
Frank Schmitt
quattro research GmbH
e-mail: schmitt NO at SPAM quattro-research !@! dot com

Jul 22 '05 #4
"toto" <no***********@toto.com> wrote in message news:<c2**********@s1.read.news.oleane.net>...
it's not OUT OF TOPIC,
yes, it is. Because you don't really have a C or C++ LANGUAGE
question, and there is no Standard C++ solution to your problem.
It is always good to check FAQ before posting:
http://www.parashift.com/c++-faq-lit...t.html#faq-5.9

Please, also read FAQ 5.4 which speaks about top-posting.

What you need is an Oracle DB library and an XML-parser library. There
are many available and the best place to ask would be NG's devoted to
Oracle and XML programming respectively.

For the latter, you can choose Xerces:
http://xml.apache.org/xerces-c/index.html

For the former, search either Web or your Oracle documentation for
Oracle CLI and/or Oracle ProC. On Windows you can also use ODBC.

Now, when you have a C++ language issue when trying to implement your
solution then you question will be most welcome in this group.

Thanks,
~Alexei
We have to use C or C++ for functional reasons.
So don't lecture me with any functionality that comes with Oracle.

what the hell yourself

"Frank Schmitt" <in*****@see-signature.info> a écrit dans le message de
news: 4c************@scxw21.4sc...
"Toto" <ma*@nospam.com> writes:
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++.

I have several tables from a database (Oracle).
I need to extract data from these tables, and then convert it into an XML file.
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.
Has anyone done that ? How would you do that ?


completely OT, but what the hell:
Why use C++ at all? Oracle brings extensive XML functionality inside the
database - you can export tables directly as XML without the need for
external programming languages. afterwards, you can transform this
XML file into another by using XSLT.
(recommended reading: "Building Oracle XML applications")

HTH & kind regards
frank

--
Frank Schmitt
quattro research GmbH
e-mail: schmitt NO at SPAM quattro-research !@! dot com

Jul 22 '05 #5
"toto" <no***********@toto.com> wrote in message
news:c2**********@s1.read.news.oleane.net...
it's not OUT OF TOPIC,
We have to use C or C++ for functional reasons.
So don't lecture me with any functionality that comes with Oracle.

what the hell yourself


I wish people would be more considerate before posting.
Here's a poster who comes to a C++ language group, seeking free help, posts
an OT question, doesn't know what OT means, gets a polite reply which goes
on to actually give him some help, and he replies with what sounds like a
"bitchy" retort.
Now he's gotten me upset, and I try really hard not to be.
He also top-posts.

How can I set my filters to get rid of this kind of stuff? (And yes, I'm on
OE.) OTOH, maybe it's a troll and I should be chuckling.....
--
Gary
Jul 22 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Michael Hill | last post by:
Hi, folks. I am writing a Javascript program that accepts (x, y) data pairs from a text box and then analyzes that data in various ways. This is my first time using text area boxes; in the past,...
2
by: Gary Wessle | last post by:
Hi I would appreciate any idea on how to approach this task. I have files which look like this: file1 men 234 women 112 children 4 cars 11
8
by: andrewtayloruk | last post by:
Hi i was wondering if anyone could help.... I have made a little script that puts whatever a user enters into a mysql database. As well as the forms my script has an image input that uploads an image...
6
by: Werner | last post by:
Hi, I try to read (and extract) some "self extracting" zipefiles on a Windows system. The standard module zipefile seems not to be able to handle this. False Is there a wrapper or has...
1
by: TYR | last post by:
I have a large dump file that originated in a MySQL db; I need to get it into an SQLite file. Various options are suggested around the web; none of them seem to work (most failing to import the...
1
by: ITCraze | last post by:
Hey everyone: I just want to discuss the problem releted to ASP.NET 2005 and MySQL database.I have a text file with delimiter as space.Now I want to import the text file data into MySQL...
47
by: ndedhia1 | last post by:
I have data in a database that looks like this: INSERT INTO ALARMNOTIFICATIONDETAIL VALUES ('1865', '2295', '15401', '1', 'Prodprdcons11InstrumentationMonitor', 'ALL'); INSERT INTO...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.