Andrej Koelewijn

Oracle soap seems to have a problem with HTTPS. When I try to connect to a secure web service (using jdeveloper 10g preview), the following error is displayed:

 [SOAPException: faultCode=SOAP-ENV:IOException; msg=javax.net.ssl.SSLException: SSL handshake failed: X509CertChainIncompleteErr; targetException=java.io.IOException: javax.net.ssl.SSLException: SSL handshake failed: X509CertChainIncompleteErr]
at org.apache.soap.SOAPException.(SOAPException.java:78)
at oracle.soap.transport.http.OracleSOAPHTTPConnection.send(OracleSOAPHTTPConnection.java:765)
at org.apache.soap.rpc.Call.invoke(Call.java:261)

To solve this problem you need to replace some of Oracle’s jar files with the ssl library which comes with the sun jdk. You can find this solution on Mike Lehmann’s blog

Oracle 10g has a new feature to call web services from pl/sql. I did not find a lot of documentation on this. I looks like you can use the utl_dbws package to dynamically consume web services without creating java stubs using jpublish.

I got a no class found exception when using the package. Mike lehmann pointed me to an updated dbws package that fixes this problem. I still can’t get it to work though. I’d be very interested to see an example that uses the utl_dbws package.