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.gritt...@wicourts.gov>:
> Sean Hsien <umph...@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
>
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
