• activiti的坑


    maven配置:

    <dependency>
    <groupId>org.activiti</groupId>
    <artifactId>activiti-engine</artifactId>
    <version>7-201802-EA</version>
    </dependency>
    <dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.4.196</version>
    <scope>test</scope>
    </dependency>

    <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.11</version>
    </dependency>

    代码:

    public class ActivitiTest {

    public static void main(String[] args) {
    ProcessEngineConfiguration processEngineConfiguration =
    ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();
    processEngineConfiguration.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/test4?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=true");
    processEngineConfiguration.setJdbcDriver("com.mysql.cj.jdbc.Driver");
    processEngineConfiguration.setJdbcUsername("root");
    processEngineConfiguration.setJdbcPassword("");
    processEngineConfiguration.setDatabaseSchema("ACT");
    processEngineConfiguration.setDatabaseSchemaUpdate("drop-create");
    processEngineConfiguration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);
    ProcessEngine processEngine = processEngineConfiguration.buildProcessEngine();
    // RepositoryService repositoryService = processEngine.getRepositoryService();
    // RuntimeService runtimeService = processEngine.getRuntimeService();

    }
    }

    运行发生错误:

    Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
    ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'test4.act_ge_property' doesn't exist
    ### The error may exist in org/activiti/db/mapping/entity/Property.xml
    ### The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
    ### The error occurred while setting parameters
    ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
    ### Cause: java.sql.SQLSyntaxErrorException: Table 'test4.act_ge_property' doesn't exist
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)

    Caused by: java.sql.SQLSyntaxErrorException: Table 'test4.act_ge_property' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118)

    解决方法:

    (1)把mysql8.0的版本改成5.0的

    <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.41</version>
    </dependency>

    (2)修改驱动:

    com.mysql.jdbc.Driver

    //activiti的服务

    Service接口作用
    RepositoryService 流程仓库Service,用于管理流程仓库,例如部署、删除、读取流程资源
    IdentifyService 身份Service,用于管理和查询用户、组之间的关系
    RuntimeService 运行时Service,可以也拿过来处理所有正在运行状态的流程实例、任务等
    TaskService 任务Service,用于管理和查询任务,例如签收、办理、指派等
    FormService 表单Service,用于读取流程、任务相关的表单数据
    HistoryService 历史Service,用于查询所有历史数据,例如流程实例、任务、活动、变量、附件
    ManagementService 引擎管理Service,和具体业务无关,主要可以查询引擎配置、数据库、作业等
  • 相关阅读:
    C#消息筛选实现自动锁屏功能
    C#Path目录路径常用操作
    WPFMVVMLight框架学习使用MVVMLight
    C#使用SqlSugar操作数据库导致的问题:托管调试助手“FatalExecutionEngineError”:运行时遇到了 错误。此错误的地址为。。。。
    django—admin 使用simpleui自定义左边菜单栏及去除simple的广告链接
    bcdedit
    Ubuntu中root用户和user用户的相互切换
    ubuntu创建、删除文件及文件夹,强制清空回收站方法
    javascript 内存监测工具
    常用前端开发工具合集
  • 原文地址:https://www.cnblogs.com/shanshen/p/9054173.html
Copyright © 2020-2023  润新知