Failed to RowUpdate to 2 different tables simultaneously
Hi there,
I am trying to update two different tables from each other after some calculation (this is related to inventory cost calculation) while I am using a 3rd table to drive the loop. Unfortunately, the following exception is occured..
Place 2o: transactionQty....>>>>:353975.0 onHandQty:844259.0
Rolled Back
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Row update failed.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseImplUpdatableResultSet.executeStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseImplUpdatableResultSet.updateRow(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.updateRow(Unknown Source)
at updateInventoryCostData(InteIc.java:915)
I can e-mail you the java file if any one want to help me.
Can any one help me?
Regards,
Mortoza
mortoza_khan@yahoo.com
