WIN10 C#使用ODBC更新数据库报错
数据库为Postgresql9.4
错误信息为:
[40001] ERROR: could not serialize access due to read/write dependencies among transactions;
Error while executing the query
[57014] ERROR: canceling statement due to statement timeout;
Error while executing the query
部分代码
strbuilderSql.AppendLine("BEGIN;");
foreach (String strItem in arrlItems)
{
sarrayItem = strItem.Split(',');
strbuilderSql.AppendFormat("UPDATE {0} SET \"iValue\"={1}, ", COMMONPARAMETER, Convert.ToInt32(sarrayItem[1]));
strbuilderSql.AppendFormat("\"dtUpdate\"='{0}' ", DaylightTimeTool.BaseNow.ToString(DBDefine.DATETIME_FORMAT));
strbuilderSql.AppendFormat("WHERE \"iAddress\"={0}", Convert.ToInt32(sarrayItem[0]));
strbuilderSql.AppendLine(";");
}
strbuilderSql.AppendLine("COMMIT;");
odbcCmd.CommandText = strbuilderSql.ToString();
iRecordNum = odbcCmd.ExecuteNonQuery();