Hello everyone:
I’m not famiIiar with Hibernate,i encountered one issue as below.
I have three entities and the same name tables:OrderDetail(Primay key:orderid),OrderItem(Primay key:orderitemid ),OrderItemRef(Primay key:itemrefid).
OrderItem reference OrderDetail by orderid column,OrderItemRef reference OrderItem by orderitemid column.
Below is the source code and hibernate mapping files.
package com.dgys.app.model;
import java.util.List;
public class OrderDetail {
private int orderId;
private String poNumber;
private String orderDate;
private String resalePermit;
private String shipVia;
private String terms;
private List<OrderItem> orderItems;
public int getOrderId() {
return orderId;
}
public void setOrderId(int orderId) {
this.orderId = orderId;
}
public String getPoNumber() {
return poNumber;
}
public void setPoNumber(String poNumber) {
this.poNumber = poNumber;
}
public String getOrderDate() {
return orderDate;
}
public void setOrderDate(String orderDate) {
this.orderDate = orderDate;
}
public String getResalePermit() {
return resalePermit;
}
public void setResalePermit(String resalePermit) {
this.resalePermit = resalePermit;
}
public String getShipVia() {
return shipVia;
}
public void setShipVia(String shipVia) {
this.shipVia = shipVia;
}
public String getTerms() {
return terms;
}
public void setTerms(String terms) {
this.terms = terms;
}
public List<OrderItem> getOrderItems() {
return orderItems;
}
public void setOrderItems(List<OrderItem> items) {
this.orderItems = items;
}
}
package com.dgys.app.model;
import java.util.List;
public class OrderItem {
private int orderItemId;
private OrderDetail orderDetail;
private String lineNum;
private String itemNumber;
private String dateRequired;
private String unit;
private String odrQty;
private String unitCost;
private String amount;
private List<OrderItemRef> itemRefs;
public int getOrderItemId() {
return orderItemId;
}
public void setOrderItemId(int orderItemId) {
this.orderItemId = orderItemId;
}
public OrderDetail getOrderDetail() {
return orderDetail;
}
public void setOrderDetail(OrderDetail orderDetail) {
this.orderDetail = orderDetail;
}
public String getLineNum() {
return lineNum;
}
public void setLineNum(String lineNum) {
this.lineNum = lineNum;
}
public String getItemNumber() {
return itemNumber;
}
public void setItemNumber(String itemNumber) {
this.itemNumber = itemNumber;
}
public String getDateRequired() {
return dateRequired;
}
public void setDateRequired(String dateRequired) {
this.dateRequired = dateRequired;
}
public String getUnit() {
return unit;
}
public void setUnit(String unit) {
this.unit = unit;
}
public String getOdrQty() {
return odrQty;
}
public void setOdrQty(String odrQty) {
this.odrQty = odrQty;
}
public String getUnitCost() {
return unitCost;
}
public void setUnitCost(String unitCost) {
this.unitCost = unitCost;
}
public String getAmount() {
return amount;
}
public void setAmount(String amount) {
this.amount = amount;
}
public List<OrderItemRef> getItemRefs() {
return itemRefs;
}
public void setItemRefs(List<OrderItemRef> itemRefs) {
this.itemRefs = itemRefs;
}
}
package com.dgys.app.model;
public class OrderItemRef {
private int itemRefId;
private OrderItem orderItem;
private String refValue;
public int getItemRefId() {
return itemRefId;
}
public void setItemRefId(int itemRefId) {
this.itemRefId = itemRefId;
}
public OrderItem getOrderItem() {
return orderItem;
}
public void setOrderItem(OrderItem orderItem) {
this.orderItem = orderItem;
}
public String getRefValue() {
return refValue;
}
public void setRefValue(String refValue) {
this.refValue = refValue;
}
}
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2019-5-29 15:39:24 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="com.dgys.app.model.OrderDetail" table="ORDERDETAIL">
<id name="orderId" type="int">
<column name="ORDERID" />
<generator class="increment" />
</id>
<property generated="never" lazy="false" name="poNumber"
type="java.lang.String">
<column name="PONUMBER" />
</property>
<property generated="never" lazy="false" name="orderDate"
type="java.lang.String">
<column name="ORDERDATE" />
</property>
<property generated="never" lazy="false" name="resalePermit"
type="java.lang.String">
<column name="RESALEPERMIT" />
</property>
<property generated="never" lazy="false" name="shipVia"
type="java.lang.String">
<column name="SHIPVIA" />
</property>
<property generated="never" lazy="false" name="terms"
type="java.lang.String">
<column name="TERMS" />
</property>
<list cascade="save-update" fetch="select" inverse="true" lazy="true"
name="orderItems" table="ORDERITEM">
<key>
<column name="ORDERID" not-null="true" />
</key>
<list-index base="0">
<column name="orderitemid" />
</list-index>
<one-to-many class="com.dgys.app.model.OrderItem" />
</list>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2019-5-29 15:39:24 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="com.dgys.app.model.OrderItem" table="ORDERITEM">
<id name="orderItemId" type="int">
<column name="ORDERITEMID" />
<generator class="increment" />
</id>
<many-to-one class="com.dgys.app.model.OrderDetail" name="orderDetail">
<column name="orderid" />
</many-to-one>
<property generated="never" lazy="false" name="lineNum"
type="java.lang.String">
<column name="LINENUM" />
</property>
<property generated="never" lazy="false" name="itemNumber"
type="java.lang.String">
<column name="ITEMNUMBER" />
</property>
<property generated="never" lazy="false" name="dateRequired"
type="java.lang.String">
<column name="DATEREQUIRED" />
</property>
<property generated="never" lazy="false" name="unit"
type="java.lang.String">
<column name="UNIT" />
</property>
<property generated="never" lazy="false" name="odrQty"
type="java.lang.String">
<column name="ODRQTY" />
</property>
<property generated="never" lazy="false" name="unitCost"
type="java.lang.String">
<column name="UNITCOST" />
</property>
<property generated="never" lazy="false" name="amount"
type="java.lang.String">
<column name="AMOUNT" />
</property>
<list cascade="save-update" inverse="true" lazy="true" name="itemRefs"
table="ORDERITEMREF">
<key>
<column name="ORDERITEMID" />
</key>
<list-index base="0" />
<one-to-many class="com.dgys.app.model.OrderItemRef" />
</list>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2019-5-29 15:39:24 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="com.dgys.app.model.OrderItemRef" table="ORDERITEMREF">
<id name="itemRefId" type="int">
<column name="ITEMREFID" />
<generator class="increment" />
</id>
<many-to-one class="com.dgys.app.model.OrderItem" name="orderItem">
<column name="ORDERITEMID" />
</many-to-one>
<property generated="never" lazy="false" name="refValue"
type="java.lang.String">
<column name="REFVALUE" />
</property>
</class>
</hibernate-mapping>
When i used the save method of session to save OrderDetail object,i got the below logs:
Hibernate: select max(ORDERID) from ORDERDETAIL
Hibernate: select max(ORDERITEMID) from ORDERITEM
Hibernate: select max(ITEMREFID) from ORDERITEMREF
Hibernate: insert into ORDERDETAIL (PONUMBER, ORDERDATE, RESALEPERMIT, SHIPVIA, TERMS, ORDERID) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEM (orderid, LINENUM, ITEMNUMBER, DATEREQUIRED, UNIT, ODRQTY, UNITCOST, AMOUNT, ORDERITEMID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: insert into ORDERITEMREF (ORDERITEMID, REFVALUE, ITEMREFID) values (?, ?, ?)
Hibernate: update ORDERITEM set orderitemid=? where ORDERITEMID=?
May 30, 2019 8:33:52 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 2292, SQLState: 23000
May 30, 2019 8:33:52 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ORA-02292: integrity constraint (FMIS.ORDERITEMREF_ORDERITEM_FK) violated - child record found
May 30, 2019 8:33:52 Am org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl release
INFO: HHH000010: On release of batch it still contained JDBC statements
May 30, 2019 8:33:52 AM org.hibernate.internal.SessionImpl$5 mapManagedFlushFailure
ERROR: HHH000346: Error during managed flush [could not execute statement]
org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:59)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at org.hibernate.persister.collection.OneToManyPersister.writeIndex(OneToManyPersister.java:265)
at org.hibernate.persister.collection.OneToManyPersister.recreate(OneToManyPersister.java:187)
at org.hibernate.action.internal.CollectionRecreateAction.execute(CollectionRecreateAction.java:50)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:582)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:456)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)
at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:465)
at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:2963)
at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2339)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:485)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65)
at com.dgys.app.dao.OrderDao.saveOrder(OrderDao.java:28)
at com.dgys.app.model.AmfitOrderParser.ParseOrderText(AmfitOrderParser.java:96)
at com.dgys.app.model.OrderDetector.parseOrder(OrderDetector.java:79)
at com.dgys.app.model.OrderDetector.<init>(OrderDetector.java:45)
at com.dgys.app.model.OrderParseMain.main(OrderParseMain.java:9)
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (FMIS.ORDERITEMREF_ORDERITEM_FK) violated - child record found
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)
... 22 more
What’s the mistake i made FOR this issue?
Have anybody know how to solve it?
Hope for your reply!