Subject Re: XA driver pooling issue
Author Ludovic Orban
Hi Roman,

--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
>
> Which version of WebLogic do you use?
>

8.1 sp5

> > <22-oct.-2005 12 h 25 min 16 s CEST> <Error> <JDBC> <BEA-001035> <The
> > following error has occurred: XA operation failed :
> > org.firebirdsql.jca.FBXAException: You are trying to resume a
> > transaction that has is new
>
> This error is really strange, it says that WebLogic asks to resume a
> distributed transaction passing an unknown Xid to it. As far as I
> understand, that is against JTA specification. But I need to check.
>

Could you please also fix the spelling of the error message ? It's not
very good english. :-)

> > Driver classname:
> > org.firebirdsql.pool.sun.AppServerXADataSource
>
> Why do you use pool for Sun App Server, not the
FBConnectionPoolDataSource?
>

I tried both and they give the same result. I've chosen this one for
no particular reason.


> > Any cluse why disabling driver pooling confuses weblogic or why
> > weblogic confuses jaybird ?
>
> Both is possible. I need to check it.
>

Is there something I can do to help you reproduce the issue ? I'm very
eager to get a fully working XA-enabled Firebird.

Some other clue: this log appears in the WLS console on startup only
when connection pooling is on:
<22-oct.-2005 21 h 25 min 31 s CEST> <Error> <JDBC> <BEA-001112> <Test
"select 1 from rdb$database" set up for pool "Firebird XA Pool DB1"
failed with exception: "java.lang.NullPointerException".>

No stack trace in this case but I'm wondering if that NPE is not the
root cause.

I also noticed that XAResource.prepare() never returns XA_RDONLY even
if no change has been done in the database. Is that some limitation of
the Firebird engine ?

Thank you,
Ludovic