Flowable工作流兼容达梦、人大金仓数据库

女爷i 2022-12-11 13:36 1549阅读 0赞

此处以金仓为例，达梦也是一样。

1、配置maven包

<dependency>
    			<groupId>com.kingbase8</groupId>
    			<artifactId>kingbase8</artifactId>
    			<version>8.2.0</version>
    			<scope>system</scope>
    			<systemPath>${basedir}/lib/kingbase8-8.2.0.jar</systemPath>
    		</dependency>

2、修改数据源

spring:
      datasource:
        dbType: kingbase
        URL: jdbc:kingbase8://192.168.1.89:54321/xx
        driverClassName: com.kingbase8.Driver

3、重写AbstractEngineConfiguration文件，添加如下：

public static final String DATABASE_TYPE_KINGBASE = "mysql";
    public static final String DATABASE_TYPE_DM = "mysql";
    public static Properties getDefaultDatabaseTypeMappings() {
        //...
        databaseTypeMappings.setProperty("KingbaseES", DATABASE_TYPE_KINGBASE);
        databaseTypeMappings.setProperty("DM DBMS", DATABASE_TYPE_DM);
        return databaseTypeMappings;
    }

此处最重要，要不找不到对应的数据库。

【注】：上面主要和key有关系，后面的value值默认可以通用mysql，若需要根据对应的数据库配置，则需要修改对应的properties文件。初始化的时候会调用如下方法，value值设置为其他值会报错空指针。所以通用mysql。

public String pathToEngineDbProperties() {
            return "org/flowable/common/db/properties/" + databaseType + ".properties";
        }

查看源码文件发现：properties文件位于如下目录![20201001154342493.png][]

参考地址：

[https://www.jianshu.com/p/24142518acf7][https_www.jianshu.com_p_24142518acf7]

[https://blog.csdn.net/qq\_42505088/article/details/108196487][https_blog.csdn.net_qq_42505088_article_details_108196487]

[https://www.cnblogs.com/DF-Kyun/p/13497135.html][https_www.cnblogs.com_DF-Kyun_p_13497135.html]

[20201001154342493.png]: /images/20221123/6952cc2092614782a193ca21f29c2ba7.png
[https_www.jianshu.com_p_24142518acf7]: https://www.jianshu.com/p/24142518acf7
[https_blog.csdn.net_qq_42505088_article_details_108196487]: https://blog.csdn.net/qq_42505088/article/details/108196487
[https_www.cnblogs.com_DF-Kyun_p_13497135.html]: https://www.cnblogs.com/DF-Kyun/p/13497135.html