Skip to Content
avatar image
Former Member

How does JDBC sender adapter reads data from DB

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 20, 2007 at 08:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 08:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded