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]

Re: XML to Database

Sandy (a@a.com) writes:[color=blue]
> 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.[/color]

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, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[John Bell]

Re: XML to Database

Hi

This site is very useful for XML information such as:

http://www.perfectxml.com/SiteSearch.asp?searchText=openxml&sType=1

Similarly

http://sqlxml.org/topics.aspx?topic=2

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

John


"Sandy" <a@a.com> wrote in message news:ddf5lo$ck0 @netnews.net.lu cent.com...[color=blue]
> 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
>
>[/color]