on 08-20-2007 9:49 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.