I have a question regarding how to track the status of the database request.
Brief Overview of what's going to happen:
1. User hits a submit button from the UI with some ids selected from the dropdown list.
2. A stored procedure is called by the webservice. Web service updates a column(REQUEST_STATUS) in the database table REQUEST with REQUEST_STATUS = NOT_YET_STARTED
3. Stored procedure starts working on the request and updates the REQUEST_STATUS column with REQUEST_STATUS= IN PROGRESS
4. When the stored procedure finishes the request, it updates the REQUEST_STATUS column with REQUEST_STATUS = COMPLETE.
I want to know if I can implement a Java process, which can constantly keep looking for the REQUEST_STATUS column of the table using some identifier maybe and once it sees as COMPLETE, I want to send an email to the user from the Java process.
In the past, I have done simething similar with ActiveMQ , where my java process was looking for the status of the request using Spring JMS listner. However, in the above scenario, I am not planning to use ActiveMQ and hence wondering how to handle this scenario.