SpringBoot JPA Hibernate：创建名为'entityManagerFactory'的bean时出错 [英] SpringBoot JPA Hibernate: Error creating bean with name 'entityManagerFactory'

查看：182
本文介绍了SpringBoot JPA Hibernate：创建名为'entityManagerFactory'的bean时出错的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我试图设置一个Spring Boot应用程序，它使用SpringBoot Security对用户进行身份验证，这些用户存储在我的MySQL数据库中。
我已经遵循了一些关于如何做到这一点的教程，但是，当我尝试使用maven运行应用程序时，出现以下错误： 

  org.springframework.beans.factory.BeanCreationException：在类路径资源[org / springframework / boot / autoconfigure / orm / jpa / HibernateJpaAutoConfiguration.class]中定义名称为'entityManagerFactory'的bean时出错：调用init方法失败;嵌套异常是javax.persistence.PersistenceException：[PersistenceUnit：default]无法在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean中创建Hibernate SessionFactory 
（AbstractAutowireCapableBeanFactory.java:1628）〜[spring-beans- 4.3.10.RELEASE.jar：4.3.10.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean（AbstractAutowireCapableBeanFactory.java:555）〜[spring-beans-4.3.10.RELEASE .jar：4.3.10.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean（AbstractAutowireCapableBeanFactory.java:483）〜[spring-beans-4.3.10.RELEASE.jar：4.3。 10.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory $ 1.getObject（AbstractBeanFactory.java:306）〜[spring-beans-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
在org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton（DefaultSingletonBe anRegistry.java:230）〜[spring-beans-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean（AbstractBeanFactory.java:302 ）〜[spring-beans-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean（AbstractBeanFactory.java:197）〜[spring- beans-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
在org.springframework.context.support.AbstractApplicationContext.getBean（AbstractApplicationContext.java:1078）〜[spring-context-4.3.10.RELEASE .jar：4.3.10.RELEASE] 
在org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization（AbstractApplicationContext.java:857）〜[spring-context-4.3.10.RELEASE.jar：4.3.10。 
 at org.springframework.context.support.AbstractApplicationContext.refresh（AbstractApplicationContext.java:543）〜[spring-context-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
 at org.springframework.boot.context.embedded.Embedded WebApplicationContext.refresh（EmbeddedWebApplicationContext.java:122）〜[spring-boot-1.5.6.RELEASE.jar：1.5.6.RELEASE] 
 at org.springframework.boot.SpringApplication.refresh（SpringApplication.java:693 ）[spring-boot-1.5.6.RELEASE.jar：1.5.6.RELEASE] 
在org.springframework.boot.SpringApplication.refreshContext（SpringApplication.java:360）[spring-boot-1.5.6。 RELEASE.jar：1.5.6.RELEASE] 
在org.springframework.boot.SpringApplication.run（SpringApplication.java:303）[spring-boot-1.5.6.RELEASE.jar：1.5.6.RELEASE] 
在org.springframework.boot.SpringApplication.run（SpringApplication.java:1118）[spring-boot-1.5.6.RELEASE.jar：1.5.6.RELEASE] 
在org.springframework.boot .SpringApplication.run（SpringApplication.java:1107）[spring-boot-1.5.6.RELEASE.jar：1.5.6.RELEASE] 
 at com.proba.Userboard.UserboardApplication.main（UserboardApplication.java:11 ）[classes /：na] 
 at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）〜[na：1.8.0_121] 
 at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）〜[na：1.8.0_121] 
 at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）〜[na：1.8.0_121] 
 at java.lang.reflect.Method.invoke（Method.java:498）〜[na：1.8.0_121] 
 at org.springframework.boot.devtools.restart.RestartLauncher.run（RestartLauncher.java ：49）[spring-boot-devtools-1.5.6.RELEASE.jar：1.5.6.RELEASE] 
导致：javax.persistence.PersistenceException：[PersistenceUnit：default]无法构建Hibernate SessionFactory 
在org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException（EntityManagerFactoryBuilderImpl.java:954）〜[hibernate-entitymanager-5.0.12.Final.jar：5.0.12.Final] 
 at org.hibernate .jpa.boot.internal.EntityManagerFactoryBuilderImpl.build（EntityManagerFactoryBuilderImpl.java:882）〜[hibernate-entitymanager-5.0.12.Final.jar：5.0.12.Final] 
 at org.springframework.orm.jpa。 vendor.SpringHibern ateJpaPersistenceProvider.createContainerEntityManagerFactory（SpringHibernateJpaPersistenceProvider.java:60）〜[spring-orm-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
 at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory（LocalContainerEntityManagerFactoryBean.java ：353）〜[spring-orm-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
在org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory（AbstractEntityManagerFactoryBean.java:370）〜[spring- orm-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
 at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet（AbstractEntityManagerFactoryBean.java:359）〜[spring-orm-4.3.10.RELEASE .jar：4.3.10.RELEASE] 
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods（AbstractAutowireCapableBeanFactory.java:1687）〜[spring-beans-4.3.10.RELEASE.jar：4.3。 10.RELEASE] 
在org.springframework.beans.factory.suppor t.AbstractAutowireCapableBeanFactory.initializeBean（AbstractAutowireCapableBeanFactory.java:1624）〜[spring-beans-4.3.10.RELEASE.jar：4.3.10.RELEASE] 
 ...共有21个框架被省略
引起： org.hibernate.MappingException：无法确定类型：java.util.Set，在table：role，对于列：[org.hibernate.mapping.Column（users）] 
在org.hibernate.mapping.SimpleValue .getType（SimpleValue.java:431）〜[hibernate-core-5.0.12.Final.jar：5.0.12.Final] 
 at org.hibernate.mapping.SimpleValue.isValid（SimpleValue.java:398） 〜[hibernate-core-5.0.12.Final.jar：5.0.12.Final] 
 at org.hibernate.mapping.Property.isValid（Property.java:225）〜[hibernate-core-5.0.12 .Final.jar：5.0.12.Final] 
在org.hibernate.mapping.PersistentClass.validate（PersistentClass.java:595）〜[hibernate-core-5.0.12.Final.jar：5.0.12。最终] 
在org.hibernate.mapping.RootClass.validate（RootClass.java:265）〜[hibernate-core-5.0.12.Final.jar：5.0.12.Final] 
 at org。 hibernate.boot.int ernal.MetadataImpl.validate（MetadataImpl.java:329）〜[hibernate-core-5.0.12.Final.jar：5.0.12.Final] 
 at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build（SessionFactoryBuilderImpl .java：443）〜[hibernate-core-5.0.12.Final.jar：5.0.12.Final] 
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build（EntityManagerFactoryBuilderImpl.java:879） 〜[hibernate-entitymanager-5.0.12.Final.jar：5.0.12.Final] 
 ... 27个常见框架省略

如果我没有弄错，这意味着我无法连接到我的数据库，因此我有问题创建bean entityManagerFactory



这是我的 pom.xml 文件 

 <？xml version =1.0encoding = UTF-8\" >？; 
< project xmlns =http://maven.apache.org/POM/4.0.0xmlns：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\"> 
< modelVersion> 4.0.0< / modelVersion> 
< groupId> com.mjamsek< / groupId> 
< artifactId> Userboard< / artifactId> 
< version> 0.0.1-SNAPSHOT< / version> 
<包装> jar< / packaging> 
<名称> Userboard< /名称> 
< description> Userboard< / description> 
< parent> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-starter-parent< / artifactId> 
< version> 1.5.6.RELEASE< / version> 
< relativePath /> <！ - 从存储库查找父级 - > 
< / parent> 
<属性> 
< project.build.sourceEncoding> UTF-8< /project.build.sourceEncoding> 
< project.reporting.outputEncoding> UTF-8< /project.reporting.outputEncoding> 
< java.version> 1.8< /java.version> 
< / properties> 
<依赖关系> 
< dependency> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-starter-actuator< / artifactId> 
< /依赖关系> 
< dependency> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-starter-data-jpa< / artifactId> 
< /依赖关系> 
< dependency> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-starter-freemarker< / artifactId> 
< /依赖关系> 
< dependency> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-starter-security< / artifactId> 
< /依赖关系> 
< dependency> 
< groupId> org.hsqldb< / groupId> 
< artifactId> hsqldb< / artifactId> 
< scope>运行时< / scope> 
< /依赖关系> 
< dependency> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-starter-web< / artifactId> 
< /依赖关系> 
< dependency> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-devtools< / artifactId> 
< scope>运行时< / scope> 
< /依赖关系> 
< dependency> 
< groupId> mysql< / groupId> 
< artifactId> mysql-connector-java< / artifactId> 
< scope>运行时< / scope> 
< /依赖关系> 
< dependency> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-starter-test< / artifactId> 
< scope> test< / scope> 
< /依赖关系> 
< dependency> 
< groupId> org.springframework.security< / groupId> 
< artifactId> spring-security-test< / artifactId> 
< scope> test< / scope> 
< /依赖关系> 
< /依赖关系> 
< build> 
< plugins> 
< plugin> 
< groupId> org.springframework.boot< / groupId> 
< artifactId> spring-boot-maven-plugin< / artifactId> 
< / plugin> 
< / plugins> 
< / build> 
< / project>

我的 application.properties ： 

  spring.datasource.url = jdbc：mysql：// localhost：3306 / userboard？useSSL = false 
 spring.datasource.username = my_username 
 spring.datasource.password = my_pass 
 spring.datasource.driver-class-name = com.mysql.jdbc.Driver 
 spring.mvc.view.prefix = / 
 spring.mvc。 view.suffix = .ftl 
 spring.jpa.show-sql = true 
 spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect 
 spring.session.store- type = jdbc 
 spring.session.jdbc.table-name = SESSIONS 
 spring.messages.basename = validation

然后，我定义了下两个实体：

User.java 

  package com.proba.Userboard.entity; 
 
 import java.util.Set; 
 import javax.persistence.Column; 
 import javax.persistence.Entity; 
 import javax.persistence.GeneratedValue; 
 import javax.persistence.GenerationType; 
 import javax.persistence.Id; 
 import javax.persistence.JoinColumn; 
 import javax.persistence.JoinTable; 
 import javax.persistence.ManyToMany; 
 import javax.persistence.Table; 
 
 @Entity 
 @Table（name =user）
 public class User {
 @Id 
 @GeneratedValue（strategy = GenerationType.AUTO） 
 @Column（name =user_id）
 private int id; 
 @Column（name =username）
私人字符串用户名; 
 @Column（name =pass）
 private String pass; 
 @Column（name =name）
私人字符串名称; 
私人字符串passConfirm; 
私人设置<角色>角色; 
 $ b $ public User（）{
 
} 
 public User（String usr，String pas，String nam）{
 this.username = usr; 
 this.pass = pas; 
 this.name = nam; 
 
 @Override 
 public String toString（）{
 return String.format（{id：％d，username：％s，pass：％s，name：％ s}，this.id，this.username，this.pass，this.name）; 
} 
 public int getId（）{
 return id; 
} 
 public void setId（int id）{
 this.id = id; 
} 
 public String getUsername（）{
 return username; 
} 
 public void setUsername（String username）{
 this.username = username; 
} 
 public String getPass（）{
 return pass; 
} 
 public void setPass（String pass）{
 this.pass = pass; 
} 
 public String getName（）{
 return name; 
} 
 public void setName（String name）{
 this.name = name; 
 
 @ManyToMany 
 @JoinTable（name =user_role，joinColumns = @JoinColumn（name =user_id），inverseJoinColumns = @JoinColumn（name =role_id））
 public Set< Role> getRoles（）{
返回角色; 
} 
 public void setRoles（Set< Role> roles）{
 this.roles = roles; 
} 
 public String getPassConfirm（）{
 return passConfirm; 
} 
 public void setPassConfirm（String passConfirm）{
 this.passConfirm = passConfirm;

Role.java 

  package com.proba.Userboard.entity; 
 
 import java.util.Set; 
 import javax.persistence.Column; 
 import javax.persistence.Entity; 
 import javax.persistence.GeneratedValue; 
 import javax.persistence.GenerationType; 
 import javax.persistence.Id; 
 import javax.persistence.ManyToMany; 
 import javax.persistence.Table; 
 $ b $ @Entity 
 @Table（name =role）
 public class Role {
 @Id 
 @GeneratedValue（strategy = GenerationType.AUTO） 
 @Column（name =role）
 private int id; 
 @Column（name =role_name）
私人字符串名称; 
私人设定<使用者>用户; 
 
 public Role（）{
 
} 
 public Role（String n）{
 this.name = n; 
} 
 public int getId（）{
 return id; 
} 
 public void setId（int id）{
 this.id = id; 
} 
 public String getName（）{
 return name; 
} 
 public void setName（String name）{
 this.name = name; 
} 
 @ManyToMany（mappedBy =roles）
 public Set< User> getUsers（）{
返回用户; 
} 
 public void setUsers（Set< User> users）{
 this.users = users; 
} 
 @Override 
 public String toString（）{
 return String.format（{id：％s，name：％s}，this.id，this。名称）;

我有以下DAO：


$ b

RoleDAO.java 

  package com.proba.Userboard .dao; 
 
 import org.springframework.data.jpa.repository.JpaRepository; 
 import org.springframework.stereotype.Repository; 
 import org.springframework.transaction.annotation.Transactional; 
 import com.proba.Userboard.entity.Role; 
 
 @Repository 
 @Transactional 
公共接口RoleDAO扩展JpaRepository< Role，Integer> {
 
}

UserDAO.java 

  import org.springframework.data.jpa.repository.JpaRepository; 
 import org.springframework.stereotype.Repository; 
 import org.springframework.transaction.annotation.Transactional; 
 import com.proba.Userboard.entity.User; 
 
 @Repository 
 @Transactional 
 public interface UserDAO扩展JpaRepository< User，Integer> {
 public User findByUsername（String username）;

我的用户服务：

  package com.proba.Userboard.service; 
 
 import java.util.HashSet; 
 import org.springframework.beans.factory.annotation.Autowired; 
 import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder; 
 import com.proba.Userboard.dao.RoleDAO; 
 import com.proba.Userboard.dao.UserDAO; 
 import com.proba.Userboard.entity.User; 
 
 public class UserServiceImpl实现UserService {
 @Autowired 
 private UserDAO userDAO; 
 @Autowired 
私人RoleDAO roleDAO; 
 @Autowired 
私人BCryptPasswordEncoder bcrypt; 
 
 @Override 
 public void save（User user）{
 
 user.setPass（bcrypt.encode（user.getPass（）））; 
 user.setRoles（new HashSet<>（roleDAO.findAll（）））; 
 userDAO.save（user）; 
 
 
 @Override 
 public User findByUsername（String username）{
 return userDAO.findByUsername（username）;

我的 SpringBoot安全配置 ：

  package com.proba.Userboard.config; 
 
 import org.springframework.beans.factory.annotation.Autowired; 
 import org.springframework.context.annotation.Bean; 
 import org.springframework.context.annotation.Configuration; 
 import org.springframework.security.config.annotation.authentication.builders.AuthenticationManagerBuilder; 
 import org.springframework.security.config.annotation.web.builders.HttpSecurity; 
 import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity; 
 import org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter; 
 import org.springframework.security.core.userdetails.UserDetailsS​​ervice; 
 import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder; 
 
 @Configuration 
 @EnableWebSecurity 
 public class SecurityConf extends WebSecurityConfigurerAdapter {
 @Autowired $ b $ private UserDetailsS​​ervice userDetailsS​​ervice; 
 @Bean 
 public BCryptPasswordEncoder bcyrpt（）{
 return new BCryptPasswordEncoder（）; 
 
 $ b @Override 
 protected void configure（HttpSecurity http）throws Exception {
 http 
 .authorizeRequests（）
 .antMatchers（ （）
 .and（）
 .formLogin（）
 .loginPage（）/ resource / **，/ registration （/ login）
 .permitAll（）
 .and（）
 .logout（）
 .permitAll（）; 
 
 $ b @Autowired 
 public void configureGlobal（AuthenticationManagerBuilder auth）throws Exception {
 auth.userDetailsS​​ervice（userDetailsS​​ervice）.passwordEncoder（bcyrpt（））; 
 
 
 
 
 
 
 $ b因此，当我运行 mvn clean spring -boot：run ，我得到了前面提到的错误，我无法弄清楚我做错了什么。以前我做过类似的应用程序，但是我找不到，为什么这个不行。    解决方案

没问题不在数据库连接中，hibernate根据id上的注释位置（在属性本身或方法上）确定其策略来检查配置注释。



在你的User类中，你告诉hibernate期望属性级别的注释 

  public class User {
 @ Id 
 @GeneratedValue（strategy = GenerationType.AUTO）
 @Column（name =user_id）
 private int id;

因此，对于hibernate，您不需要映射其他attirbute角色，因为它不会检查映射，所以你需要做的是从方法中取得注释并将其放入属性中。
$ b $ $ $ $ $ $ $ $ $ c $ @ $ @ b $ b @JoinTable（name =user_role，joinColumns = @JoinColumn（name =user_id），inverseJoinColumns = @JoinColumn（name =role_id））
private Set< Role>角色;

您需要在所有注释中执行此操作


I am trying to setup a Spring Boot application, which uses SpringBoot Security to authenticate users, which are stored in my MySQL database. I have followed some tutorials on how to make this, however, when i try to run the application with maven i get the following error:

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:1628) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1078) ~[spring-context-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:857) ~[spring-context-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543) ~[spring-context-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122) ~[spring-boot-1.5.6.RELEASE.jar:1.5.6.RELEASE]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693) [spring-boot-1.5.6.RELEASE.jar:1.5.6.RELEASE]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360) [spring-boot-1.5.6.RELEASE.jar:1.5.6.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:303) [spring-boot-1.5.6.RELEASE.jar:1.5.6.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1118) [spring-boot-1.5.6.RELEASE.jar:1.5.6.RELEASE]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1107) [spring-boot-1.5.6.RELEASE.jar:1.5.6.RELEASE]
    at com.proba.Userboard.UserboardApplication.main(UserboardApplication.java:11) [classes/:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_121]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_121]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
    at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) [spring-boot-devtools-1.5.6.RELEASE.jar:1.5.6.RELEASE]
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.12.Final.jar:5.0.12.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:882) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
    at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60) ~[spring-orm-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:353) ~[spring-orm-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:370) ~[spring-orm-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:359) ~[spring-orm-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1687) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624) ~[spring-beans-4.3.10.RELEASE.jar:4.3.10.RELEASE]
    ... 21 common frames omitted
Caused by: org.hibernate.MappingException: Could not determine type for: java.util.Set, at table: role, for columns: [org.hibernate.mapping.Column(users)]
    at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:431) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:398) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.mapping.Property.isValid(Property.java:225) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:595) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.mapping.RootClass.validate(RootClass.java:265) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.boot.internal.MetadataImpl.validate(MetadataImpl.java:329) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:443) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:879) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
    ... 27 common frames omitted

If I am not mistaken, this means that I cannot connect to my database, therefore I have problem creating bean entityManagerFactory

So, this is my pom.xml file

<?xml version="1.0" encoding="UTF-8"?>
<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">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.mjamsek</groupId>
    <artifactId>Userboard</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>
    <name>Userboard</name>
    <description>Userboard</description>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.6.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-actuator</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-freemarker</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-security</artifactId>
        </dependency>
        <dependency>
            <groupId>org.hsqldb</groupId>
            <artifactId>hsqldb</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.security</groupId>
            <artifactId>spring-security-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

My application.properties:

spring.datasource.url=jdbc:mysql://localhost:3306/userboard?useSSL=false
spring.datasource.username=my_username
spring.datasource.password=my_pass
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.mvc.view.prefix=/
spring.mvc.view.suffix=.ftl
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
spring.session.store-type=jdbc
spring.session.jdbc.table-name=SESSIONS
spring.messages.basename=validation

Then, I have defined next two Entities:

User.java

package com.proba.Userboard.entity;

import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.Table;

@Entity
@Table(name="user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name="user_id")
    private int id;
    @Column(name="username")
    private String username;
    @Column(name="pass")
    private String pass;
    @Column(name="name")
    private String name;
    private String passConfirm;
    private Set<Role> roles;

    public User() {

    }
    public User(String usr, String pas, String nam) {
        this.username = usr;
        this.pass = pas;
        this.name = nam;
    }
    @Override
    public String toString() {
        return String.format("{ id : %d, username : %s, pass : %s, name : %s }", this.id, this.username, this.pass, this.name);
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPass() {
        return pass;
    }
    public void setPass(String pass) {
        this.pass = pass;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    @ManyToMany
    @JoinTable(name="user_role", joinColumns = @JoinColumn(name="user_id"), inverseJoinColumns = @JoinColumn(name="role_id"))
    public Set<Role> getRoles() {
        return roles;
    }
    public void setRoles(Set<Role> roles) {
        this.roles = roles;
    }
    public String getPassConfirm() {
        return passConfirm;
    }
    public void setPassConfirm(String passConfirm) {
        this.passConfirm = passConfirm;
    }
}

Role.java

package com.proba.Userboard.entity;

import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.ManyToMany;
import javax.persistence.Table;

@Entity
@Table(name="role")
public class Role {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name="role")
    private int id;
    @Column(name="role_name")
    private String name;
    private Set<User> users;

    public Role() {

    }
    public Role(String n) {
        this.name = n;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    @ManyToMany(mappedBy = "roles")
    public Set<User> getUsers() {
        return users;
    }
    public void setUsers(Set<User> users) {
        this.users = users;
    }
    @Override
    public String toString() {
        return String.format("{ id : %s, name: %s }", this.id, this.name);
    }
}

I have the following DAOs:

RoleDAO.java

package com.proba.Userboard.dao;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import com.proba.Userboard.entity.Role;

@Repository
@Transactional
public interface RoleDAO extends JpaRepository<Role, Integer> {

}

UserDAO.java

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import com.proba.Userboard.entity.User;

@Repository
@Transactional
public interface UserDAO extends JpaRepository<User, Integer> {
    public User findByUsername(String username);
}

My User Service:

package com.proba.Userboard.service;

import java.util.HashSet;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
import com.proba.Userboard.dao.RoleDAO;
import com.proba.Userboard.dao.UserDAO;
import com.proba.Userboard.entity.User;

public class UserServiceImpl implements UserService {
    @Autowired
    private UserDAO userDAO;
    @Autowired
    private RoleDAO roleDAO;
    @Autowired
    private BCryptPasswordEncoder bcrypt;

    @Override
    public void save(User user) {

        user.setPass(bcrypt.encode(user.getPass()));
        user.setRoles(new HashSet<>(roleDAO.findAll()));
        userDAO.save(user);

    }
    @Override
    public User findByUsername(String username) {
        return userDAO.findByUsername(username);
    }
}

My SpringBoot Security configuration:

package com.proba.Userboard.config;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.security.config.annotation.authentication.builders.AuthenticationManagerBuilder;
import org.springframework.security.config.annotation.web.builders.HttpSecurity;
import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;
import org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;
import org.springframework.security.core.userdetails.UserDetailsService;
import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;

@Configuration
@EnableWebSecurity
public class SecurityConf extends WebSecurityConfigurerAdapter {
    @Autowired
    private UserDetailsService userDetailsService;
    @Bean
    public BCryptPasswordEncoder bcyrpt() {
        return new BCryptPasswordEncoder();
    }

    @Override
    protected void configure(HttpSecurity http) throws Exception {
        http
            .authorizeRequests()
                .antMatchers("/resource/**", "/registration").permitAll()
                .anyRequest().authenticated()
            .and()
                .formLogin()
                    .loginPage("/login")
                    .permitAll()
            .and()
                .logout()
                    .permitAll();
    }

    @Autowired
    public void configureGlobal(AuthenticationManagerBuilder auth) throws Exception {
        auth.userDetailsService(userDetailsService).passwordEncoder(bcyrpt());
    }
}

So, when i run mvn clean spring-boot:run, I get previously mentioned error and I cannot figure out what I am doing wrong. Previously I made similiar app, which worked, but I cannot figure out, why this one doesn't.

解决方案

No the problem is not in the connection of the database, hibernate determines its policy to check the configuration annotations base on the annotation place on the id ( on the attribute itself or on a method)

In your User class you are telling hibernate to expect the annotations on the attribute level

public class User {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="user_id")
private int id;

So for hibernate you do not have mapping for other attirbute like roles because it will not check the methods for the mapping, so what you need to do is to take the annotation from the method and put it in the attribute

@ManyToMany
@JoinTable(name="user_role", joinColumns = @JoinColumn(name="user_id"), inverseJoinColumns = @JoinColumn(name="role_id"))
private Set<Role> roles;

You need to do this in all your annotations

这篇关于SpringBoot JPA Hibernate：创建名为'entityManagerFactory'的bean时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
Java开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆