yes.
and use properties attribute instead the standard params, and Oracle XA
instead of minerva...
this is from my jboss.jcml :
<mbean code="org.jboss.jdbc.RawXADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=OraclePool">
<attribute name="PoolName">OraclePool</attribute>
<attribute
name="DataSourceClass">oracle.jdbc.xa.client.OracleXADataSource</attribute>
<attribute
name="Properties">URL=jdbc:oracle:oci8:scott/tiger@orcl</attribute>
</mbean>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Simphoukham,
Southin
Sent: Monday, April 09, 2001 2:15 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] Solving Oracle Connection Pool Hanging
Shahar,
How do you do that?
Do you replace org.jboss.jdbc.XADataSourceLoader?
<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="Properties"></attribute>
Southin
-----Original Message-----
From: Shahar Solomianik [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 6:23 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Solving Oracle Connection Pool Hanging
Use RawXADataSource and it works (at least for me)
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tim Taylor
Sent: Saturday, April 07, 2001 11:56 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging
I tend to agree that the JBoss-blocking behavior of incorrectly set up
XADataSources is a bug. I ran into this too, and judging from the
number of "Oracle pool hanging" messages on this list, a lot of people
are running into it.
I think it happens at the end of the pool creation when
XADataSourceLoader of JBoss does a quick call to check the health of the
Minerva XADataSource. The health check hangs waiting for a connection
from the source. If the data source is set up incorrectly in any way,
the pool will never contain a connection to allocate, and the call hangs.
I think a call to an XADataSource.getConnection() should get an
SQLException when the underlying connection factory (in this case, in
the excellent Minerva) gets an SQLException. My $0.02.
Tim Taylor
Tim Kemp wrote:
> I too have suffered from the Oracle Connection Pool hanging JBoss 2.1 on
> startup.
>
> By adding the following line to the Datasource mbean (in jboss.jcml), the
> exact error is displayed in the JBoss output.
>
> <attribute name="LoggingEnabled">true</attribute>
>
> In my case it was an incorrect database instance that caused the
connection
> pool to hand
>
> [OraclePool] Starting
> [OraclePool] XA Connection pool OraclePool bound to java:/OraclePool
> [OraclePool] java.sql.SQLException: Io exception: Connection
> refused(DESCRIPTION
>
=(TMP=)(VSNNUM=135294976)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)
> )))
> [OraclePool] Pool OraclePool factory
> org.opentools.minerva.jdbc.xa.XAConnectionF
> actory@6ac461 unable to create new object!
> [OraclePool] Pool OraclePool [0/0/10] waiting for a free object <<<<<
> Surely this is a problem in JBoss!!!!! >>>>>
>
> So the connection pool couldn't connect to Oracle - causing JBoss to hang
> while it was waiting for a free connection, which could never be returned
> cos the connection failed!
>
> Tim
>
> _______________________________________________
> 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
_______________________________________________
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
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
