Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC sender adapter provides incomplete data

Hi,

I have a JDBC sender adapter which reads data from a MySQL table, and passes it to a proxy which writes the data then in a SAP table.

- Query SQL statement = SELECT Field1, Field2, Field3, Field4 FROM jdbctest WHERE Processed = 'N'

- Update SQL statement = UPDATE jdbctest SET Processed='Y' WHERE Processed='N'

I did a stress test with a program that writes data simultaneously to the MySQL table (up to 10000 records), and the JDBC sender adapter which checks the table every 15 seconds.

At the end, my SAP table contained only 9965 records.

This means that probably there have been records added between the Query and the Update statement (So they haven't been read, but their status is changed).

Does anyone have a solution for this?

Best regards,

Nicolas De Corte

Former Member
Former Member replied

Hello Nicolas,

Set the Isolation level to Serializable

regards

Gangaprasad

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question