PostgreSQL JDBC-Driver - Writing empty TIMESTAMP

dev support
1

Environment:
OS: Windows 10 Pro
Java Version 11.0.6 (64 bit)
Apache Tomcat: 9.0.34
Lucee Version 6.1.0.243
PostgreSQL JDBC Driver: 42.7.3

In the past it was possible to erase a TIMESTAMP field in a PostgreSQL-Database by updating the field by writing a empty variable to the DB.
Writting an empty variable is no longer possible with the native driver.

Message: can’t cast to date value;
Is this a bug or a feature?

How can I empty a TIMESTAMP field in the database using the JDBC-Driver?

Best regards
Heinz Baltes

2 
UPDATE table
SET timestamp_field = NULL;

I don’t know if I understood correctly.
You can’t pass empty value (‘’") field is timestamp.

3

I suspect that previous versions of PostgreSQL would have been lenient enough to automatically cast the empty string to null. That probably changed. If you looked through PostgreSQL docs and release notes you might find when the change happened.

4

Thanks a lot for your hints. Solved my problem!