Activiti5.19查询报错[java.sql.SQLSyntaxErrorException: ORA-00936: 缺失表达式]

最新推荐文章于 2024-08-13 16:56:29 发布

转载最新推荐文章于 2024-08-13 16:56:29 发布 · 616 阅读

文章标签：

#java #activiti #mysql

java 同时被 2 个专栏收录

25 篇文章

订阅专栏

activiti

1 篇文章

订阅专栏

在使用Activiti开发项目过程中，更新Spring、SpringMVC及MyBatis版本后出现查询错误。具体表现为activiti自带查询功能失效，并提示ORA-00936:缺失表达式错误。通过排查发现问题源于MyBatis版本升级至3.3.0，回滚至3.2.6后问题解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一.问题

今天用activiti新做一个项目,直接复制之前的代码,然后建数据库,随手把Spring,Spring MVC和Mybatis等版本升级了一下,问题就出现了.

所有activiti自带的查询都无法使用,全部报错如下

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00936: 缺失表达式

### The error may exist in org/activiti/db/mapping/entity/Task.xml
### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria-Inline
### The error occurred while setting parameters
### SQL: select * from ( select a.*, ROWNUM rnum from (     select distinct RES.*              from ACT_RU_TASK RES                                          inner join ACT_RE_PROCDEF D on RES.PROC_DEF_ID_ = D.ID_                        WHERE  RES.ASSIGNEE_ = ?                                                                                                                                                                                   and D.KEY_ = ?                                                                                                                                                                         and RES.SUSPENSION_STATE_ = 1                order by  order by RES.ID_ desc, RES.CREATE_TIME_ desc         ) a where ROWNUM < ?) where rnum  >= ?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00936: 缺失表达式

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:981)
    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:860)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)