I uncommented this line in jboss.properties
jboss.xa.xidclass=oracle.jdbc.xa.OracleXid
and change my jboss.jcml to |:
<!-- 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>
<mbean code="org.jboss.jdbc.HypersonicDatabase"
name="DefaultDomain:service=Hypersonic">
<attribute name="Port">1476</attribute>
<attribute name="Silent">true</attribute>
<attribute name="Database">default</attribute>
<attribute name="Trace">false</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=OracleDS">
<attribute name="PoolName">OracleDS</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="URL">jdbc:oracle:thin:@sc2:1521:cad</attribute>
<attribute name="JDBCUser">cons_tre</attribute>
<attribute name="Password">pcdigital</attribute>
<attribute name="MinSize">2</attribute>
<attribute name="LoggingEnabled">true</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
</mbean>
At 03:50 07/06/01 -0400, you wrote:
>Guy: your example worked. The difference that made it work was the
>specification of "OracleDB" rather than "OracleDS".
>
>Whoever maintains http://www.jboss.org/documentation/HTML/ch03s05.html,
>please
>correct the example, as it specified "OracleDS", which doesn't work, and
>has
>caused at least two other people the same failure.
>
>The following is an example of the console log as it looks when Oracle
>connectivity works..
>
>[OracleDB] Starting
>[OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
>[OracleDB] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
>created new Co
>
>nnection (oracle.jdbc.driver.OracleConnection) with XAResource
>org.opentools.min
>
>erva.jdbc.xa.wrapper.XAResourceImpl and XAConnection
>org.opentools.minerva.jdbc.
>
>xa.wrapper.XAConnectionImpl.
>[OracleDB] No transaction right now.
>[OracleDB] Pool OracleDB [0/0/Unlimited] gave out new object:
>org.opentools.mine
>
>rva.jdbc.xa.wrapper.XAConnectionImpl@b8914
>[OracleDB] Pool OracleDB [0/1/Unlimited] returned object
>org.opentools.minerva.j
>
>dbc.xa.wrapper.XAConnectionImpl@b8914 to the pool.
>[OracleDB] Started
>[Service Control] Started 26 services
>[Default] JBoss 2.2.2 Started in 0m:33s
>
>Guy Rouillier wrote:
>
>> ----- Original Message -----
>> From: "David Filiatrault" <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>
>> Sent: Tuesday, June 05, 2001 11:32 AM
>> Subject: Re: [JBoss-user] NullPointerException in XAPoolDataSource.java:165
>>
>> > Yes, I know I'm using an unusual port. I verified it was working using
>> > tnsping. If it was a problem connecting to Oracle, I would expect to see
>> an SQL
>> > Exception logged before this NullPointerException. Is this a valid
>> expectation?
>>
>> No. If it can't get a connection, you'll just get a null pointer, because
>> with no connection, nothing gets added to the connection pool and you have
>> no connection object.
>>
>> >
>> > Does anybody have a jboss.jcml which does work with Oracle? If so,
please
>> post
>> > it (and feel free to xxx out the password), as I've gotten two emails
from
>> other
>> > users who say they have the same problem.
>> >
>> > -David
>> >
>>
>> Note that if you are running 2.2.2, the pool name has changed to JBossPool.
>> I haven't upgraded yet.
>>
>> <mbean code="org.jboss.jdbc.XADataSourceLoader"
>> name="DefaultDomain:service=XADataSource,name=OracleDB">
>> <attribute name="PoolName">OracleDB</attribute>
>> <attribute
>>
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
>> l</attribute>
>> <attribute
>> name="URL">jdbc:oracle:thin:@localhost:1521:homedb</attribute>
>> <attribute name="LoggingEnabled">true</attribute>
>> <attribute name="JDBCUser">guyr</attribute>
>> <attribute name="Password">xxxxx</attribute>
>> </mbean>
>>
>> _______________________________________________
>> JBoss-user mailing list
>> [EMAIL PROTECTED]
>> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
>_______________________________________________
>JBoss-user mailing list
>[EMAIL PROTECTED]
>http://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
Emerson Cargnin
TRE-SC
Setor de Desenvolvimento
Tel: (48) 251-3700 - Ramal 3134
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
