使用@OneToMany进行级联保存时，出现Many端没法保存One端的ID而出现报错?报错

表

create table student
(
    id bigint auto_increment primary key,
    name varchar(30) default '' not null,
    age int default '0' not null,
    school_id bigint default '0' not null
)
comment '学生';

create table school
(
    id bigint auto_increment primary key,
    name varchar(30) default '' not null
) comment '学校';

实体类：

@Data
@Entity
@Accessors(chain = true)
public class School {


    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    protected Long id;
    private String name;

    @OneToMany(cascade = CascadeType.PERSIST, mappedBy = "school")
    private List<Student> students = new ArrayList<>();

    public School addStudent(Student student) {
        students.add(student);
        return this;
    }
}

@Data
@Entity
@Accessors(chain = true)
public class Student {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    private Integer age;

    @ManyToOne(cascade = CascadeType.ALL)
    @JoinColumn(name = "school_id")
    private School school;
}

具体操作：

School school = new School();
school.setName("学校");
Student student1 = new Student();
student1.setName("张三").setAge(18);
Student student2 = new Student();
student2.setName("李四").setAge(19);

school.addStudent(student1).addStudent(student2);
schoolRepository.save(school);

通过以上的操作，由于student表里的school_id设置了not null ，执行以上操作时报错Column 'school_id' cannot be null;

还尝试了在数据库里student里设置了school_id字段为外键，结果还是不行；

请问有遇到过这种问题的么？