Skip to Content

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

Some Data Missing in JDBC-Sender Adapter? Urgent!

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

replied

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,

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