Subject Re: jaybird returns zero instead of null for DECIMAL colmn
Author paulstevenhowells
--- In, Roman Rokytskyy <roman@...>
> > I have a Firebird 2.1 database installed on Windows XP. I am
> > accessing the DB from a java web application using the jaybird-
> > 2.1.3.jar JDBC driver. My problem is that when I select null
from my
> > "primary_image decimal(10)" column the result set returns zero.
> > need it to return null. I don't know if this is a feature that I
> > need to turn off or what. The table definition and log4j logs
> > below...
> > ...
> > You can see above that a null is being inserted into in the
> > PRIMARY_IMAGE column. I have verified that it is null in the
> > database by using another tool. When the above SQL is executed
> > null is returned as zero. WFT?
> Sounds strange... can you prepare a standalone test case to
> the issue?
> Roman

I will try that today.