Several Connection Pools for CMP

[anichin]

Hi,

I have configured Oracle connection pool for CMP as it is described in JBoss documentation. However when I deploy my EJB, Jboss uses Hypersonic.

What I need to do to state that I would like to use Oracle for CMP ?

Thank you

[tom]

Hi,

I use serveral DataSources, but the default one is bound to DefaultDS in jboss.jcml . You might comment
out your HSQL / InstantDB parts.

...

<!--
First load the drivers AS A COMMA SEPERATED LIST !!!!
-->

oracle.jdbc.driver.OracleDriver,com.jnetdirect.jsql.JSQLDriver


<!-- Default database (Oracle on *******) -->

DefaultDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:thin:@**************
**********
**********


<!-- External Database ***** on ****) -->

*******
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:JSQLConnect://*********
*******
******

...

[anichin]

Thank you. It works.

Another solution I found was to specify
the datasource in jaws.xml file:


java:/OracleDB
<type-mapping>Oracle8</type-mapping>
....

[foglesa]

you should also change the standard-jboss.xml if you change the database of the defaultDS, or if you remove it since standard-Jboss.xml uses defaultDS and hypersonic as the mappings.

Al