Forum Stats

  • 3,836,789 Users
  • 2,262,190 Discussions
  • 7,900,110 Comments

Discussions

Database Table Polling for a Date field.

user13268867
user13268867 Member Posts: 35
edited Jul 3, 2013 2:04AM in SOA Suite Discusssions

Hi Gurus,

We have a requirement which requires database table polling on a base table. I need to design a SOA Service which is polling on a table's date field. Initially the date value will be null and whenever a date value is "updated" for that record, I need to read the data of that record and generate an XML file.

Now the date value could be sysdate or anything which is not same always. Can anyone help me with the design of this.

Database table polling for a date value which is initially null.

Thanks in advance,

G

Answers

  • user100012345
    user100012345 Member Posts: 171

    First of all it is not a best practice to have polling on base table.

    Create a staging table and apply polling on the same.

    Second after polling it is best practice to update one of the field basically a status flag from N to Y marking it is processed.

This discussion has been closed.