Automatic retrieval and execution of data from Oracle DB in Java service Task

[sajukumar]

Hi Everyone,

I am trying to design a work flow engine with a Java service task that constantly looks into Oracle DB and checks for a row with a FLAG(Y/N) attribute. If the FLAG value equals 'Y' ,then it must go to the next Task. In simple terms, Activiti Engine should look and automatically execute only if there is an update in the DB record. Any ideas on how to implement this scenario ?

[jbarrez]

Use a service task that does the query. if 'N', go to an intermediate timer to wait a bit (to avoid DDOSSing your db) and then go back to your service task. When 'Y', go to the next task.