Some Data Missing in JDBC-Sender Adapter? Urgent!

[former_member203764]

Hi Gurus,

How are you?!

I have a urgent Problem with JDBC Adapter.

This is a Sender JDBC Channel, which reads data from 3 tables.

These 3 tables are joined with internal time stamp (TID).

After reading the protocal table would be updated.

These are select and update SQL-Statements:

SELECT

ISAP_WMTOCO_HEAD_EXPORT.LGNUM,

ISAP_WMTOCO_HEAD_EXPORT.TANUM,

ISAP_WMTOCO_HEAD_EXPORT.QNAME,

ISAP_WMTOCO_HEAD_EXPORT.ENAME,

ISAP_WMTOCO_HEAD_EXPORT.QUKNZ,

ISAP_WMTOCO_POSITION_EXPORT.TAPOS,

ISAP_WMTOCO_POSITION_EXPORT.ALTME,

ISAP_WMTOCO_POSITION_EXPORT.SQUIT,

ISAP_WMTOCO_POSITION_EXPORT.NISTA,

ISAP_WMTOCO_POSITION_EXPORT.NDIFA,

ISAP_WMTOCO_POSITION_EXPORT.WEMPF,

ISAP_WMTOCO_POSITION_EXPORT.LHM,

ISAP_WMTOCO_POSITION_EXPORT.VEGR1

FROM ISAP_WMTOCO_HEAD_EXPORT INNER JOIN ISAP_WMTOCO_POSITION_EXPORT ON ISAP_WMTOCO_HEAD_EXPORT.TANUM = ISAP_WMTOCO_POSITION_EXPORT.TANUM AND ISAP_WMTOCO_HEAD_EXPORT.TID = ISAP_WMTOCO_POSITION_EXPORT.TID INNER JOIN ISAP_PROTOCOL ON ISAP_WMTOCO_HEAD_EXPORT.TID = ISAP_PROTOCOL.TID

WHERE (ISAP_PROTOCOL.OBJTYP = 'WMTOCO') AND (ISAP_PROTOCOL.ISENDER = 'MF') AND (ISAP_PROTOCOL.ISTATE = 'RDY')

UPDATE ISAP_PROTOCOL SET ISTATE='FIN'

WHERE TID IN ( SELECT TID FROM ISAP_PROTOCOL WHERE ISENDER='MF' AND ISTATE='RDY' AND OBJTYP='WMTOCO'

-------------

But there is a Problem: during selecting there are some new Position data could be insert into Position table. whose ISTATE would be updated to FIN without being selected.

Could you help me out?

Thanks and Regards

Sara

[stefan_grube · Accepted solution]

Set "Transaction Isolation Level" to "serializable(strongest setting)"

This will prevent inserts during the select/update sequence.

[former_member203764 · Accepted solution]

Hi Stefan,

here is my configuration:

Acctually the transaction isolation level is set on serializable.

It maybe problem with the parameter "Database Auto-Commit-Enabled(No Transactioni Handling)?

Thanks in advance!

Sara

[iaki_vila · Accepted solution]

Hi Sara,

With this check the driver does not control the isolation level. To use transactio isolation level serializable the JDBC driver must support it and the table/s must be created as serializables.

Regards,

[former_member184720 · Accepted solution]

What is the backend database?

[former_member203764 · Accepted solution]

Microsoft SQL Server

[former_member203764 · Accepted solution]

Thanks for the Input!

I have removed this Option and waiting for the Feedback from customer.