Send data to remote webservices

From: <sandro.salari_at_gmail.com>
Date: Thu, 04 Oct 2007 01:25:36 -0700
Message-ID: <1191486336.664058.69410@g4g2000hsf.googlegroups.com>

Hi,
I have an oracle server with a "java stored procedure" that sends a SOAP message to remote server over HTTP. I upload the follow jar to my user tablespace with loadjava:

cglib-nodep-2.1_3.jar
commons-beanutils-1.7.0.jar
commons-logging-1.1.jar
dbwsa.jar
dbwsclient.jar
dbwsclientdb102.jar
jsr173_1.0_api.jar
xom-1.1.jar
xpp3_min-1.1.3.4.O.jar
XStream.jar
(and my application jar).

Then I get the follow grant to my user:

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',


'SYS:java.net.SocketPermission', '*', 'resolve' )

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',


'SYS:java.net.SocketPermission', '*', 'connect' )

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',

'SYS:java.util.PropertyPermission', 'HTTPClient.socket.idleTimeout',
'write' );

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',
'SYS:java.lang.RuntimePermission', 'createClassLoader', '' );
exec
dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21','SYS:java.lang.RuntimePermission',
'accessDeclaredMembers', '' );

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',
'SYS:java.lang.reflect.ReflectPermission', 'suppressAccessChecks',
'' );

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',
'SYS:java.lang.RuntimePermission', 'setFactory', '' );

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',
'SYS:java.lang.RuntimePermission', 'shutdownHooks', '' )

exec dbms_java.grant_permission( 'TST_GSTECOGRAFICO_V21',
'SYS:java.lang.RuntimePermission', 'shutdownHooks', '' )

exec dbms_java.grant_permission('TST_GSTECOGRAFICO_V21',
'SYS:java.util.logging.LoggingPermission','control','')

exec
dbms_java.grant_permission('TST_GSTECOGRAFICO_V21','SYS:java.net.SocketPermission','*','connect,resolve');

When I try to send a message using my application I receive the follow error:

java.rmi.RemoteException: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPExcept
ion: Message send failed: 2 > 0; nested exception is:

        HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send
failed: 2 > 0

        at
it.escsolution.hostInterscambio.core.runtime.HostActionManagerSoapBinding_Stub.executeNodo(HostActionManagerSoapBinding_Stub.java: 601
)

        at
it.escsolution.hostInterscambio.core.HostActionManagerClient.executeNodo(HostActionManagerClient.java: 92)

        at
it.escsolution.clientInterscambio.myThread.xStream.NodoSenderXStream.useSpecificWS(NodoSenderXStream.java: 39)

        at
it.escsolution.clientInterscambio.myThread.xStream.ThreadSenderXStream.run(ThreadSenderXStream.java: 171)

        at
it.escsolution.clientInterscambio.core.ClientActionManager.deliveryDatas(ClientActionManager.java: 970)
Caused by: HTTP transport error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message se
nd failed: 2 > 0

        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: 165)

        at
oracle.j2ee.ws.client.StreamingSender._send(StreamingSender.java:110)

        at
it.escsolution.hostInterscambio.core.runtime.HostActionManagerSoapBinding_Stub.executeNodo(HostActionManagerSoapBinding_Stub.java: 585
)

        ... 4 more
responce: null

Tnx to all,
Bye. Received on Thu Oct 04 2007 - 03:25:36 CDT