You are here:

XML/importing XML into SQL server database


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

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.



All Answers

Ask Experts


Ziv Ben-Eliahu


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


2 years with XSLT (and related XPath)

M.Sc. from Ben-Gurion University

Past/Present Clients
I.D.I Technology

©2017 All rights reserved.

[an error occurred while processing this directive]