Hmmm... My first thought is to let the database do this for you. I would use a trigger on the tables that you are watching. At that point you can trigger events as they come in. With out a little more background on the problem statement I am not sure how much help we can give.
Nathan On 6/1/07, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
Hi I have a requirement where i have to constantly monitor a database for changes, for example if thers is an row added, or row changed the java program will process those records. is there any good way of doing it, currently i am thinking of writing a TimerTask which will sleep for 5-10 seconds to read the database. I have a flag in database which is updated when it is processed, so i need to monitor for all the rows where this flag is not updated. any ideas? Ashish
