consuming a web service from the database
533580Mar 15 2007 — edited Mar 16 2007Hello,
We have 10.2.0.2.0 database,oas 10.1.3.0.0, jdeveloper 10.1.3.
We have to call our webservice deployed to the OAS from the database. The webservice is deployed and works fine (we can call it from a java application).
The web service itself and the client proxy have been generated by the jdeveloper.
The proxy has been loaded to the database and wrapped into a plsql package function using Jdeveloper "Load java and stored procedure deployment profile".
When we run the function we receive the following error:
calling http://z0001-app0821-s.hodc.ad.allstate.com:7779/amcddout_dvlp/DDRequesterWSSoapHttpPort java.lang.NoClassDefFoundError at HTTPClient.HttpURLConnection.<clinit>(HttpURLConnection.java:166) at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection.createConnection(HttpSOAPConnection.java:697) at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:347) at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection$PriviledgedPost.run(HttpSOAPConnection.java:796) at java.security.AccessController.doPrivileged(Native Method) at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:149) at oracle.j2ee.ws.client.http.HttpClientTransport.invokeImpl(Unknown Source) at oracle.j2ee.ws.client.http.HttpClientTransport.invoke(Unknown Source) at oracle.j2ee.ws.client.StreamingSender._sendImpl(StreamingSender.java:169) at oracle.j2ee.ws.client.StreamingSender._send(StreamingSender.java:110) at com.amc.dd.ws.test.runtime.DDRequesterWSSoapHttp_Stub.sendMessage(DDRequesterWSSoapHttp_Stub.java:77) at com.amc.dd.ws.test.DDRequesterWSSoapHttpPortClient.sendMessage(DDRequesterWSSoapHttpPortClient.java:42) at com.amc.dd.WsTest.callWS(WsTest.java:12)
Has anybody had the same problem?
Thank you
Kate