Activiti在和mybatis出现的问题

[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