NutzCN Logo
问答 工作流读取列表出错
发布于 3337天前 作者 qq_b76927b4 2900 次浏览 复制 上一个帖子 下一个帖子
标签: 工作流

activiti工作流,这个地址http://localhost:8080/WfFrame/private/wf/model/list出错
2015-11-03 15:08:59,107 [DEBUG][org.activiti.engine.impl.interceptor.LogInterceptor] - --- starting ModelQueryImpl --------------------------------------------------------
2015-11-03 15:08:59,109 [DEBUG][org.apache.ibatis.transaction.jdbc.JdbcTransaction] - Opening JDBC Connection
2015-11-03 15:08:59,109 [DEBUG][org.apache.ibatis.transaction.jdbc.JdbcTransaction] - Setting autocommit to false on JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4ec7fa8c]
2015-11-03 15:08:59,109 [DEBUG][org.activiti.engine.impl.persistence.entity.ModelEntity.selectModelsByQueryCriteria] - ==> Preparing: select distinct RES.* from ACT_RE_MODEL RES order by order by RES.CREATE_TIME_ desc LIMIT ? OFFSET ?
2015-11-03 15:08:59,109 [DEBUG][org.activiti.engine.impl.persistence.entity.ModelEntity.selectModelsByQueryCriteria] - ==> Parameters: 10(Integer), 0(Integer)
2015-11-03 15:08:59,112 [DEBUG][org.activiti.engine.impl.interceptor.CommandContext] - Error while closing command context
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.CREATE_TIME_ desc

LIMIT 10 OFFSET 0' at line 6

The error may exist in org/activiti/db/mapping/entity/Model.xml

The error may involve org.activiti.engine.impl.persistence.entity.ModelEntity.selectModelsByQueryCriteria-Inline

The error occurred while setting parameters

SQL: select distinct RES.* from ACT_RE_MODEL RES order by order by RES.CREATE_TIME_ desc 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.CREATE_TIME_ desc

LIMIT 10 OFFSET 0' at line 6
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)
6 回复

oracle? 那limit是mysql的语法

来自炫酷的 NutzCN

@wendal mysql,这个需要在哪里配置是mysql吗

噢!我看到了order by order by

来自炫酷的 NutzCN

@wendal 这个是直接拷贝的大鲨鱼的代码,别的没有动,是配置的原因吗

@qq_b76927b4 不诚实。。。还什么没动,改了pom.xml文件

mybatis的版本与activit兼容

添加回复
请先登陆
回到顶部