org.hibernate.QueryException, in expected..

最新推荐文章于 2021-07-03 15:03:53 发布
最新推荐文章于 2021-07-03 15:03:53 发布
阅读量580 收藏
点赞数
分类专栏： SSH 文章标签： Hibernate Java Weblogic Apache Servlet
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/iteye_16184/article/details/81818319
版权
来自http://nistck.iteye.com/blog/556725 

org.hibernate.QueryException: in expected: device [select device,
       s.name ,
       mr.name ,
		  p.productTypeId, 
       p.name
 from DeviceBaseInfo_Simple device,
       com.test.DAO.ecmis.Station        s,
       com.test.DAO.ecmis.MachineRoom    mr,
       com.test.DAO.ecmis.Product        p
  where device.id in (2641,2642,2641,2642)
  and device.stationId=s.id(+)
  and device.productId=p.id(+)
  and device.machineRoomId=mr.id(+)
]
	at org.hibernate.hql.classic.FromParser.token(FromParser.java:106)
	at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:86)
	at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:108)
	at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:28)
	at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:216)
	at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:185)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1624)
	at com.test.DAO.ABaseHibernateQueryDAO.findListBySql(ABaseHibernateQueryDAO.java:617)
	at com.test.ecmis.sheet.serviceImpl.SheetServiceImpl.updateCircuitModifyRecord(SheetServiceImpl.java:325)
	at com.test.ecmis.circuit.serviceImpl.CircuitServiceImpl.saveCircuit(CircuitServiceImpl.java:1405)
	at com.test.ecmis.circuit.action.CircuitAction.saveCircuit(CircuitAction.java:329)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:128)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:148)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:128)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.test.common.interceptors.CommonInterceptor.intercept(CommonInterceptor.java:56)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.test.common.interceptors.ActionInvocationRecordInterceptor.intercept(ActionInvocationRecordInterceptor.java:30)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at com.test.common.interceptors.ExceptionInterceptor.intercept(ExceptionInterceptor.java:24)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:76)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
	at com.test.base.BaseFilter.doFilter(BaseFilter.java:190)
	at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3496)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

可能有两种：

1、 FROM 后面的Hibernate实体类类名大小写写错。

2、 FROM 后面某个Hibernate实体类的 hbm 映射文件, 路径没有放到Hibernate.cfg.xml中。
iteye_16184
关注
专栏目录
Hibernate中in expected错误的原因之一。
显斌的技术Blog
05-31 7284
执行查询的时候出了如下错误：net.sf.hibernate.QueryException: in expected: visitRecords [from ServiceVisitRecord visitRecords]     at net.sf.hibernate.hql.FromParser.token(FromParser.java:102)     at net.sf.
Hibernate异常之org.hibernate.QueryException: Expected positional parameter count: 1, actual parameters
静若清池，动如涟漪_
08-01 2403
1、异常描述 org.hibernate.QueryException: Expected positional parameter count: 1,actual parameters: [] [from Student where name like ?] 备注： 此处hibernate版本号：3.6.10.Final 2、示例代码 2-1 StudentDao.jav...
org.hibernate.QueryException: in expected错误
zhanyingle_1981的专栏
10-20 849
错误信息：org.hibernate.QueryException: in expected:select nre from X nre where nre.id=:ruleId   其中一个原因是：代码中X需要写上全名即包名才行
org.hibernate.QueryException: , expected in
美好的天空
09-24 1141
   org.hibernate.QueryException: , expected in SELECT [SELECT NEW com.coscon.cbs.domain.result.settlement.SettlementCommissionSumDetailResult (companys.companyNameCn as companyNameCn,commCntr.contain...
解决org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0];
qq_45610112的博客
12-26 1971
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expect...
H2和Hibernate:ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table
superlidengke的专栏
10-25 7425
今天一如继往的用hibernate和H2,结果试图保存对象Order时，出错了。并且连这个表都创建不了。 INFO :org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: order ERROR:org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create t
学习hibernate遇到的问题及解决方案
wuc20140的博客
11-02 1191
使用工具版本：Eclipse Java EE IDE for Web Developers.Version: Neon.3 Release (4.6.3)， hibernate版本：hibernate-release-5.2.12.Final JUnit4测试单元版本：junit-4.12（由于自4.8版本以后，JUbit4.jar包中并不包含hamcrest-core-1.3.jar和ham
org.apache.axis.client.Service调用服务webservice时报Unexpected wrapper element sayHello found. Expected
qq_42599451的博客
07-03 3604
先看报错信息： 2021-07-03 14:51:54.696 [http-nio-8090-exec-4] WARN org.apache.cxf.phase.PhaseInterceptorChain - Interceptor for {http://webservice.demo.lerr.com}CxfService#{http://webservice.demo.lerr.com/}sayHello has thrown exception, unwinding now org.apache.
Hibernate中in expected错误的原因之一
lansky07
01-28 7143
今天在执行语句查询时发现怎么都执行不了，换数据库别的表可以执行，以为是数据库表生成时哪里出了问题，一遍又一遍的对映射文件，数据库表，就是没有想出到底哪儿错了，还删了表重新生成表和索引，都没有办法。在网上看了一下资料突然明白，在Spring中没有配置BO。真晕！出现错误是：执行查询的时候出了如下错误：net.sf.hibernate.QueryException: in expected
异常org.hibernate.QueryException: could not resolve property的原因
lucky
08-28 6951
异常消息如下： Exception in thread "main" org.hibernate.QueryException: could not resolve property: deptid of: org.jsoft.vo.Dept at org.hibernate.persister.entity.AbstractPropertyMapping.propertyExceptio
org.springframework.orm.hibernate3.HibernateQueryException: in expected: resource [FROM Resource ...
lq2016的博客
09-11 907
spring整个hibernate，hibernate没有使用配置文件的方式，而是用hibernate-annotations注解的方法，启动报错： org.springframework.orm.hibernate3.HibernateQueryException: in expected: resource [FROM Resource resource WHERE resource.typ...
Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61) at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46) at org.hibernate.jdbc.BatchingBatcher.checkRowCounts(BatchingBatcher.java:68) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41) at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1690) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152) at com.sinosoft.sysframework.persistence.HibernateSQLQuery.doInHibernate(HibernateSQLQuery.java:118) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366) at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:338) at com.sinosoft.sysframework.persistence.BaseDaoHibernateImpl.queryList(BaseDaoHibernateImpl.java:224) at com.sinosoft.application.reins.persistence.hibernate.base.GrRePlanItemDaoHibernateImplBase.find(GrRePlanItemDaoHibernateImplBase.java:127) at com.sinosoft.application.reins.service.spring.GrTrialServiceSpringImpl.endorTrialDataSurrender(GrTrialServiceSpringImpl.java:9536) at com.sinosoft.application.reins.service.
最新发布
06-03
这个错误一般是由于更新时没有找到符合预期的行导致的。这可能是由于在更新之前，已经有其他的会话或事务更新了相同的行，导致当前的更新未能找到预期的行。你可以检查一下，是否有其他的操作在同时修改这个表中的数据。此外，你也可以尝试使用乐观锁或悲观锁来避免这种错误。如果你需要更具体的解决方案，可以提供更多的上下文信息。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值