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