Oracle SOA Suite Adapter Tips

If you change the database column definition (such as from VARCHAR2 to NUMBER), you need to regenerate the database adapter.
* Double click database adapter to open the Edit Partner Link wizard.
* Click ‘Define Adapter Service…’ icon (between the flash light and refresh buttons).
* Click ‘Next’ until the Select Table step.
* Click ‘Import Tables…’ button.
* Select table.
* Click ‘Yes’ at the ‘re-import Table’ prompt.
* Click ‘Finish’ button.

* SOA 10.1.3.5
* After Creating JMS Adapter, you need to manually configure the following files.
* Edit j2ee\oc4j_soa\config\application.xml.
– Set the resource-provider name to match the one used in JMS adapter (e.g. OEMS).
– Also, configre the ‘url’ property accordingly.

<resource-provider class="oracle.jms.OjmsContext" name="OEMS">
  <description>Resource provider for the OEMS database</description>
  <property name="url" value="jdbc:oracle:thin:jmsuser/jmsuser@localhost:1521:orcl" />
</resource-provider>

* Edit j2ee\oc4j_soa\application-deployments\default\JmsAdapter\oc4j-ra.xml
– Set connector-factory location to match the one used in JMS adapter (e.g. eis/Jms/OEMS).
– Set config-property ‘connectionFactoryLocation’ value to use the resource provider name configured previously (e.g. OEMS).
– For Queue destination:
~ Set config-property ‘connectionFactoryLocation’ value to use QueueConnectionFactories/myQCF.
~ Set config-property ‘isTopic’ to ‘false’.
– For Topic destination:
~ Set config-property ‘connectionFactoryLocation’ value to use TopicConnectionFactories/myTCF.
~ Set config-property ‘isTopic’ to ‘true’.
– Set config-property ‘username’.
– Set config-property ‘password’.

<connector-factory location="eis/Jms/OEMS" connector-name="JmsAdapter">
  <config-property name="connectionFactoryLocation" value="java:comp/resource/OEMS/TopicConnectionFactories/myTCF"/>
  <config-property name="factoryProperties" value=""/>
  <config-property name="acknowledgeMode" value="AUTO_ACKNOWLEDGE"/>
  <config-property name="isTopic" value="true"/>
  <config-property name="isTransacted" value="true"/>
  <config-property name="username" value="jmsuser"/>
  <config-property name="password" value="jmsuser"/>
  <connection-pooling use="none">
  </connection-pooling>
  <security-config use="none">
  </security-config>
</connector-factory>