472,145 Members | 1,486 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

saving XML into database

hi all,
I have developed a code which writes into an xml ,after writing im saving them as XML file only. i want to know how can i save it into a database.
Is there any function available for doing so ???

Thank u,
Dec 31 '08 #1
9 4514
8,658 Expert Mod 8TB
you can save it like any other text. make sure the encoding of the file and the database matches.

Dec 31 '08 #2

But how do i store it??? actually im new to this database and xml stuff so if u could lemme know more it would be helpfull

thank u
Dec 31 '08 #3
8,658 Expert Mod 8TB
what do you mean? you store it like any other text, that's all.
Dec 31 '08 #4
i mean do i have to make a database connection or something???
Dec 31 '08 #5
im using this function to save to a file.

Expand|Select|Wrap|Line Numbers
  1. {
  2. _variant_t varString = strFileName;
  3.     parser->myComPtrDocument->save(varString);
  4.     return true;
  5. }
now i want to store this file to an existing database using void pointer ,
Dec 31 '08 #6
8,658 Expert Mod 8TB
of course you have to. use the database functions your language provides. which are basicly 2: one for connecting and one to execute the query.
Dec 31 '08 #7
ok , il try it

thanks a lot
Dec 31 '08 #8
there is a number of databases that supports XML natively, one of their data types exactly XML when in simple databases maximum you could have is TEXT only. You want to deal with XML in database naturally you have two ways one is to use XML enabled databases like Microsoft SQL 2005/2008 or IBM DB2 (both of them have free Express editions) or use native XML databases like Berkeley DB XML (unfortunately was acquired by Oracle), Sedna, MarkLogic...
Jan 9 '09 #9
hey thank u so much

Jan 12 '09 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Roy Gourgi | last post: by
2 posts views Thread by manning_news | last post: by
reply views Thread by sameer | last post: by
1 post views Thread by Allie | last post: by
10 posts views Thread by Nathan Sokalski | last post: by
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

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.