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 15:16:34
From:   prasanrr
Hi
I am using JBoss 4.0.2 and Oracle 9.x. I am trying to migrate from weblogic to JBoss. I am trying to configure a few JDBC connection pools for an Oracle database and have the data sources use these connection pools. I ave been searching on the web but could not find any examples. I do see data source configuration examples, but not connection pool and how to make the data source use the connection pool. Hope you can help me.
Thank You
Full Threads Oldest First

Showing messages 1 through 2 of 2.

  • JDBC connection Pool and data sources
    2005-08-29 16:05:46  Deepak Vohra | [View]

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