repositoryService.createProcessDefinitionQuery().list() Query Bug?

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

tangwei

I use activiti 5.17

When invoke below:

List<ProcessDefinition> processDefinitionList = repositoryService.createProcessDefinitionQuery().list();

this is two "order by"?
the Exception :

org.apache.ibatis.exceptions.PersistenceException:
### 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
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
   at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:426)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:417)
   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:407)
   at org.activiti.engine.impl.persistence.entity.ProcessDefinitionEntityManager.findProcessDefinitionsByQueryCriteria(ProcessDefinitionEntityManager.java:57)
   at org.activiti.engine.impl.ProcessDefinitionQueryImpl.executeList(ProcessDefinitionQueryImpl.java:288)

tangwei

It is not support mybatis 3.3?
using mybatis 3.2 will be ok.