Tuesday, August 08, 2006

Running Webservices using APEX on XE

Just fiddling around with my ApEx (2.2) installation on XE I tried to add a Webservice. So I used the Web Service wizard and choose Yes in "Search the UDDI registry" and clicked Next. In the next screen I selected (the only available) "xMethods UDDI v2" and clicked Next. The I searched for "stock". The next screen showed "ORA-20001: The webservice was unreachable because either the URL you supplied was invalid, or your environment requires a valid proxy server address for HTTP requests.". So I added the proxy server under the Application Attributes Definitions and followed the same steps as above. The search for "stock" returns "ORA-20001: The response from the UDDI registry was invalid." this time. Looking at the Apex and XE forums didn't return any valuable hits. The I switched (from FireFox) to IE. This time the error told me something more: "the proxy server required authentication", so I added my username and password to the proxy server definition (http://<username>:<password>@<proxy>:<port>). But that still didn't solve the problem. Because my company has a strict password policy I had chosen a password with an "@" in it. After changing my password in something else and changing this also in the proxy server definition....it worked!

So with some trying-and-error I finally succeeded in using webservices in XE!

So I hope this little blog can save you some time figuring out the same...