HI Friends
Iam working on JDBC Sender.
I gave the Poll interval in ID as 60 sec. I want the database to be hit after whenever a row is updated.
Iam giving the select query as
<b>select * from vendormaster where search_term='X'</b>
and giving the update command as
<b>update vendormaster set search_term=' '</b>
So the select command executes only once.
Now Iam updating the search_term to 'X' in the oracle database using the SQL Command in SQL Plus. But it is not getting reflected in XI. It is not retrieving the Data.
<b>What should be the select and update commands if I want to hit the database(retrieve the data) whenever a row is updated from outside of XI.</b>