Hi,

did You check the "ResultSet.wasNull()" method?
fr.

Am Mittwoch, 18. Juni 2008 01:54 schrieb paulstevenhowells:

> Hopefully someone out there can point me int he right direction.
>
> 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...
>
> create table inventory_item (
> inventory_item_id decimal(10) primary key,
> name varchar(254) not null,
> short_description varchar(2000) not null,
> long_description BLOB SUB_TYPE TEXT,
> price decimal(18,2) not null,
> primary_image decimal(10),
> deleted_ind varchar(1) not null,
> entry_userid varchar(100) not null,
> entry_timestamp timestamp not null,
> update_userid varchar(100) not null,
> update_timestamp timestamp not null,
> FOREIGN KEY (primary_image) REFERENCES image (image_id)
> );
>
> DEBUG java.sql.PreparedStatement - {pstm-100055} Executing
> Statement:
> INSERT INTO INVENTORY_ITEM (
> INVENTORY_ITEM_ID,
> NAME,
> SHORT_DESCRIPTION,
> LONG_DESCRIPTION,
> PRICE,
> PRIMARY_IMAGE,
> DELETED_IND,
> ENTRY_USERID,
> ENTRY_TIMESTAMP,
> UPDATE_USERID,
> UPDATE_TIMESTAMP
> ) VALUES (
> ?,
> ?,
> ?,
> ?,
> ?,
> ?,
> 'N',
> ?,
> CURRENT_TIMESTAMP,
> ?,
> CURRENT_TIMESTAMP
> );
> DEBUG java.sql.PreparedStatement - {pstm-100055} Parameters: [1,
> item1, SD, Ld, 7.0, null, nhowells, nhowells]
> DEBUG java.sql.PreparedStatement - {pstm-100055} Types:
> [java.lang.Long, java.lang.String, java.lang.String,
> java.lang.String, java.lang.Double, null, java.lang.String,
> java.lang.String]
>
>
> DEBUG java.sql.Connection - {conn-100056} Preparing Statement:
> SELECT T.INVENTORY_ITEM_ID,
> T.NAME,
> T.SHORT_DESCRIPTION,
> T.LONG_DESCRIPTION,
> T.PRICE,
> T.PRIMARY_IMAGE,
> T.ENTRY_USERID,
> T.ENTRY_TIMESTAMP,
> T.UPDATE_USERID,
> T.UPDATE_TIMESTAMP
> FROM INVENTORY_ITEM T
> WHERE T.DELETED_IND = 'N'
> AND T.INVENTORY_ITEM_ID = ?;
> DEBUG java.sql.PreparedStatement - {pstm-100057} Executing
> Statement:
> SELECT T.INVENTORY_ITEM_ID,
> T.NAME,
> T.SHORT_DESCRIPTION,
> T.LONG_DESCRIPTION,
> T.PRICE,
> T.PRIMARY_IMAGE,
> T.ENTRY_USERID,
> T.ENTRY_TIMESTAMP,
> T.UPDATE_USERID,
> T.UPDATE_TIMESTAMP
> FROM INVENTORY_ITEM T
> WHERE T.DELETED_IND = 'N'
> AND T.INVENTORY_ITEM_ID = ?;
> DEBUG java.sql.PreparedStatement - {pstm-100057} Parameters: [1]
> DEBUG java.sql.PreparedStatement - {pstm-100057} Types:
> [java.lang.Long]
> DEBUG java.sql.ResultSet - {rset-100058} ResultSet
> DEBUG java.sql.ResultSet - {rset-100058} Header: [INVENTORY_ITEM_ID,
> NAME, SHORT_DESCRIPTION, LONG_DESCRIPTION, PRICE, PRIMARY_IMAGE]
> DEBUG java.sql.ResultSet - {rset-100058} Result: [1, item1, SD, Ld,
> 7.0, 0]
>
> 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?
>
> Any help appreciated.
>
> Thanks
>
> Paul