1 Reply Latest reply on Aug 29, 2005 10:28 AM by Steven Ostrowski

    JDBC Connection Pool and Data source configuration.

    Prasanna Rajagopal Newbie

      Hi,
      I am using a Oracle database. I would like to know how I can setup connection pools and also setup data sources that use these connection.
      I setup configuration in oracle-ds.xml, but I think that would just be data sources directly connecting to database and not through connection pool.
      This is how my oracle-ds file looks, for e.g .

      <local-tx-datasource>
      <jndi-name>Pool1</jndi-name>
      <connection-url>jdbc:oracle:thin:@101.1.9.51:1521:db1</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>dbuser</user-name>
      dbuser
      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

      <type-mapping>Oracle9i</type-mapping>

      </local-tx-datasource>



      But this is, I think, is a data source configuration. How do I do connection pools and have data sources use that connection pool?
      Thank You