public static void thr1 () { int ii; NpgsqlTransaction trans = null; try { NpgsqlConnection conn2 = new NpgsqlConnection (targ_db); conn2.Open (); asdf a = new asdf (); while (true) { try { while (true) { lock (q) { if (q.Count > 0) { a = q.Dequeue (); threads++; if (trans == null) trans = conn2.BeginTransaction (); break; } } if (trans != null) { trans.Commit (); trans = null; lock (q) { threads--; } } System.Threading.Thread.Sleep (200); } try { NpgsqlCommand cmd2 = new NpgsqlCommand (a.cmd, conn2); for (ii=0; ii<a.data.Length; ii++) { object o = a.data [ii]; if (typeof(bool).IsInstanceOfType (o)) { o = (((bool)o == true) ? 1 : 0); } cmd2.Parameters.Add ("col_" + ii.ToString (), o); } cmd2.ExecuteNonQuery (); } catch (Exception ex1) { Console.WriteLine ("exception: " + ex1.Message); } } finally { lock (q) { threads--; } } } conn2.Close (); } catch (Exception ex) { Console.WriteLine ("exception: " + ex.Message); } }
public static void thr1() { int ii; NpgsqlTransaction trans = null; try { NpgsqlConnection conn2 = new NpgsqlConnection(targ_db); conn2.Open(); asdf a = new asdf(); while (true) { try { while (true) { lock (q) { if (q.Count > 0) { a = q.Dequeue(); threads++; if (trans == null) { trans = conn2.BeginTransaction(); } break; } } if (trans != null) { trans.Commit(); trans = null; lock (q) { threads--; } } System.Threading.Thread.Sleep(200); } try { NpgsqlCommand cmd2 = new NpgsqlCommand(a.cmd, conn2); for (ii = 0; ii < a.data.Length; ii++) { object o = a.data [ii]; if (typeof(bool).IsInstanceOfType(o)) { o = (((bool)o == true) ? 1 : 0); } cmd2.Parameters.Add("col_" + ii.ToString(), o); } cmd2.ExecuteNonQuery(); } catch (Exception ex1) { Console.WriteLine("exception: " + ex1.Message); } } finally { lock (q) { threads--; } } } conn2.Close(); } catch (Exception ex) { Console.WriteLine("exception: " + ex.Message); } }