Skip to Content
0
Former Member
Nov 30, 2006 at 10:57 AM

Xi JDBC Adapter - Query SQL Statement & Update SQL Statement

551 Views

Hi!

I configure the JDBC adapter sender (XI) to take data from Oracle database.

I set the Query and Update SQL Statement in the Processing parameters of the communication channel in this way:

Query SQL Statement :

SELECT * FROM XI_TABLE WHERE STATUS = 'WAIT' ORDER BY ROW_NUM

Update SQL Statement :

UPDATE XI_TABLE SET STATUS = 'DONE', DATE = SYSDATE WHERE STATUS = 'WAIT'

My question is :

If a new record with the field STATUS = 'WAIT' is added to the table (xi_table) during the time between the execution of the query statement and the start of the update statement, what will happen to that record during the update?

There is a way to avoid the update of that record? or to pass to the update statement only the record selected in the query statement?

Please, may you give me some example?

Thanks,

Francesco