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:05:46
From:   dvohra09
Response to: JDBC connection Pool and data sources

In JBoss the jdbc is configured in the datasource configuration file.


Refer
http://www.onjava.com/pub/a/onjava/2004/02/25/jbossjdbc.html#oracle

Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • JDBC connection Pool and data sources
    2005-08-29 16:50:07  prasanrr [View]

    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.