The major database companies (Oracle, IBM, Sybase, Microsoft) all provide tools to expose a store procedure as a Web service.
If you are using a different database, then I suggest you start with Apache Axis (http://ws.apache.org/axis -- the follow-on project to Apache SOAP). Deploy Axis in Tomcat. Write a class that uses JDBC to call the stored procedure. Deploy this class in Axis, and you're done. Anne ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 28, 2003 3:36 AM Subject: Re: Implementing Soap Server > I'm new myself, but from I understand you could simply install apache SOAP over > Tomcat and then simply deploy a webservice to execute your DB call... > > Zameer > On Wed, 28 May 2003 09:11:13 +0200, Marco Laponder wrote: > > > > > Hi All, > > > > I am pretty new in the Web Enabled development so don't flame me for stupid > > questions ;-). What I want to accomlish is to call a stored procedure in the > > DBMS of our company. I can acces it by jdbc. Now I want to call it over http > > so I thought I can create a servlet (in Tomcat attached to Apache with > > mod_jk module) with as input an xml message and which outputs also an xml > > message with the result of the call. But this loos pretty much like > > implementing soap myself. > > > > I like your opinion how you would setup to accomplish what I like to > > accomplish ? What can I use ? Must I implement my own soap server in Tomcat > > ? Any documents describing such a setup are of course also appreciated. > > > > Kind regards > > Marco Laponder > > mlr AT interchain DOT nl > > > >
