org.hibernate.QueryException, in expected..

最新推荐文章于 2022-08-31 20:51:33 发布
最新推荐文章于 2022-08-31 20:51:33 发布
阅读量796 收藏 1
点赞数 1
文章标签： Hibernate Java Weblogic Apache Servlet
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/asp20/article/details/83521815
版权 
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)
  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中。

asp20
关注
Hibernate中in expected错误的原因之一。
显斌的技术Blog
05-31 7318
执行查询的时候出了如下错误：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 2455
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 881
错误信息：org.hibernate.QueryException: in expected:select nre from X nre where nre.id=:ruleId   其中一个原因是：代码中X需要写上全名即包名才行
org.hibernate.QueryException: , expected in
美好的天空
09-24 1167
   org.hibernate.QueryException: , expected in SELECT [SELECT NEW com.coscon.cbs.domain.result.settlement.SettlementCommissionSumDetailResult (companys.companyNameCn as companyNameCn,commCntr.contain...
No data type for node:org.hibernate.hql.ast.tree.IdentNode异常
Smiling_Coder的博客
12-10 623
hql查询的时候，报错如下 百度后发现可能是字段类型不匹配导致，所以找provId的类型。后来发现，是provId前面的字段 taskId的类型不匹配。 因为在  hbm.xml文件中，taskId 作为外键关联了其他表，但是数据库中，删除了该外键，所以报错。hql中删除改字段后，查询成功。  ...
解决org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0];
qq_45610112的博客
12-26 2121
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 7483
今天一如继往的用hibernate和H2,结果试图保存对象Order时，出错了。并且连这个表都创建不了。 INFO :org.hibernate.tool.hbm2ddl.DatabaseMetadata - table not found: order ERROR:org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create t
org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class XXX解决
DBA@Robin
11-14 7962
环境 MyEclipse 8.6+Hibernate3.2   问题   使用Hibernate出现如下错误:   org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [com.lo.entities.User] [select new User(u
【spring boot - JPA--H2报错】H2 error: “Syntax error in SQL statement ... expected identifier“
wondersfan的博客
08-31 5674
出错原因：Hibernate/JPA生成的表与数据库保留字冲突，在我创建的User类如下所示： ‘USER’ 与数据库保留字冲突 解决的方法：修改表名，增加如下一行： 重新运行程序，故障解除
Caused By: org.hibernate.QueryException: ClassNotFoundException: org.hibernate.hql.ast.HqlToken
心寒的博客
12-15 9697
SSH框架报错： Caused By: org.hibernate.QueryException: ClassNotFoundException: org.hibernate.hql.ast.HqlToken 原因：weblogic中自带antlr.jar包，而hibernate用到了其他版本的antlr.jar，因此导致jar包冲突的异常。 解决办法： unix系统下Weblogic： 1、把项目用的ant包放入weblogic目录下（如：/data/wls10_mp1/Oracle/Mid..
org.springframework.orm.hibernate3.HibernateQueryException: in expected: resource [FROM Resource ...
lq2016的博客
09-11 947
spring整个hibernate，hibernate没有使用配置文件的方式，而是用hibernate-annotations注解的方法，启动报错： org.springframework.orm.hibernate3.HibernateQueryException: in expected: resource [FROM Resource resource WHERE resource.typ...
异常org.hibernate.QueryException: could not resolve property的原因
lucky
08-28 6989
异常消息如下： Exception in thread "main" org.hibernate.QueryException: could not resolve property: deptid of: org.jsoft.vo.Dept at org.hibernate.persister.entity.AbstractPropertyMapping.propertyExceptio
Mysql查询int型字段的最大值，表为空结果为null时处理成0
weixin_30877227的博客
04-12 1689
1.使用ifnull()函数，失败 如：SELECT ifnull(max(t.order_num), 0) FROM biodata.taxon as t where t.status='1'; 报错：Caused by: org.hibernate.QueryException: No data type for node: org.hibernate.hql.internal.ast.t...
nested exception is org.hibernate.QueryException: could not resolve property
weixin_34302798的博客
01-11 699
SSH框架出现了下面的错误： nested exception is org.hibernate.QueryException: could not resolve property 检查了hbm.xml文件无误，后来才发现是查询语句的属性名大小写搞错了。...
出现“org.hibernate.QueryException: could not resolve property”错误的解决，针对多对一的表的结构
AI菜鸡，NLP领域，至今为发不出论文掉头发
06-28 1386
ggg滚滚滚
关于hibernate的异常Caused by: org.hibernate.hql.ast.QuerySyntaxException: Table is not mapped错误分析
weixin_42243829的博客
08-29 4553
最近新入职一家公司，用的是2.X版本的hibernate，由于长时间没用这个技术了有些生疏了，所以用起来有些不太熟练，导致了下面一些列错误，经过排查希望能给小伙伴掉坑里的一些帮助。 错误： Caused by: org.hibernate.hql.ast.QuerySyntaxException: Cltest is not mapped [select cl from Cltest cl w...
【最新】异常“org.hibernate.QueryException: could not resolve property”成功解决
超逸の学习技术博客
12-15 2509
每次写作业都会遇到各种BUG，这不，又遇到一个… org.hibernate.QueryException: could not resolve property 这是由于HQL和SQL的语句使用不同造成的。hibernate使用hql语法，而sql语法与hql是不一样的。使用hql时，字段名要与hbm.xml文件中的“name”的值保持一致： <propery name="StuId"...
Hibernate框架使用中出现could not instantiate RegionFactory 异常的解决方法
qq_34332010的博客
02-14 4528
二级缓存配置如下：<!-- 指定要使用的缓存的提供商，打开二级缓存--> <property name="hibernate.cache.use_second_level_cache"> true </property> <property name="hibernate.cache.provider_class"> org.hibernate.cache.EhCacheProvid
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、付费专栏及课程。

余额充值