kettle创建资源库报错

记录一下：
报错：
执行: INSERT INTO R_VERSION(ID_VERSION, MAJOR_VERSION, MINOR_VERSION, UPGRADE_DATE, IS_UPGRADE) VALUES (1,5,0,‘2020/01/09 22:05:16.918’,‘N’)

时发生错误

org.pentaho.di.core.exception.KettleDatabaseException:

Couldn’t execute SQL: INSERT INTO R_VERSION(ID_VERSION, MAJOR_VERSION, MINOR_VERSION, UPGRADE_DATE, IS_UPGRADE) VALUES (1,5,0,‘2020/01/09 22:05:16.918’,‘N’)

Incorrect integer value: ‘N’ for column ‘IS_UPGRADE’ at row 1

执行: INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (1,‘admin’,‘2be98afc86aa7f2e4cb79ce71da9fa6d4’,‘Administrator’,‘User manager’,‘Y’) 时发生错误
org.pentaho.di.core.exception.KettleDatabaseException:
Couldn’t execute SQL: INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (1,‘admin’,‘2be98afc86aa7f2e4cb79ce71da9fa6d4’,‘Administrator’,‘User manager’,‘Y’)

Incorrect integer value: ‘Y’ for column ‘ENABLED’ at row 1

执行: INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (2,‘guest’,‘2be98afc86aa7f2e4cb79ce77cb97bcce’,‘Guest account’,‘Read-only guest account’,‘Y’) 时发生错误
org.pentaho.di.core.exception.KettleDatabaseException:
Couldn’t execute SQL: INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (2,‘guest’,‘2be98afc86aa7f2e4cb79ce77cb97bcce’,‘Guest account’,‘Read-only guest account’,‘Y’)

Incorrect integer value: ‘Y’ for column ‘ENABLED’ at row 1

有三句sql执行报错true
解决：‘N’改为false 'Y’改为true
将以上语句改成下面的，然后在mysql数据库中手工执行一下
INSERT INTO R_VERSION(ID_VERSION, MAJOR_VERSION, MINOR_VERSION, UPGRADE_DATE, IS_UPGRADE) VALUES (1,5,0,‘2020/01/09 22:05:16.918’,FALSE)；

INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (1,‘admin’,‘2be98afc86aa7f2e4cb79ce71da9fa6d4’,‘Administrator’,‘User manager’,TRUE)；

INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (2,‘guest’,‘2be98afc86aa7f2e4cb79ce77cb97bcce’,‘Guest account’,‘Read-only guest account’,TRUE)；