Re: issue with integer nullable column and value 0 - Mailing list pgsql-bugs

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 =3D new StringBuilder();
        sql.append("UPDATE nvt_entity" +
                " SET user_id =3D ?" +
                " WHERE entity_id =3D ?");

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

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

Thanks for your time.

2009/10/15 Kevin Grittner <Kevin.Grittner@wicourts.gov>:
> Sean Hsien <umphy27@gmail.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? =C2=A0Also, what are the OS and Java versions on the client
> side?
>
> -Kevin
>