Обсуждение: issue with integer nullable column and value 0

Hi guys,

I'm not sure what the source of this bug is, as I'm getting a
discrepancy between 8.1 on Linux vs. 8.4 on Windows, using the latest
JDBC driver type 4.

The issue is this, 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.

Not sure if anyone else has come across this issue?

Thanks in advance.

Sean

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?  Also, what are the OS and Java versions on the client
side?

-Kevin

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
>

Sean Hsien <umphy27@gmail.com> wrote:
> 2009/10/15 Kevin Grittner <Kevin.Grittner@wicourts.gov>:

>> what are the OS and Java versions on the client side?

> 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.

So the Java code is running on the same machine as the database in
each case?

>> Could you post a small, self-contained example of code which
>> exhibits this problem?

> Here is a small code snippet

A self-contained example would include creation and population of the
table, as well as enough code to actually run the snippet and show the
results.  You should run this in both environments to confirm that the
problem indeed manifests as you describe with the example you provide.

-Kevin

Found the bug...was my fault, of course.

Sorry for the mistake.

Sean