Subject | Re: jaybird returns zero instead of null for DECIMAL colmn |
---|---|
Author | paulstevenhowells |
Post date | 2008-06-18T15:30:49Z |
--- In Firebird-Java@yahoogroups.com, Roman Rokytskyy <roman@...>
wrote:
wrote:
>full-
> > 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 nullfrom 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 Iare
> > need to turn off or what. The table definition and log4j logs
> > below...the
> > ...
> > 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?reproduce
>
> Sounds strange... can you prepare a standalone test case to
> the issue?I will try that today.
>
> Roman
>