Monday, 10 August 2009

JDeveloper 11g R1 and PLSQL Web Services

Good to see PLSQL Web Services make it back into JDeveloper 11g R1 and I quickly gave it a test run today on some old but useful PLSQL code I previously used. By chance I stumbled upon the ability to test the web service in a browser once you have a running web service.

1. Right click on your created PLSQL Web Service and select Run
2. Wait for output as follows indicating the WS is running.

Warning: JMS queue 'weblogic.wsee.DefaultQueue' is not found, as a result, Web Service async responses via jms transport is not supported. If the target service uses JMS transport, the responses will not be able to come back. Run startup time: 6406 ms.
[Application WebServices deployed to Server Instance DefaultServer]

Target URL -- http://localhost:7101/WebServices-PLSQLWebServices-context-root/PLSQLWSPort

09/08/10 14:11:18 Web service PLSQLWS has been started on the embedded server

3. Copy and paste the URL into a browser and there is your web client.
4. Click on "Test Page"


Gerard Davison said...


Out of interest why don't you just click on the link to use the internal testing tools in JDeveloper?

You can get this directly with "Test Web Service"


Pas Apicella said...

Yeah the internal one I have used / do use but the fact we can use a web based tool is handy while we test a live web service already deployed assuming it's available in a default WLS domain which I assume it would be.

I use the OC4J 10.1.3.x web service tester alot so something similar is great.