Oracle ESB: AQ JMS Adapter Sample

Downloads

* Download Lesson07: OEMS: JMS (AQ) to DB PL/SQL
* Download ESBSamples.zip from oracle.

Configurations

OC4J: application.xml

* Located in j2ee\oc4j_soa\config directory.

<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>

JMS Adapter: oc4j-ra.xml

* Located in j2ee\oc4j_soa\application-deployments\default\JmsAdapter directory.

<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>

Database Adapter: oc4j-ra.xml

* Located in j2ee\oc4j_soa\application-deployments\default\DbAdapter directory.

<connector-factory location="eis/DB/EmployeeDB" connector-name="Database Adapter">
  <config-property name="xADataSourceName" value="jdbc/EmployeeDB-XA"/>
  <config-property name="dataSourceName" value="jdbc/EmployeeDB"/>
  <config-property name="platformClassName" value="oracle.toplink.platform.database.Oracle9Platform"/>
  <config-property name="usesNativeSequencing" value="true"/>
  <config-property name="sequencePreallocationSize" value="50"/>
  <config-property name="defaultNChar" value="false"/>
  <config-property name="usesBatchWriting" value="true"/>
  <connection-pooling use="none">
  </connection-pooling>
  <security-config use="none">
  </security-config>
</connector-factory>

Database Adapter: data-sources.xml

* Located in j2ee\oc4j_soa\config directory.

<connection-pool name="EmployeePool">
  <connection-factory 
    factory-class="oracle.jdbc.pool.OracleDataSource" 
    user="dbapp" 
    password="dbapp" 
    url="jdbc:oracle:thin:@//localhost:1521/orcl"> 
  </connection-factory> 
</connection-pool>
 
<managed-data-source name="EmployeeDB-XA" connection-pool-name="EmployeePool" jndi-name="jdbc/EmployeeDB-XA"/>
<managed-data-source name="EmployeeDB" connection-pool-name="EmployeePool" jndi-name="jdbc/EmployeeDB"/>

Log Files

* j2ee\oc4j_soa\log\oc4j_soa_default_group_1\oc4j\log.xml
* opmn\logs\default_group~oc4j_soa~default_group~1.log

This entry was posted in esb, oc4j, oracle. Bookmark the permalink.