Hi,

I think the two issues with the jdbc driver are resolved, see comments below..

> > 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
>
> When does it happen? Can you post your statement in which this happens?

This error happend in a query where the users query string exceeded the length
of the corresponding varchar field, so im to blame here, sorry for the noise.
I just think that the "operation was cancelled" message made me overlook that
the error was instead releated to a data truncation.

What led me in the right direction was an earlier thread where a guy was getting
Operation was cancelled in an insert statement where a field was exceeded.
(Re: PrepardStatement field truncation - 2004.03.04)

> > org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544726. Error
> > reading data from the connection.

This one turned out to be related to the above error, because it always happend
after the "Operation was cancelled".

Actually you have already concluded that in the same previous thread :

"Seems that 'operation was cancelled' belongs to so called "fatal"
exceptions, after which FBManagedConnectionFactory sees no sense to
continue."

So bottom line is, the real bug thats left is the NullPointer in GDS_Impl in
the JCA-JDBC driver!!

Is this a registered bug, do I need to register it somewhere ? Should I try to
contact David on this? This really is a showstopper for using the driver..

Regards
Torsten

> It seems that engine closes the socket. Can it be that engine has
> crashed? Can you post a stack trace here?
>
> > I must admit that im not sure these are due to driver errors, im
> > currently investigating that.
>
> First one might be driver problem. For some reasons engine sometimes
> returns "operation was cancelled" when we send incorrect packet over
> the socket. I need some test case.
>
>
> One more suggestion: try to contact David Jencks, he wrote a big part
> of the driver and all JCA stuff, as well as JCA support in JBoss.
> Currently he's not participating actively in both projects, but I
> think you can reach him through Core Developers Network.
>
> Best regards,
> Roman Rokytskyy