Activiti在和mybatis出现的问题

最新推荐文章于 2023-10-16 16:07:29 发布

iteye_8560

最新推荐文章于 2023-10-16 16:07:29 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： mybatis Acitviti 文章标签： mybatis spring Activiti

本文链接：https://blog.youkuaiyun.com/iteye_8560/article/details/82638793

mybatis 同时被 2 个专栏收录

4 篇文章

订阅专栏

Acitviti

4 篇文章

订阅专栏

本文解决Activiti在与MyBatis整合时出现的SQL语法错误，通过更换MyBatis版本从3.3.0更改为3.2.5来解决。同时提供了解决在安装ActivitiDesigner插件时遇到的错误，如安装补丁graphiti和ActivitiBPMN2.0designer的方法。此外，还提到了在eclipse中遇到的类似错误及解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[b]bug1
[/b]Activiti在和mybatis整合时候出现

Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 2147483647 OFFSET 0' at line 7
### The error may exist in org/activiti/db/mapping/entity/ProcessDefinition.xml
### The error may involve org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionsByQueryCriteria_mysql-Inline
### The error occurred while setting parameters
### SQL: select distinct RES.*              from ACT_RE_PROCDEF RES                       order by  order by RES.ID_ asc       LIMIT ? OFFSET ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RES.ID_ asc  
    LIMIT 2147483647 OFFSET 0' at line 7] with root cause

order by order by错误的例子，我用的是mybatis-3.3.0就会出现这个问题换成官网支持的mybatis-3.2.5就OK了

案例1：
我在安装Activiti Designer插件时候出现

An error occurred while collecting items to be installed
session context was:(profile=epp.package.jee, phase=org.eclipse.equinox.internal.p2.engine.phases.Collect, operand=, action=).
No repository found containing: osgi.bundle,org.aspectj.runtime.source,1.7.0.20120703164200
No repository found containing: osgi.bundle,org.eclipse.contribution.weaving.jdt.source,2.2.0.e37x-RELEASE-20120704-0900

类似的错误。你需要先安装eclipse的补丁
graphiti：http://archive.eclipse.org/graphiti/updates/0.9.0/
再安装Activiti BPMN 2.0 designer:http://activiti.org/designer/update/
Ok 在一种办法就是将所有版本的插件放入eclipse的插件中重启eclipse