Geek asks and answers

Oracle database to send notifications / Call the java method when the time specified in the column is reached

I have a table containing information about events. New entries will be added to this table by another process continuously. The table has an Event-end-time column.

I need to create a mechanism to call the java method to process events when the event reaches the end time. Some of the options I have:

  • Continuously query the database (every 1 min.) And find the next last report to be processed and call it when the end time is reached.
  • Find out if there is any built-in mechanism in the ORACLE database to send a notification / Oracle itslef java application calling the java method when the event reaches the end time.

I saw notification options if the record is inserted / updated / deleted (based on triggers), but so far I have not been lucky if the notification condition has been changed (if the time indicated in the record column has been reached).

Any advice on this would be greatly appreciated.

Regards, Deepak

+3
source share
2 answers

The best way I know this is with Oracle AQ (JMS implementation)

There is also a notice of a database change in which I have no experience, but it may be that you, after that, I believe are actually based on AQ.

+2
source

/* , ,  * , /  */

, , Oracle , . . CREATE_JOB Oracle Documentation. Oracle Scheduler , pl/sql-, procdures shell-, .

+1

More articles:


All Articles