Search code examples
javams-accessschedulingjetjackcess

checking an access file via java and mailing for a specific row

I need to write a program that checks a access .mdb file and when a specific row is added (say the "name" field column of the newly added a row that contains a specific string, it should send an email to a specific address.

For this I am planning to use "Jackcess" library for reading the mdb file and "Apache's commons-email library" for SMTP mailing. However I am not sure which library of Java can be used to execute this "row check" every X time.

Thanks

Solution

  • If you're happy for the program to run continuously, I'd use Quartz (http://www.quartz-scheduler.org/). Otherwise a cronjob...