cancel
Showing results for 
Search instead for 
Did you mean: 

How does JDBC sender adapter reads data from DB

Former Member
0 Kudos

Hi ALL,

I have scenario where the JDBC adapter has to read the data once every month. now how would JDBC adapter know that it has to select data which has been updated after last months select only and not the old data?

XIer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hey

in the sender JDBC adapter you give the select statement as well as update statement.

what you do is that once you select the data from data base you use an update query to set a flag to false,so that you dont select that data again next time.

have a look at this blog

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

in this he has used both select and update query on the sender side

Thanx

Aamir suhail

Message was edited by:

Aamir Suhail

Answers (1)

Answers (1)

Former Member
0 Kudos

Use the update statement to mark it as read. Then ensure your select only reads the 'unread' entries.

OR

use a stored procedure and validate against a timestamp.

sincerely,

--NM

Former Member
0 Kudos

How do we use stored procedure call in sender JDBC adapter?

Xier