Execution time difference between SELECT & UPDATE statement in JDBC Sender.

[jagesh_lakdawala]

Hi Experts,

In my scenario, I have used the JDBC Sender Adapter with the SELECT and UPDATE statement.

Now the problem is in between the execution of Select and update statement, few more entries are coming in the same DB Table.

So result of this is updation take place for those entries which are not even picked up by the select statement.

Can we avoid this execution time difference between the SELECT & UPDATE statemet on JDBC Sender side???

Thanks & Regards

Jagesh

[dharamveer_gaur2 · Accepted solution]

Hi

Use serializable option in additional parameters, now all new entries would also be updated.