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
First answer is RTFM ;)
Second answer is that you configure the connection pool inside of the datasource. Look at the manual for how to specify connection pool options.