Oracle数据库在到达列中指定的时间时发送通知/调用java方法 [英] Oracle database to send notification / Invoke a java method on reaching Time specified in a column
问题描述
我有一张包含事件详情的表格。新记录将由另一个进程连续插入此表。该表有一个Event-end-time列。
I have a table which has event-details. New records will be inserted to this table by another process continuously. The table has a column Event-end-time.
我必须设计一种机制来调用java方法来处理事件到达事件结束时间。我有的一些选项是:
I have to design a mechanism to invoke a java method to process the events upon reaching the event end time. Some of the option i have are :
- 连续查询数据库(每1分钟)并找到要处理和调用的下一个最新报告到达结束时间。
- 弄清楚ORACLE数据库中是否有内置机制向java应用程序发送通知/ Oracle itlef在到达结束时间时调用java方法事件。
如果记录被插入/更新/删除(基于触发),我看过通知选项,但直到现在我如果通知条件是自定义的(如果达到记录列中的时间),则没有运气。
I have seen options for notification if an record is Inserted/updated/deleted (trigger based) , but till now i have had no luck if the Notification condition to be made custom(if time specified in a column of teh record is reached).
对此有任何建议将非常感激。
Any advice regarding this will be much appreciated.
问候,
迪帕克
Regards, Deepak
推荐答案
最好的方法我知道这样做是通过 Oracle AQ (一个JMS实现心理)
The best way that I know of to do this is via Oracle AQ ( a JMS implementation )
还有数据库更改通知,我没有任何经验,但可能是你所追求的,我相信它实际上建立在AQ之上。
There is also database change notification, which I don't have any experience in, but could be what you are after, I believe it actually builds upon AQ.
这篇关于Oracle数据库在到达列中指定的时间时发送通知/调用java方法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!