Re: setNull on prepared statement not working?

[Sunitha Kambhampati]

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.