JMS connection from SAP PI to Oracle AQ via JNDI...

[Former Member]

Hi,

I am currently working on a project that requires connections between PI and Oracle AQ. It was advised that we shoule use PI JMS adpater with JNDI driver. However, it seems that not many people have tried this approach.

Has anyone had similar solutions in production ? How repliable it is ?

Your help is very much appreciated

Tim

[robertot4s · Accepted solution]

Hi Tim,

We implemented a similar scenario and now itu2019s still working.

You have to configure a JNDI connection, but not directly with the Oracle AQ. The Oracle AQ are just queues, and you need a JMS provider in order to establish the connection with these queues. The solution we implemented was:

1. Configure one OC4J server as JMS provider for the Oracle AQ queues.

2. Configure JMS communication channels in SAP PI to establish the connection with the OC4J server.

Maybe you can use a different and newer JMS provider, as BEA Weblogic or SAP WAS (I donu2019t know if itu2019s possible).

We implement the scenario in SAP PI 7.0, and with this version we had a problem: When the communication between JMS adapter and the queues was broken (the DDBB fell down for example), the channel failed, itu2019s normal. But when the DDBB was already running the channel stayed in an error state, and we had to restart the channel manually. The response of SAP to this issue was that the channel behavior was correct because the connection failed.

But this problem occurred rarely, maybe once a month. The solution is very reliable, we exchange a lot of message with this solution, and support messages of any size with an excellent performance.

Best Regards,

Roberto

[Former Member]

Great help !

Many thanks, Roberto.