Spring Boot + JPA 一对多关联查询无数据问题求助

业务关系：一个客户可拥有多个账户，一个账户仅属于一个客户；客户可无账户，但账户必须归属客户。

在Spring Boot 3.1.5集成JPA实现该关联时，H2数据库表结构生成、数据插入正常，但查询客户关联账户始终返回空集合。开发阶段每次重启自动生成Schema，从H2控制台可见，Account表已生成CUSTOMER_ID列并填充客户ID，但外键未指向Customer表的id字段。

相关代码 #

Customer实体类 #

@Data
@Entity
@NoArgsConstructor
public class Customer extends BaseEntity {

    @Id
    @SequenceGenerator(name= "customer_seq", sequenceName = "customer_seq", allocationSize = 1, initialValue = 100)
    @GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "customer_seq")
    private Long id;

    @Column(length = 256, nullable = false, unique = false)
    private String email;

    @NotNull(message = "Password cannot be null")
    @Size(min = 8, max = 16, message = "Password must be between 8 and 16 characters long")
    private String password;

    // Where do you tell it the table to map to (i.e. Account) and the FK column in that table (i.e. customer_id)?
    // If it can "guess" the table by the "Account" object name, why cant it guess the FK column name is "customer_id"?
    @OneToMany(mappedBy = "customer", fetch = FetchType.EAGER)
    private Set<Account> accounts;

    public Customer(String email, String password) {
        this.email = email;
        this.password = password;
    }

    @Temporal(TemporalType.DATE) // not needed any more?
    private Date dob;  // or use sql.Date?

// other fields omitted for brevity.

}

Account实体类（尝试过多种注解组合） #

@Data
@Entity
@NoArgsConstructor
public class Account  {

    @Id
    @SequenceGenerator(name= "account_seq", sequenceName = "account_seq", allocationSize = 1, initialValue = 100)
    @GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "account_seq")
    private Long id;

    BigDecimal balance = new BigDecimal(0);

    // How can you tell it that "customer" is the FK to the ID of the Customer Table?  It should be able to guess that.
    @ManyToOne(optional = false)

// runs, but doesnt find any accounts for any customer.
//    @OneToOne(optional = false)

// runs, but doesnt find any accounts for any customer.
//    @JoinColumn

//  This one runs, but never finds accounts for any customer.
//    @JoinColumn(name = "customer_id", nullable = false)

//  Fails with: Column 'id' is duplicated in mapping for entity 'com.ohds.bomj.entity.Account'
//    @JoinColumn(name = "id", nullable = false)

//  This one also runs, but never finds accounts for any customer.
    @JoinColumn(name = "customer_id", referencedColumnName = "id", nullable = false) // doesnt run

//  This one fails with: references a column named 'customer_id' but the target entity 'com.ohds.bomj.entity.Customer' has no property which maps to this column
//    @JoinColumn(name = "customer_id", referencedColumnName = "customer_id", nullable = false)
    Customer customer;

    public Account(Customer c) {
        this.customer = c;
    }
}

Controller代码 #

@RestController
class CustomerController {

    Logger log = LoggerFactory.getLogger(CustomerController.class);

    private final CustomerRepository repository;

    CustomerController(CustomerRepository repository) {
        this.repository = repository;
    }

    @GetMapping("/customers")
    List<Customer> all() {

        List<Customer> customers = repository.findAll();

        // for each customer, get the accounts
        for (Customer customer : customers) {
            log.info("customer: " + customer);
            log.info("accounts: " + customer.getAccounts());
        }

        return customers;
    }
}

Repository代码 #

public interface CustomerRepository extends JpaRepository<Customer, Long> {}

// and

public interface AccountRepository extends JpaRepository<Account, Long> {}

排查与修复方案 #

1. 修正Account实体的关联注解配置 #

当前Account实体的@JoinColumn与@ManyToOne注解分离，JPA无法正确识别关联关系。需将@JoinColumn直接标注在关联字段上，绑定外键配置：

@ManyToOne(optional = false)
@JoinColumn(name = "customer_id", referencedColumnName = "id", nullable = false)
private Customer customer;

注解分离会导致JPA无法建立字段与关联规则的绑定，进而无法生成正确的外键约束，最终关联查询失效。

2. 维护双向关联的对象一致性 #

创建Account对象时，除了设置Account的customer属性，还需将Account添加到Customer的accounts集合中，保证内存中对象关系的一致性：

// 示例创建逻辑
Customer customer = new Customer("test@example.com", "password123");
customer = customerRepository.save(customer);

Account account = new Account(customer);
customer.getAccounts().add(account); // 维护双向关联
accountRepository.save(account);

仅设置Account的customer属性会导致数据库CUSTOMER_ID字段填充正确，但JPA缓存或查询时无法识别内存中的关联关系，影响EAGER加载的结果。

3. 验证数据库外键约束生成 #

重启应用后，在H2控制台查看Account表结构，确认CUSTOMER_ID外键已指向Customer表的id字段。若外键未生成，检查Spring Boot JPA配置：

spring.jpa.hibernate.ddl-auto=create # 开发环境用create/create-drop确保Schema重建
spring.jpa.generate-ddl=true
spring.jpa.show-sql=true # 可选，查看生成的SQL语句验证外键创建逻辑

4. 检查BaseEntity的影响 #

Customer继承了BaseEntity，需确认BaseEntity中未定义重复的id字段或冲突注解，避免字段映射冲突导致关联失效。

5. 显式关联查询（可选） #

若上述修复后仍有问题，可在CustomerRepository中添加自定义查询，强制关联加载账户数据：

@Query("SELECT c FROM Customer c LEFT JOIN FETCH c.accounts")
List<Customer> findAllWithAccounts();

在Controller中使用该方法替代findAll()，确保关联数据被正确加载。

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