原因:com.sybase.jdbc2.jdbc.sybsqlexception:表检查中的列detail_id不允许空值

Question

package com.hibernate.mapping;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="exam_detail")
public class ExamDetail {

    private int id;
    private String fullName;
    private int numberOfQuestions;
    private int passingPercentage;

    @Id
    @GeneratedValue
    @Column(name="id")
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getFullName() {
        return fullName;
    }
    public void setFullName(String fullName) {
        this.fullName = fullName;
    }
    public int getNumberOfQuestions() {
        return numberOfQuestions;
    }
    public void setNumberOfQuestions(int numberOfQuestions) {
        this.numberOfQuestions = numberOfQuestions;
    }
    public int getPassingPercentage() {
        return passingPercentage;
    }
    public void setPassingPercentage(int passingPercentage) {
        this.passingPercentage = passingPercentage;
    }
}

package com.hibernate.mapping;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;
import javax.persistence.Table;

@Entity
@Table(name="exam")
public class Exam {

    private int id;
    private String shortName;
    private ExamDetail detail;

    @Id
    @GeneratedValue
    @Column(name="id")
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getShortName() {
        return shortName;
    }
    public void setShortName(String shortName) {
        this.shortName = shortName;
    }

    @OneToOne(cascade=CascadeType.PERSIST)
    @JoinColumn(name="detail_id")
    public ExamDetail getDetail() {
        return detail;
    }
    public void setDetail(ExamDetail detail) {
        this.detail = detail;
    }
}

package com.hibernate.mapping;

import org.hibernate.Session;

import com.hibernate.util.HibernateUtil;

public class TestMapping {

    public static void main(String[] args) {
        Session session = HibernateUtil.beginTransaction();

        Exam exam = new Exam();
        exam.setShortName("SCJA");

        ExamDetail detail = new ExamDetail();
        detail.setFullName("Sun Certified Associate");
        detail.setNumberOfQuestions(50);
        detail.setPassingPercentage(60);

        exam.setDetail(detail);

        session.save(exam);
        HibernateUtil.commitTransaction();
    }
}

在com.sybase.jdbc2.tds.tds.processeed(tds.java:2535)在com.sybase.jdbc2.tds.tds.tds.nextresult(tds.java:1916)在com.sybase.jdbc2.jdbc.sybstatement.nextresult(resultgetter.java:69)在com.sybase.jdbc2.jdbc.sybstatement.nextresult(sybstatement.java:201)在com.sybase.jdbc2.jdbc.sybstatement.nextresult(sybstatement.java:182)在96）com.sybase.jdbc2.jdbc.sybstatement.execute(sybstatement.java:1588)com.sybase.jdbc2.jdbc.sybpreparedstatement.execute(sybpreparedstatement.java:580)org.hibernate.id.identitygenerator$insertselectdelegate.executeandextract(identitygenerator.java:138)org.hibernate.id.insert.abstractreturningdelegate.performinsert(abstractreturningdelegate.java:57)..22其他

我做错了什么？

有没有漏掉的口供？

Answer 1

您需要在JPA中引用ID生成。

此处：引用

JPA示例