Inconsistent JDBC Adapter

[Former Member]

Hi Guys,

Took me quite a while to find this page haha I prefer the old sdn.. Anyway.. I've got some issues on my JDBC adapter. With the default parameters I'mselecting records from a SQL database:

My Select and Update Queries:

Reason why I'm selecting 500 at a time is cause our ECC system goes up to about 5000 IDOCS then undoes the process cause off some buffer size I suppose which basis does not want to change. So I'm selecting batches of 500 updating their selectindicators to 1 so it should not select the same set twice. This is exactly what it does 😕 If I run this on SQL server itself it works 100% every time. Selecting the top 500 transactions for a specific day. Oh and there's no primary key on the table.. After the select it updates the exact same set.

With PI though, it's works but every other set it duplicates a set Why on earth would it do that? I've tried increasing the poll interval to 30 but it still happens..

Thanks, Jan

[former_member212767]

Set the Transction Isolation Level to serializable in the Advanced settings --> Advanced mode.