Re: What can be a better solution

It depends on the architecture. Normally for something like this, I
tend to use php (mainly due to my background with it) as itis pretty
simple to use... you could use SAX or the DOM (or even simpleXML in
php5). Basically, you have a set of queries, i.e. "INSERT INTO
companies (name, street, city, state, zip) VALUES (?, ?, ?, ?, ?)",
and pass value syou get from the xml file to it using adodb or
something like that.

I'd simply write a dataMapper that maps xml nodes to database fields
usin gthe DOM (or SAX if it was large) and adodb.

Of course, I am sure you could do something simular using C++, but it
would seem simpler just to use some high level language to get it done
quickly.

Thanks,
JC

On 11/18/05, [email protected]
<[email protected]> wrote:
>
>
>
> Hi All,
>
>
>
> This is a more specific requirement what I have.
>
>
>
> I have lot many .xml files from which I need the data to be uploaded into my
> database.
>
>
>
> To achieve this I need a generic solution to proceed.
>
>
>
> I am a C/C++ guy. So to parse the .xml, I am thinking of using "xerces-C"
> libraries and then will right some data storage stuff.
>
>
>
> Do let me know if there is any better solution to it.
>
>
>
> As I am new to XML I need valuable suggestions to proceed further.
>
>
>
> ThanX
>
> --Pranav