Hi,
Now, I'm not able to set a null value for a timestamp.
My table:
CREATE TABLE TEST_TABLE (C_TIMESTAMP TIMESTAMP)
My query:
SELECT * FROM TEST_TABLE WHERE ? IS NULL OR ? = C_TIMESTAMP
Data type and type name for my column C_TIMESTAMP are respectively 93 and "timestamp" (checked with the metadata provided by the driver).
Using PreparedStatement.setNull(pos, 93) or PreparedStatement.setNull(pos, 93, "timestamp") for pos = 1, 2 does not work (could not determine data type of parameter).
Using PreparedStatement.setNull(pos, 91) does work!
Is it expected?
Rémi
So
ps.setNull(1, Types.TIMESTAMP);
Doesn't work ?
--