Spring迁移至常规项目后Hibernate JPA配置异常排查

你遇到的核心问题是同一个实体中嵌入两个相同类型的嵌入式对象时，Hibernate默认会将嵌入式对象的属性直接映射到主实体表中，导致重复列名冲突，比如两个Address的addressLine1字段会被映射到同一列，最终触发BeanCreationException。下面是具体的解决步骤：

1. 用@AttributeOverride重命名重复列 #

针对Customer实体里的两个Address对象（比如shippingAddress和billingAddress），通过@AttributeOverride注解为每个嵌入式对象的属性指定唯一的列名，彻底避免冲突。

示例代码如下：

@Entity
public class Customer {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    
    // 收货地址：重命名addressLine1为shipping_address_line1，以此类推
    @Embedded
    @AttributeOverrides({
        @AttributeOverride(name = "addressLine1", column = @Column(name = "shipping_address_line1")),
        @AttributeOverride(name = "addressLine2", column = @Column(name = "shipping_address_line2")),
        @AttributeOverride(name = "city", column = @Column(name = "shipping_city")),
        @AttributeOverride(name = "postalCode", column = @Column(name = "shipping_postal_code"))
    })
    private Address shippingAddress;
    
    // 账单地址：重命名addressLine1为billing_address_line1
    @Embedded
    @AttributeOverrides({
        @AttributeOverride(name = "addressLine1", column = @Column(name = "billing_address_line1")),
        @AttributeOverride(name = "addressLine2", column = @Column(name = "billing_address_line2")),
        @AttributeOverride(name = "city", column = @Column(name = "billing_city")),
        @AttributeOverride(name = "postalCode", column = @Column(name = "billing_postal_code"))
    })
    private Address billingAddress;
    
    // 其他属性、构造方法及getter/setter...
}

// 嵌入式Address实体
@Embeddable
public class Address {
    private String addressLine1;
    private String addressLine2;
    private String city;
    private String postalCode;
    
    // 构造方法、getter/setter...
}

2. 验证自定义HibernateJpaConfig配置 #

确保你的自定义配置类正确扫描了实体包，且没有冲突的映射规则：

@Configuration
@EnableTransactionManagement
public class HibernateJpaConfig {
    @Bean
    public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
        LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
        em.setDataSource(dataSource());
        em.setPackagesToScan("com.yourproject.entity"); // 替换为你的实体所在包路径
        
        HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
        em.setJpaVendorAdapter(vendorAdapter);
        
        Properties properties = new Properties();
        properties.setProperty("hibernate.hbm2ddl.auto", "update"); // 根据你的需求调整
        properties.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL8Dialect"); // 替换为你的数据库方言
        em.setJpaProperties(properties);
        
        return em;
    }
    
    // DataSource、TransactionManager等其他必要配置...
}

3. 额外注意事项 #

• 确认application.properties中的自动配置排除项完全生效，避免和自定义配置冲突：

  spring.autoconfigure.exclude=org.springframework.boot.autoconfigure.thymeleaf.ThymeleafAutoConfiguration,org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration,org.springframework.boot.autoconfigure.h2.H2ConsoleAutoConfiguration,org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration
  

• 启动前清理项目编译目录（如target或build文件夹），避免旧编译文件的缓存干扰。

完成上述修改后，Hibernate就能正确区分两个Address对象的属性列，不会再出现重复映射错误，EntityManagerFactory即可正常创建。

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