Hi,

> I am using cmp so jboss is making the create statements for me.
> Anyway, here is what he create:
> The problem is when trying to set attribute 2 in here:
>
> AND (o.lastStateUpdateTime + o.stateUpdateTimeout BETWEEN 0 AND ?2)
>
> and it is taking it as FBIntegerField.
>
> Once again here is the mapping form jboss, but I think that problem is

I have found the issue. However, unfortunately this is not a bug in JayBird
(which would be easy to fix), but in Firebird, and I'm not sure if fixing it
is easy. Statement "<column> BETWEEN 0 AND ?" is processed by Firebird and
it assigns the INTEGER datatype to the parameter. This type is sent to the
driver and it correctly instantiates the FBIntegerField to handle datatype
conversions.

Sorry, but the workaround you have specified is the only possible solution
at present time.

I will create a corresponsding bug report for Firebird, maybe it will be
fixed in Firebird 2.0.

Roman