首先抱歉。我知道有很多相同的话题,但可能是我的英语不好,或者是我没有找到正确的答案。
我使用乐观锁定@Version注释。我需要一个来自一个表的一行有许多来自不同表的行我这样插入:
所以它应该是这样的
Institution(这是我的表(Institution)中的一行)
- CreationDate A (this is row from different table(CreationDate) bind with Institution with JoinTable, ManyToMany) - CreationDate B (this is row from different table(CreationDate) bind with Institution with JoinTable, ManyToMany) - CreationDate C (this is row from different table(CreationDate) bind with Institution with JoinTable, ManyToMany)
所以,为了把这个CreationDate放在不同的变体中,我决定手动为我想添加我的CreationDate的特定机构添加id。
我的主方法类:
CreationDate crdate = new CreationDate();
Institution inst= new Institution();
Set<Institution> instituset = new HashSet<Institution>();
***inst.setInstitutionId(2);***
inst.setNameOfInstitution("MyInstitution");
inst.setTypeName("Education");
instituset.add(inst);
当我想要附加到我的机构的另一行数据后,首先插入我的版本行数据库更改为一个。
这里是我的机构实体:
@Entity
@Table(name="INSTITUTION")
public class Institution implements Serializable{
private static final long serialVersionUID = -7636394097858726922L;
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="INSTITUTION_ID")
private int institutionId;
@Version
@Column(name="VERSION")
private int version;
@Column(name="NAME_INSTITUTION")
private String nameOfInstitution;
@Column(name="TYPE_NAME")
private String typeName;
@ManyToMany(mappedBy="institution", fetch = FetchType.LAZY)
@Cascade(org.hibernate.annotations.CascadeType.ALL)
private Set<CreationDate> creationDate = new HashSet<CreationDate>();
//getter and setter methods ommited
public String toString() {
return institutionId + " , " + nameOfInstitution + " , " + typeName
}
}
和createdate实体:
@Entity
@Table(name="CREATION_DATE")
public class CreationDate implements Serializable {
private static final long serialVersionUID = 1648102358397071136L;
@Id
@GeneratedValue(strategy=IDENTITY)
@Column(name="DATE_ID")
private int dateId;
@Column(name="PARTICULAR_DATE")
private Date particularDate;
@Version
@Column(name="VERSION")
private int version;
@Temporal(TemporalType.DATE)
@Column(name="CHILD_GO_SCHOOL_DATE")
private Date childGoSchoolDate;
@Temporal(TemporalType.DATE)
@Column(name="CHILD_ADMISSION_DATE")
private Date childAdmissionDate;
@ManyToMany(fetch = FetchType.LAZY)
@Cascade(org.hibernate.annotations.CascadeType.ALL)
@JoinTable(name="CREATIONDATE_INSTITUTION",
joinColumns=@JoinColumn(name="DATE_ID"),
inverseJoinColumns=@JoinColumn(name="INSTITUTION_ID"))
private Set<Institution> institution = new HashSet<Institution>();
@OneToMany(fetch=FetchType.EAGER, orphanRemoval=true)
@Cascade(org.hibernate.annotations.CascadeType.ALL)
@JoinTable(name="SRC_DATE", joinColumns=@JoinColumn(name="DATE_ID"),
inverseJoinColumns=@JoinColumn(name="SRC_ID"))
private List<ScheduleRotationChild> scheduleRotationChild = new ArrayList<ScheduleRotationChild>();
//getter and setter methods ommited
public String toString() {
return dateId + " , "
+ particularDate + " , "
+ childGoSchoolDate + " , "
+ childAdmissionDate + " " + scheduleRotationChild ;
}
}
我的道:
public CreationDate insertData(CreationDate creationdate) {
sessionFactory.getCurrentSession().saveOrUpdate(creationdate);
log.info(creationdate.getDateId());
return creationdate;
}
因此,当我第二次尝试将数据插入到我的Institution时,就会出现异常。
Hibernate: insert into CREATION_DATE (CHILD_ADMISSION_DATE,
CHILD_GO_SCHOOL_DATE, PARTICULAR_DATE, VERSION) values (?, ?, ?, ?)
Hibernate: insert into SCHEDULE_ROTATION_CHILD (CHILD_ADMITTED,
CHILD_GO_SCHOOL, CHILD_UNDER_3_YEARSOLD, CHILD_UPPER_3_YEARSOLD,
DAY_SCHEDULE, NUMBER_OF_CHILD, ROTATION, VERSION, WORK_SCHEDULE)
values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: update INSTITUTION set
NAME_INSTITUTION=?, TYPE_NAME=?, VERSION=? where INSTITUTION_ID=? and
VERSION=? Exception in thread "main"
org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException:
Object of class [edu.demidov.dom.Institution] with identifier [2]:
optimistic locking failed; nested exception is
org.hibernate.StaleObjectStateException: Row was updated or deleted by
another transaction (or unsaved-value mapping was incorrect):
[edu.demidov.dom.Institution#2]
我遇到了同样的问题,这是春天和冬眠的结合。在头疼了3-4个小时后,我只是随机检查了一下我的专栏。由于我使用的是一个旧表,我最近引入了版本列,并且没有默认为零-所以它为所有行和我试图删除的行添加了null
。所以就像我猜的那样,我输入了0,它在下一次运行中神奇地工作了。
如果我理解正确,您正在尝试将ID为2的现有Institution添加到新的creatationdate。由于该机构已经存在,您不应该创建一个新的机构。您应该简单地从Hibernate会话中获取:
Institution institution = (Institution) session.load(Institution.class, 2);
creationDate.addInstitution(institution);
检查将要更新的模型对象。基本上你应该检查你的"非空"值;比如已经定义的和主键等。
对我来说,问题是我总是使用相关JpaRepository
的save
方法而不首先获取现有实体。因此,第一次保存总是很顺利,但当我更新实体时,抛出了异常。我检查了数据库中的version
列,发现版本永远不会超过1。确保在更新实体之前总是尝试获取它!