SqlLite in Soap Service.

[Ramaraju V.N]

HI All,

 Can any one tell how to integrate or create sql database with existing soap web service using staff(C++ based on Axis2/C) framework. 

 I am struggling to find out? Can you please provide any example/sample code for that?

-Ram

[Dmitry Utkin]

If you want to use DB in C++ service you should connect to DBMS and use it's functions as you done it for generic console application, Only you should take care of  OnCreate and OnDestroy methods to handle DB connection properly.

IMO much easier is to work with DB using DAS. In this case you will not write C++ web services bug deploy web services in XML. There are several of DBMS supported: sqlite, postgres, mysql (as well as shell provider available). 

Examples: 

https://code.google.com/p/staff/source/browse/#svn%2Ftrunk%2Fdas%2Fsamples%2FUsers

Example of DAS web service:

https://code.google.com/p/staff/source/browse/trunk/das/samples/Users/datasources/mysql/datasources/Users.datasources

how to start with https://code.google.com/p/staff/source/browse/trunk/das/samples/Users/README.txt

DAS Manual:  https://code.google.com/p/staff/wiki/DasScriptProgramming

пятница, 24 июля 2015 г., 14:54:24 UTC+3 пользователь Ramaraju V.N написал:

[Ramaraju V.N]

Thank you very much Dmitry Utkin. I will try.

-Ram