If you are using DB2/UDB, there is a provision to turn a database procedure into a webservice and it can be called using SOAP over HTTP. I guess, Oracle and SQLServer must be having a similar way to do so..
Regards,
VS
Marco Laponder <[EMAIL PROTECTED]> wrote:
VS
Marco Laponder <[EMAIL PROTECTED]> 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
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).