Debezium报错处理系列之六十五:Debezium JDBC connector无法支持mysql字段默认值为DEFAULT CURRENT_TIMESTAMP的解决方法
一、完整报错
- Caused by: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [CREATE TABLE ods_dw_prod_retail_order_detail_rt (id bigint NOT NULL, cdc_code longtext NOT NULL, product longtext NOT NULL, price integer NOT NULL, city longtext NOT NULL, user_deleted smallint DEFAULT 0 NOT NULL, is_completed smallint DEFAULT 1 NOT NULL, b smallint DEFAULT 1 NOT NULL, create_time datetime(6) DEFAULT ‘1970-01-01 00:00:00’ NULL, create_time2 timestamp(6) DEFAULT ‘1970-01-01T00:00:00’ NOT NULL, PRIMARY KEY(id))]
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java