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

[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.

[devesh]

Hi,
 
  It would be big change for me to use the downgraded version of MyBatis now.
  I may need to take a look at JBOSS one now …
 
Thank You for the replies .

[trademak]

We have a PR outstanding to upgrade to MyBatis 3.3.0, so we'll support the latest MyBatis in the next version of Activiti.

Best regards,