look into the directory docs/examples/jca/oracle* for a template.
You should try the XA variant if you plan to have more than one transaction participant (DB, JMS ..) otherwise you can use the 'normal' one.
From Java code you must lookup via context and use the provided connenction.
Thanks for the response.
I'd like to use the Connection Pool manager that is part of Oracle JDBC driver class - oracle.jdbc.pool.OracleDataSource within JBoss AS
I assume configuring a Oracle datasource using the following uses JBoss built-in connection pool manager<datasources>
Can I configure oracle.jdbc.pool.OracleDataSource class for use with JBoss as it contains built-in conncetion pool manager? If so, could you help with sample ds configuration data.
I never think about it, but I suppose not.
But why do you want to use a different connection-pool?
If you drop the ojdbc.jar into server/.../lib and configure the oracle-ds.xml the JBoss will provide the oracle connection in the same way.
In a cluster you deploy the same oracle-ds.xml on each server instance and thats it.
You should configure the same max connection value because of load balancing if the JBoss instance distribute the load.
My understanding is JBoss AS uses commons-dbcp connection pool which is Single threaded and there is no support for high concurrency (on multi core CPU machines)
Are there any plans to enhance commons-dbcp connecton pool manager?
What is the Connection Provide implementation used in JBoss?
commons-dbcp or C3P0 or JBoss own implementation?