通过将Spring Jpa与Hibernate结合使用来创建架构（如果不存在） [英] Create schema if does not exist by using spring Jpa with hibernate

问题描述

我正在开发Spring Boot 2应用程序，并尝试通过配置hikari数据源和spring Jpa与postgresql数据库建立连接。

I'm working on spring boot 2 application and trying to establish connection with postgresql database with configuring hikari datasource and spring Jpa.

我在那方面取得了成功，并且我正在使用 hibernate.hbm2ddl.auto 作为 update ，因此它正在创建表（如果不存在），但这只是问题所在是否在架构不存在时抛出异常

I'm succeed in that and i'm using hibernate.hbm2ddl.auto as update so it is creating table if not exists, but only the problem is it is throwing an exception when schema does not exist

错误

GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
Caused by: org.postgresql.util.PSQLException: ERROR: schema "test_schema" does not exist

我通过配置类手动配置了所有内容

I configured everything manually through config class

配置类

@Bean
@Primary
public HikariDataSource dataSource() {

    HikariConfig config = new HikariConfig();

    config.setJdbcUrl(databaseUrl);
    config.setUsername(username);
    config.setPassword(password);
    config.setDriverClassName(driverClassName);
    config.setConnectionTimeout(connectionTimeout);
    config.setIdleTimeout(idleTimeout);
    config.setMaximumPoolSize(maxpoolSize);
    config.setMaxLifetime(maxLifeTime);
    config.setMinimumIdle(minIdleConnections);
    //config.setPoolName(poolName);

    return new HikariDataSource(config);
}

@Bean
public Properties additionalProps() {
    Properties jpaProps = new Properties();

    jpaProps.put(hbDialect, "org.hibernate.dialect.PostgreSQLDialect");
    jpaProps.put(autoDDL, "update");
    jpaProps.put(showSql, true);
    jpaProps.put(formatSql, true);

    return jpaProps;
}

@Bean
public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
    LocalContainerEntityManagerFactoryBean factory = new LocalContainerEntityManagerFactoryBean();
    factory.setDataSource(dataSource());
    factory.setJpaVendorAdapter(new HibernateJpaVendorAdapter());
    factory.setPackagesToScan("com.target.storetaskcount.entity");
    factory.setJpaProperties(additionalProps());
    return factory;
}

@Bean
public JpaTransactionManager transactionManager(EntityManagerFactory factory) {
    JpaTransactionManager transactionManager = new JpaTransactionManager();
    transactionManager.setEntityManagerFactory(entityManagerFactory().getObject());
    return transactionManager;
}

如果不存在该如何创建模式？

How would i make this to create schema if not exist?

我在这里看到了类似的问题，并尝试了所有到目前为止没有碰到的问题类似问题（我不想使用flyway db）

I saw a similar question here and tried everything no luck so far similar-question (i don't wanna use flyway db)

以下是文档休眠文档，但尚不清楚如何添加此属性来创建模式 javax.persistence.schema-generation.database.action

Here is the documentation hibernate-doc, but it's not clear how add this property to create schema javax.persistence.schema-generation.database.action

推荐答案

如果不存在，添加此属性将有效并创建架构

Adding this property worked and created schema if not exist here

jpaProps.put("javax.persistence.create-database-schemas", true);

hibernate.hbm2dll.create_namespaces的JPA变体。指定除了创建数据库对象（表，序列，约束等）外，持久性提供程序是否还将创建数据库模式。如果持久性提供程序要在数据库中创建架构或生成包含 CREATE SCHEMA命令的DDL，则应将此布尔属性的值设置为true。如果未提供此属性（或显式为false），则提供程序不应尝试创建数据库模式。

The JPA variant of hibernate.hbm2dll.create_namespaces. Specifies whether the persistence provider is to create the database schema(s) in addition to creating database objects (tables, sequences, constraints, etc). The value of this boolean property should be set to true if the persistence provider is to create schemas in the database or to generate DDL that contains "CREATE SCHEMA" commands. If this property is not supplied (or is explicitly false), the provider should not attempt to create database schemas.

这篇关于通过将Spring Jpa与Hibernate结合使用来创建架构（如果不存在）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！