org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

Question

I am trying run a spring-boot application which uses hibernate via spring-jpa, but i am getting this error:

Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set

        at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:104)

        at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:71)

        at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:205)

        at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:111)

        at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:234)

        at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:206)

        at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1885)

        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1843)

        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)

        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:843)

        at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:398)

        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:842)

        at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:152)

        at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:336)

        at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:318)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1613)

        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1550)

        ... 21 more

my pom.xml file is this:

<parent>

    <groupId>org.springframework.boot</groupId>

    <artifactId>spring-boot-starter-parent</artifactId>

    <version>1.1.8.RELEASE</version>

</parent>

<dependencies>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-web</artifactId>

    </dependency>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-actuator</artifactId>

    </dependency>

    <dependency>

        <groupId>org.springframework.security</groupId>

        <artifactId>spring-security-web</artifactId>

       </dependency>

    <dependency>

        <groupId>org.springframework.security</groupId>

        <artifactId>spring-security-config</artifactId>

    </dependency>

    <dependency>

        <groupId>org.springframework.security</groupId>

        <artifactId>spring-security-taglibs</artifactId>

    </dependency>

    <dependency>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-data-jpa</artifactId>

    </dependency>

    <dependency>

        <groupId>commons-dbcp</groupId>

        <artifactId>commons-dbcp</artifactId>

    </dependency>

</dependencies>

my hibernate configuration is that (the dialect configuration is in the last method from this class):

@Configuration

@EnableTransactionManagement

@ComponentScan({ "com.spring.app" })

public class HibernateConfig {

   @Bean

   public LocalSessionFactoryBean sessionFactory() {

      LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();

      sessionFactory.setDataSource(restDataSource());

      sessionFactory.setPackagesToScan(new String[] { "com.spring.app.model" });

      sessionFactory.setHibernateProperties(hibernateProperties());

      return sessionFactory;

   }

   @Bean

   public DataSource restDataSource() {

      BasicDataSource dataSource = new BasicDataSource();

      dataSource.setDriverClassName("org.postgresql.Driver");

      dataSource.setUrl("jdbc:postgresql://localhost:5432/teste?charSet=LATIN1");

      dataSource.setUsername("klebermo");

      dataSource.setPassword("123");

      return dataSource;

   }

   @Bean

   @Autowired

   public HibernateTransactionManager transactionManager(SessionFactory sessionFactory) {

      HibernateTransactionManager txManager = new HibernateTransactionManager();

      txManager.setSessionFactory(sessionFactory);

      return txManager;

   }

   @Bean

   public PersistenceExceptionTranslationPostProcessor exceptionTranslation() {

      return new PersistenceExceptionTranslationPostProcessor();

   }

   Properties hibernateProperties() {

      return new Properties() {

         /**

         * 

         */

        private static final long serialVersionUID = 1L;

        {

            setProperty("hibernate.hbm2ddl.auto", "create");

            setProperty("hibernate.show_sql", "false");

            setProperty("hibernate.dialect", "org.hibernate.dialect.PostgreSQLDialect");

         }

      };

   }

}

what I am doing wrong here?

Answer 1

I was facing a similar problem when starting up the application (using Spring Boot) with the database server down.

Hibernate can determine the correct dialect to use automatically, but in order to do this, it needs a live connection to the database.