当我试图在soapUI中使用POST方法插入一个值时,我得到了这个错误。当我编写插入查询时,值被插入到数据库中,但是POST方法在soapUI中不起作用。
列“EMPLOYEE_ID”不允许为NULL;SQL语句:
我在这里有两个实体类
Employee.java:
@Entity
@Table(name="EMPLOYEE")
public class Employee{
@Id
@GeneratedValue(strategy=Generation.IDENTITY)
@Column(name="EMPLOYEE_ID", updatable= false, nullable= false)
private long employeeId;
@Column(name="NAME")
private String name;
@Column(name="EMAIL_ID")
private String email;
@OneToMany(cascade=cascadeType.ALL , fetch = FetchType.LAZY, mappedBy = "employee")
private List<Address> address = new ArrayList<Address>();
//Getters and SettersAddress.java:
@Entity
@Table(name="ADDRESS")
public class Address{
@Id
@GeneratedValue(strategy=Generation.IDENTITY)
@Column(name="ADDRESS_ID")
private long addressId;
@Column(name="ADDRESS_LINE_1")
private String addressLine1;
@Column(name="CITY")
private String city;
@Column(name="STATE")
private String state;
@Column(name="COUNTRY")
private String country;
@Column(name="PINCODE")
private int pincode;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name="EMPLOYEE_ID", nullable = false)
private Employee employee;
//Getters and Setters我尝试通过soapUI post方法发布下面的值。
{
"name": "Ron",
"email": "ron@gmail.com",
"address": [
{
"addressLine1": "No 21",
"city": "Chennai",
"state": "Tamil Nadu",
"country": "India",
"pincode": 187
},
{
"addressLine1": "No 90",
"city": "Banglore",
"state": "Karnataka",
"country": "India",
"pincode": 187
}
]
}当我尝试插入上面的内容时,我得到的错误是"EMPLOYEE_ID";SQL语句不允许使用NULL。
发布于 2021-03-27 01:49:33
您需要从Address实体中删除可为空的部分,然后它才能工作。
使用这个。
Address.java
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name="EMPLOYEE_ID")
private Employee employee; https://stackoverflow.com/questions/66821074
复制相似问题