ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Maves" <nathan.ma...@gmail.com>
Subject Re: checking for Database changes
Date Mon, 04 Jun 2007 21:07:22 GMT
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 <ashish.kulkarni13@gmail.com> 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
>

Mime
View raw message