我试图使用hibernate和postgresql将一个集合映射到数据库中。

目标： 手动为集合创建数据库表，而不使用hbm2ddl.auto配置。

数据库表

  CREATE TABLE patients(
    patient_id BIGSERIAL NOT NULL,
    first_name VARCHAR(255) NOT NULL,
    last_name VARCHAR(255) NOT NULL,
    PRIMARY KEY(patient_id));
    CREATE TABLE address (
    patient_id BIGINT NOT NULL,
    city VARCHAR(255),
    province VARCHAR(255),
    PRIMARY KEY(patient_id),
    CONSTRAINT testcollection FOREIGN KEY(patient_id) REFERENCES patients(patient_id));

Java代码病人类

@Entity
@Table(name = "patients")
public class Patient {
    @GenericGenerator(name = "primaryIncrement", strategy = "increment")
    @GeneratedValue(generator = "primaryIncrement")
    @Column(name = "patient_id")
    private long patientID;
    @Column(name = "first_name")
    private String firstName;
    @Column(name = "last_name")
    private String lastName;
    @ElementCollection
    @JoinTable(name="address", joinColumns=@JoinColumn(name = "patient_id"))
    private Collection<Address> listOfAddresses = new ArrayList<Address>();

(getter and setter略去)

地址类

@Embeddable
public class Address {
    @Column(name = "city")
    private String city;
    @Column(name = "province")
    private String province;

HibernateServletTest类

Configuration config = new Configuration();
        config.configure("hibernate.cfg.xml");
        SessionFactory sessionFactory = config.buildSessionFactory();
        Session session = sessionFactory.openSession();
        Transaction transaction = session.getTransaction();
        transaction.begin();
        Patient patient = new Patient();
        Address address = new Address();
        Address homeAddress = new Address();
        patient.setFirstName("Ron");
        patient.setLastName("Weasly");
        address.setCity("Diagon Alley");
        address.setProvince("london");
        homeAddress.setCity("Abbey Road");
        homeAddress.setProvince("Chelsea");
        patient.getListOfAddresses().add(address);
        patient.getListOfAddresses().add(homeAddress);
        session.save(patient);
        transaction.commit();
        session.close();
        System.out.println("Successfully Saved!");

在运行代码时，我遇到了一个异常

org.postgresql.util.PSQLException: ERROR:重复键值违反了唯一约束"address_pkey“的详细信息: key (patient_id)=(0)已经存在。

基于堆栈跟踪，地址数据库表使用已经存在的patient_id。

我的问题是，如何将病人的表主键映射到地址表中的外键？我相信我的错误是在我的数据库语法，但我不知道哪一部分是错误的。