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

1. Log in to Oracle Enterprise Manager.
2. Select the OC4J instance, for example oc4j_soa.
3. On the Administration tab, select Services, then JDBC Resources.
4. On the JDBC Resources page, under Connection Pools, click Create.
5. On the Create Connection Pool - Application page, accept the defaults and click Continue.
6. On the Create Connection Pool page, enter the following information:

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

7. Click Finish.

   The new connection pool is displayed on the JDBC Resources page.

8. Open the data-sources.xml file, which is found in the OracleAS_HOME/j2ee/OC4J_container/config directory, in a text editor.
9. 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"

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