========================================bpel.xml==============================
<?xml version = '1.0' encoding = 'UTF-8'?>
<BPELSuitcase>
<BPELProcess id="RawQueuePayloadUsingNativeFormat"
src="RawQueuePayloadUsingNativeFormat.bpel">
<partnerLinkBindings>
<partnerLinkBinding name="Dequeue">
<property name="cacheConnections">false</property>
<property name="wsdlLocation">Dequeue.wsdl</property>
<property name="retryMaxCount">10</property>
<property name="retryInterval">60</property>
</partnerLinkBinding>
<partnerLinkBinding name="Enqueue">
<property name="wsdlLocation">Enqueue.wsdl</property>
<property name="retryMaxCount">10</property>
<property name="retryInterval">60</property>
<property name="cacheConnections">false</property>
</partnerLinkBinding>
</partnerLinkBindings>
<activationAgents>
<activationAgent
className="oracle.tip.adapter.fw.agent.jca.JCAActivationAgent"
partnerLink="Dequeue">
<property name="portType">Dequeue_ptt</property>
</activationAgent>
</activationAgents>
</BPELProcess>
</BPELSuitcase>
============================================================================== ======/SOA/10.1.3.1/OracleAS_1/j2ee/oc4j_soa/config/data-sources.xml============
==============================================================================
<managed-data-source connection-pool-name="AQSAMPLE_POOL"
jndi-name="jdbc/aqSample" name="AQSAMPLE_DS"
manage-local-transactions="false" tx-level="global" />
<connection-pool name="AQSAMPLE_POOL" validate-connection='true'>
<connection-factory
factory-class="oracle.jdbc.xa.client.OracleXADataSource" user="scott"
password="welcome1" url="jdbc:oracle:thin:@localhost:1521:orcl"
connection-retry-interval="60" max-connect-attempts="60"
commit-record-table-name="" validate-connection-statement="select 'x' from
dual"/>
<connection-properties>
<property name="oracle.jdbc.ReadTimeout" value="300000"/>
</connection-properties>
</connection-pool>
==============================================================================
==/SOA/10.1.3.1/OracleAS_1/j2ee/oc4j_soa/application-deployments/default/AqAdapter/oc4j-ra.xml==
==============================================================================
<connector-factory location="eis/AQ/aqSample" connector-name="AQ Adapter">
<config-property name="xADataSourceName"
value="jdbc/aqSample"/>
<config-property name="dataSourceName" value=""/>
<config-property name="connectionString" value=""/>
<config-property name="userName" value=""/>
<config-property name="password" value=""/>
<config-property name="defaultNChar" value="false"/>
<config-property name="useDefaultConnectionManager"
value="true"/>
<connection-pooling use="none">
</connection-pooling>
<security-config use="none">
</security-config>
</connector-factory>
==============================================================================
Note: I am using useDefaultConnectionManager not private connection
Additional properties you check for RAC and other timeouts:
validate-connection="true" time-to-live-timeout="60" abandoned-connection-timeout="60" property-check-interval="600" inactivity-timeout="60" initial-limit="10" max-connections="20" min-connections="10"
<property name="connectionCachingEnabled" value="true"/>
<property name="fastConnectionFailoverEnabled" value="true" />
For 10.1.3.X XA Datasource Requirement refer:
Oracle Metalink/Support note:738108.1
http://www.oracle.com/technology/tech/soa/pdf/oracle-soa-suite-xa-rac-guide.pdf
http://www.oracle.com/technology/tech/java/newsletter/articles/oc4j_datasource_config.html
http://www.oracle.com/technology/tech/java/newsletter/articles/oc4j_data_sources/oc4j_ds.htm
http://download.oracle.com/docs/cd/B25221_04/web.1013/b14427/datasrc.htm#sthref442
http://www.oracle.com/technology/pub/notes/technote_ds_caching.html
http://www.oracle.com/technology/sample_code/products/rac/index.html
