具有此实体类:
@Entity
@Table(name="t_period")
public class Period {
@Id
@GeneratedValue(strategy = SEQUENCE, generator = "periodSeq")
@Column(name = "PERIOD_ID", unique = true, nullable = true)
@SequenceGenerator(name = "periodSeq", sequenceName = "seq_period", allocationSize=1)
private Long periodId;
@OneToOne(fetch = FetchType.EAGER, cascade=CascadeType.ALL)
@JoinColumn(name = "CLASS_GROUP_ID", referencedColumnName = "ID")
ClassGroup classGroup;
@Column(name="PERIOD1")
Integer period1;
@Column(name="PERIOD2")
Integer period2;
...
}
和..
/**
* ProductGroup generated by Tomasz Borowiec
*/
@SuppressWarnings("serial")
@Entity
@Table(name = "T_CLASS_GROUP", uniqueConstraints = @UniqueConstraint(columnNames = "KEY"))
@SequenceGenerator(name = "seqCLASS_GROUP", sequenceName = "SEQ_CLASS_GROUP")
public class ClassGroup implements java.io.Serializable {
private Long id;
private String key;
@Id
@Column(name = "ID", unique = true, nullable = false, precision = 38, scale = 0)
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seqCLASS_GROUP")
public Long getId() {
return this.id;
}
...
}
the DAO
public class PeriodDaoImpl extends JpaDaoSupport implements PeriodDao {
...
@Override
public Period saveOrUpdate(Period period) throws Exception {
if (period.getPeriodId() == null &&
find(period.getClassGroup()) == null) {
getEntityManager().persist(period);
} else {
period = getEntityManager().merge(period);
}
return period;
}
...
}
在Junit中使用以下代码来测试DAO:
ClassGroup classGroup = classGroupDao.findById(1);
Period period = new Period();
period.setClassGroup(classGroup)
period.setPeriod1(1);
period = periodDao.saveOrUpdate(period);
period.setPeriod1(2);
period = periodDao.saveOrUpdate(period);
我在第二次更新中收到此错误,执行合并,但未持久
在数据库级别中,我为对象classGroup设置了唯一的键:
CREATE TABLE t_period
(
period_id number(38) not null,
class_group_id number(38) not null,
period1 number,
period2 number,
CONSTRAINT pk_period PRIMARY KEY (period_id),
CONSTRAINT fk_class_group FOREIGN KEY (class_group_id) REFERENCES t_class_group(id),
CONSTRAINT uk_class_group UNIQUE (class_group_id)
);
ORA-00001:唯一约束(ENV_ECAT.UK_CLASS_GROUP)被违反
使用此代码,persist
永远不会执行,因为find(period.getClassGroup())
永远不会返回null。这意味着merge()
被调用了两次,但是它并没有给您ID,所以我认为这就是为什么它试图将同一对象插入两次的原因。
因此,尝试find(...)
从if
语句中删除以查看其是否有效。
if (period.getPeriodId() == null) {
getEntityManager().persist(period);
}
如果确实有效,则必须提出其他条件才能将调用转移到merge()
和persist()
。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句