Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table student(
- id bigint primary key auto_increment,
- name varchar(20),
- student_class_id bigint foreign key references student_class(id)
- )
- create table student_class(
- id bigint primary key auto_increment,
- name varchar(20)
- )
- @Table(name = "students")
- @Entity
- public class Student {
- private Integer id;
- private Integer name;
- private StudentClass studentClass;
- @Id
- @Column(name = "id")
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- public Integer getId() {
- return id;
- }
- public void setId(Integer id) {
- this.id = id;
- }
- @Column(name = "name")
- public Integer getName() {
- return name;
- }
- public void setName(Integer name) {
- this.name = name;
- }
- @OneToOne
- @JoinColumn(name = "student_class_id")
- @Cascade(org.hibernate.annotations.CascadeType.SAVE_UPDATE)
- public StudentClass getStudentClass() {
- return studentClass;
- }
- // setter getter
- }
- @Entity
- @Table(name = "student_class")
- public class StudentClass {
- private Integer id;
- private String name;
- private Set<Student> students = new HashSet<Student>();
- @Id
- @Column(name = "id")
- @GeneratedValue(strategy = GenerationType.IDENTITY)
- public Integer getId() {
- return id;
- }
- public void setId(Integer id) {
- this.id = id;
- }
- @Column(name = "name")
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- @Cascade(org.hibernate.annotations.CascadeType.SAVE_UPDATE)
- @OneToMany(mappedBy = "studentClass", cascade = {CascadeType.ALL}, fetch = FetchType.EAGER)
- public Set<Student> getStudents() {
- return students;
- }
- /setter getter
- }
- java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: could not resolve property: student_class_id of: com.f.pojo.Student [select sc.name from com.f.pojo.StudentClass sc left join com.f.pojo.Student s on sc.id = s.student_class_id]
Add Comment
Please, Sign In to add comment