未添加JPA一对一关系

Question

我在数据库中有两个表一对一的关系：

CREATE  TABLE IF NOT EXISTS `toproject`.`osoby` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `imie` VARCHAR(45) NOT NULL ,
  `nazwisko` VARCHAR(45) NOT NULL ,
  `pesel` VARCHAR(11) NOT NULL ,
  `telefon` VARCHAR(45) NULL ,
  `pensja` VARCHAR(45) NULL ,
  `typ` VARCHAR(45) NOT NULL ,
  `stanowisko_id` INT NULL ,
  PRIMARY KEY (`id`) ,
  UNIQUE INDEX `pesel_UNIQUE` (`pesel` ASC) ,
  INDEX `fk_osoby_stanowiska_idx` (`stanowisko_id` ASC) ,
  CONSTRAINT `fk_osoby_stanowiska`
    FOREIGN KEY (`stanowisko_id` )
    REFERENCES `toproject`.`stanowiska` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

CREATE  TABLE IF NOT EXISTS `toproject`.`adresy` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `ulica` VARCHAR(45) NOT NULL ,
  `miejscowosc` VARCHAR(45) NOT NULL ,
  INDEX `fk_adres_osoby1_idx` (`id` ASC) ,
  PRIMARY KEY (`id`) ,
  CONSTRAINT `fk_adres_osoby1`
    FOREIGN KEY (`id` )
    REFERENCES `toproject`.`osoby` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

我必须使用@inherity(strategy=inheritancetype.single_table)来编写Java实体类：

@Entity
@Table(name = "osoby")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
@DiscriminatorColumn(name="typ", discriminatorType=DiscriminatorType.STRING)
public class Osoba implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(name = "id")
    private Integer id;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 45)
    @Column(name = "imie")
    private String imie;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 45)
    @Column(name = "nazwisko")
    private String nazwisko;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 11)
    @Column(name = "pesel")
    private String pesel;

客户端类：

@Entity
@DiscriminatorValue(value = "Klient")
public class Klient extends Osoba {

    @Size(max = 45)
    @Column(name = "telefon")
    private String telefon;
    @OneToMany(cascade = CascadeType.ALL, mappedBy = "osobyId")
    private Collection<Zamowienie> zamowienieCollection;
    @OneToOne(cascade = CascadeType.ALL, mappedBy = "klient")
    private Adres adres;

占有实体：

@Entity
@Table(name = "adresy")
public class Adres implements Serializable {

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Basic(optional = false)
    @Column(name = "id")
    private Integer id;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 45)
    @Column(name = "ulica")
    private String ulica;
    @Basic(optional = false)
    @NotNull
    @Size(min = 1, max = 45)
    @Column(name = "miejscowosc")
    private String miejscowosc;
    @JoinColumn(name = "id", referencedColumnName = "id", insertable = false, updatable = false)
    @OneToOne(optional = false)
    private Klient klient;

我有一个klientMB，它添加了人和地址

@ManagedBean
@RequestScoped
public class KlientMB {

    @EJB
    private KlientDaoLocal klientDao;
    private Klient klient;

    public KlientMB() {
    }

    public Klient getKlient() {
        if (klient == null) {
            klient = new Klient();
            Adres adres = new Adres();
            klient.setAdres(adres);
            adres.setOsoba(klient);
        }
        return klient;
    }

    public void setKlient(Klient klient) {
        this.klient = klient;
    }

    public String createKlient() {
        klientDao.create(klient);
        return "klienci.xhtml?faces-redirect=true";

    }

但是当我尝试添加一个Klient时，我出现了这个错误：

Answer 1

我认为问题在于您使用toproject.adresy表中的id（主键）列作为外键连接到toproject.osoby。您应该引入一个新列（例如osoby_id)作为外键列，以连接到toproject.osoby。当前发生的情况是，ADRES表的id被用来在OSOBY表中查找记录，但没有记录。