ORA-29532: HTTP transport error: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send fail
Posted by Steve Racanovic | Posted in DBMS Callout , jpub | Posted on 1:57 PM
1
After running jpub using the 'get joke' web service and then calling the web service in sqlplus, I get the following error:
[sracanov@sracanov-au D]$ jpub -user=scott/tiger -sysuser=sys/welcome1
-proxywsdl=getjoke.asmx.xml
-endpoint=http://interpressfact.net/webservices/getjoke.asmx
tmp\src\genproxy\GetJokeSoapClientJPub.java
plsql_wrapper.sql
plsql_dropper.sql
plsql_grant.sql
plsql_revoke.sql
Executing plsql_dropper.sql
Executing plsql_wrapper.sql
Executing plsql_grant.sql
Loading plsql_proxy.jar
[sracanov@sracanov-au D]$ sqlplus scott/tiger
Logging into sqlplus - scott @orcl
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Feb 25 14:06:32 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
scott@orcl> select jpub_plsql_wrapper.getjoke('') from dual;
select jpub_plsql_wrapper.getjoke('') from dual
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.rmi.RemoteException: java.rmi.RemoteException:; nested exception is:
HTTP transport error: javax.xml.soap.SOAPException:
java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message
send failed: Connection refused
This error is occurring due to the proxy. So I need to execute setHttpProxy(host VARCHAR2, port NUMBER) to avoid this.
scott@orcl> call jpub_plsql_wrapper.setHttpProxy('www-proxy',8080);
Call completed.
scott@orcl> select jpub_plsql_wrapper.getjoke('') from dual;
JPUB_PLSQL_WRAPPER.GETJOKE('')
--------------------------------------------------------------------------------
Murphy's Military Laws:15.
Don't be conspicuous. In the combat zone, it draws fire. Out of the combat zone,
it draws sergeants.
To completely avoid this error, set jpub to call the WSDL directly rather than a local file and set the http proxy for jpub.
[sracanov@sracanov-au D]$ jpub -user=scott/tiger -sysuser=sys/welcome1
-proxywsdl=http://interpressfact.net/webservices/getjoke.asmx?WSDL
-endpoint=http://interpressfact.net/webservices/getjoke.asmx
-httpproxy=www-proxy:8080
tmp\src\genproxy\GetJokeSoapClientJPub.java
plsql_wrapper.sql
plsql_dropper.sql
plsql_grant.sql
plsql_revoke.sql
Executing plsql_dropper.sql
Executing plsql_wrapper.sql
Executing plsql_grant.sql
Loading plsql_proxy.jar
[sracanov@sracanov-au D]$ sqlplus scott/tiger
Logging into sqlplus - scott @orcl
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Feb 25 14:02:50 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
scott@orcl> select jpub_plsql_wrapper.getjoke('') from dual;
JPUB_PLSQL_WRAPPER.GETJOKE('')
--------------------------------------------------------------------------------
Q: How many `Real Men' does it take to change a light bulb?
A: None: `Real Men' aren't afraid of the dark.