org.hibernate.hql.internal.ast.QuerySyntaxException 异常之一解决方案

最新推荐文章于 2023-04-19 11:39:07 发布
最新推荐文章于 2023-04-19 11:39:07 发布
阅读量1.7k 收藏
点赞数
分类专栏： 分页 hibernate 文章标签： java hql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_40881285/article/details/113997061
版权

源码

public PageImpl getList(Pageable pageable, PageImpl pageImpl, UseSealApply useSealApply) {
        StringBuilder querySql = new StringBuilder();
        List<Object> para = new ArrayList<>();
        querySql.append(" from UseSealApply");
        querySql.append(" where visible = '" + CommonConstants.VISIBLE[1] + "'");
        // 拼接条件

        try{
            Page<UseSealApply> page = useSealApplyDao.query(querySql.toString(), pageable, para.toArray());
            return new PageImpl((int) page.getTotalElements(), page.getContent());
        }catch (Exception e){
            log.error(e.getMessage(),e);
        }
        return  null;

    }

报错信息如下

23-Feb-2021 17:13:17.270 SEVERE [http-apr-8080-exec-10] com.sinosoft.sinoep.modules.yzgl.useSealApply.services.UseSealApplyServiceImpl.getList org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 15 [ select count(where) from com.sinosoft.sinoep.modules.yzgl.useSealApply.entity.UseSealApply  where visible = '1' and outMsg is null and creUserId='3ABC8994B2E97C054825844D000C75AB' and creDeptId='4028d0827251101901725129eb7f020f' and (subflag is null or subflag='0')]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 15 [ select count(where) from com.sinosoft.sinoep.modules.yzgl.useSealApply.entity.UseSealApply  where visible = '1' and outMsg is null and creUserId='3ABC8994B2E97C054825844D000C75AB' and creDeptId='4028d0827251101901725129eb7f020f' and (subflag is null or subflag='0')]
 org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 15 [ select count(where) from com.sinosoft.sinoep.modules.yzgl.useSealApply.entity.UseSealApply  where visible = '1' and outMsg is null and creUserId='3ABC8994B2E97C054825844D000C75AB' and creDeptId='4028d0827251101901725129eb7f020f' and (subflag is null or subflag='0')]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 15 [ select count(where) from com.sinosoft.sinoep.modules.yzgl.useSealApply.entity.UseSealApply  where visible = '1' and outMsg is null and creUserId='3ABC8994B2E97C054825844D000C75AB' and creDeptId='4028d0827251101901725129eb7f020f' and (subflag is null or subflag='0')]
	at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:390)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:246)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:525)
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:209)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:122)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy75.query(Unknown Source)
	at com.sinosoft.sinoep.modules.yzgl.useSealApply.services.UseSealApplyServiceImpl.getList(UseSealApplyServiceImpl.java:198)
	at com.sinosoft.sinoep.modules.yzgl.useSealApply.services.UseSealApplyServiceImpl$$FastClassBySpringCGLIB$$b173bd2a.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671)
	at com.sinosoft.sinoep.modules.yzgl.useSealApply.services.UseSealApplyServiceImpl$$EnhancerBySpringCGLIB$$15939a84.getList(<generated>)
	at com.sinosoft.sinoep.modules.yzgl.useSealApply.controller.UseSealApplyController.getList(UseSealApplyController.java:110)
	at com.sinosoft.sinoep.modules.yzgl.useSealApply.controller.UseSealApplyController$$FastClassBySpringCGLIB$$af4d7509.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:736)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:96)
	at com.sinosoft.sinoep.common.auditlog.aspect.LogAspect.around(LogAspect.java:107)
	at sun.reflect.GeneratedMethodAccessor259.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.aspectj.AspectJAfterThrowingAdvice.invoke(AspectJAfterThrowingAdvice.java:62)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:671)
	at com.sinosoft.sinoep.modules.yzgl.useSealApply.controller.UseSealApplyController$$EnhancerBySpringCGLIB$$467a953d.getList(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:854)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:765)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	at com.sinosoft.sinoep.common.servlet.SpringDispatcherServlet.service(SpringDispatcherServlet.java:36)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.sinosoft.sinoep.sso.filter.SSOAuth.doFilter(SSOAuth.java:150)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.sinosoft.sinoep.sso.filter.NewXssFilter.doFilter(NewXssFilter.java:82)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at com.sinosoft.sinoep.sso.filter.DomainFilter.doFilter(DomainFilter.java:130)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:528)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1099)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2508)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2497)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 15 [ select count(where) from com.sinosoft.sinoep.modules.yzgl.useSealApply.entity.UseSealApply  where visible = '1' and outMsg is null and creUserId='3ABC8994B2E97C054825844D000C75AB' and creDeptId='4028d0827251101901725129eb7f020f' and (subflag is null or subflag='0')]
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1750)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:331)
	at sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:301)
	at com.sun.proxy.$Proxy58.createQuery(Unknown Source)
	at com.sinosoft.sinoep.common.jpa.repository.SimpleJdbcRepository.queryCount(SimpleJdbcRepository.java:73)
	at com.sinosoft.sinoep.common.jpa.repository.SimpleJdbcRepository.query(SimpleJdbcRepository.java:64)
	at sun.reflect.GeneratedMethodAccessor503.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:436)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:421)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:393)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$DefaultMethodInvokingMethodInterceptor.invoke(RepositoryFactorySupport.java:506)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
	... 90 more
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: where near line 1, column 15 [ select count(where) from com.sinosoft.sinoep.modules.yzgl.useSealApply.entity.UseSealApply  where visible = '1' and outMsg is null and creUserId='3ABC8994B2E97C054825844D000C75AB' and creDeptId='4028d0827251101901725129eb7f020f' and (subflag is null or subflag='0')]
	at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:91)
	at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:109)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:304)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131)
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93)
	at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
	at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
	at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
	at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1800)
	at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:328)
	... 111 more

解决方法

实体添加自定义名
具体是为什么暂时不太清楚，但是问题得到了解决，知道的可以帮我解释下。

槑ii*
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
weblogic10.3 org.hibernate.hql.ast.HqlToken报错问题
04-09
在本问题中，我们遇到了一个特定的错误，即“weblogic10.3 org.hibernate.hql.ast.HqlToken报错”，这涉及到Hibernate ORM框架和其在WebLogic上的运行。让我们深入探讨这个问题，以及可能的解决方案。 首先，`org....
HQL子查询报错：org.hibernate.hql.ast.QuerySyntaxException: unexpected token...
Mr_sqw
06-17 1万+
HQL子查询报错：org.hibernate.hql.ast.QuerySyntaxException: unexpected token... HQL子查询只能出现在select或where字句中
org.hibernate.hql.internal.ast.QuerySyntaxException 查询操作时报错-解决
心有谦谦结
09-22 1万+
一、报错：org.hibernate.hql.internal.ast.QuerySyntaxException: XXXis not mapped [FROM XXX WHERE owner = ?1] 具体报错： Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: student is not mapped [FROM student WHERE owner = ?1] Caused by: java.lang.Ille.
org.hibernate.hql.internal.ast.QuerySyntaxException 异常处理
懂哥的博客
02-28 6029
一.概述 1.1 场景： 在写Repository类的时候，写自定义的@Query语句的时候，报错如下： org.hibernate.hql.internal.ast.QuerySyntaxException 1.2 备注： select from后跟的不是表名，是Entity对象名。 如果为Entitiy对象设置了nam...
org.hibernate.hql.internal.ast.QuerySyntaxException错误原因
weixin_39309402的博客
02-26 8766
在开发一个密码重置的功能过程中，因为调用方法失误，报了一个这样的错误： org.hibernate.hql.internal.ast.QuerySyntaxException: USERS is not mapped [sql语句]，后面跟一大堆乱七八糟的东西，其实语句已经提示很明显，就是因为Hibernate。 我们都知道Hibernate执行查询的语句hql是面向对象的查询，而非面向数据库...
报错org.hibernate.hql.internal.ast.QuerySyntaxException: XX is not mapped或者Unknown entity
最新发布
花式芜湖的的博客
04-19 944
报错org.hibernate.hql.internal.ast.QuerySyntaxException: XX is not mapped或者Unknown entity
org.hibernate.hql.ast.QuerySyntaxException: is not mapped解决办法
热门推荐
云想衣裳花想容
03-04 2万+
is not mapped这个异常的抛出主要有几个方面： 1、首先要检查的就是不是表名，这个应该大家都知道，hql语句对大小写很严格，因此请注意大小写；你的hql语句中的from是实体类而 2、你的hibernate配置文件中没有加入相应的映射文件； 3、如果上面两方面检查了都没问题，但是还有错，那就是hql语句有错了，好好检查一下，仔细点，不行就重新写一遍，放到数据
weblogic12 下 org.hibernate.hql.ast.HqlToken
04-20
weblogic12 下最新 org.hibernate.hql.ast.HqlToken解决办法
Hibernate_HQL.rar_hibernate HQL_hibernate hql src
09-19
对hibernate的hql进行了详尽的讲解
Hibernate-HQL.rar_HQL_hibernate hql
09-23
本篇文档将深入探讨Hibernate中的HQL（Hibernate Query Language），一种面向对象的查询语言，它提供了与SQL类似的语法，但更贴近于面向对象的思维模式，使得开发者可以更加便捷地进行数据查询。 一、HQL简介 HQL是...
hibernate-原理共2页.pdf.zip
10-29
Hibernate作为Java中最流行的ORM框架，提供了便捷的数据持久化解决方案。 1. **配置与初始化** Hibernate的使用首先需要进行配置，包括数据库连接信息、实体类路径等。这些信息通常在`hibernate.cfg.xml`配置文件...
WIN10 解决“无法完成操作，因为文件包含病毒或潜在的垃圾软件”
海涛高软
12-03 1万+
解决办法如下：     FR:徐海涛（Hunk Xu） QQ技术交流群：386476712 
异常积累:org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token:
chongbu9515的博客
09-20 1473
今天写Hibernate的HQL的时候的一个Junit测试类 public void TestGroupBy() { String hql="Select min(e.salary), max(e.salary)" + "From Employee e "+ "G...
org.hibernate.hql.ast.QuerySyntaxException: unexpected token 异常解决
徐明坤的博客
03-28 4147
今天在学习 hibernate 的过程中遇到这样一个异常 org.hibernate.hql.ast.QuerySyntaxException: 报这种错，一般情况就是HQL 语句有问题，这时候需要仔细检查下的HQL 是否符合HQL语法的标准 在这里上一下楼主报错的代码： List list1 = session.createQuery(" from Customer c left...
Spring整合Hibernate错误：org.hibernate.hql.internal.ast.QuerySyntaxException
qq_43590003的博客
12-14 1021
一.org.hibernate.hql.internal.ast.QuerySyntaxException: book is not mapped [UPDATE book b SET b.stock = b.stock - 1 WHERE b.isbn = ? ] 在spring中使用hibernate 的hql语句要注意与sql语句的区别！ hql中所查找的并不是表名，而是表的映射-实体类。 ...
cannot be cast to org.hibernate.query.internal.NativeQueryImpl 异常处理
weixin_43687353的博客
10-26 6819
1.异常提示 2.错误代码 3.修改办法 第一种: 使用过期的方法 listQuery.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); 第二种: 打上事务注解,改为只读 @Transactional(readOnly = true) 4.问题原因 com.sun.proxy，是用的jdk动态代理，必须面向接口，NativeQueryImpl类的setResultTransformer，并
org.hibernate.hql.internal.ast.QuerySyntaxException ---- 可能占位符语法错误
心有谦谦结
06-30 473
-> 具体报错: Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: ? near line 1, column 47 [FROM sgggzyjy.domain.Cqpgxmjy WHERE ssjysq = 1?] at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxExcepti...
org.hibernate.hql.internal.ast.querysyntaxexception
03-16
org.hibernate.hql.internal.ast.querysyntaxexception是Hibernate框架中的一个异常类，表示HQL查询语法错误。当HQL查询语句中存在语法错误时，Hibernate会抛出该异常。需要检查HQL查询语句是否符合Hibernate的语法...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值