JDBC Adapter polling

[Former Member]

Hi,

i've got a question regarding the JDBC adapter working as sender. Suppose I had a database table with 10 rows. Would the adpater pick up these rows and send them in a message once or would it send them repeatedly after a certain time interval?

Kind regards,

Heiko

[MichalKrawczyk]

hi,

yes

if works on the select statement

but you can also update your records after the select statement - so for example

after you select the records and send them to XI

you can set one column value from "new" to "old"

and in the select statement always use the

SELECT ... where column = new

or where column <> old

Regards,

michal