Spring Boot-手动JPA配置与配置文件问题

Question

我的Spring Boot应用程序JPA配置有一个问题。我有两个配置文件-dev(H2 db）和prod（PostgreSQL）。我想在没有Spring Boot“Magic”的情况下手动设置JPA，所以我创建了如下所示的配置类

@Configuration
@EnableTransactionManagement
public class PersistenceContext {

@Primary
@Bean
public DataSourceProperties dataSourceProperties() {
    return new DataSourceProperties();
}

@Bean
public DataSource dataSource(DataSourceProperties properties) {
    return properties
            .initializeDataSourceBuilder()
            .type(HikariDataSource.class)
            .build();
}

@Bean
public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
    final LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
    em.setDataSource(dataSource(dataSourceProperties()));
    em.setPackagesToScan("model");
    em.setJpaVendorAdapter(new HibernateJpaVendorAdapter());
    return em;
}

@Bean
public PlatformTransactionManager transactionManager(final EntityManagerFactory emf) {
    return new JpaTransactionManager(emf);
}

}

10:37:47.951 [main] DEBUG org.hibernate.SQL - insert into Book (id, author, bookType, bookstore, new_price, old_price, title, url) values (null, ?, ?, ?, ?, ?, ?, ?)
10:37:47.955 [main] DEBUG o.h.e.jdbc.spi.SqlExceptionHelper - could not prepare statement [insert into Book (id, author, bookType, bookstore, new_price, old_price, title, url) values (null, ?, ?, ?, ?, ?, ?, ?)]
org.h2.jdbc.JdbcSQLException: Table "BOOK" not found; SQL statement:
insert into Book (id, author, bookType, bookstore, new_price, old_price, title, url) values (null, ?, ?, ?, ?, ?, ?, ?) [42102-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)

spring.datasource.url=jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.platform=h2
spring.datasource.username=sa
spring.datasource.password=
spring.datasource.driver-class-name=org.h2.Driver

spring.jpa.hibernate.ddl-auto=create-drop
spring.jpa.generate-ddl=true
spring.data.jpa.repositories.enabled=true
spring.jpa.properties.hibernate.hbm2ddl.auto=create-drop
spring.jpa.database-platform=org.hibernate.dialect.H2Dialect
spring.jpa.show-sql=true

spring.h2.console.enabled=true
spring.h2.console.path=/h2-console

我发现这可能是spring.jpa.properties.hibernate.hbm2ddl.auto=create-drop的问题，因为当我在PersistenceContext类中通过属性映射设置该属性时，它可以正常工作。我不知道如何通过属性文件正确设置它。事先谢谢你的帮助。

Answer 1

spring.jpa.hibernate.ddl-auto=update和spring.jpa.properties.hibernate.hbm2ddl.auto=create-drop执行相同的操作。但是，由于您被选择不使用Spring自动配置魔法，这些属性是无效的。

所以您必须使用JPA属性映射，并在LocalContainerEntityManagerFactoryBean中设置它。