activiti5.16扩展支持达梦数据库

xYzz丶

已于 2024-04-17 17:48:54 修改

阅读量474

点赞数 5

文章标签：数据库

于 2024-04-17 17:34:31 首次发布

本文链接：https://blog.csdn.net/shmily_ab/article/details/137879273

版权

本文介绍了如何下载Activiti5.16源码，重点在于修改ProcessEngineConfigurationImpl和DbSqlSessionFactory类以支持DMDBMS数据库，并针对特定数据库如DMDBMS调整SQL语句，最后生成新的jar包替换项目中的旧版本。

摘要由CSDN通过智能技术生成

1.下载Activiti-activiti-5.16源码包；

https://codeload.github.com/Activiti/Activiti/zip/refs/tags/activiti-5.16https://codeload.github.com/Activiti/Activiti/zip/refs/tags/activiti-5.16

2.找到activiti-engine模块，只需修改两个类和表结构资源：

a、找到org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl类，在getDefaultDatabaseTypeMappings()方法中添加如下代码：

databaseTypeMappings.setProperty("DM DBMS","dm");

b、找到org.activiti.engine.impl.db.DbSqlSessionFactory类，在static块中添加如下代码：

    // dm
    databaseSpecificLimitBeforeStatements.put("dm", "select * from ( select a.*, ROWNUM rnum from (");
    databaseSpecificLimitAfterStatements.put("dm", "  ) a where ROWNUM < #{lastRow}) where rnum  >= #{firstRow}");
    databaseSpecificLimitBetweenStatements.put("dm", "");
    databaseOuterJoinLimitBetweenStatements.put("dm", "");
    databaseSpecificOrderByStatements.put("dm", defaultOrderBy);
    addDatabaseSpecificStatement("dm", "selectExclusiveJobsToExecute", "selectExclusiveJobsToExecute_integerBoolean");
    addDatabaseSpecificStatement("dm", "selectUnlockedTimersByDuedate", "selectUnlockedTimersByDuedate_oracle");
    addDatabaseSpecificStatement("dm", "insertEventLogEntry", "insertEventLogEntry_oracle");