Skip to Content
0
Former Member
Sep 23, 2005 at 06:54 AM

JDBC Sender---Please respond Immediately.

36 Views

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>