org.hibernate.exception.SQLGrammarException: could not execute query

后台信息:

330913157 [[ACTIVE] ExecuteThread: ‘2‘ for queue: ‘weblogic.kernel.Default (self-tuning)‘] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1795, SQLState: 42000
330913157 [[ACTIVE] ExecuteThread: ‘2‘ for queue: ‘weblogic.kernel.Default (self-tuning)‘] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01795: 列表中的最大表达式数为 1000

页面信息:

could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute quer

原因:

在Hibernate进行Hql查询时,Hql中的in()条件中的数目不能大于1000.导致抛出could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query异常

解决方式:

修改in中的条件数目。

本文出自 “Mr_Dai” 博客,请务必保留此出处http://8551527.blog.51cto.com/8541527/1378159

org.hibernate.exception.SQLGrammarException: could not execute query,布布扣,bubuko.com

org.hibernate.exception.SQLGrammarException: could not execute query

上一篇:MSSQLSERVER2005安装指导


下一篇:迁移cacti数据库