Uploaded image for project: 'ActiveMQ'
  1. ActiveMQ
  2. AMQ-3902

Documentation for JMS Bridge With Oracle AQ

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.0
    • Component/s: Documentation
    • Labels:

      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

        Attachments

          Activity

            People

            • Assignee:
              davsclaus Claus Ibsen
              Reporter:
              denis.baklikov Denis Baklikov
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: