在DML事件中从Oracle数据库发送JMS消息 [英] Sending a JMS Message from Oracle Database on DML Event

问题描述

我正在尝试确定是否可以配置Oracle Database 11g，以在发生特定DML事件(例如，插入或更新特定表)时将JMS消息发送给代理(在我的情况下为ActiveMQ)，因此我可以在外部非Oracle应用程序中处理此事件.

I'm trying to determine if it is possible to configure Oracle Database 11g to send a JMS message to a broker (ActiveMQ in my case) when a particular DML event (say an insert or update to a particular table) occurs so that I can process this event in an external, non-Oracle application.

我已经进行了一些搜索，由于Oracle Streams暗示了JMS，因此Oracle Streams似乎有能力使用该用例，但是该文档似乎只专注于从Oracle Database到Oracle Database JMS消息的发送.

I've done some searching and it seems like Oracle Streams is capable of this use case since it alludes to JMS, but the documentation seems to focus only on Oracle Database to Oracle Database JMS message sending.

我并没有特别要求HOW做到这一点，但是，即使有可能，尽管当然，如果您能向我介绍如何进行设置的教程，我也将不胜感激.

I'm not particularly asking HOW to do this but if it is even possible at all, though of course if you could refer me to a tutorial on how to set it up I would be grateful for that as well.

推荐答案

您可以使用Oracle trigger 来调用 Java存储过程.

You could use an Oracle trigger which calls a Java stored procedure.

Java存储过程可以使用JMS发送消息.

The Java stored procedure in turn could send a message using JMS.

看看这个示例.

这篇关于在DML事件中从Oracle数据库发送JMS消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！