Women in Technology

Hear us Roar



Article:
  Migrating a WebLogic EJB Application to JBoss
Subject:   JDBC connection Pool and data sources
Date:   2005-08-29 16:50:07
From:   prasanrr
Response to: JDBC connection Pool and data sources

I currently have the following in Oracle datasource configuration file
<datasources>
<local-tx-datasource>
<jndi-name>DataSource1</jndi-name>
<connection-url>jdbc:oracle:thin:@101.71.7.59:1521:db1</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>dbuser</user-name>
<password>dbuser</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<new-connection-sql>select sysdate from dual</new-connection-sql>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
I am assuming something close the following would confgure the connection pool:
<connection-factories>
<tx-connection-factory>
<jndi-name>Pool1</jndi-name>
<rar-name></rar-name>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<connection-url>101.71.7.59:1521:db</connection-url>
<min-pool-size>10</min-pool-size>
<max-pool-size>200</max-pool-size>
<idle-timeout-minutes>200</idle-timeout-minutes>
<user-name>dbuser</user-name>
<password>dbuser</password>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</tx-connection-factory>
</connection-factories>
I am clear as to what would be RAR name and other tage and how it fits with the data source configuration. Just like in Weblogic, there does not seem to be a Pool-name tag for data source configuration.
Thank you for your help.