级联双向@OneToOne与@MapsId

huangapple
go评论99阅读模式
英文:

Cascade on bidirectional @OneToOne with @MapsId

问题

我使用的是Spring Boot 2.1.1.RELEASE 和 Hibernate 5.3.7.FINAL 版本。

规则是，用户可以没有电话（user 中的 phone 可为空），但是电话不能没有用户（phone 中的 user 不可为空）。

实体类：

  1. @Entity
  2. public class Phone {
  4.    @Id
  5.    private Long id;
  7.    @OneToOne
  8.    @MapsId
  9.    @JoinColumn(name = "id")
  10.    private User user;
  12.    public Long getId() {
  13.        return id;
  14.    }
  15.    public void setId(final Long id) {
  16.        this.id = id;
  17.    }
  19.    public User getUser() {
  20.       return user;
  21.    }
  22.    public void setUser(final User user) {
  23.       this.user = user;
  24.    }
  25. }
  27. @Entity
  28. public class User {
  30.    @Id
  31.    @GeneratedValue(strategy = GenerationType.IDENTITY)
  32.    private Long id;
  34.    @OneToOne(mappedBy = "user", cascade = CascadeType.ALL, orphanRemoval = true)
  35.    private Phone phone;
  37.    public Long getId() {
  38.        return id;
  39.    }
  40.    public void setId(final Long id) {
  41.        this.id = id;
  42.    }
  44.    public Phone getPhone() {
  45.        return phone;
  46.    }
  47.    public void setPhone(final Phone phone) {
  48.        this.phone = phone;
  49.    }
  50. }

控制器：

  1. @RestController
  2. @RequestMapping
  3. public class UserController {
  5.    private final UserService userService;
  7.    public UserController(final UserService userService) {
  8.        this.userService = userService;
  9.    }
  11.    @GetMapping("/demo")
  12.    public void createUserAndAddPhone() {
  13.        final User user = new User();
  14.        userService.save(user);
  15.        final Phone phone = new Phone();
  17.        phone.setUser(user);
  18.        user.setPhone(phone);
  19.        userService.update(user);
  20.    }
  21. }

仓库：

  1. public interface UserRepository extends PagingAndSortingRepository<User, Long> {
  2. }

服务：

  1. @Service
  2. public class UserService {
  4.    private final UserRepository userRepository;
  6.    public UserService(final UserRepository userRepository) {
  7.        this.userRepository = userRepository;
  8.    }
  10.    @Transactional
  11.    public void save(final User user) {
  12.        userRepository.save(user);
  13.    }
  15.    @Transactional
  16.    public void update(final User user) {
  17.        userRepository.save(user);
  18.    }
  19. }

表结构：

  1. CREATE TABLE `phone` (
  2.    `id` bigint(20) NOT NULL,
  3.    PRIMARY KEY (`id`)
  4. );
  6. CREATE TABLE `user` (
  7.    `id` bigint(20) NOT NULL AUTO_INCREMENT,
  8.    PRIMARY KEY (`id`)
  9. )

应用配置 application.yml：

  1. spring:
  2.    datasource:
  3.       url: jdbc:mysql://localhost:3308/demo?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&useLegacyDatetimeCode=false&allowPublicKeyRetrieval=true
  4.       username: root
  5.       password: 123456
  6.       driver-class-name: com.mysql.jdbc.Driver
  7.    jpa:
  8.       database-platform: org.hibernate.dialect.MySQL5Dialect
  9.       hibernate:
  10.          ddl-auto: validate

pom.xml 配置：

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.1.1.RELEASE</version>
  9.         <relativePath/> <!-- lookup parent from repository -->
  10.     </parent>
  12.     <groupId>com.example</groupId>
  13.     <artifactId>demo</artifactId>
  14.     <version>0.0.1-SNAPSHOT</version>
  15.     <name>demo</name>
  16.     <description>Demo project for Spring Boot</description>
  18.     <properties>
  19.         <java.version>1.8</java.version>
  20.     </properties>
  22.     <dependencies>
  23.         <dependency>
  24.             <groupId>org.springframework.boot</groupId>
  25.             <artifactId>spring-boot-starter</artifactId>
  26.         </dependency>
  27.         <dependency>
  28.             <groupId>org.springframework.boot</groupId>
  29.             <artifactId>spring-boot-starter-data-jpa</artifactId>
  30.         </dependency>
  31.         <dependency>
  32.             <groupId>org.springframework.boot</groupId>
  33.             <artifactId>spring-boot-starter-web</artifactId>
  34.         </dependency>
  35.         <dependency>
  36.             <groupId>com.google.code.findbugs</groupId>
  37.             <artifactId>jsr305</artifactId>
  38.             <version>2.0.1</version>
  39.         </dependency>
  40.         <dependency>
  41.             <groupId>mysql</groupId>
  42.             <artifactId>mysql-connector-java</artifactId>
  43.             <version>5.1.46</version>
  44.             <scope>runtime</scope>
  45.         </dependency>
  46.     </dependencies>
  48.     <build>
  49.         <plugins>
  50.             <plugin>
  51.                 <groupId>org.springframework.boot</groupId>
  52.                 <artifactId>spring-boot-maven-plugin</artifactId>
  53.             </plugin>
  54.         </plugins>
  55.     </build>
  56. </project>

调用 GET http://localhost:8080/demo 时出现错误：

org.hibernate.id.IdentifierGenerationException: attempted to assign id
from null one-to-one property [com.example.demo.Phone.user]

当我注释掉 userService.save(user); 时，代码可以正常运行并生成以下 SQL：

  1. insert into `user` 
  2. values ( )
  4. -- Generated identifier: 13, using strategy: org.hibernate.id.ForeignGenerator
  5.                 
  6. insert into `phone` (`id`)  values (?)
  7. -- Binding parameter [1] as [BIGINT] - [13]

但是如果先持久化 user，然后再更新，就会出现问题（引发上述异常）。

英文:

I work on spring boot 2.1.1.RELEASE, hibernate 5.3.7.FINAL

Rules are, that user can have no phone (phone is nullable in user) but, phone can't exist without a user (user is not null in phone).

Entities:

  1. @Entity
  2. public class Phone {
  3.     
  4.    @Id
  5.    private Long id;
  6.     
  7.    @OneToOne
  8.    @MapsId
  9.    @JoinColumn(name = &quot;id&quot;)
  10.    private User user;
  11.     
  12.    public Long getId() {
  13.        return id;
  14.    }
  15.    public void setId(final Long id) {
  16.        this.id = id;
  17.    }
  18.     
  19.    public User getUser() {
  20.       return user;
  21.    }
  22.    public void setUser(final User user) {
  23.       this.user = user;
  24.    }
  25. }
  26.         
  27. @Entity
  28. public class User {
  30.    @Id
  31.    @GeneratedValue(strategy = GenerationType.IDENTITY)
  32.    private Long id;
  33.     
  34.    @OneToOne(mappedBy = &quot;user&quot;, cascade = CascadeType.ALL, orphanRemoval = true)
  35.    private Phone phone;
  36.     
  37.    public Long getId() {
  38.        return id;
  39.    }
  40.    public void setId(final Long id) {
  41.        this.id = id;
  42.    }
  43.     
  44.    public Phone getPhone() {
  45.        return phone;
  46.    }
  47.    public void setPhone(final Phone phone) {
  48.        this.phone = phone;
  49.    }
  50. }

Controller:

  1. @RestController
  2. @RequestMapping
  3. public class UserController {
  4.     
  5.    private final UserService userService;
  6.     
  7.    public UserController(final UserService userService) {
  8.        this.userService = userService;
  9.    }
  10.     
  11.    @GetMapping(&quot;/demo&quot;)
  12.    public void createUserAndAddPhone() {
  13.        final User user = new User();
  14.        userService.save(user);
  15.        final Phone phone = new Phone();
  16.     
  17.        phone.setUser(user);
  18.        user.setPhone(phone);
  19.        userService.update(user);
  20.    }
  21. }

Repository:

  1. public interface UserRepository  extends PagingAndSortingRepository&lt;User, Long&gt; {
  2. }

Serivce:

  1. @Service
  2. public class UserService {
  3.     
  4.    private final UserRepository userRepository;
  5.     
  6.    public UserService(final UserRepository userRepository) {
  7.        this.userRepository = userRepository;
  8.    }
  9.     
  10.    @Transactional
  11.    public void save(final User user) {
  12.        userRepository.save(user);
  13.    }
  14.     
  15.    @Transactional
  16.    public void update(final User user) {
  17.        userRepository.save(user);
  18.    }
  19. }

Tables:

  1. CREATE TABLE `phone` (
  2.    `id` bigint(20) NOT NULL,
  3.    PRIMARY KEY (`id`)
  4. );
  5.     
  6. CREATE TABLE `user` (
  7.    `id` bigint(20) NOT NULL AUTO_INCREMENT,
  8.    PRIMARY KEY (`id`)
  9. )

application yml:

  1. spring:
  2.    datasource:
  3.       url: jdbc:mysql://localhost:3308/demo?characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=UTC&amp;useLegacyDatetimeCode=false&amp;allowPublicKeyRetrieval=true
  4.       username: root
  5.       password: 123456
  6.       driver-class-name: com.mysql.jdbc.Driver
  7.    jpa:
  8.       database-platform: org.hibernate.dialect.MySQL5Dialect
  9.       hibernate:
  10.          ddl-auto: validate

pom xml:

  1. &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
  2.     &lt;project xmlns=&quot;http://maven.apache.org/POM/4.0.0&quot; xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;
  3.     	xsi:schemaLocation=&quot;http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd&quot;&gt;
  4.   	&lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
  5.    	&lt;parent&gt;
  6.    		&lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  7.    		&lt;artifactId&gt;spring-boot-starter-parent&lt;/artifactId&gt;
  8.    		&lt;version&gt;2.1.1.RELEASE&lt;/version&gt;
  9.    		&lt;relativePath/&gt; &lt;!-- lookup parent from repository --&gt;
  10.    	&lt;/parent&gt;
  12.    	&lt;groupId&gt;com.example&lt;/groupId&gt;
  13.    	&lt;artifactId&gt;demo&lt;/artifactId&gt;
  14.    	&lt;version&gt;0.0.1-SNAPSHOT&lt;/version&gt;
  15.    	&lt;name&gt;demo&lt;/name&gt;
  16.    	&lt;description&gt;Demo project for Spring Boot&lt;/description&gt;
  17.     
  18.    	&lt;properties&gt;
  19.    		&lt;java.version&gt;1.8&lt;/java.version&gt;
  20.    	&lt;/properties&gt;
  21.     
  22.    	&lt;dependencies&gt;
  23.    		&lt;dependency&gt;
  24.    			&lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  25.    			&lt;artifactId&gt;spring-boot-starter&lt;/artifactId&gt;
  26.    		&lt;/dependency&gt;
  27.    		&lt;dependency&gt;
  28.    			&lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  29.    			&lt;artifactId&gt;spring-boot-starter-data-jpa&lt;/artifactId&gt;
  30.    		&lt;/dependency&gt;
  31.    		&lt;dependency&gt;
  32.    			&lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  33.    			&lt;artifactId&gt;spring-boot-starter-web&lt;/artifactId&gt;
  34.    		&lt;/dependency&gt;
  35.    		&lt;dependency&gt;
  36.    			&lt;groupId&gt;com.google.code.findbugs&lt;/groupId&gt;
  37.    			&lt;artifactId&gt;jsr305&lt;/artifactId&gt;
  38.    			&lt;version&gt;2.0.1&lt;/version&gt;
  39.    		&lt;/dependency&gt;
  40.    		&lt;dependency&gt;
  41.    			&lt;groupId&gt;mysql&lt;/groupId&gt;
  42.    			&lt;artifactId&gt;mysql-connector-java&lt;/artifactId&gt;
  43.    			&lt;version&gt;5.1.46&lt;/version&gt;
  44.   			&lt;scope&gt;runtime&lt;/scope&gt;
  45.    		&lt;/dependency&gt;
  46.    	&lt;/dependencies&gt;
  47.     
  48.    	&lt;build&gt;
  49.    		&lt;plugins&gt;
  50.    			&lt;plugin&gt;
  51.    				&lt;groupId&gt;org.springframework.boot&lt;/groupId&gt;
  52.    				&lt;artifactId&gt;spring-boot-maven-plugin&lt;/artifactId&gt;
  53.    			&lt;/plugin&gt;
  54.    		&lt;/plugins&gt;
  55.    	&lt;/build&gt;
  56. &lt;/project&gt;

Call GET http://localhost:8080/demo gives me an error:

> org.hibernate.id.IdentifierGenerationException: attempted to assign id
> from null one-to-one property [com.example.demo.Phone.user]

When I comment out userService.save(user);, it works and generates:

  1. insert into `user` 
  2. values ( )
  4. -- Generated identifier: 13, using strategy: org.hibernate.id.ForeignGenerator
  5.                 
  6. insert into `phone` (`id`)  values (?)
  7. -- Binding parameter [1] as [BIGINT] - [13]

but if the user is persisted and then updated, it doesn't work (raises the above exception)

答案1

得分: 2

啊，最终，这是一个 Hibernate 的 bug（HHH-12436）。

通过以下用例，在纯 Hibernate 应用程序中可以重现这个问题：

  1. Session session = sessionFactory.openSession();
  3. Transaction tr1 = session.beginTransaction();
  4. User user = new User();
  5. session.persist(user);
  6. tr1.commit();
  8. Transaction tr2 = session.beginTransaction();
  9. Phone newPhone = new Phone();
  10. user.setPhone(newPhone);
  11. newPhone.setUser(user);
  12. session.merge(user);
  13. tr2.commit();
  15. session.close();

如你可以从上面的链接看到，这个问题在 Hibernate 5.4 分支中已经修复。

附注：我能够在最新的 5.3 版本（5.3.18.Final）中复现这个问题。

英文:

Ah, in the end, this is a hibernate bug (HHH-12436).

It is reproducible in a pure hibernate application by the following use case:

  1. Session session = sessionFactory.openSession();
  3. Transaction tr1 = session.beginTransaction();
  4. User user = new User();
  5. session.persist(user);
  6. tr1.commit();
  8. Transaction tr2 = session.beginTransaction();
  9. Phone newPhone = new Phone();
  10. user.setPhone(newPhone);
  11. newPhone.setUser(user);
  12. session.merge(user);
  13. tr2.commit();
  15. session.close();

As you can see from the above link it is fixed in hibernate 5.4 branch.

P.S. I was able to reproduce the problem in the latest 5.3 version (5.3.18.Final)

huangapple
  • 本文由 发表于 2020年10月8日 23:52:25
  • 转载请务必保留本文链接：https://go.coder-hub.com/64266219.html
  • hibernate
  • java
  • jpa
  • one-to-one
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定