Transports and Interfaces: Siebel Enterprise Application Integration > EAI JMS Transport > Process of Configuring the OJMS Resource Adapter on the OC4J Container >
Creating the Connection Pool
You create the connection pool in Oracle Enterprise Manager. This is a step in Process of Configuring the OJMS Resource Adapter on the OC4J Container. To create the connection pool
- Log in to Oracle Enterprise Manager.
- Select the OC4J instance, for example oc4j_soa.
- On the Administration tab, select Services, then JDBC Resources.
- On the JDBC Resources page, under Connection Pools, click Create.
- On the Create Connection Pool - Application page, accept the defaults and click Continue.
- On the Create Connection Pool page, enter the following information:
|
|
Name |
TestJmsConn |
JDBC URL |
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=tcp)(HOST=hostname )(PORT=port )))(CONNECT_DATA=(SERVICE_NAME=servicename ))) |
Username |
jmsuser |
Password (clear text) |
jmsuser |
- Click Finish.
The new connection pool is displayed on the JDBC Resources page.
- Open the data-sources.xml file, which is found in the
OracleAS_HOME /j2ee/ OC4J_container /config directory, in a text editor.
- Add the following parameters to the
connection-pool tag for the TestJmsConn connection pool:
abandoned-connection-timeout="-1"
inactivity-timeout="60"
used-connection-wait-timeout="60"
- Remove the following code if present:
<property name="connectionCachingEnabled" value="False"/>
The code for the TestJmsConn connection pool will resemble the following example: <connection-pool name="TestJmsConn" abandoned-connection-timeout="-1" inactivitytimeout="60" used-connection-wait-timeout="60">
<connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" user="jmsuser"password="jmsuser" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS= (PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME= orcl)))" commit-record-table-name="">
</connection-factory>
</connection-pool>
|