The value class java.time.LocalDateTime cannot be converted to a date
You may encounter this error in ColdFusion when working with MySQL. It is rather strange:
The value class java.time.LocalDateTime cannot be converted to a date
First, let’s talk about the solution. This error occurs due to the MySQL Connector version 8.0.23 and newer. If you recently upgraded ColdFusion, CF Docker image, ColdBox, or manually adjust MySQL connector to one of the recent versions, you will see this error rather sooner than later.
The solution is to remove the 8.0.23 driver and download the older one from https://downloads.mysql.com/archives/c-j/
You should select a Platform-independent driver in version 8.0.22 – that is the last one that works.
Once the connector is replaced and ColdFusion restarted – the error is gone.
You may read more about this one on Adobe ColdFusion alerts page:
https://coldfusion.adobe.com/2021/03/alert-mysql-connector-j-8-0-23/
There is also some information provided on the MySQL bug tracker: