JPA OneToMany Update Delete Error

Question

@Entity
@Table(name = "VACP_POLICY_PKG_TYPE")
@NamedQueries( { @NamedQuery(name = "getVacpPolicyPkgType", query = "SELECT v FROM VacpPolicyPkgType v"),
@NamedQuery(name = "getVacpPolicyPkgTypeByPkgTypeId", query = "SELECT v FROM VacpPolicyPkgType v WHERE v.pkgTypeId = :pkgTypeId"),
@NamedQuery(name = "getVacpPolicyPkgTypeByPkgTypeName", query = "SELECT v FROM VacpPolicyPkgType v WHERE v.pkgTypeName = :pkgTypeName"),
@NamedQuery(name = "getVacpPolicyPkgTypeByAppId", query = "SELECT v FROM VacpPolicyPkgType v WHERE v.appId = :appId") })
public class VacpPolicyPkgType implements Serializable, DataBean {
@Id
@Unique
@Column(name = "PKG_TYPE_ID")
@GeneratedValue(generator = "PKG_TYPE_ID_G", strategy = GenerationType.SEQUENCE)
@SequenceGenerator(name = "PKG_TYPE_ID_G", sequenceName = "SEQ_PKG_TYPE_ID")
private long pkgTypeId;
 
@Column(name = "PKG_TYPE_NAME")
private String pkgTypeName;
 
@Column(name = "APP_ID")
private BigDecimal appId;
 
@Column(name = "UPDATE_DATE")
private Date updateDate;
 
@Column(name = "UPDATE_USER")
private String updateUser;
 
@Column(name = "TYPE_DESC")
private String typeDesc;
 
private static final long serialVersionUID = 1L;
 
@OneToMany(cascade=CascadeType.ALL, fetch = FetchType.EAGER, mappedBy = "policyPkgType")
private List<VacpPkgTypeSerRef> vacppkgtypeserrefList;
 
public VacpPolicyPkgType() {
super();
}
 
public long getPkgTypeId() {
return this.pkgTypeId;
}
 
public void setPkgTypeId(long pkgTypeId) {
this.pkgTypeId = pkgTypeId;
}
 
public String getPkgTypeName() {
return this.pkgTypeName;
}
 
public void setPkgTypeName(String pkgTypeName) {
this.pkgTypeName = pkgTypeName;
}
 
public BigDecimal getAppId() {
return this.appId;
}
 
public void setAppId(BigDecimal appId) {
this.appId = appId;
}
 
public Date getUpdateDate() {
return this.updateDate;
}
 
public void setUpdateDate(Date updateDate) {
this.updateDate = updateDate;
}
 
public String getUpdateUser() {
return this.updateUser;
}
 
public void setUpdateUser(String updateUser) {
this.updateUser = updateUser;
}
 
public String getTypeDesc() {
return this.typeDesc;
}
 
public void setTypeDesc(String typeDesc) {
this.typeDesc = typeDesc;
}
 
/**
 * @param vacppkgtypeserrefList
 *            要设置的 vacppkgtypeserrefList
 */
public void setVacppkgtypeserrefList(List<VacpPkgTypeSerRef> vacppkgtypeserrefList) {
this.vacppkgtypeserrefList = vacppkgtypeserrefList;
}
 
/**
 * @return vacppkgtypeserrefList
 */
public List<VacpPkgTypeSerRef> getVacppkgtypeserrefList() {
return vacppkgtypeserrefList;
}
 
}
 
package com.icbc.vacp.policy.pkg;
 
import java.io.Serializable;
 
import javax.persistence.CascadeType;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
 
@Entity
@Table(name = "VACP_PKG_TYPE_SER_REF")
public class VacpPkgTypeSerRef implements Serializable {
@EmbeddedId
private VacpPkgTypeSerRefPK pk;
 
@ManyToOne(cascade = { CascadeType.MERGE, CascadeType.REFRESH })
@JoinColumn(name = "PKG_TYPE_ID", referencedColumnName = "PKG_TYPE_ID")
private VacpPolicyPkgType policyPkgType;
 
private static final long serialVersionUID = 1L;
 
public VacpPkgTypeSerRef() {
super();
}
 
public VacpPkgTypeSerRefPK getPk() {
return this.pk;
}
 
public void setPk(VacpPkgTypeSerRefPK pk) {
this.pk = pk;
}
 
/**
 * @param policyPkgType
 *            要设置的 policyPkgType
 */
public void setPolicyPkgType(VacpPolicyPkgType policyPkgType) {
this.policyPkgType = policyPkgType;
}
 
/**
 * @return policyPkgType
 */
public VacpPolicyPkgType getPolicyPkgType() {
return policyPkgType;
}
}

Answer 1

Error When Update VacpPolicyPkgType。vacppkgtypeserrefList10-7-16 10:55:40:035 CST 00000031 FfdcProvider I com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on D:\Program Files\IBM\SDP\runtimes\base_v7\profiles\was70profile1\logs\ffdc\server1_51fc51fc_10.07.16_10.55.40.0047670.txt com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate 449
10-7-16 10:55:40:082 CST 00000031 SystemErr R <openjpa-1.2.1-SNAPSHOT-r422266:686069 fatal store error> org.apache.openjpa.persistence.RollbackException: 事务已回滚。请参阅嵌套异常，以了解有关发生的错误的详细信息。
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:523)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.icbc.vacp.policy.pkg.controller.VacpPolicyPkgTypeManager.updateVacpPolicyPkgType(VacpPolicyPkgTypeManager.java:105)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at java.lang.reflect.Method.invoke(Method.java:599)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:740)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:744)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:593)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.directwebremoting.dwrp.BaseCallHandler.handle(BaseCallHandler.java:90)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:120)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:141)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1449)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1384)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.icbc.vacp.ctp.CtpSessionCheck.doFilter(CtpSessionCheck.java:54)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:852)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:785)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:443)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3610)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:274)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:926)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1557)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:173)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:202)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:766)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:896)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1527)
10-7-16 10:55:40:082 CST 00000031 SystemErr R Caused by: <openjpa-1.2.1-SNAPSHOT-r422266:686069 fatal general error> org.apache.openjpa.persistence.PersistenceException: 事务已回滚。请参阅嵌套异常，以了解有关发生的错误的详细信息。

Answer 2

10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2163)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2010)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1908)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1826)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1350)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:877)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:512)
10-7-16 10:55:40:082 CST 00000031 SystemErr R ... 40 more
10-7-16 10:55:40:082 CST 00000031 SystemErr R Caused by: <openjpa-1.2.1-SNAPSHOT-r422266:686069 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-00001: 违反唯一约束条件 (VACP.PK_VACP_POLICY_PKG_SER_REF)
{prepstmnt 871904248 INSERT INTO VACP.VACP_PKG_TYPE_SER_REF (PKG_TYPE_ID, SERVER_IP) VALUES (?, ?) http://params=(long) 65, (String) 122.3.4.9} code=1, state=23000
FailedObject: com.icbc.vacp.policy.pkg.VacpPkgTypeSerRef@19e919e9
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4231)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4196)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.batchOrExecuteRow(BatchingPreparedStatementManagerImpl.java:102)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:86)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.persistence.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:78)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at com.ibm.ws.persistence.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:60)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:655)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
10-7-16 10:55:40:082 CST 00000031 SystemErr R ... 47 more
10-7-16 10:55:40:082 CST 00000031 SystemErr R Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00001: 违反唯一约束条件 (VACP.PK_VACP_POLICY_PKG_SER_REF)
{prepstmnt 871904248 INSERT INTO VACP.VACP_PKG_TYPE_SER_REF (PKG_TYPE_ID, SERVER_IP) VALUES (?, ?) http://params=(long) 65, (String) 122.3.4.9} code=1, state=23000
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:866)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1504)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:151)
10-7-16 10:55:40:082 CST 00000031 SystemErr R at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:120)
10-7-16 10:55:40:082 CST 00000031 SystemErr R ... 58 more