Skip to Content
avatar image
Former Member

Delay in JDBC Receive Adapter

Hi Everyone.

I have an asynchronous scenario, RFC -> PI -> JDBC (Oracle DB)... This does an UPDATE in each message... When try to process 400 message the time of execution in the DB takes 2 minutes. For the client, this time is too long, but I've done everything and the time does not improve.

This is the message:

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

<ns1:SQLString xmlns:ns1="urn:envioinventario:sap:seus">

<Statement>

<Inventario action="SQL_DML">

<access>UPDATE Inventario SET CAN = 65.0, CAN_CD = 876.9 WHERE C_EMP = &apos;JA&apos; AND BOD = &apos;72&apos; AND COD = &apos;T9876&apos;</access>

</Inventario>

</Statement>

</ns1:SQLString>

And this is the configuration of the cc:

Please, I need help, I don't know what else to do.

Thank you so much.

CRISTINA M. H.

1.png (22.0 kB)
2.png (8.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer