XI JDBC adapter isolation level serializable - Not working properly????

[Former Member]

Hi all,

I have a JDBC sender adapter which perform in Transaction isolation Method serializable(Advance Mode settings) but it seems that it updates the wrong records witch results in records no to be send in XI.

the select statement I am using is

select OwnerCode,DeliveryNo , ErpWarehouseCode, TrtCode, PostGIdate, PostGIdateChangedFlg, DocumentNo, DocumentDate, CancelFlg, PostGIFlg, TacticalRouteCode, LicenceNo, PackagesQty, CusPickUpFlg, CusPickUpChangedFlg, RouteChangedFlg, DlvPriority, PickingDate, PickingDateChangedFlg, DlvPriorityChangedFlg, OdtLineNumber, ItemCode, WmsStatusCode, Lot, ExpirationDate,ProductionDate, TraUnitQty, TraUnitCode, Qty, MainUnitCode, ConvFactor, ConvDivisor, InitQty, DocQty, DeleteLineFlg, ParentLineNumber, ItemType, CusPickUpDescr, CusPickUpChangedFlg2

from wmsConfDlv2ERP

where flg = 0 and

DeliveryNo in ( select top 1 DeliveryNo from wmsConfDlv2ERP where flg = 0 )

and the update is

UPDATE wmsConfDlv2ERP set flg = -1

where flg = 0 and

DeliveryNo in ( select top 1 DeliveryNo from wmsConfDlv2ERP where flg = 0 )

Any ideas? The DB is an MS SQL 2005... Thanks.

[Former Member]

adding ORDER BY seems to solve the problem of instability

[VijayKonam]

Hi,

As far as I know, the JDBC adapter does not support nested queries (just my experience). I always used SPs to properly handle the situation and flow logic.

VJ