Denis Baklikov created AMQ-3902:
-----------------------------------

             Summary: Documentation for JMS Bridge With Oracle AQ 
                 Key: AMQ-3902
                 URL: https://issues.apache.org/jira/browse/AMQ-3902
             Project: ActiveMQ
          Issue Type: Improvement
            Reporter: Denis Baklikov


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: 
{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;  
{code}

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



--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira