[AMQ-3902] Documentation for JMS Bridge With Oracle AQ

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 5.7.0
• Component/s: Documentation
• Labels: documentation
• Assignee: Claus Ibsen
• Reporter: Denis Baklikov
• Created: 27/Jun/12 13:45
• Updated: 08/Sep/12 09:33
• Resolved: 08/Sep/12 09:32

Description

I am using ActiveMQ as bridge to oracle's AQ.
Documentation provided by the following url if not complete. There are only Camel config, but no SQL for Oracle. It is quite important thing, becauce of a bug in the aqapi.jar which produces Null pointer exception. It works properly only with SYS.AQ$JMS* payload types. More information can be found here http://docs.oracle.com/cd/B13789_01/server.101/b10785/jm_exmpl.htm

Here is sample code:

BEGIN
 DBMS_AQADM.CREATE_QUEUE_TABLE( queue_table => 'queue_message_table', queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE');
END;        

BEGIN
  DBMS_AQADM.CREATE_QUEUE( queue_name => 'ORACLE_QUEUE', queue_table => 'queue_message_table');
END;

BEGIN
  DBMS_AQADM.START_QUEUE(queue_name => 'ORACLE_QUEUE');
END;  

Source url
http://activemq.apache.org/jms-bridge-with-oracle-aq.html