flowable6.6.0启动报错class java.time.LocalDateTime cannot be cast to class java.lang.String解决

路过君

发布于 2022-06-30 13:42:18

1.8K0

发布于 2022-06-30 13:42:18

文章被收录于专栏：路过君BLOG from CSDN

版本

flowable 6.6.0 mysql-connector-java 8.0.29

现象

配置自动初始化数据库，第一次启动正常，并成功初始化数据库重新启动失败，报错

org.flowable.common.engine.api.FlowableException: Error initialising eventregistry data model … Caused by: java.lang.ClassCastException: class java.time.LocalDateTime cannot be cast to class java.lang.String (java.time.LocalDateTime and java.lang.String are in module java.base of loader ‘bootstrap’) at liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:328)

原因

flowable 6.6.0 默认依赖liquibase-core:3.8.0

liquibase通过查询数据库表变更日志检查是否需要更新表结构，由于数据库驱动版本较新，返回的数据日期格式为LocalDateTime，导致不兼容报错 liquibase.changelog.StandardChangeLogHistoryService

public List<RanChangeSet> getRanChangeSets() throws DatabaseException {
    ...
    // 此处tmpDateExecuted 为LocalDateTime    
    Object tmpDateExecuted = rs.get("DATEEXECUTED");
    Date dateExecuted = null;
    if (tmpDateExecuted instanceof Date) {
        dateExecuted = (Date)tmpDateExecuted;
    } else {
        DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        try {
            dateExecuted = df.parse((String)tmpDateExecuted);
        } catch (ParseException var24) {
        }
    }
	...
}

解决

方案1：mysql数据库驱动版本退回到8.0.22 方案2：liquibase-core依赖版本升级到4.3.1以后的版本修复此问题 liquibase.changelog.StandardChangeLogHistoryService

public List<RanChangeSet> getRanChangeSets() throws DatabaseException {
	...
	Object tmpDateExecuted = rs.get("DATEEXECUTED");
    Date dateExecuted = null;
    if (tmpDateExecuted instanceof Date) {
        dateExecuted = (Date)tmpDateExecuted;
    } else if (tmpDateExecuted instanceof LocalDateTime) { // 增加了对LocalDateTime类型的处理
        dateExecuted = Date.from(((LocalDateTime)tmpDateExecuted).atZone(ZoneId.systemDefault()).toInstant());
    } else {
        DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        try {
            dateExecuted = df.parse((String)tmpDateExecuted);
        } catch (ParseException var26) {
        }
    }
	...
}

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2022-06-29，如有侵权请联系 cloudcommunity@tencent.com 删除

java