This content has been marked as final. Show 3 replies
I haven't used JMS successfully, but I think there are several moving pieces needed, including a web server. If your site already has JMS working via Oracle advanced queues then http://docs.oracle.com/cd/E11882_01/server.112/e11013/jm_exmpl.htm tells you how to generate a JMS message from PL/SQL.
If you don't already have JMS happening via Oracle, you need to talk to someone who does know JMS. Perhaps try asking in the JMS forum Java Message Service (JMS) (Java / Java Enterprise & Remote Computing / Java Message Service (JMS) on the menu)
When I tried to use this on Oracle 10.2 I did not succeed in getting PL/SQL messages through to the Java client via JMS, but my knowledge of JMS was almost nil.
Thanks. I have been told that the server currently has ActiveMQ running as its JMS Server. Will I be able to use that to communicate message via PL/SQL?
Definitely time to talk to the JMS forum.
The Oracle® Streams Advanced Queuing User's Guide says
In this case Oracle JMS, part of Oracle Database, is the JMS provider.so I don't think the PL/SQL Streams Advanced Queuing API will talk to your ActiveMQ JMS Server.
When / how often will you be doing this ?
As an occasional, externally triggered task it sounds like a normal java client program is the right way.
Edited by: davidp 2 on Jun 6, 2013 6:53 PM