spring boot项目报错：Validation failed for query for method public abstract...

最新推荐文章于 2025-03-19 17:13:03 发布
最新推荐文章于 2025-03-19 17:13:03 发布
阅读量7.5k 收藏 9
点赞数 14
分类专栏： 各类实践报错 文章标签： spring boot java spring jquery 后端
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45880844/article/details/121751892
版权

找错路上的离大谱事件

事情的起因

我和平常一样在Dao层文件里面写Query语句，但是突然就给我报了个错，错误内容如下：这让我非常非常迷惑，因为我一直都是这样写语句的呀！！

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2021-12-06 17:30:23.795 ERROR 7972 --- [  restartedMain] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'newsController': Unsatisfied dependency expressed through field 'newsService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'newsService': Unsatisfied dependency expressed through field 'newsDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'newsDao': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract shuhuan.bond.entity.common.News shuhuan.bond.dao.common.NewsDao.find(java.lang.Long)!
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:596) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:374) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1378) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:575) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$91/497617310.getObject(Unknown Source) ~[na:na]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:846) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:863) ~[spring-context-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546) ~[spring-context-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140) ~[spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) [spring-boot-2.1.0.RELEASE.jar:2.1.0.RELEASE]
	at shuhuan.bond.App.main(App.java:19) [classes/:na]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0]
	at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0]
	at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) [spring-boot-devtools-2.1.0.RELEASE.jar:2.1.0.RELEASE]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'newsService': Unsatisfied dependency expressed through field 'newsDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'newsDao': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract shuhuan.bond.entity.common.News shuhuan.bond.dao.common.NewsDao.find(java.lang.Long)!
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:596) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:374) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1378) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:575) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$91/497617310.getObject(Unknown Source) ~[na:na]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:273) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1239) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1166) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:593) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	... 25 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'newsDao': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract shuhuan.bond.entity.common.News shuhuan.bond.dao.common.NewsDao.find(java.lang.Long)!
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1745) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:576) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory$$Lambda$91/497617310.getObject(Unknown Source) ~[na:na]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:273) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1239) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1166) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:593) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	... 39 common frames omitted
Caused by: java.lang.IllegalArgumentException: Validation failed for query for method public abstract shuhuan.bond.entity.common.News shuhuan.bond.dao.common.NewsDao.find(java.lang.Long)!
	at org.springframework.data.jpa.repository.query.SimpleJpaQuery.validateQuery(SimpleJpaQuery.java:93) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.jpa.repository.query.SimpleJpaQuery.<init>(SimpleJpaQuery.java:63) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.jpa.repository.query.JpaQueryFactory.fromMethodWithQueryString(JpaQueryFactory.java:76) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.jpa.repository.query.JpaQueryFactory.fromQueryAnnotation(JpaQueryFactory.java:56) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$DeclaredQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:139) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$CreateIfNotFoundQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:206) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.jpa.repository.query.JpaQueryLookupStrategy$AbstractQueryLookupStrategy.resolveQuery(JpaQueryLookupStrategy.java:79) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lookupQuery(RepositoryFactorySupport.java:566) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$mapMethodsToQuery$1(RepositoryFactorySupport.java:559) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor$$Lambda$603/596276474.apply(Unknown Source) ~[na:na]
	at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) ~[na:1.8.0]
	at java.util.Iterator.forEachRemaining(Iterator.java:116) ~[na:1.8.0]
	at java.util.Collections$UnmodifiableCollection$1.forEachRemaining(Collections.java:1109) ~[na:1.8.0]
	at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801) ~[na:1.8.0]
	at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:512) ~[na:1.8.0]
	at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:502) ~[na:1.8.0]
	at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) ~[na:1.8.0]
	at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:1.8.0]
	at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499) ~[na:1.8.0]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.mapMethodsToQuery(RepositoryFactorySupport.java:561) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$new$0(RepositoryFactorySupport.java:551) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor$$Lambda$599/327508397.apply(Unknown Source) ~[na:na]
	at java.util.Optional.map(Optional.java:215) ~[na:1.8.0]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.<init>(RepositoryFactorySupport.java:551) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport.getRepository(RepositoryFactorySupport.java:324) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.lambda$afterPropertiesSet$5(RepositoryFactoryBeanSupport.java:297) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport$$Lambda$576/205783182.get(Unknown Source) ~[na:na]
	at org.springframework.data.util.Lazy.getNullable(Lazy.java:211) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.util.Lazy.get(Lazy.java:94) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.repository.core.support.RepositoryFactoryBeanSupport.afterPropertiesSet(RepositoryFactoryBeanSupport.java:300) ~[spring-data-commons-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean.afterPropertiesSet(JpaRepositoryFactoryBean.java:119) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1741) ~[spring-beans-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	... 50 common frames omitted
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: news is not mapped [select n from news where id = :id]
	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:713) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) ~[na:na]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0]
	at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0]
	at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:350) ~[spring-orm-5.1.2.RELEASE.jar:5.1.2.RELEASE]
	at com.sun.proxy.$Proxy130.createQuery(Unknown Source) ~[na:na]
	at org.springframework.data.jpa.repository.query.SimpleJpaQuery.validateQuery(SimpleJpaQuery.java:87) ~[spring-data-jpa-2.1.2.RELEASE.jar:2.1.2.RELEASE]
	... 82 common frames omitted
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: news is not mapped [select n from news where id = :id]
	at org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.java:79) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:219) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:143) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:119) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:595) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:704) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	... 89 common frames omitted
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: news is not mapped
	at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:169) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:91) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:79) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:331) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3695) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3584) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:720) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:576) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:313) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:261) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:271) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:191) ~[hibernate-core-5.3.7.Final.jar:5.3.7.Final]
	... 95 common frames omitted

进一步发展

而且很奇怪的是，只要我把这个query语句删了，项目就还和之前一样，我就🐇了呀：

/**
 * 新闻Dao层
 */
@Repository
public interface NewsDao extends JpaRepository<News, Long> {
	/**
	 * 根据id查找
	 * @param id
	 * @return
	 */
	@Query(value="select n from news where id = :id")
	News find(@Param("id")Long id);
}

找解决方法

因为这个方法是必须要写的，不能用别的代替，所以我就开始百度，查了好多办法，甚至还把配置文件pom.xml给改了，但是还是错！！呜呜，就去debug了一下：
在这里插入图片描述
？？？这是什么意思，查了半天上下文，发现还是不懂[委屈]。所以就接着查呗：

柳暗花明

终于后来被我找到了解决方法！！！如下：

/**
 * 新闻Dao层
 */
@Repository
public interface NewsDao extends JpaRepository<News, Long> {
	/**
	 * 根据id查找
	 * @param id
	 * @return
	 */
	@Query(value="select n from hsh_news where id = :id",nativeQuery=true)
	News find(@Param("id")Long id);
}

在这里插入图片描述
没错就是这样，就可以解决了。

分析原因

所以，我就去查了一下原因:

  • 加了nativeQuery = true后，sql为原生sql，from后写的是表名；
  • 不加nativeQuery = true时，sql语句中from写的是entity名称。

举一反三

于是我开始修改代码尝试把nativeQuery = true删掉：
在这里插入图片描述
在这里插入图片描述
写在最后：遇到问题还是要认真寻找解决办法。

Spring boot+JPA(hibernate)配置复杂查询的坑
mxd446814583的博客
05-08 7328
小弟刚从mybatis转到hibernate，遇到了不少坑，在这里不定期更新。以告慰相同处境的亲。 1、首先hibernate的HQL语法有很多坑，有些在SQL中能执行的语句，在HQL中未必能执行，比如HQL就不支持union操作，可以考虑把你要union的两个查询分开写，然后将结果合起来，传到你要使用union的地方。2、其次，注意mysql数据库与SqlServer、oracle数据库存在差别...
CDH6.1.0环境搭建 完成后 登录admin账户失败
baidu_18355515的专栏
02-14 3897
CDH环境搭建完成，启动cloudera-manager-server成功，下面是启动日志 [root@node-1 ~]# sudo systemctl start cloudera-scm-server [root@node-1 ~]# sudo tail -f /var/log/cloudera-scm-server/cloudera-scm-server.log 2019-02-14 ...
springmvc+jpa+springdata中遇到的错误解决办法
lzx925060109的专栏
10-20 8904
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'studentServiceBean': Invocation of init method failed; nested exception is java.lang.
异常java.lang.IllegalArgumentException: Validation failed for query for method public abstract..原因和解决
wenqi
10-28 6434
使用Spring Data JPA 报java.lang.IllegalArgumentException: Validation failed for query for method public abstract …异常的一种原因和解决办法 报错： java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List com.dao.BarDao.findB.
jpa报错 Validation failed for query for method public abstract
最新发布
weixin_43735471的博客
03-19 215
jpa报错
Jpa使用@Query时 报错Validation failed for query for method public abstract
Wu_______的博客
11-24 1658
在Jpa中使用@Query注解时出现以下错误： Validation failed for query for method public abstract 解决方法：这是由于在@Query注解中使用原生SQL时未将nativeQuery属性值显式设为true @Query(nativeQuery = true,value = "update user as u set u.userName=?1 where u.userName=?2") void updatePasswordByUser
【已解决】Validation failed for query for method public abstract java.util.List
weixin_41904925的博客
08-13 5456
解决方案：在Spring Data JPA中自定义SQL语句，使用@Query(value=“")的时候出现如上错误 然后需要在@Query中添加nativeQuery = true，如@Query(value="”，nativeQuery = true)。 有nativeQuery = true时，是可以执行原生SQL语句，所谓原生SQL，也就是说这段SQL拷贝到数据库中，然后把参数值给OK了， 查找对应的是数据库而不是实体类 ...
Spring Data Jpa使用@Query时 报错Validation failed for query for method public abstract
北辰
01-07 5778
问题：在使用Spring Data Jpa作为持久化层，在使用@Query注解时出现以下错误： Validation failed for query for method public abstract 解决方法：这是由于在@Query注解中使用原生SQL时未将nativeQuery属性值显式设为true， @Query(nativeQuery = true,value = "select * from user where id = ?") List<User> getById(@P
public interface Query {
07-27
- *3* [spring boot项目报错：Validation failed for query for method public abstract...](https://blog.csdn.net/weixin_45880844/article/details/121751892)[target="_blank" data-report-click={"spm":"1018....
Java学习（下）
Lzdnydppx的博客
08-16 670
web开发、spring开发、spring boot开发、spring cloud开发
SpringBoot + Mybatis + Druid多数据源集成的心得
u011126891的博客
01-09 5109
最近在做一个项目，需要使用SpringBoot+Mybatis+Druid使用多数据源，前提条件是数据源的个数和名称不确定，是在application.properties文件中设定，在使用时根据条件动态切换。 这样就不能像Druid官网提到的，通过ConfigurationProperties注解创建多个DruidDataSource，因为这样属于硬编码，添加一个数据源就要再添加代码，我考虑的
记录 @Query 报错Validation failed for query for method public abstract
qq_39615345的博客
07-11 8806
代码 当查询只想要两个返回参数的时候报错 Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'articleTest': Unsatisfied dependency expressed through field 'a...
Jpa 【已解决】Validation failed for query for method public abstract java.util.List
Tongyao
06-10 1277
jpa @Query 注解错误记录
异常java.lang.IllegalArgumentException: Validation failed for query for method public abstract
qq_40140473的博客
12-13 3万+
出现下列异常信息，异常关键报错：java.lang.IllegalArgumentException: Validation failed for query for method public abstract java.util.List org.aodous.mall.order.dao.OrderRepository.queryOrderByOpenIdAndStatus(java.lan
Validation failed for query for method
weixin_30919235的博客
03-14 1824
问题原因 sql语法，使用@Query("select id, username, usersex, userphone from User where User.usersex = ?1")会报错 问题解决 @Query("select id, username, usersex, userphone from User u where u.usersex = ?1") Bug重现 o...
Validation failed for query for method public abstract java.lang.Long com.huaxin.cloud.village.repos
jieyigeweixiao的博客
06-27 8751
Validation failed for query for method public abstract java.lang.Long com.huaxin.cloud.village.repository.StationRepository.getSumProcessCapacity(java.util.Collection)! @Query(value = “select sum(proc...
JPA hql报错 BeanCreationException：Validation failed
茉么乔的博客
05-14 314
报错如下： Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'ITestDao': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abst
Unsatisfied dependency expressed through field ‘xxxService‘； nested exception is org.springframework
热门推荐
嘻哈熊的专栏
04-25 3万+
报错如下 org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'xxxController': Unsatisfied dependency expressed through field 'xxxService'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionE
[ERROR] Failed to read artifact descriptor for org.springframework.boot:spring-boot-starter-test:jar:unknown [ERROR] [server] Maven transfer artifact problem: org.springframework.boot:spring-boot-starter-test:pom:unknown [INFO] Validation error: [ERROR] Failed to read artifact descriptor for org.springframework.boot:spring-boot-starter-web:jar:unknown [ERROR] [server] Maven transfer artifact problem: org.springframework.boot:spring-boot-starter-web:pom:unknown [ERROR] Maven model problem: 'dependencies.dependency.version' for org.springframework.boot:spring-boot-starter-test:jar is missing. at D:\desktop\2025_se\xiaozhong_dianping\server\pom.xml:58:21 [ERROR] Maven model problem: 'dependencies.dependency.version' for org.springframework.boot:spring-boot-starter-web:jar is missing. at D:\desktop\2025_se\xiaozhong_dianping\pom.xml:208:21 Cannot resolve org.springframework.boot:spring-boot-starter-web:unknown Cannot resolve org.springframework.boot:spring-boot-starter-test:unknown
03-09
<think>好的，用户遇到了Maven构建错误，主要涉及无法解析`spring-boot-starter-test`和`spring-boot-starter-web`这两个依赖项的版本问题。我需要先分析错误信息，找出可能的原因，并提供解决方案。 首先，错误信息显示`Failed to read artifact descriptor`，通常是因为Maven无法找到对应的依赖版本。用户的项目可能没有正确指定Spring Boot的版本，或者父POM中没有正确配置版本管理。在之前的对话中，用户提供的common模块的pom.xml确实继承了父项目，但父项目的pom.xml可能存在版本缺失的问题。 接下来，注意到错误中提到了`version: unknown`，这表明Maven无法确定依赖的版本。这可能是因为在子模块中直接声明了这些依赖，但没有指定版本，而父POM的`dependencyManagement`部分也没有正确管理这些依赖的版本。例如，如果父项目是Spring Boot项目，应该使用`spring-boot-starter-parent`作为父POM，或者在`dependencyManagement`中导入Spring Boot的BOM（Bill of Materials），这样依赖的版本就会自动管理，无需手动指定。 另外，用户可能在父POM或子模块的依赖声明中遗漏了版本号。例如，在父POM的`dependencyManagement`里正确声明Spring Boot的版本，或者在子模块的依赖中明确指定版本号。此外，用户需要检查Maven的settings.xml文件，确保仓库配置正确，没有被网络问题或仓库地址错误所影响。 解决方案可能包括以下几个步骤：首先，确认父POM是否正确配置了Spring Boot的版本管理；其次，在子模块的依赖中要么继承父POM的版本管理，要么显式指定版本号；第三，检查网络连接和Maven仓库配置，确保能够正确下载依赖；最后，执行Maven的清理和重新构建命令，如`mvn clean install -U`，强制更新依赖。 此外，还需要提醒用户检查IDE中的Maven配置，确保使用的是正确的Maven版本和本地仓库路径。如果问题仍然存在，建议手动删除本地仓库中相关的依赖目录，然后重新构建项目，强制Maven重新下载依赖。</think>--- ### **问题分析** 您遇到的 Maven 错误主要与依赖版本解析失败有关，核心问题是：**Spring Boot 相关依赖的版本号未被正确指定**，导致 Maven 无法找到对应的依赖包。以下是分步解决方案： --- ### **1. 根本原因定位** #### **错误现象** ``` [ERROR] Failed to read artifact descriptor for org.springframework.boot:spring-boot-starter-test:jar:unknown [ERROR] Maven model problem: 'dependencies.dependency.version' for ... is missing ``` #### **直接原因** - 依赖项未声明版本号（如 `<version>` 标签缺失） - 父 POM 未通过 `<dependencyManagement>` 统一管理版本 #### **深层原因** - Maven 依赖继承机制未正确配置 - Spring Boot 父项目（或 BOM）未引入 --- ### **2. 解决方案** #### **方法 1：通过父项目统一管理版本（推荐）** 在**父项目**的 `pom.xml` 中添加 Spring Boot 版本控制： ```xml <parent> <!-- 继承 Spring Boot 官方父项目 --> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.1.5</version> <!-- 根据需求选择版本 --> <relativePath/> <!-- 从仓库查找，非本地路径 --> </parent> ``` - **作用**：自动继承 Spring Boot 所有依赖的标准版本 - **验证**：子模块依赖无需写 `<version>`，例如： ```xml <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> ``` #### **方法 2：手动指定版本号** 在子模块或父项目的 `<dependencies>` 中显式声明版本： ```xml <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <version>3.1.5</version> <!-- 需与 spring-boot-starter-web 版本一致 --> <scope>test</scope> </dependency> ``` - **缺点**：版本号分散，维护成本高 #### **方法 3：通过 BOM 管理依赖（适合多模块项目）** 在父项目的 `<dependencyManagement>` 中导入 Spring Boot BOM： ```xml <dependencyManagement> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-dependencies</artifactId> <version>3.1.5</version> <type>pom</type> <scope>import</scope> </dependency> </dependencies> </dependencyManagement> ``` - **优势**：集中管理所有 Spring Boot 相关依赖版本 --- ### **3. 验证步骤** 1. **清理本地仓库缓存** ```bash mvn dependency:purge-local-repository ``` 2. **强制更新依赖** ```bash mvn clean install -U ``` 3. **检查依赖树** ```bash mvn dependency:tree -Dincludes=org.springframework.boot ``` --- ### **4. 附加排查** #### **检查网络与仓库配置** - 确认 Maven `settings.xml` 中仓库地址可访问（如阿里云镜像） ```xml <mirror> <id>aliyunmaven</id> <mirrorOf>*</mirrorOf> <name>阿里云公共仓库</name> <url>https://maven.aliyun.com/repository/public</url> </mirror> ``` #### **检查 IDE 配置** - 在 IntelliJ/Eclipse 中刷新 Maven 项目 - 确保 IDE 使用的 Maven 版本与命令行一致 --- ### **5. 典型错误修复示例** 假设父项目 `xiaozhong_dianping/pom.xml` 缺少版本管理，修复后结构应类似： ```xml <project> <modelVersion>4.0.0</modelVersion> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>3.1.5</version> </parent> <groupId>com.fudan</groupId> <artifactId>xiaozhong_dianping</artifactId> <version>0.0.1-SNAPSHOT</version> <modules> <module>common</module> <module>server</module> </modules> <!-- 其他配置 --> </project> ``` --- ### **总结** 通过统一管理 Spring Boot 依赖版本（推荐使用父项目继承或 BOM 导入），可彻底解决 `version:unknown` 问题。修复后，Maven 将自动解析正确的依赖版本。
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

一只天蝎

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值