How to make my java class to continuously read the database in a loop and then send reminders through java mail if there is an entry in the database.
For example, I have a table called "jobs" which has the columns job_id, epoch_time, email_id. Here when the epoch_time equals current time, I have to send mail to email_id.
Thanks in advance.
You can use trigger to call a JAVA program you want. Say, you can call a program in AFTER INSERT or BEFORE INSERT. Refer https://docs.oracle.com/database/122/JJDEV/calling-Java-from-database-triggers.htm#JJDEV13286. Hope this suits your scenario.