You are here:

XML/importing XML into SQL server database

Advertisement


Question
Hi Ziv,
I am new in this type of programming. My question is. How to import XML body into SQL Server database using web service. Could you provide some small example, please.
Thank you.
Dmitriy Akerman

Answer
Hi Dmitiry,
Sorry I can't provide an example right now.
Start from two sides - the webservice (WS) and the database (DB).
(1) Make a WS.
First try - simply receive a test input and display it. Now you know the service works.
Second try - the service will receive the data as attachment or as text.

(2) make a JDBC logic - connect to the DB and insert an entry to the table.
Set the statement variable as LOB.

Now simply make the two sides work together.

Ziv

XML

All Answers


Ask Experts

Volunteer


Ziv Ben-Eliahu

Expertise

I can answer XSLT (XSL) questions - XML transformation. I like XPath and XQuery concepts. I know some XML parsing techniques.

Experience

2 years with XSLT (and related XPath)

Education/Credentials
M.Sc. from Ben-Gurion University

Past/Present Clients
I.D.I Technology

©2016 About.com. All rights reserved.