Grails中hibernate出现的异常

最新推荐文章于 2021-02-15 22:49:49 发布

robbenren

最新推荐文章于 2021-02-15 22:49:49 发布

阅读量640

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/robbenren/article/details/8113651

版权

java 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

异常为：

java.sql.SQLException: ORA-00936: 缺失表达式
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:813)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at grails.orm.HibernateCriteriaBuilder.invokeMethod(HibernateCriteriaBuilder.java:1163)


at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.grails.plugin.resource.DevModeSanityFilter.doFilter(DevModeSanityFilter.groovy:44)
at org.apache.shiro.grails.SavedRequestFilter.doFilter(SavedRequestFilter.java:55)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:359)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:275)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:344)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:272)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:81)
at java.lang.Thread.run(Thread.java:619)

查询的语句是：

def resultList = criteria.list {
        'in'("material",Material.findAllByMaterialType(matType))
        if(params.keyword){
           if(!params.keyword.equals("请输入搜索名称或关键词")){
               def materialList = Material.findAllByNameLike("%"+params.keyword+"%")
               if(materialList){
                     'in'("material",materialList)
              }else{
                  eq("material",null)
              }
         }
     }     
}

出现上面异常的原因：数据表中没有数据时才会出现，通过打印SQL语句，然后到数据库客户端执行，发现其中一条SQL出现错误。具体原因是因为表达式： 'in'("material",Material.findAllByMaterialType(matType)) ，在这个子查询的语句中，表达式Material.findAllByMaterialType(matType)得到的结果是一个没有数据的数组（此处不是null,不信可以println出来看一眼），而在整个SQL语句中有where 语句他的一个字段在这个没有数据的数组中，但是这个没有数据的数组又不是null，这样就导致整个SQL语句错误。修改的方法为：

def resultList = criteria.list {
        if(Material.findAllByMaterialType(matType).size!=0){
               'in'("material",Material.findAllByMaterialType(matType))
        }
        if(params.keyword){
           if(!params.keyword.equals("请输入搜索名称或关键词")){
               def materialList = Material.findAllByNameLike("%"+params.keyword+"%")
               if(materialList){
                     'in'("material",materialList)
              }else{
                  eq("material",null)
              }
         }
     }