Following the Web Services User's Guide, I tried creating a
WebService of type raw (Eg. 1 in Chapter 4), as follows:
create service rawservice type raw as select
'<html><h1>' + @@version + '</h1></html>'
go
sp_webservices 'deploy', 'all'
go
However when I tried to consume the webservice through the
web browser, e.g.
http://myhost:8181/services/pubs2?method=rawservice&username=bob&password=bob123
I receive nothing on the browser. I then checked the
webservice.log for error and I got the following:
2007-11-28 16:45:41.906 INFO [IbmJsseListener1-9] -
Insecure HTTP Get request denied. Only SOAP or
HTTP Post requests are honored.
And I tried to consume the webservice by PowerBuilder9 (thru
Soap) and it works OK, but it's in the format of SQL/XML
resultset instead of raw.
Appreciate if anyone could point out what I'm missing.
TIA,
Jonathan
ASE Version: Adaptive Server Enterprise/15.0.2/EBF 14882
ONE-OFF/P/RS6000/AIX 5.2/ase1502/2486/64-bit/FBO/Sun Aug 12
13:57:13 2007
sp_webservices 'deploy', 'all'
go
It appears to be complaining about the get request (insecure
method of passing the name and password). From its message,
its expecting a post request instead. That means you'd have
to write a web page to process and pass the name and password
as a post operation rather than in the URL as a get request.
> And I tried to consume the webservice by PowerBuilder9 (thru
> Soap) and it works OK, but it's in the format of SQL/XML
> resultset instead of raw.
Sorry but I can't offer any comments on that.
Easiest thing to do would be to whip up a simple web page
that lets you enter a name and password.
-am © 2007