【BUG之路】activiti执行查询 ： MySQL server version for the right syntax to use near 'LIMIT 100'

程序上activiti查询任务脚本：

==>  Preparing: select distinct RES.* from ACT_RU_TASK RES WHERE RES.ASSIGNEE_ = ? order by RES.ID_ asc LIMIT ? OFFSET ? 
Fri May 24 09:12:56 CST 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
==> Parameters: suwan(String), 2147483647(Integer), 0(Integer)

 

替换为可执行脚本为：

select distinct RES.* from ACT_RU_TASK RES WHERE RES.ASSIGNEE_ ='suwan' order by RES.ID_ asc LIMIT 2147483647  OFFSET  0;

这个脚本 有些mysql数据库的版本可以执行 ，有些就会报上面的错误。

这里我的解决方案是：

taskService.createTaskQuery()        //创建查询对象
                .taskAssignee(USERNAME).listPage(0,10); 

 

listPage(0,10);   分页查询，测试通过。