插入的量大时,就挂掉了,1万条可以,10万条直接卡住,挂掉了以下是主要代码: 怎么回事啊
public static bool OperateDatasWithTransaction(List<string> sqlList)
{
OracleConnection myConnection = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnStrOrcl"]);
myConnection.Open();
OracleCommand myCommand = myConnection.CreateCommand();
OracleTransaction myTrans;
// Start a local transaction
myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted);
// Assign transaction object for a pending local transaction
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
try
{
foreach (string item in sqlList)
{
myCommand.CommandText = item;
myCommand.ExecuteNonQuery();
}
myTrans.Commit();
return true;
}
catch (Exception)
{
myTrans.Rollback();
return false;
}
finally
{
myConnection.Close();
}
public static bool OperateDatasWithTransaction(List<string> sqlList)
{
OracleConnection myConnection = new OracleConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnStrOrcl"]);
myConnection.Open();
OracleCommand myCommand = myConnection.CreateCommand();
OracleTransaction myTrans;
// Start a local transaction
myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted);
// Assign transaction object for a pending local transaction
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans;
try
{
foreach (string item in sqlList)
{
myCommand.CommandText = item;
myCommand.ExecuteNonQuery();
}
myTrans.Commit();
return true;
}
catch (Exception)
{
myTrans.Rollback();
return false;
}
finally
{
myConnection.Close();
}
解决方案 »
- 关于C#接收和发送串口数据
- 文件夹右键的图标 设置问题,关于注册表问题
- 请教:要监听Com口上的设备要怎么写?
- c#的socket不能传特殊字符?是不是不能传字符串?一定要byte?谢谢
- C#中 C/S结构怎样加密字符串
- 谁可帮我弄一个大专的毕业证,要可在网上查ID的,请不要删此贴,我要找工作!
- 关于CrystalReport中RecordSelectionFormula的用法(在线等!!!!!!!)
- 请问域和变量有什么区别啊?
- 求助,服务器接收URL传的汉字时汉字变成了乱码
- asp.net core 2.0 +EF +MySql怎么处理行版本问题?
- 请教各位:两台电脑用网线直连后如何访问?
- C#执行存储过程异常
数据库不是我弄的,这样的数据库明显有问题啊