Thanks for everyones help.  It turned out to be a simple user error.  I had 
the wrong URL (Oracle SID) for my connection.

On another note what is the preferred "DataSourceClass" for Oracle?

1. org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl

or

2. oracle.jdbc.xa.client.OracleXADataSource

The JBoss docs say there are some problems with Oracle's JDBC 2.0 support.

Thanks again,

Brett


>       <attribute
>name="URL">jdbc:oracle:thin:@localhost:1521:instance</attribute>

>From: "Brett Palmer" <[EMAIL PROTECTED]>
>Reply-To: "JBoss-User" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: [jBoss-User] Changes in DB configuration for Oracle
>Date: Tue, 06 Mar 2001 12:36:16 -0700
>
>Thanks for your help.  Your suggestion fixed the exceptions I was getting
>when I started Jboss, but now Jboss hangs when it starts to create the
>connection pool to Oracle and the connection is never made to the database.
>Here is the last output I get from Jboss is:
>
>[MyOracleDataSource] Starting
>[MyOracleDataSource] XA Connection pool MyOracleDataSource bound to
>java:/MyOracleDataSource
>
>I have to control-c to exit Jboss at this point.  My jboss.jcml
>
>  <mbean code="org.jboss.jdbc.XADataSourceLoader"
>name="DefaultDomain:service=XADataSource,name=MyOracleDataSource">
>    <attribute name="PoolName">MyOracleDataSource</attribute>
>    <attribute
>name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
>    <attribute name="Properties"></attribute>
>       <attribute
>name="URL">jdbc:oracle:thin:@localhost:1521:instance</attribute>
>    <attribute name="GCMinIdleTime">1200000</attribute>
>       <attribute name="JDBCUser">in2m</attribute>
>    <attribute name="MaxSize">10</attribute>
>       <attribute name="Password">in2m</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">3</attribute>
>  </mbean>
>
>I also tried setting the "DataSourceClass" to
>oracle.jdbc.xa.client.OracleXADataSource but the result was the same.
>
>Thanks again,
>
>Brett
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com



--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]

Reply via email to