My previous post ( http://oracleappshelp.com/2018/05/05/soa-12c-db-adapter-conifguration/) had shown the steps to configure the DB Adapter but it is observed that the DB Adapter Polling does not work correctly when records are retrieved in a clustered environment.
The Customer Order details to be picked from the Oracle Database , transformation of the data as per business scenario and then send the updated data to the target server for further processing. In a clustered environment, the DB Adapter polling will be done simultaneously by all the configured managed server at the same whereas single instance should be initiated to retrieve the order details.
- NON XA Datasource : Do not use the XA datasource when using distributed transactions as it can cause problems with autonomous transactions such as java.sql.SQLException
- Distributed Polling : While configuring the DB Adapter , select the option for the Distributed Polling
- DB Adpater Plan.xml : Ensure that once the configuration of DB Adapter in the Weblogic Server is being done, update the Plan.xml file (deployment plan for the DbAdapter) to the other managed server
- Singleton Property in Composite: To enable for high availability environment for a inbound database adapter , add the
singletonJCA service binding property in the
composite.xmlwith value as ‘true’
<binding.jca config="readDataFromDB.jca"> <property name="singleton">true</property> </binding.jca>