We have a requirement wherein we will be polling database using a complex SQL every few seconds to check whether we have any update or not. If there is update then will process it further. Sometime we might get one record or might get 100 records.
Based on this i started looking into database listener which allows polling of database and then it publishes the document on broker. Now in IS 9.5, these database listener have started using EAD - Event driven architecture in combination with NERV. To use these new technologies, you need to do few configuration to make it work which i fell is too much to achieve this sime requirement. Writing Complex SQL using Databse listener is also big pain as it provides you a wizard to come up with SQL instead of accepting SQL from property file.
Now my question on this topic is there any better idea you folks can suggest to poll the database periodically and get the information out and process it further.