Change Timestamp column in job_instance_status for mysql

jlolling / talendcomp_tJobInstance

Talend User Components to work with the cimt framework for batch jobs. These components are developed as cooperation between cimt AG and Jan Lolling

Apache License 2.0

14 stars 7 forks source link

Change Timestamp column in job_instance_status for mysql #11

Closed mattywausb closed 7 years ago

mattywausb commented 7 years ago

During some "crazy" default beaviour with timestamps in mysql, at least the timestamps for job_start and job_stop should be decared with default "null" as follows:

JOB_STARTED_AT TIMESTAMP(3) NULL default NULL, JOB_ENDED_AT TIMESTAMP(3) NULL default NULL,

Else the mysql assigns 0 as default, wich will result in exceptions, when reading the timestamps with talend.

jlolling commented 7 years ago

Documentation fixed