Dear All,
I am using a Java code to update a record in table but when my program reaches at prepareStatement.executeUpdate(); it just hangs for almost two min and then it inserts the data to table. Can anyone help me why this is happening. Even my table only have 10 to 20 records.
updateQuery = "update XXMPC.XXMDN_B2B_LMS_TRANSFER set PAYMENT_DISBURSEMENT_STTS_CODE=?,PAYMENT_DISBURSEMENT_STTS_DESC=? where TRXN_REFERENCE_NUMBER=?";
conn.setAutoCommit(true);
prepareStatement = conn.prepareStatement(updateQuery);
prepareStatement.setString(1, StatusCode);
prepareStatement.setString(2, StatusDetail);
prepareStatement.setInt(3, Integer.parseInt(SequenceNum));
prepareStatement.executeUpdate();
conn.close();
conn = null;