problem with synchronous JDBC to RFC all status are Success

[former_member633453]

Hi!!!

i read almost blogs and posible solution, but i don't find it.

My scenary is simple, it is a synchronous problem.

JDBC -> RFC the same RFC -> JDBC

1. the info get it by jdbc is sending to sap-rfc. no problem

2. the response sap-rfc is sending to jdbc. no problem

the monitoring of CC is OK

the monitoring of messages is OK too

the QOS of CC jdbc is Best Effort

but when i read the table for confirm the info, it isn't exist.

i read the note 801367 but not work for jdbc sender.

this is the code

outbound

<ns:MT_RS>
  <row>
    <CJANUTIP>2</CJANUTIP> 
    <CJMOTANU>1</CJMOTANU> 
    <CJANUOFN>CEN</CJANUOFN> 
    <CJANUBTH>CAJA06</CJANUBTH> 
    <CJANUSEQ>1</CJANUSEQ> 
    <CJANUPED1>23108</CJANUPED1> 
    <CJANUUSR>DSGODARTJ</CJANUUSR> 
    <CJANUOS>0</CJANUOS> 
    <CJANUFECPI>20080403</CJANUFECPI> 
    <CJANUHRAPI>201455</CJANUHRAPI> 
    <CJANUFECXI>0</CJANUFECXI> 
    <CJANUHRAXI>0</CJANUHRAXI> 
    <CJANUSTSXI>A</CJANUSTSXI> 
  </row>
</ns:MT_RS>

inbound (this doesn't insert to db)

<ns1:MT_INSERT>
  <statement1>
    <dbtable action="INSERT">
      <table>PMMNCJPR04.CJCONFANU</table> 
      <access>
        <CJCOFOFN>CEN</CJCOFOFN> 
        <CJCOFBTH>none</CJCOFBTH> 
        <CJCOFSEQ>0</CJCOFSEQ> 
        <CJCOFPED1>23108</CJCOFPED1> 
        <CJCOFOS>0</CJCOFOS> 
        <CJCOFTIP>2</CJCOFTIP> 
        <CJCOFTMSG>OO2</CJCOFTMSG> 
        <CJCOFIDMSG>Z03</CJCOFIDMSG> 
        <CJCOFMSGN>013</CJCOFMSGN> 
        <CJCOFMSGE>PEDIDO NO EXISTE Ó NO TIENE ENTREGA Ó NO TIENE FACTURA</CJCOFMSGE> 
        <CJCOFFECXI>20080507</CJCOFFECXI> 
        <CJCOFHRAXI>180245</CJCOFHRAXI> 
        <CJCOFSTSXI>A</CJCOFSTSXI> 
        <CJCOFFECPI>0</CJCOFFECPI> 
        <CJCOFHRAPI>0</CJCOFHRAPI> 
      </access>
    </dbtable>
  </statement1>
</ns1:MT_INSERT>

[prateek · Accepted solution]

Although the BE option is provided, the JDBC sender cant be configured Sync without BPM. U ll have to use BPM

1. Receive step - for Sender JDBC adapter

2. Send Synchronous - for RFC call synchrnous

3. Send Async - for Receievr JDBC adapter

Regards,

Prateek

[former_member633453]

hi Prateek!!

my scenary isn't BPM.

it is normal synchronous with Message Interfases

i made the sentence SQL with the parameters get it by the message interfase and using dbvisualizer, this are inserted correctly...

any idea?

How do i make the proof with convertion from XML to sentence SQL?