Error invoking client loaded in oracle database

[Ruben Ramirez]

I have a web service client loaded into the database which is invoked from plqls through a function based on a class that is also in the database

During execution the following error is generated...



java.rmi.RemoteException: ; nested exception is:
HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: 2 > 0
at bcr.rltasas.service.runtime.ControlDataBloombergServiceSoapHttpPortBinding_Stub.solicitarTasasBloomberg(ControlDataBloombergServiceSoapHttpPortBinding_Stub:95)
at bcr.rltasas.service.ControlDataBloombergServiceSoapHttpPortClient.solicitarTasasBloomberg(ControlDataBloombergServiceSoapHttpPortClient:44)
at ServicioRltasas.cargarTasasRL(ServicioRltasas:66)
Caused by: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: 2 > 0
at oracle.j2ee.ws.client.http.HttpClientTransport.invokeImpl(HttpClientTransport.java:172)
at oracle.j2ee.ws.client.http.HttpClientTransport.invoke(HttpClientTransport.java:148)
at oracle.j2ee.ws.client.StreamingSender._sendImpl(StreamingSender.java:175)
at oracle.j2ee.ws.client.StreamingSender._send(StreamingSender.java:112)
at bcr.rltasas.service.runtime.ControlDataBloombergServiceSoapHttpPortBinding_Stub.solicitarTasasBloomberg(ControlDataBloombergServiceSoapHttpPortBinding_Stub:79)
... 2 more
RetVal = Error invocando el metodo solicitarTasasBloomberg. ; nested exception is:
HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: 2 > 0


the grant at user are:

DBMS_JAVA.grant_permission('LIQUID', 'SYS:java.net.SocketPermission', 'localhost', 'resolve');
DBMS_JAVA.grant_permission('LIQUID', 'SYS:java.net.SocketPermission', 'localhost:1521', 'connect,resolve');
dbms_java.grant_permission( 'LIQUID', 'SYS:java.lang.RuntimePermission', 'getClassLoader', '' )
dbms_java.grant_permission( 'LIQUID', 'SYS:java.lang.RuntimePermission', 'accessClassInPackage.sun.util.calendar', '' );
dbms_java.grant_permission( 'LIQUID', 'SYS:java.lang.RuntimePermission', 'shutdownHooks', '' );
dbms_java.grant_permission( 'LIQUID', 'SYS:java.util.logging.LoggingPermission', 'control', '' );
dbms_java.grant_permission( 'LIQUID', 'SYS:java.util.PropertyPermission', 'HTTPClient.socket.idleTimeout', 'write' );


Any idea of the solution?