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
