notify a DB change in java

[amanda]

Hi All,

I have a list of jobs running in DB. sometimes those jobs gets errored out and the column STATUS Changes into ERROR. All i want to have is an exe file always running on my machine.and to notify me whenever the error gets changed. Any pointers on how this could be done.

Thanks,
Amy

[travishein]

I guess start out by finding the SQL query to run on this job status table to determine when a job has failed. maybe something like

select count(*) form job_table where STATUS = 'ERROR';

Then create a [Java?] program to connect to the database with the appropriate credentials and invoke this query.

Then create a thread that runs in an infinite loop and just sleeps for some interval like a minute or two, and then wakes up and invokes this query. If there is an error condition, have it print out a message to the console.

Then later on, create a Swing dialog that will pop up with the message instead.

And for finishing touches, investigate using the system tray feature (new in java 1.6) to have the application run as an icon in the system tray.