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
