CODEWITHSUNDEEP
jmsrabbitmqintegrationamqpadvanced-queuing
Casper
Casper

Reputation: 107

Oracle Advanced Queue - RabbitMQ integration

In some of our projects, the messages will be consumed from Oracle Advanced Queue and will be published to RabbitMQ.

How can I integrate Oracle Advanced Queue with RabbitMQ?

Upvotes: 0

Views: 10044

Answers (2)

Panagiotis Piperopoulos
Panagiotis Piperopoulos

Reputation: 534

My answer if far from complete but it might help someone. Some time ago while i was searching about the integration of oracle with rabbitMQ i found this in github.

https://github.com/pmq/rabbitmq-oracle-stored-procedures

I modified the code for my needs and it worked fine (oracle 12.1.0.1.0 ). Using an oracle trigger i managed to send messages to a rabbitMQ queue after CRUD operations. I am very, very sorry i don't have the code but github is there with the original code. I made minor modifications in this github code and worked fine. I remember i created and loaded in oracle some stored procedures in java (like those in the github repository i mentioned) and used them to communicate with rabbitMQ. I also loaded in oracle necessary rabbitMQ libraries (jars). This was done using loadjava tool. My messages where in json format.

I would be very happy if this extremely incomplete answer helps someone.

Upvotes: 2

Petter Nordlander
Petter Nordlander

Reputation: 22279

The question is very wide. Writing a program that reads rabbit queues and copies them to Oracle queues is straight forward in multiple languages, at least in Java.

You can get help from integration suites like Mule ESB and Apache Camel to get all boiler plate code setup for you.

If you want a more specific answer you better rephrase the question to narrow the scope a bit.

Upvotes: 1

Related Questions