OracleXADataSource works fine in 8.1.7 (for me). I have heard of problems
in earlier
versions.
Brett Palmer wrote:
> 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.XADataSourceIm
pl</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]
---------------------------------------------------------------------
This message (including any attachments) contains confidential, proprietary
or privileged information intended for a specific purpose and individual(s),
and is protected by law. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. Any unauthorized disclosure,
copying or distribution of any part of this message, or the taking of any
unauthorized action based on it, is strictly prohibited.
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
