> >
> > > Hi,
> > >
> > > > Im facing a problem that seems to be caused by a bug in the firebird
> > > > JCA driver, i may wrong though, so im posting here to see if any
> > > > body else have experienced this, or have some idea about whats
> > > > happening....
> > > >
> > > > I am using Firebird 1.5 final (superserver on windows) and jaybird
> > > > 1.5-beta3 in a j2ee app running on jBoss.
> > > >
> > > > Now sometimes the login verification sql query will result in a
> null
> > > > pointer in
> > >
> >org.firebirdsql.jgds.GDS_Impl.isc_start_transaction(GDS_Impl.java:539)
> > >
> > > I have at least one bug report for this problem. It seems that under
> > > some conditions db handle is invalidated, but connection is still
> in use.
> > >
> > > Do you have a reproducable test case?
> >
> > Sorry but no, i cannot reproduce it :-( If i manage to, i will let
> you know.
> >
> > > > When this happens subsequent attemps to use the datasource will all
> > > > fail. The only fix is to restart the ManagedConnectionFactory in
> > > > jboss.jca domain.
> > >
> > > How important is XA support for you? If you can use normal JDBC
> > > driver, please try this.
> >
> > I will try without XA support...
> >
> > Thanks a lot...
> > Torsten
> >
> > > Thanks!
> > > Roman
> > >
>
> Torsten,
>
> Did you ever resolve this issue. I have the same error using
> JBoss3.2.3 and Firebird1.0.1 + JCA-JDBC Driver. 99.9% of the
> transactions done work but the odd one fails with NullPointerException
> in org.firebirdsql.jgds.GDS_Impl.isc_start_transaction(GDS_Impl.java:486)

No it's not resolved :-(

It's an issue with both firebird 1.01 and 1.5beta4.

I have tried to switcing to using a normal jdbc driver with jaybird 1.5
(<local-tx-datasource> in jboss) as advised ealier in this thread. This
really is not an option for me, I need the JCA support, but I wanted to
see if this configuration would result in other isssues... and it has :-(

now im getting a lot of the following exceptions:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544794. operation was cancelled
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544726. Error reading data from the connection.

I must admit that im not sure these are due to driver errors, im currently
investigating that.

I have a setup running with firebird on one server and my j2ee app on another,
this setup has not yet had any errors.

Another setup with the same j2ee application on a server which has its disks
in a SAN, is throwing those exceptions

Now i havent been running them long enough to know if rule out that its a software
issue and not, as perhaps more obvious, hardware related.

I cant seem to find many posts/info regarding these exception :-(

If you manage to resolve the issue with the JCA-JDBC driver, PLEASE post your results,
I will do the same..

Regards,
Torsten

> Unfortunately this is hard to reproduce because it may take 100,000's
> of transactions before you get the error.

Yep thats the problem :-(

> regards,
>
> Jeff.