db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremiah Jahn <jerem...@goodinassociates.com>
Subject Re: setNull on prepared statement not working?
Date Tue, 08 Feb 2005 14:30:20 GMT
It was the crack then...! I guess postgres and the as400 are just more
forgiving.... thanx for the help.

-jj-

On Mon, 2005-02-07 at 15:11 -0800, Sunitha Kambhampati wrote:
> Jeremiah Jahn wrote:
> 
> >	insertPreparedStatement.setNull(5,Types.NULL); where column is a
> >timestamp column.
> >
> >This is with the latest official release(10.0.2.1). running on java 5
> >and linux.
> >  
> >
> Actually, if you are trying to set null on a column with type timestamp 
> , I think it should be
> 
>         insertPreparedStatement.setNull(5,Types.TIMESTAMP);
> 
> http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedStatement.html#setNull(int,%20int)
> 
> Hope this helps,
> Sunitha.
> 
> 
> 
> 
The truth is what is; what should be is a dirty lie. -- Lenny Bruce

Mime
View raw message