[stackoverflow] [progress Openedge Abl] Failure Getting Record Lock On A Record From Table

[Chandana Kumara]

I developed java code to insert and update data to some tables in progress DB.

This is my code:-

DBConnection1 con1 = new DBConnection1();
DBConnection2 con2 = new DBConnection2();
DBTransaction transac = new DBTransaction();
con1.makeConnection();
con2.makeConnection();
con1.getConnection().setAutoCommit(false);
con2.getConnection().setAutoCommit(false);

transac.modifyData(CloseCutSQL.updateDivl(SystemPara.frmID, productionOrder.getDiphid().intValue(), productionOrder.getSeizid(), productionOrder.getKlrnid(), productionOrder.getVar().intValue(), changeSizeTotalQty, isComplete),con1.getConnection());
transac.modifyData(CloseCutSQL.updateDipl(SystemPara.frmID, productionOrder.getDiphid().intValue(), productionOrder.getSeizid(), productionOrder.getKlrnid(), productionOrder.getVar().intValue(), changeSizeTotalQty, isComplete),con1.getConnection());
transac.modifyData(CloseCutSQL.updateDivh(SystemPara.frmID, productionOrder.getDiphid().intValue(), productionOrder.getSeizid(), changeSizeTotalQty, isComplete),con1.getConnection());
transac.modifyData(CloseCutSQL.updateDiph(SystemPara.frmID, productionOrder.getDiphid().intValue(), productionOrder.getSeizid(), changeSizeTotalQty, isComplete),con1.getConnection());

.......
......

con1.getConnection().commit();
con2.getConnection().commit();
con1.dropConnection();
con2.dropConnection();


But I am getting following exception.

java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Failure getting record lock on a record from table PUB.prds.
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.fetchProcessReply(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.fetch(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplResultSet.fetchAtPosition(Unknown Source)
at com.ddtek.jdbc.base.BaseImplResultSet.next(Unknown Source)
at com.ddtek.jdbc.base.BaseImplResultSetClientSideUpdatable.next(Unknown Source)


Pls help me to solve this problem? I saw some posts about this. But there is no exact answer for this.

Continue reading...