Error creating bean with name entityManagerFactory defined in class path resource Invocation of init method failed

Question

When I compile my spring project  I got the following 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 am using STS Eclipse and MySql Database  My Connection string in Application Properties is  spring datasource url jdbc mysql   localhost 3306 stgdb spring datasource username root spring datasource password root spring datasource driver-class-name com mysql jdbc Driver spring jpa hibernate ddl-auto update   The detailed error is given below                                                     2016-10-15 15 34 38 875 0 39m  31mERROR 0 39m  35m3700 0 39m  2m--- 0 39m  2m            main  0 39m  36mo s boot SpringApplication               0 39m  2m  0 39m Application startup failed  org springframework beans factory BeanCreationException  Error creating bean with name  entityManagerFactory  defined in class path resource  org springframework boot autoconfigure orm jpa HibernateJpaAutoConfiguration class   Invocation of init method failed  nested exception is javax persistence PersistenceException   PersistenceUnit  default  Unable to build Hibernate SessionFactory     at org springframework beans factory support AbstractAutowireCapableBeanFactory initializeBean AbstractAutowireCapableBeanFactory java 1583    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support AbstractAutowireCapableBeanFactory doCreateBean AbstractAutowireCapableBeanFactory java 545    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support AbstractAutowireCapableBeanFactory createBean AbstractAutowireCapableBeanFactory java 482    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support AbstractBeanFactory 1 getObject AbstractBeanFactory java 306    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support DefaultSingletonBeanRegistry getSingleton DefaultSingletonBeanRegistry java 230    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support AbstractBeanFactory doGetBean AbstractBeanFactory java 302    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support AbstractBeanFactory getBean AbstractBeanFactory java 197    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework context support AbstractApplicationContext getBean AbstractApplicationContext java 1076    spring-context-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework context support AbstractApplicationContext finishBeanFactoryInitialization AbstractApplicationContext java 851    spring-context-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework context support AbstractApplicationContext refresh AbstractApplicationContext java 541    spring-context-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework boot context embedded EmbeddedWebApplicationContext refresh EmbeddedWebApplicationContext java 122    spring-boot-1 4 1 RELEASE jar 1 4 1 RELEASE      at org springframework boot SpringApplication refresh SpringApplication java 761   spring-boot-1 4 1 RELEASE jar 1 4 1 RELEASE      at org springframework boot SpringApplication refreshContext SpringApplication java 371   spring-boot-1 4 1 RELEASE jar 1 4 1 RELEASE      at org springframework boot SpringApplication run SpringApplication java 315   spring-boot-1 4 1 RELEASE jar 1 4 1 RELEASE      at org springframework boot SpringApplication run SpringApplication java 1186   spring-boot-1 4 1 RELEASE jar 1 4 1 RELEASE      at org springframework boot SpringApplication run SpringApplication java 1175   spring-boot-1 4 1 RELEASE jar 1 4 1 RELEASE      at com s2g testrestapplication TestRestApplication main TestRestApplication java 10   classes  na  Caused by  javax persistence PersistenceException   PersistenceUnit  default  Unable to build Hibernate SessionFactory     at org hibernate jpa boot internal EntityManagerFactoryBuilderImpl persistenceException EntityManagerFactoryBuilderImpl java 954    hibernate-entitymanager-5 0 11 Final jar 5 0 11 Final      at org hibernate jpa boot internal EntityManagerFactoryBuilderImpl build EntityManagerFactoryBuilderImpl java 882    hibernate-entitymanager-5 0 11 Final jar 5 0 11 Final      at org springframework orm jpa vendor SpringHibernateJpaPersistenceProvider createContainerEntityManagerFactory SpringHibernateJpaPersistenceProvider java 60    spring-orm-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework orm jpa LocalContainerEntityManagerFactoryBean createNativeEntityManagerFactory LocalContainerEntityManagerFactoryBean java 353    spring-orm-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework orm jpa AbstractEntityManagerFactoryBean buildNativeEntityManagerFactory AbstractEntityManagerFactoryBean java 373    spring-orm-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework orm jpa AbstractEntityManagerFactoryBean afterPropertiesSet AbstractEntityManagerFactoryBean java 362    spring-orm-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support AbstractAutowireCapableBeanFactory invokeInitMethods AbstractAutowireCapableBeanFactory java 1642    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE      at org springframework beans factory support AbstractAutowireCapableBeanFactory initializeBean AbstractAutowireCapableBeanFactory java 1579    spring-beans-4 3 3 RELEASE jar 4 3 3 RELEASE          16 common frames omitted Caused by  org hibernate exception GenericJDBCException  Unable to obtain JDBC Connection     at org hibernate exception internal StandardSQLExceptionConverter convert StandardSQLExceptionConverter java 47    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate engine jdbc spi SqlExceptionHelper convert SqlExceptionHelper java 109    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate engine jdbc spi SqlExceptionHelper convert SqlExceptionHelper java 95    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema extract internal ExtractionContextImpl getJdbcConnection ExtractionContextImpl java 65    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema extract internal ExtractionContextImpl getJdbcDatabaseMetaData ExtractionContextImpl java 75    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema extract internal InformationExtractorJdbcDatabaseMetaDataImpl locateTableInNamespace InformationExtractorJdbcDatabaseMetaDataImpl java 339    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema extract internal InformationExtractorJdbcDatabaseMetaDataImpl getTable InformationExtractorJdbcDatabaseMetaDataImpl java 241    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema extract internal DatabaseInformationImpl getTableInformation DatabaseInformationImpl java 105    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema internal SchemaMigratorImpl doMigrationToTargets SchemaMigratorImpl java 162    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema internal SchemaMigratorImpl doMigration SchemaMigratorImpl java 60    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool hbm2ddl SchemaUpdate execute SchemaUpdate java 134    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool hbm2ddl SchemaUpdate execute SchemaUpdate java 101    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate internal SessionFactoryImpl  lt init gt  SessionFactoryImpl java 472    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate boot internal SessionFactoryBuilderImpl build SessionFactoryBuilderImpl java 444    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate jpa boot internal EntityManagerFactoryBuilderImpl build EntityManagerFactoryBuilderImpl java 879    hibernate-entitymanager-5 0 11 Final jar 5 0 11 Final          22 common frames omitted Caused by  com atomikos jdbc AtomikosSQLException  Connection pool exhausted - try increasing  maxPoolSize  and or  borrowConnectionTimeout  on the DataSourceBean      at com atomikos jdbc AtomikosSQLException throwAtomikosSQLException AtomikosSQLException java 46    transactions-jdbc-3 9 3 jar na      at com atomikos jdbc AbstractDataSourceBean throwAtomikosSQLException AbstractDataSourceBean java 90    transactions-jdbc-3 9 3 jar na      at com atomikos jdbc AbstractDataSourceBean throwAtomikosSQLException AbstractDataSourceBean java 85    transactions-jdbc-3 9 3 jar na      at com atomikos jdbc AbstractDataSourceBean getConnection AbstractDataSourceBean java 347    transactions-jdbc-3 9 3 jar na      at com atomikos jdbc AbstractDataSourceBean getConnection AbstractDataSourceBean java 394    transactions-jdbc-3 9 3 jar na      at org hibernate engine jdbc connections internal DatasourceConnectionProviderImpl getConnection DatasourceConnectionProviderImpl java 122    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate engine jdbc env internal JdbcEnvironmentInitiator ConnectionProviderJdbcConnectionAccess obtainConnection JdbcEnvironmentInitiator java 180    hibernate-core-5 0 11 Final jar 5 0 11 Final      at org hibernate tool schema extract internal ExtractionContextImpl getJdbcConnection ExtractionContextImpl java 62    hibernate-core-5 0 11 Final jar 5 0 11 Final          33 common frames omitted                                Pom xml file      lt project xmlns  http   maven apache org POM 4 0 0  xmlns xsi  http   www w3 org 2001 XMLSchema-instance      xsi schemaLocation  http   maven apache org POM 4 0 0 http   maven apache org xsd maven-4 0 0 xsd  gt       lt modelVersion gt 4 0 0 lt  modelVersion gt        lt groupId gt com s2g testrestapplication lt  groupId gt       lt artifactId gt testrestapplication lt  artifactId gt       lt version gt 0 0 1-SNAPSHOT lt  version gt       lt packaging gt jar lt  packaging gt        lt name gt TestRestApplication lt  name gt       lt description gt Demo project for Spring Boot lt  description gt        lt parent gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-starter-parent lt  artifactId gt           lt version gt 1 4 1 RELEASE lt  version gt           lt relativePath   gt   lt  -- lookup parent from repository -- gt       lt  parent gt        lt properties gt           lt project build sourceEncoding gt UTF-8 lt  project build sourceEncoding gt           lt project reporting outputEncoding gt UTF-8 lt  project reporting outputEncoding gt           lt java version gt 1 8 lt  java version gt       lt  properties gt        lt dependencies gt           lt dependency gt               lt groupId gt io springfox lt  groupId gt               lt artifactId gt springfox-swagger2 lt  artifactId gt               lt version gt 2 2 2 lt  version gt           lt  dependency gt            lt dependency gt               lt groupId gt io springfox lt  groupId gt               lt artifactId gt springfox-swagger-ui lt  artifactId gt               lt version gt 2 2 2 lt  version gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-security lt  artifactId gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-web lt  artifactId gt           lt  dependency gt            lt dependency gt               lt groupId gt mysql lt  groupId gt               lt artifactId gt mysql-connector-java lt  artifactId gt               lt scope gt runtime lt  scope gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-test lt  artifactId gt               lt scope gt test lt  scope gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-data-jpa lt  artifactId gt           lt  dependency gt           lt dependency gt               lt groupId gt org opensaml lt  groupId gt               lt artifactId gt opensaml-saml-api lt  artifactId gt               lt version gt 3 1 1 lt  version gt           lt  dependency gt           lt dependency gt               lt groupId gt org apache commons lt  groupId gt               lt artifactId gt commons-lang3 lt  artifactId gt               lt version gt 3 0 lt  version gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-jersey lt  artifactId gt           lt  dependency gt           lt dependency gt               lt groupId gt org springframework boot lt  groupId gt               lt artifactId gt spring-boot-starter-jta-atomikos lt  artifactId gt           lt  dependency gt       lt  dependencies gt        lt build gt           lt plugins gt               lt plugin gt                   lt groupId gt org springframework boot lt  groupId gt                   lt artifactId gt spring-boot-maven-plugin lt  artifactId gt               lt  plugin gt           lt  plugins gt       lt  build gt     lt  project gt

User · Accepted Answer

I would start by adding the following dependency:

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-core</artifactId>
    <version>4.1.4.Final</version>
</dependency>

and

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-entitymanager</artifactId>
    <version>5.2.3.Final</version>
</dependency>

UPDATE: Or simply add the following dependency.

<dependency>
    <groupId>javax.xml.bind</groupId>
    <artifactId>jaxb-api</artifactId>
    <version>2.3.0</version>
</dependency>

User · Answer

For me  it was a result of another error     org postgresql util PSQLException  FATAL  password authentication failed for user    Which means you just need to review your authentication credentials

User · Answer

I solved mine by updating spring dependencies versions from 2 0 4 to 2 1 6   lt parent gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-starter-parent lt  artifactId gt           lt version gt 2 0 4 RELEASE lt  version gt           lt relativePath   gt   lt  -- lookup parent from repository -- gt   lt  parent gt    to   lt parent gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-starter-parent lt  artifactId gt           lt version gt 2 1 6 RELEASE lt  version gt           lt relativePath   gt   lt  -- lookup parent from repository -- gt   lt  parent gt

User · Answer

I have gone through similar error  The error was not coming earlier  but recently I reinstall my oracle db and change the instance name from  xe  to  orcl   but forget to change this piece of code in property file   spring datasource driver-class-name oracle jdbc driver OracleDriver spring datasource url jdbc oracle thin  localhost 1521    xe    spring datasource username system spring datasource password manager   Once I change it from  xe  to  orcl  everything is fine

User · Answer

Whoever still having the same issue  Please add the following line in application properties    The SQL dialect makes Hibernate generate better SQL for the chosen database    I am using Mysql8 so I have declared MySQL8Dialect if you have other versions just add    that version number spring jpa properties hibernate dialect    org hibernate dialect MySQL8Dialect

User · Answer

I ve jdk-12 0 2 jdk   ve found solution to the problem  add dependencies to pom xml    lt  -- https   mvnrepository com artifact javax xml bind jaxb-api -- gt   lt dependency gt       lt groupId gt javax xml bind lt  groupId gt       lt artifactId gt jaxb-api lt  artifactId gt       lt version gt 2 3 1 lt  version gt   lt  dependency gt   lt  -- https   mvnrepository com artifact org javassist javassist -- gt   lt dependency gt       lt groupId gt org javassist lt  groupId gt       lt artifactId gt javassist lt  artifactId gt       lt version gt 3 25 0-GA lt  version gt   lt  dependency gt

User · Answer

For those who are not using JPA and instead prefer to exclude the  entityManagerFactory and use Spring Data JDBC or Spring JDBC can exclude the bean to avoid the exception    SpringBootApplication exclude    HibernateJpaAutoConfiguration class

User · Answer

For me it was the name of the database on application properties  When I provided the correct name it worked ok

User · Answer

I faced the same issue  I was using Java 9 and the following dependency in pom file   lt dependencies gt       lt dependency gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-starter-data-jpa lt  artifactId gt       lt  dependency gt       lt dependency gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-starter-jdbc lt  artifactId gt       lt  dependency gt       lt dependency gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-starter-web lt  artifactId gt       lt  dependency gt       lt dependency gt           lt groupId gt com h2database lt  groupId gt           lt artifactId gt h2 lt  artifactId gt           lt scope gt runtime lt  scope gt       lt  dependency gt       lt dependency gt           lt groupId gt org springframework boot lt  groupId gt           lt artifactId gt spring-boot-starter-test lt  artifactId gt           lt scope gt test lt  scope gt       lt  dependency gt   lt  dependencies gt   The issue was resolved after adding the dependency below in pom   lt dependency gt       lt groupId gt javax xml bind lt  groupId gt       lt artifactId gt jaxb-api lt  artifactId gt       lt version gt 2 3 0 lt  version gt   lt  dependency gt

User · Answer

If nothing work then I have one solution  Access value AccessType FIELD  add this line in under model class after you used  Entity then followed by the class and after class when you defining id and all that time you use above line

User · Answer

Adding dependencies didn t fix the issue at my end   The issue was happening at my end because of  additional  fields that are part of the   Entity  class and don t exist in the database   I removed the additional fields from the  Entity class and it worked    Goodluck

User · Answer

My error was solved after adding this dependency    lt  -- https   mvnrepository com artifact org hibernate hibernate-validator -- gt       lt dependency gt           lt groupId gt org hibernate validator lt  groupId gt           lt artifactId gt hibernate-validator lt  artifactId gt           lt version gt 6 0 16 Final lt  version gt       lt  dependency gt

User · Answer

Try to annotate the class with  EnableTransactionManagement  I was facing the same issue and it got resolved by adding this    EnableTransactionManagement public class ConfigurationBean

User · Answer

In my case I got this error when trying to make Proguard   Spring Boot 2 work  Adding -dontusemixedcaseclassnames to proguard conf fixes it

User · Answer

I suspect that the jar files of hibernate-core and hibernate-entitymanager dependencies are corrupted or were not installed properly on your machine   I suggest that you just delete the folders named hibernate-core and hibernate-entitymanager from your Maven local repository and Maven will reinstall them   The default location for Maven local repository is C  Documents and Settings  USERNAME   m2 in windows or    m2 in Linux Mac

User · Answer

People using Java 9 include this dependency   lt dependency gt       lt groupId gt javax xml bind lt  groupId gt       lt artifactId gt jaxb-api lt  artifactId gt       lt version gt 2 3 0 lt  version gt   lt  dependency gt

User · Answer

For my case it was due to Intellij IDEA by default set Java 11 as default project SDK  but project was implemented in Java 8  I ve changed  Project SDK  in File -  Project Structure -  Project  in Project Settings

User · Answer

I resolved this issue by Adding implements Serializable in the Model    Entity  Table name  Model Rest    IdClass Model Rest class  public class Model Rest implements Serializable                                private static final long serialVersionUID   1L                                 GeneratedValue strategy   GenerationType AUTO         Column columnDefinition  id         Id     private String login       Id     private String password           Autowired     public String getLogin             return login              Autowired     public void setLogin String login            this login   login              Autowired     public String getPassword             return password              Autowired     public void setPassword String password            this password   password             public Model Rest                TODO Auto-generated constructor stub            public Model Rest String login  String password            this login   login          this password   password              Override     public String toString             return  Model Rest  login     login      password     password

User · Answer

I resolved mine by defining reverse-relationship annotation for an additional field

User · Answer

The problem might be because of package conflicts   When you use  Id annotation in an entity  it might use the  Id of Spring framework  however  it must use  Id annotation of persistence API   So use  javax persistence Id annotation in entities

User · Answer

In our case  we had some extra lines in the  properties file which was not needed with the new image  spring jpa properties hibernate cache use second level cache true Obviously with didn t had that Entity what it tried to load

User · Answer

Try adding the following dependencies    lt dependency gt      lt groupId gt org springframework boot lt  groupId gt      lt artifactId gt spring-boot-starter-data-jpa lt  artifactId gt   lt  dependency gt   lt dependency gt      lt groupId gt com h2database lt  groupId gt      lt artifactId gt h2 lt  artifactId gt   lt  dependency gt

User · Answer

use  Id  Worked for me Otherwise it i will throw error It depends on is there anything missing in your entity class or repository

User · Answer

This error may be also related to the fact that you have an error in your  spring datasource url  when you gave a wrong db name for example

User · Answer

In my case  deleting any of the below annotations cause the error message  entityManagerFactory  to show  for example      Id    GeneratedValue strategy GenerationType AUTO    or    ManyToMany targetEntity listOfObject x class    The error message disappears after adding the missing annotation s    package mypackage unameit  import javax persistence PrePersist  import javax validation constraints NotNull  import javax validation constraints Size   import lombok Data    Data  Entity public class Someclasss       Id    GeneratedValue strategy GenerationType AUTO    private Long id      NotNull    Size min 5  message  Name must be at least 5 characters long     private String name     private Date createdAt      ManyToMany targetEntity listOfObject x class     Size min 1  message  You must choose at least 1 ingredient     private List lt listOfObject x gt      new ArrayList lt  gt         PrePersist   void createdAt         this createdAt   new Date

User · Answer

For those who use Gradle instead of Maven  add this to the dependencies in your build file   compile  javax xml bind jaxb-api 2 3 0

User · Answer

If you use JDK 1 8 0 201 or latest try it with older JDK   I have same issue with JDK1 8 0 201  however it works with JDK1 8 0 101 without any code change

User · Answer

Try changing spring version  I had the same issue and that worked for me

User · Answer

I had the same issue on my Eclipse Luna   I figure out that I am using JDK12 and Java 1 8  I changed JDK to JDK8 and the problem was solved  If you want to check your JDK in Eclipse go to   Window- gt  Preferences- gt  Java-  gt Installed JREs    and check if they are compatible with your project  Good luck

User · Answer

I was able to fix the problem by changing the maximum-pool size value from one to two  spring datasource hikari maximum-pool-size 2

[java] Error creating bean with name 'entityManagerFactory' defined in class path resource : Invocation of init method failed

Examples related to java

Examples related to spring

Examples related to hibernate

Examples related to spring-mvc

Examples related to jpa