Wednesday, September 23, 2009

Configuring MQ in 11g SOA Suite

As in earlier version of SOA suite we need to configure oc4j-ra.xml for the mq adapter we will be configuring the same from the console.

go to deployment

Then select mqSeriesAdapter



Now go to configuration -Outbound Connections pools and select the default connection

and say new




Select the connection factory and say next





Now provide the jndi name for the queue.



Say finish .Now select a folder for the deployment plan .Make sure you already have created the folder and say ok



Check the deployment file if it is deployed correctly.





Save the changes.

Go to deployment again choose mqseries adapter and say update.





just say finish and check if it is deployed.



Verify





Now go to the connection and provide the values corresponding to your mq.



If you dont have created a channel.You can use the default channel and port

The default channel i am using is SYSTEM.DEF.SVRCONN and the channel 1414

provide your queue manager name



Also i will enable it for xa transaction



Now we will create the project in jdeveloper and try to connect to a queue.

i will be using the default queue Q1INPUT.

One additional step in configuration is

before using the Oracle MQ Series Adapter add the com.ibm.mq.jar property to the classpath for the Oracle MQ Series Adapter i.e copy the com.ibm.mq.jar file to the /lib folder.


Restart the server and post your query from em console and check the out put in the queue

Now the queue name we willb e providing in jdeveloper while designing the process.



provide the jndi name created





Select to put data in mq



Provide queue name



Choose opaque schema



and say finish




YOu might receive errors like

Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'Enqueue' failed due to: [MessageProduce] Error while Translation. [MessageProduce] Error while Translation. [MessageProduce] Error while Translation. ". The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution.


or may be error like this

BINDING.JCA-13040
[MessageProduce] Error while Translation.
[MessageProduce] Error while Translation.
[MessageProduce] Error while Translation.
Correct the reported problem if possible. Contact oracle support if error is not fixable.


This is because you are using opaque schema.

So if you define your own schema you can got pass through this error.

It should even work for opaque schema.I am trying to find out will update as soon as i will discover it.

for now you can download the project file from

http://arpitrahi.wordpress.com/2009/09/23/mq-adapter-11g/

location .download and rename it as .zip and unzip.

Make sure you have qmanager and queue same as mine

1 comment:

Anonymous said...

Hello Arpit,

Did you find a solution on how to make a opaque schema work?

Thanks,
MD