JDBC Multitable Consumer handling of null date values

asked 2019-02-03 04:04:45 -0500

Ronald M gravatar image

I'm trying to ingest MySQL tables with an offset based on a date column. Unfortunately, some rows have a date column equal to NULL (some have actual values).

I was able to address scenarios where dates are equal to zero - a connection property can be added to the JDBC connect string to convert this to NULL or a rounded value (used round instead of null).

A JDBC NullPointerException occurs when tables with NULL dates are used as offset. Is there a solution to convert the NULL date to something else (like the round option for zeroDateTime property)?

edit retag flag offensive close merge delete