Technology Adapters 10g to 11g Migration

 

Upgrade Tasks associated with Technology Adapters

Ø  Verifying Adapters with the Oracle JDeveloper 11g Adapter Configuration Wizard

After upgrading Oracle SOA Suite 10g projects to Oracle SOA Suite 11g, Oracle recommends to use the adapter configuration wizard to verify the upgrade of your technology adapters. This will ensure that all required fields in 11g are populated and that the adapter connections to new Oracle Fusion Middleware SOA Suite 11g environment are valid.

Ø  Upgrading Adapter Header variables

Issue: After upgrading an application that uses adapter headers, you will likely receive an error after you open the Application in Oracle JDeveloper 11g. The error will indicate that a variable or parameter was not recognized while it was parsing a header function.

This is caused by a change in the way adapter header variables are defined in Oracle Fusion Middleware SOA Suite 11g.  In Oracle Application Server 10g Release 3 (10.1.3), you create adapter header variables in a wsdl file that has a name like, or a similar name for the direction and adapter type you are using: fileAdapterOutboundHeader.wsdl

How to create a JNDI for MQ Adapter on Weblogic

How to create a JNDI for MQ Adapter on Weblogic

This post explains how to create a simple JNDI for MQ Adapter in Weblogic 10.3.x. This JNDI properties can be further changed to configure One-way or Two-way SSL on MQ Adapter as explained in post Enabling SSL on MQ Series Adapter - Part 2.

• Login to Weblogic Server Administration Console and navigate to Deployments > MQSeriesAdapter > Configuration Tab > Outbound Connection Pool.





• Click on New button and select javax.resource.cci.ConnectionFactory and click Next.

Correlating the request/response messages in MQ Series Adapter – Oracle SOA 11g

Correlating the request/response messages in MQ Series Adapter – Oracle SOA 11g

 

Mapping a response to a request in a request-reply interaction requires correlation.The MQ adapter provide the inbuilt options to correlate the request and response messages, there is no need of implementing the custom correlation to correlate the request and response messages.

Each MQSeries request message contains a message ID and a correlation ID. When an application receives a request message from Oracle BPEL PM, it checks for the correlation schema defined for the response message. Based on the correlation schema, the application generates the message ID and correlation ID of the response message. Based on the Message ID/Correlation ID the request/response messages will be correlated in the MQAdapter.

How to create and purge a AQ Queue/Topic

I was looking for testing the AQ Adapter and that forced me to look for steps on how to create and purge a AQ Queue/Topic? I referred the Article which explains all about AQ but in brief the steps are as under,

Creating a AQ Queue:

1. Grant the privileges to the Database User
2. Create a Queue/Topic table
3. Create a Queue/Topic
4. Start the Queue/Topic

In SQL terms,

1. Grant the privileges:

connect as sys;

grant connect, resource, aq_administrator_role to [USER] identified by [USER];
grant execute on sys.dbms_aqadm to [USER];
grant execute on sys.dbms_aq to [USER];
grant execute on sys.dbms_aqin to [USER];
grant execute on sys.dbms_aqjms to [USER];

Oracle SOA 11g AQ Adapter Resource 2

WebLink

http://jamessmith73.wordpress.com/oracle-fusion-middleware/oracle-soa-bpm-11g-blogs/soa-10g/soa-hands-on-4/

Oracle SOA Suite 11g – Configure AQ Adapter Resource 1

AQAdapters (Same type of config works for Apps adapter)

AQ is Oracle’s Advanced Queuing – a database backed channel. We use AQ Queues a lot when doing integration projects and it always helps to have a local install of SOA Suite with AQ capabilities (i.e. your own DB with AQ Queues etc)

Weblogic requires a “weblogic-ra.xml” along with the “ra.xml” file in the “META-INF” folder of the RAR file for the adapter.  The trickiest part is getting the Web console to apply changes … what I mean is that initially I tried to “Update” an existing “Deployment” of AQAdapter from the Weblogic Admin Console and it blew up … later I found out because the AQAdapter was packaged up in a RAR file (and not exploded on the filesystem) …as a result my changes from the console were not making it through.

The steps below show how I extracted the AQAdapter.rar to AQAdapter folder I created under the $SOA_HOME/soa/connectors/  folder. You can use these steps to configure any adapter (I have personally tested Oracle Apps Adapter – screen shots later)