• Register
0 votes

Problem :

I want to run the spring-boot application which uses thre hibernate via spring-jpa, but i am facing below 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:114)at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:82)at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:312)
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:222)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:345)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:308)


6 5 3
7,540 points

Please log in or register to answer this question.

2 Answers

0 votes

Solution :

I also faced the similar issue in the recent past. And it was due to a invalid password provided. Also, I would like to say that your code seems to be very old-style code using the spring. You have already mentioned that you are trying to use the spring boot, which clearly means most of your things will be completely auto configured for you. The Hibernate dialect will also be auto selected based on your DB driver available on your classpath along with your valid credentials which can also be used to test your connection properly. If there is any issue with your connection then you will have to again face your same error. So you only need Three properties in your application.properties

# Replace with the valid connection string
# Replace with the valid credentials

 If you follow above approach properly then you will be able to resolve your issue with minimum efforts on your side.


9 7 4
38,600 points
0 votes


First remove all of your configuration Spring Boot will begin it for you. In case you truly require a SessionFactory instead of an EntityManagerFactory include a HibernateJpaSessionFactoryBean.

Ensure that you have an application.properties in your classpath and include the following properties.



In case you truly require access to a SessionFactory and that is originally for the similar data source, then you can do the following (which is further docmented here although for XML, not JavaConfig).

public class HibernateConfig {

    public HibernateJpaSessionFactoryBean sessionFactory(EntityManagerFactory emf) {
         HibernateJpaSessionFactoryBean factory = new HibernateJpaSessionFactoryBean();
         return factory;

That method you have both an EntityManagerFactory and a SessionFactory.

Pretending you have a class with a main method with @EnableAutoConfiguration you don't require the @EnableTransactionManagement annotation, as that will be enabled by Spring Boot for you. A basic application class in the com.spring.app package must be enough.

public class Application {

    public static void main(String[] args) throws Exception {
        SpringApplication.run(Application.class, args);


Something like that must be enough to have all your classes (together with entities and Spring Data based repositories) detected.

I would also point out removing the commons-dbcp dependency as that would approve Spring Boot to configure the faster and more robust HikariCP implementation.

Including the following line to the properties file solve this problem at the time I had that error



10 6 4
31,120 points

Related questions

0 votes
1 answer 4.4K views
Problem : After executing spring boot with h2 database and JPA i am facing below error org.hibernate.tool.schema.spi.commandacceptanceexception: error executing ddl via jdbc statement
asked Nov 12, 2019 peterlaw 6.9k points
0 votes
1 answer 44 views
Problem : This is the error that is thrown when trying to run my web app: [INFO] WARNING: Nested in org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration': Injection of ... of the Datanucleus is no longer supported by your DataNucleus project I don't know what is missing in my app?
asked Dec 21, 2019 alecxe 7.5k points
0 votes
1 answer 4.8K views
Problem : I am developing the application in Spring, using a Tomcat, Mysql5, Java8... My problem is that I cannot deploy it, due to the "required bean 'entityManagerFactory' not found" problem. I have developed my project with the coworkers but ... a bean named 'entityManagerFactory' that could not be found. Action: Consider defining a bean named 'entityManagerFactory' in your configuration.
asked Jan 25, 2020 jwilliam 3.9k points
0 votes
1 answer 43 views
Problem: I am working on Hibernate and now I am facing what I believe is a simple problem with the Hibernate but still I can't solve it. I have written a simple class I would like to persist but still keep facing below error: SEVERE: Field 'id' doesn't have a ... that is not working for me. Initializing the id also did not help me either! I am looking for Hibernate expert to fix my above error.
asked Jul 30, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 1.8K views
Problem : I am a completely novice in the hibernate world and facing below error, WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement The ... hibernate 4 version all my code runs very well. I looked for many solutions but they are not working for me.
asked Feb 4, 2020 jwilliam 3.9k points
0 votes
2 answers 560 views
Problem : I am new to the Spring and JPA, wasted 10 days and no result with the searching on internet. I want to save the object to SQL SERVER, my connection is correct but when I write .flush() I get below exception “nested exception is javax.persistence.TransactionRequiredException: no transaction is in progress”
asked Jan 21, 2020 jwilliam 3.9k points
1 vote
1 answer 2.6K views
Problem : When I try to compile my spring project, I always face the below error : Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Invocation of init method failed I have the ... >1.4.1.RELEASE</version> <relativePath /> <!-- lookup parent from repository --> </parent> . . .
asked Dec 12, 2019 alecxe 7.5k points
0 votes
1 answer 295 views
Problem : I am new to Spring and JPA I want to save object to SQL SERVER, connection is correct but when I write .flush() I get the exception as below javax.persistence.TransactionRequiredException: no transaction is in progress
asked Oct 22, 2019 peterlaw 6.9k points
0 votes
1 answer 2.7K views
Problem : I am getting bellow error while using hibernate JPA with spring and mongodb and running my application on Glassfish-4.0. javax.persistence.transactionrequiredexception: executing an update/delete query
asked Oct 19, 2019 peterlaw 6.9k points
0 votes
1 answer 4.2K views
Problem : I am very new to the hibernate and I want to set up two classes. Also want to create a one to one bidirectional dependency using annotations. I have added all the libraries to the build path. But when i try to run the simple main class by ... .entity.SingleTableEntityPersister Because of this error I am confused. My SQL DB is running via XAMPP. May I get the solution for above error?
asked Dec 4, 2019 alecxe 7.5k points