SQLException: Zero date value prohibited about dbeam HOT 4 CLOSED

Can you provide some example on how you are using DBeam. I think I still don't understand why do we have some '1970-01-01' here.

from dbeam.

We are trying to use it to replicate tables from a MySQL database and it works in most cases. This issue is when we are trying to replicate a table that has dates with this value: 0000-00-00.

I was thinking of possibilities and maybe we could have some options when using dbeam to either change that zero date to some accepted range (that's why I said 1970) or maybe convert to NULL all dates that don't fall into the accepted range

from dbeam.

@jmriego I would say it should be much more easier to replace some dates in your own SQL query.
Have you seen an option:

--sqlFile: a path to a file containing a SQL query (used instead a generated query based on table parameter)

from dbeam.

I totally missed that parameter. That definitely works for me. Thanks!

from dbeam.