Toby, I think you are right.
I replaced the mbean configuration to use XADataSourceLoader and minerva (I
had to patch minerva to support scrollable result sets...), tested the
server under load and it was MUCH faster.
I didnt get into details and log/trace files, but the differences in speed
were visible to the human eye ....
Thanks, Shahar.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Toby Allsopp
Sent: Tuesday, April 10, 2001 3:47 AM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] Solving Oracle Connection Pool Hanging
On Mon, Apr 09, 2001 at 11:20:36PM +0200, Shahar Solomianik wrote:
> Apart from things like that in my code (bmp entities and stateless
sessions)
> :
>
> Context ctx = new InitialContext();
> DataSource ds =
(DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB");
> conn = ds.getConnection();
Hang on. Are you saying that the class
oracle.jdbc.xa.client.OracleXADataSource
implements javax.sql.DataSource *and* javax.sql.XADataSource?
Do you have documentation on what this class actually implements?
It looks like Oracle's JDBC driver is doing some of the stuff that I said
it wouldn't. If this is working properly, then you need to be aware that
this is not in any way portable.
I still don't believe that transactions will work correctly, because the
JDBC driver doesn't have a hook into JBoss's transaction manager. Be
very, very careful before you decide it's working. I'd be interested to see
some debugging output from the transaction manager if you decide this is
working (set trace to true in TxCapsule or something, I think).
Toby.
> <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>
>
> Shahar.
_______________________________________________
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
