Hibernate Spring: spring.jpa.hibernate.ddl-auto property doesn't create generate tables doesn't work

Question

I'm using Spring MVC with Hibernate. I configure Hibernate using configuration Java class:

DbConfig.java:

@Configuration
 @EnableTransactionManagement
@EnableJpaRepositories(basePackages = "testproject", entityManagerFactoryRef = "entityManagerFactory")
 public class DbConfig {
    @Bean
    public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
        LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
        entityManagerFactoryBean.setDataSource(getDatasource());
        entityManagerFactoryBean.setPersistenceProviderClass(HibernatePersistenceProvider.class);

        entityManagerFactoryBean.setJpaProperties(getHibernateProperties());

        entityManagerFactoryBean.setPackagesToScan("testproject");

        return entityManagerFactoryBean;
    }


    @Bean
    public DataSource getDatasource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("org.postgresql.Driver");
        dataSource.setUrl("jdbc:postgresql://127.0.0.1:5432/testproject");
        dataSource.setUsername("postgres");
        dataSource.setPassword("mypass");
        return dataSource;
    }

    @Bean
    public SessionFactory getSessionFactory() throws IOException {
        LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean();
        sessionFactoryBean.setPackagesToScan("testproject");
        //getHibernateProperties method is a private method

        sessionFactoryBean.setHibernateProperties(getHibernateProperties());
        sessionFactoryBean.setDataSource(getDatasource());
        sessionFactoryBean.afterPropertiesSet();

        return sessionFactoryBean.getObject();
    }

    @Bean(name = "transactionManager")
    public HibernateTransactionManager getTransactionManager() throws IOException {
        HibernateTransactionManager transactionManager = new HibernateTransactionManager();
        transactionManager.setSessionFactory(getSessionFactory());
        return transactionManager;
    }


    private static Properties getHibernateProperties() {
        Properties hibernateProperties = new Properties();
        hibernateProperties.put("hibernate.dialect", "org.hibernate.dialect.HSQLDialect");
        hibernateProperties.put("hibernate.show_sql", false);
        hibernateProperties.put("spring.jpa.hibernate.ddl-auto", "create");

        System.out.println();
        // other properties
        return hibernateProperties;
    }
}

The auto-creation of tables is configured inside getHibernateProperties method:

hibernateProperties.put("spring.jpa.hibernate.ddl-auto", "create");

However it doesn't seem to work: after I deploy server and try to insert an entity I get an error and the database has no tables.

@MinarMahmund org.hibernate.exception.SQLGrammarException: could not extract ResultSet - it's not the point here - that error happens because the tables have not been created. The question is about how to get Hibernate to auto-create tables — parsecer
– parsecer, Commented Jun 26, 2020 at 23:00

parsecer · Accepted Answer · 2020-06-26 23:37:51Z

1

The property spring.jpa.hibernate.ddl-auto is of type org.springframework.boot.autoconfigure.orm.jpa.JpaProperties.Hibernate which is from Spring Boot. But you are using Spring MVC.

use hibernate.hbm2ddl.auto instead.

Further Reading

Metadata Format in Spring Boot Reference

This is the properties code that works:

   @Bean
    private static Properties getHibernateProperties() {
        Properties hibernateProperties = new Properties();
        hibernateProperties.put("hibernate.dialect", "org.hibernate.dialect.PostgreSQLDialect");
        hibernateProperties.put("hibernate.show_sql", true);
        hibernateProperties.put( "hibernate.hbm2ddl.auto", "create-drop");
        return hibernateProperties;
    }

edited Jun 26, 2020 at 23:37

parsecer

5,23920 gold badges86 silver badges171 bronze badges

answered Jun 26, 2020 at 23:19

Minar Mahmud

2,6636 gold badges22 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Hibernate Spring: spring.jpa.hibernate.ddl-auto property doesn't create generate tables doesn't work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related