为外键status_id设默认值时遇Hibernate MappingException问题求助

Let's break down your problem step by step and work through the fixes:

First, Understand the Root Causes #

Your error Unknown entity: de.example.model.Status and the failure with @Generated on the Status field come from two key issues:

1. @Generated doesn't work with entity associations: This annotation is designed for basic data-type columns (like your type field) where the database generates a value. It can't handle @ManyToOne entity references—Hibernate has no way to map a database-generated foreign key value to a full Status instance using this annotation.
2. Hibernate isn't scanning your Status entity: The error means Hibernate doesn't recognize Status as a managed entity, usually due to a package scanning misconfiguration.
3. Table name mismatch (bonus issue): Your Einsender entity maps to a table named einsender, but your database table is actually customer—this will cause problems later even if you fix the immediate error.

Step 1: Fix the @Generated Annotation Issue #

Remove the @Generated(GenerationTime.INSERT) annotation from your Status field immediately. It's invalid for entity associations:

// Corrected Status field in Einsender.java
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "status_id")
private Status status;

Step 2: Ensure Hibernate Scans the Status Entity #

Make sure your Status class is in a package that Spring Boot's entity scanner can find:

• If your main application class is in de.example, and Status is in de.example.model, Spring Boot will scan it by default.
• If Status is in a different package, add the @EntityScan annotation to your main application class to specify the entity package:

@SpringBootApplication
@EntityScan(basePackages = {"de.example.model"}) // Replace with your actual Status package
public class YourApplication {
    public static void main(String[] args) {
        SpringApplication.run(YourApplication.class, args);
    }
}

Double-check that Status has all required annotations correctly applied (no typos!):

@Data 
@Entity 
@Table(name = "status") 
public class Status { 
    @Id 
    @GeneratedValue(strategy = GenerationType.SEQUENCE) 
    private BigDecimal statusId; 

    @OneToMany(mappedBy = "status", fetch = FetchType.LAZY) 
    private List<Einsender> customerList; 

    @Column 
    private String name; 
}

Step 3: Fix the Table Name Mismatch #

Your Einsender entity maps to the wrong table. Update the @Table and @Entity annotations to match your database's customer table:

@Data
@Entity(name = "customer")
@Table(name = "customer")
public class Einsender { // Consider renaming this class to Customer to avoid confusion
    // ... rest of your fields ...
}

Step 4: Correctly Handle the Default Status Association #

Your database trigger already sets status_id to 1 when it's null, but Hibernate won't automatically load the associated Status instance. You have two reliable options:

Option 1: Refresh the Entity After Persistence #

After saving the customer, use EntityManager.refresh() to pull the latest data (including the triggered status_id and its associated Status instance) from the database:

@Autowired
private EntityManager entityManager;

public Einsender saveCustomer(Einsender customer) {
    entityManager.persist(customer);
    entityManager.refresh(customer); // This loads the associated Status from the DB
    return customer;
}

Option 2: Set the Default Status in Java Code #

Avoid relying solely on the trigger by setting the default Status in your business logic or entity lifecycle:

Using a Lifecycle Callback

Add a @PrePersist method to your Einsender class to set the default status before persistence:

@Data
@Entity(name = "customer")
@Table(name = "customer")
public class Einsender {
    // ... your fields ...

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "status_id")
    private Status status;

    @PersistenceContext
    private EntityManager em;

    @PrePersist
    public void prePersist() {
        if (this.status == null) {
            // Fetch the default status from the database
            this.status = em.find(Status.class, new BigDecimal(1));
        }
    }
}

Using Business Logic

Set the default status in your service layer before saving:

@Autowired
private StatusRepository statusRepository;

public Einsender saveCustomer(Einsender customer) {
    if (customer.getStatus() == null) {
        Status defaultStatus = statusRepository.findById(new BigDecimal(1))
            .orElseThrow(() -> new RuntimeException("Default status not found in database"));
        customer.setStatus(defaultStatus);
    }
    return customerRepository.save(customer);
}

Step 5: Verify Your Trigger Works #

Double-check your trigger logic by running a manual insert to ensure it sets status_id correctly:

INSERT INTO customer (customer_id, firstname) VALUES (1, 'TestCustomer');
SELECT status_id FROM customer WHERE customer_id = 1;

This should return 1 (the ID of your DEFAULT status).

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