Re: issue with integer nullable column and value 0

I'm using CentOS 5.2 64-bits with postgres 8.1.11 + java 6u16, and
Windows Vista 32-bits with postgres 8.4.1 + java 6u13.

Here is a small code snippet that shows the problem, where the user id
value is 0:

public void update(EntityVO vo) {
StringBuilder sql = new StringBuilder();
sql.append("UPDATE nvt_entity" +
" SET user_id = ?" +
" WHERE entity_id = ?");

Object args[] = {
vo.getUserId() == -1 ? null : vo.getUserId(),
vo.getEntityId()
};

getJdbcTemplate().update(sql.toString(), args);
}

Thanks for your time.

2009/10/15 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> Sean Hsien <umphy27(at)gmail(dot)com> wrote:
>
>> using the latest JDBC driver type 4.
>
>> I have a nullable integer column in one of my tables. When I'm
>> updating the column in 8.4 Windows with value 0, it stays as null,
>> but on the Linux 8.1 it will try to update it with the value 0.
>
> Could you post a small, self-contained example of code which exhibits
> this problem?  Also, what are the OS and Java versions on the client
> side?
>
> -Kevin
>