[JBoss-user] [JCA/JBoss] - JDBC Connection Pool and Data source configuration.

[rrprasan <nu...@jb...>]

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


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3891852#3891852

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3891852