This is what we use:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=DataSource">
<attribute name="PoolName">DataSource</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="Properties"></attribute>
<attribute
name="URL">jdbc:oracle:thin:@XXX.XXX.XXX.XXX:1521:DNAME</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">uid</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">pwd</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
and it seems to work fine...
>
> Does anyone have the jboss.cfml example for oracle 8i connection pooling
for
> JBoss 2.1?
>
> I have the following in my cfml file but JBoss crashes. Once I remove it
> JBoss starts up just fine.
>
> <!-- JDBC -->
> <mbean code="org.jboss.jdbc.JdbcProvider"
> name="DefaultDomain:service=JdbcProvider">
> <attribute
>
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,orac
> le.jdbc.driver.OracleDriver</attribute>
> </mbean>
>
> <!-- J2EE deployer -->
> <mbean code="org.jboss.ejb.AutoDeployer"
name="EJB:service=AutoDeployer">
> <attribute name="Deployer">J2EE:service=J2eeDeployer</attribute>
> <attribute name="URLs">../deploy</attribute>
> </mbean>
>
> <!-- Add your custom MBeans here -->
> <mbean
>
code="org.jboss.jdbc.XADataSourceLoader"name="DefaultDomain:service=XADataSo
> urce,name=OracleDB">
> <attribute name="PoolName">OracleDB</attribute>
> <attribute
>
name="DataSourceClass">oracle.jdbc.xa.client.OracleXADataSource</attribute>
> <attribute name="Properties"></attribute>
> <attribute name="URL">something</attribute>
> <attribute name="JDBCUser">userid</attribute>
> <attribute name="Password">password</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]