XML/importing XML into SQL server database
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.
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.