Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

JDBC Multitable Consumer handling of null date values

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)?