一对多单向关联插入查询获取失败

Question

我拥有具有one-to-many单向关系的User和Address实体。当我尝试插入具有Address详细信息的User时，它失败了，出现异常"strong>"；参考完整性约束违反"，当我检查Address没有插入userId时，它有0我不明白这是怎么回事。

我的用户实体：

@Entity 
@Table(name = "users")
public class User{

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "ID")
private long id;

@OneToMany(orphanRemoval = true,cascade = CascadeType.ALL, fetch=FetchType.EAGER)
@JoinColumn(name = "USER_ID", referencedColumnName = "ID")
private List<Address> address;
// other table columns

}

我的地址实体：

@Entity
@Table(name = "address")
public class Address{

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "ID")
private long id;

@Column(name = "USER_ID")
private long userId;
//other table columns
}

我的控制器：

@PostMapping("/")
public ResponseEntity<UserDTO> saveUser(@RequestBody UserRequestDTO userRequestDTO){
try {
if (userRequestDTO != null) {
return new ResponseEntity<>(userService.saveUser(userRequestDTO), HttpStatus.CREATED);
}
} catch (Exception ex) {
return new ResponseEntity<>(HttpStatus.INTERNAL_SERVER_ERROR);
}
return null;
}

我的服务层：

@Override
public UserDTO saveUser(UserRequestDTO userDto) {
User obj = modelMapper.map(userDto, User.class);
System.out.println(obj.toString());
obj = userRepository.save(obj);
return modelMapper.map(obj, UserDTO.class);
}

这是我的UserRequestDTO在这个我有所有属性

public class UserRequestDTO {

private long id;
private long clientId;
private String clientName;
private String email;
private String firstName;
private String lastName;
private String employeeNo;
private String designation; 
private String status;
private String phoneNumber;
private String employeeType;
private String reportingTo;
private String department;
private String division;
private String password;
private String gender;  
private String bloodGroup;
private String maritalStatus;
private String spouseName;
private String noOfChildren;
private Date dateOfBirth;
private Date hiredDate;
private LocalDate createdDate;
private String createdBy;
private LocalDate updatedDate;
private String updatedBy;
private List<Address> address;
}

查看了许多在线教程，但无法找到根本原因来自控制台的错误消息：

User(id=0, clientId=1, email=[e-mail], firstName=user 10, lastName=K, password=password@123, employeeNo=EH5213, phoneNumber=9999999990, status=A, designation=Developer, employeeType=FullTime, reportingTo=Roshan, department=Information Technology, division=division, locationId=null, gender=null, bloodGroup=null, maritalStatus=null, spouseName=null, noOfChildren=null, dateOfBirth=null, hiredDate=null, createdDate=2022-03-25, createdBy=admin, updatedDate=2022-03-25, updatedBy=admin, organization=null, address=[Address(id=0, clientId=1, userId=0, address1=add1Sample, address2=add2Sample, state=sample, addressType=P, country=sample, city=sample, zipCode=000002, primaryPhone=1111111111, secondaryPhone=2222222222, active=true, createdDate=2022-03-25, createdBy=admin, updatedDate=2022-03-25, updatedBy=admin), Address(id=0, clientId=1, userId=0, address1=sample2, address2=add2sample2 , state=sample2, addressType=T, country=sample2, city=sample2, zipCode=000008, primaryPhone=4444444444, secondaryPhone=666666666, active=true, createdDate=2022-03-25, createdBy=admin, updatedDate=2022-03-25, updatedBy=admin)], employeeGroups=null)
Hibernate: insert into users (id, blood_group, client_id, created_by, created_date, date_of_birth, department, designation, division, email, employee_no, employee_type, first_name, gender, hired_date, last_name, location_id, marital_status, no_of_children, organization_id, password, phone_number, reporting_to, spouse_name, status, updated_by, updated_date) values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into address (id, active, address_line_1, address_line_2, address_type, city, client_id, country, created_by, created_date, primary_phone, secondary_phone, state, updated_by, updated_date, user_id, zip_code) values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[2m2022-03-30 12:41:25.689[0;39m [33m WARN[0;39m [35m13308[0;39m [2m---[0;39m [2m[nio-8085-exec-2][0;39m [36mo.h.engine.jdbc.spi.SqlExceptionHelper  [0;39m [2m:[0;39m SQL Error: 23506, SQLState: 23506
[2m2022-03-30 12:41:25.702[0;39m [31mERROR[0;39m [35m13308[0;39m [2m---[0;39m [2m[nio-8085-exec-2][0;39m [36mo.h.engine.jdbc.spi.SqlExceptionHelper  [0;39m [2m:[0;39m Referential integrity constraint violation: "FK6I66IJB8TWGCQTETL8EEEED6V: PUBLIC.ADDRESS FOREIGN KEY(USER_ID) REFERENCES PUBLIC.USERS(ID) (0)"; SQL statement:
insert into address (id, active, address_line_1, address_line_2, address_type, city, client_id, country, created_by, created_date, primary_phone, secondary_phone, state, updated_by, updated_date, user_id, zip_code) values (default, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23506-200]

Answer 1

这可以通过实体级别的一些小更改来修复：
更改1:在用户实体中添加nullable=false，如下所示：

@Entity 
@Table(name = "users")`
public class User{`

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "ID")
private long id;

@OneToMany(orphanRemoval = true,cascade = CascadeType.ALL, fetch=FetchType.EAGER)
@JoinColumn(name = "USER_ID", referencedColumnName = "ID", nullable = false)
private List<Address> address;
// other table columns
}

变更-2：在地址实体中添加insertable=false和updateable=false，类似于

@Entity
@Table(name = "address")
public class Address{

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "ID")
private long id;
@Column(name = "USER_ID", insertable = false, updatable = false)
private long userId;
//other table columns
}

使用nullable=false：它将非null约束应用于特定的数据库列

要了解insertable=false、updatable=false的用法，请参阅此：请参考JPA@Column annotation 解释insertable=false和updatable=false

Answer 2

您必须先插入User，然后插入Address意味着您必须在插入Address之前获得User的引用。但在Unidirectional Mapping中，您不需要放置插入Address的代码，因为它会自动从User获得引用。此处不需要DTO。

从Address.java中删除此列，因为手动插入外键是错误的做法：

@Column(name = "USER_ID", insertable = false, updatable = false)
private long userId;

下面是修改后的代码：

控制器

@RequestMapping(value = "/")
@ResponseBody
public ResponseEntity<User> addUser(@RequestBody User user)
{
userRepository.save(user);
return new ResponseEntity<>(user, HttpStatus.CREATED);
}

你不想在这里制作DTO。。。