Set hibernate.ddl-auto in springboot programmatically

Question

I use springboot in a non web application and data jpa. I use the default configuration except for datasource:

private static final String dataSourceUrl = "jdbc:h2:./Database;DB_CLOSE_ON_EXIT=FALSE";
@Bean
public DataSource dataSource() {
    return DataSourceBuilder.create().url(dataSourceUrl).username("user").password("pwd").build();
}

How can I set the spring.jpa.hibernate.ddl-auto property also programmatically?

Maybe this helps: petrikainulainen.net/programming/spring-framework/… — Jens
– Jens, Commented Dec 11, 2015 at 11:57

Semaphor · Accepted Answer · 2015-12-11 12:41:01Z

20

Adding the following bean seems to do the job (thanks to Jens' comment):

  @Bean
  public LocalContainerEntityManagerFactoryBean entityManagerFactory(DataSource dataSource) {
    LocalContainerEntityManagerFactoryBean em = new LocalContainerEntityManagerFactoryBean();
    em.setDataSource(dataSource);
    em.setPackagesToScan(new String[] { "packages.to.scan" });

    JpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
    em.setJpaVendorAdapter(vendorAdapter);

    Properties properties = new Properties();
    properties.setProperty("hibernate.dialect", "org.hibernate.dialect.H2Dialect");
    properties.setProperty("hibernate.hbm2ddl.auto", "update");
    em.setJpaProperties(properties);

    return em;
  }

answered Dec 11, 2015 at 12:41

Semaphor

1,0702 gold badges15 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Set hibernate.ddl-auto in springboot programmatically

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related