Forum OpenACS Development: soap-db

Collapse
21: soap-db (response to 1)
Posted by Rocael Hernández Rizzardini on
Ok, the package is called:
soap-db, is on cvs now.
Basically it allows you to perform queries in a db_ style, send it to a soap server, and operate in the callers environment the results in the same way you do with the normal db_ API.

soap-db is the client API that mimics the db_ API.
This allow you to connect to any database without the need of having specific drivers for aolserver.

Also, there is a server API implementation for openacs as well, the working code we use is here:
http://cvs.openacs.org/cvs/openacs-4/packages/soap-db/tcl/example-soap-procs.txt?rev=1.1.1.1&view=auto

You need to have installed tsoap package, plus for the server side you'll need the soap-gateway (which allows you to expose oacs procs to soap).

The original design was mine, the development was done by derick at galileo.

We have been using it in production for quite a while without troubles.
The only thing that we cannot handle yet is transactions (like db_transaction), the best approach we use is to substitute that to a complete SOAP proc call that in the server side the proc should handle itself the transaction.