openXML with JDBC

From: "Sandy" <a@xxxxx>
Date: Thu, 11 Aug 2005 14:56:13 +0530

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.

Thanks

.

Follow-Ups:
- Re: openXML with JDBC
  - From: Dai Wei

Prev by Date: extract data from java applet
Next by Date: Re: SQL queries on CSV
Previous by thread: extract data from java applet
Next by thread: Re: openXML with JDBC
Index(es):
- Date
- Thread

Relevant Pages

XML to Database
... load data from xml file into database) ... I am using mssqlserver.jar (JDBC fro sqlserver by MS). ... Is there any other way to load XML data into database using java. ...
(comp.databases.ms-sqlserver)
Import XML in SQL Server 2000
... How to import XML file in SQL, without knowing the structure of XML ... I tried the OPENXML function but the XML contains more than 150 ...
(microsoft.public.sqlserver.xml)