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"