创建名为securityConfiguration的bean时出错：无法满足通过字段userDetailsService表示的依赖关系

Question

我正在尝试创建一个Spring Boot应用程序，它使用Spring Security和OAuth2通过数据库进行身份验证。我正试图按照GitHub的例子来介绍这个存储库（https://github.com/TechPrimers/spring-security-db-example）现在面对这个错误。

段落短语的StackTrace：

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'securityConfiguration': Unsatisfied dependency expressed through field 'userDetailsService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userDetailsDervice': Unsatisfied dependency expressed through field 'usersRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usersRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Failed to create query for method public abstract java.util.Optional com.user.path.to.repository.UsersRepository.findByName(java.lang.String)! No property name found for type AccountUser!

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userDetailsDervice': Unsatisfied dependency expressed through field 'usersRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usersRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Failed to create query for method public abstract java.util.Optional com.user.path.to.repository.UsersRepository.findByName(java.lang.String)! No property name found for type AccountUser!

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'usersRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Failed to create query for method public abstract java.util.Optional com.user.path.to.repository.UsersRepository.findByName(java.lang.String)! No property name found for type AccountUser!

Caused by: java.lang.IllegalArgumentException: Failed to create query for method public abstract java.util.Optional com.user.path.to.repository.UsersRepository.findByName(java.lang.String)! No property name found for type AccountUser!

Caused by: org.springframework.data.mapping.PropertyReferenceException: No property name found for type AccountUser!

以下是我的课程：

CustomUserDetails服务

  @Service("userDetailsDervice")
  public class CustomUserDetailsService implements UserDetailsService {

  @Autowired
  private UsersRepository usersRepository;


  @Override
  public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
    Optional<AccountUser> optionalUsers = usersRepository.findByName(username);

    optionalUsers
            .orElseThrow(() -> new UsernameNotFoundException("Username not found"));
    return optionalUsers
            .map(CustomUserDetails::new).get();
  }
}

用户还原

@Repository
public interface UsersRepository extends JpaRepository<AccountUser, Integer> {
    Optional<AccountUser> findByName(String username);
}

帐户用户

@Entity
@Table(name = "User")
public class AccountUser {

@Column(name = "title")
private String title;

@Column(name = "firstname")
private String firstname;

@Column(name = "lastname")
private String lastName;

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "email")
private String email;

@Column(name = "password")
private String password;

@Column(name = "modified")
private Date modified;

@Column(name = "accessed")
private Date accessed;

/* ... getters and setters ....*/

Answer 1

@Repository
public interface UsersRepository extends JpaRepository<AccountUser, Integer> {
    Optional<AccountUser> findByName(String username);
}

替换为下面的

@Repository
public interface UsersRepository extends JpaRepository<AccountUser, Integer> {
    Optional<AccountUser> findByLastName(String username);
}

您没有Name作为实体的一部分，JPA无法找到属性"name"

为了订购你需要的

@存储库公共接口UsersRepository扩展了JpaRepository{可选findByLastNameOrderByAccessedDesc（字符串用户名）；}

在这里，您可以在本节表2.3中找到jpa查询https://docs.spring.io/spring-data/jpa/docs/1.5.0.RELEASE/reference/html/jpa.repositories.html的示例。方法名称中支持的关键字