Problem between SOAP Sender and JDBC Receiver

[former_member184166]

Hi,

I have a asynchronous scenary between SOAP Sender and JDBC Receiver.

The idea is sending an ID for updating one register.

Table structure is:

TABLE AS_PERSONA

(P_RUT VARCHAR2(10) NOT NULL,

P_NOMBRE VARCHAR2(50),

P_APELLIDO VARCHAR2(50))

The ID is the P_RUT field.

The structure of message that I send by SOAP, is the following:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<SOAP-ENV:Body>

<m:MT_CONS_SOAP xmlns:m="urn:prueba:voliva">

<CONSULTA>

<P_RUT>15445</P_RUT>

</CONSULTA>

</m:MT_CONS_SOAP>

</SOAP-ENV:Body>

</SOAP-ENV:Envelope>

The JDBC receiver structure is:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_CONS_PERSONA xmlns:ns0="urn:prueba:voliva">

<Statement>

<AS_PERSONA action="UPDATE">

<table>AS_PERSONA</table>

<access>

<P_NOMBRE>DELETE_BY_XI</P_NOMBRE>

<P_APELLIDO>DELETE_BY_XI</P_APELLIDO>

</access>

<key>

<P_RUT>15445</P_RUT>

</key>

</AS_PERSONA>

</Statement>

</ns0:MT_CONS_PERSONA>

When I do a call to SOAP by XMLspy, it returns a message without data, that means succesfull reply.

I see message monitor and see the succesfull flag. But in the database it doesn't update the register.

This scenario was proved using the File Sender and same JDBC Receiver, then result was succesfull.

I proved SOAP Sender with a File Receiver, storing information from SOAP sender in an archive, and works well.

Then I imagine that exist some problem between SOAP and JDBC. what could be happening ?

Thanks.

[Former Member]

Hi,

Go to the adapter monitoring of JDBC adapter.If you are not clear with the error check the adapter logs that will be stored on the server.

Regards,

Sudheer.

[Former Member]

Hi,

Looks like the problem is with the JDBC receiver...try updating the value in the table by using a File-JDBC scenario..does it work..check the adapter monitor in RWB..

Regards,

Sushumna

[moorthy]

Hi,

Can you check the logs in the RWB->message Monitoring->Audit Log

Also check the Adapter monitoring for JDBC receiver.There may be some error

Regards,

Moorthy