有这么一段程序:
OleDbConnection conSin = new OleDbConnection(connStrSin3);
OleDbCommand comSin = new OleDbCommand();
try
{
conSin.Open();
comSin.Connection = conSin;
comSin.CommandText = " update testlockb set cid=5 ";
comSin.ExecuteNonQuery();
int x = 0;
}
catch (Exception ex)
{
}
finally
{
comSin.Dispose();
conSin.Close();
conSin.Dispose();
}
在“ int x = 0;”处加断点,并使用sqlplus 执行语句 update tablelockb set cid =2; 能够执行,不等待锁。说明即使没有close连接,ExecuteNonQuery(),也