Subject Re: [Firebird-Java] jaybird returns zero instead of null for DECIMAL colmn
Author Roman Rokytskyy
> I have a Firebird 2.1 database installed on Windows XP. I am
> accessing the DB from a java web application using the jaybird-full-
> 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. I
> 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 are
> 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 the
> null is returned as zero. WFT?

Sounds strange... can you prepare a standalone test case to reproduce
the issue?

Roman