XML to Database

[Sandy]

Hi,

I want to use the MS-Sqlserver's OPENXML function in my java application (to
load data from xml file into database)
I am using mssqlserver.jar (JDBC fro sqlserver by MS).
Can somebody tell me how do i execute the OPENXML function from JDBC.

Is there any other way to load XML data into database using java.
Thanks

[Erland Sommarskog]

Sandy ([e-mail]) writes:

I want to use the MS-Sqlserver's OPENXML function in my java application
(to load data from xml file into database) I am using mssqlserver.jar
(JDBC fro sqlserver by MS). Can somebody tell me how do i execute the
OPENXML function from JDBC.

Look at OPENXML in Books Online. There is no example in Java per se, but
when you come as far as OPENXML, you have all the data in the server,
so it does not matter which language you come from.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[John Bell]

Hi

This site is very useful for XML information such as:
http://www.perfectxml.com/SiteSearch...penxml&sType=1
Similarly
http://sqlxml.org/topics.aspx?topic=2

You may also find this handy! http://www.perfectxml.com/JAXP.asp

John
"Sandy" <[e-mail]> wrote in message news:dd********@netnews.net.lucent.com...

Hi,

I want to use the MS-Sqlserver's OPENXML function in my java application
(to
load data from xml file into database)
I am using mssqlserver.jar (JDBC fro sqlserver by MS).
Can somebody tell me how do i execute the OPENXML function from JDBC.

Is there any other way to load XML data into database using java.
Thanks