fixteam/fixflow

部署后访问报数据库查询SQL语法错误,数据库用的是MySQL 5.5.13

Opened this issue · 0 comments

下载fixflow5.2部署到apache-tomcat-8.0.36后,使用admin用户登录访问报数据库异常:
[com.found
er.fix.fixflow.core.impl.db.MappingSqlSession.selectList(MappingSqlSession.java:
348)] - 规则: selectTaskByQueryCriteria 执行出错,规则执行类为: com.founder.fix.f
ixflow.expand.rulescript.select.TaskQueryScript,错误信息: 查询错误: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 CREATE_TIME desc ) as RN_
FROM (select distinct top 100 percent T.' at line 1
com.founder.fix.fixflow.core.exception.FixFlowException: 查询错误:You have an e
rror in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '( order by CREATE_TIME desc ) as RN_
FROM (select distinct top 100 percent T.' at line 1
at com.founder.fix.fixflow.core.impl.db.SqlCommand.queryForList(SqlComma
nd.java:258)
at com.founder.fix.fixflow.expand.rulescript.select.TaskQueryScript.find
TasksByQueryCriteria(TaskQueryScript.java:136)

数据库用的是MySQL 5.5.13