Spring Boot注册接口开发遇Bean初始化错误：No query specified on getOne

我正在开发REST API的注册功能，但因Bean或查询相关问题陷入困境，无法定位错误根源。最初认为问题出在Repository层，因为最终错误提示为"No query specified on getOne"，但检查了自定义的RoleRepository和UserRepository（均继承自JpaRepository）后，未发现异常；也排查了注解使用情况，未找到违规之处。由于刚接触Spring，怀疑问题可能很简单。启动时抛出的完整异常栈如下：

org.springframework.beans.factory.UnsatisfiedDependencyException: 创建名为'userController'的Bean失败：通过字段'userService'表达的依赖不满足；嵌套异常为org.springframework.beans.factory.UnsatisfiedDependencyException: 创建名为'userServiceImpl'的Bean失败：通过字段'roleRepository'表达的依赖不满足；嵌套异常为org.springframework.beans.factory.BeanCreationException: 创建名为'roleRepository'的Bean失败：初始化方法调用失败；嵌套异常为java.lang.IllegalStateException: No query specified on getOne
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:116) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:397) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1429) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) ~[spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
at pl.popiel.sms.SmsApplication.main(SmsApplication.java:14) ~[classes/:na]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: 创建名为'userServiceImpl'的Bean失败：通过字段'roleRepository'表达的依赖不满足；嵌套异常为org.springframework.beans.factory.BeanCreationException: 创建名为'roleRepository'的Bean失败：初始化方法调用失败；嵌套异常为java.lang.IllegalStateException: No query specified on getOne
... 32 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: 创建名为'roleRepository'的Bean失败：初始化方法调用失败；嵌套异常为java.lang.IllegalStateException: No query specified on getOne
... 42 common frames omitted
Caused by: java.lang.IllegalStateException: No query specified on getOne
at org.springframework.data.jdbc.repository.support.JdbcRepositoryQuery.determineQuery(JdbcRepositoryQuery.java:200) ~[spring-data-jdbc-1.1.0.RELEASE.jar:1.1.0.RELEASE]
... 26 common frames omitted

解决方案与排查思路 #

嘿，别着急，这个问题其实挺常见的，尤其是刚接触Spring生态的时候。让我们一步步拆解：

核心问题定位 #

从异常栈里的spring-data-jdbc相关类（比如JdbcRepositoryQuery）可以看出，你的项目里同时引入了Spring Data JPA和Spring Data JDBC依赖，导致Spring容器错误地用JDBC的Repository实现来处理你的JpaRepository接口了。

JpaRepository自带的getOne()方法是JPA特有的懒加载查询，但Spring Data JDBC并不支持这个方法，所以在初始化roleRepository的时候就抛出了"No query specified on getOne"的错误。

具体修复步骤 #

1. 移除多余的Spring Data JDBC依赖

打开你的项目依赖配置文件（Maven的pom.xml或者Gradle的build.gradle），找到Spring Data JDBC的依赖项并删除。比如Maven中的依赖可能长这样：

<dependency>
    <groupId>org.springframework.data</groupId>
    <artifactId>spring-data-jdbc</artifactId>
</dependency>

删除后重新构建项目，大部分情况下这个错误就会消失。

2. 若需同时使用JPA和JDBC，明确指定Repository类型

如果你的项目确实需要同时使用两种数据访问方式，那就要给你的JPA Repository接口加上@RepositoryDefinition注解，强制Spring使用JPA的实现：

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.repository.RepositoryDefinition;
import pl.popiel.sms.model.Role;

@RepositoryDefinition(domainClass = Role.class, idClass = Long.class)
public interface RoleRepository extends JpaRepository<Role, Long> {
    // 你的自定义查询方法
}

同样给UserRepository也加上这个注解，确保每个Repository都对应正确的实现类。

3. 确认启动类的Repository扫描配置

检查你的Spring Boot启动类，确保@EnableJpaRepositories注解指定了正确的Repository包路径，避免Spring扫描到错误的Repository实现：

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.data.jpa.repository.config.EnableJpaRepositories;

@SpringBootApplication
@EnableJpaRepositories(basePackages = "pl.popiel.sms.repository")
public class SmsApplication {
    public static void main(String[] args) {
        SpringApplication.run(SmsApplication.class, args);
    }
}

新手小贴士 #

刚学Spring的时候，建议先专注于一个数据访问模块（比如先只用JPA），不要同时引入多个类似的依赖，这样能减少很多奇怪的冲突问题。另外，也可以检查一下你的实体类是否正确添加了JPA注解（比如@Entity、@Id、@GeneratedValue等），这也是Repository初始化失败的常见诱因。

内容的提问来源于stack exchange，提问作者nullobject