187 |
MySqlCommand updateCmd = new MySqlCommand(updateSql, sqlWriteConnection); |
MySqlCommand updateCmd = new MySqlCommand(updateSql, sqlWriteConnection); |
188 |
int numrows = updateCmd.ExecuteNonQuery(); |
int numrows = updateCmd.ExecuteNonQuery(); |
189 |
|
|
190 |
translog.WriteLine(getNowString() + " " + msgString + "\n"); |
translog.WriteLine(getNowString() + " " + msgString); |
191 |
|
|
192 |
if (numrows != 1) |
if (numrows != 1) |
193 |
{ |
{ |
285 |
|
|
286 |
if (numrows == 1) |
if (numrows == 1) |
287 |
{ |
{ |
288 |
translog.WriteLine(getNowString() + " " + msgString + "\n"); |
translog.WriteLine(getNowString() + " " + msgString); |
289 |
mqMgr.Commit(); |
mqMgr.Commit(); |
290 |
statusData.counter++; |
statusData.counter++; |
291 |
} |
} |
328 |
} |
} |
329 |
catch (Exception e) |
catch (Exception e) |
330 |
{ |
{ |
331 |
|
//Det vil være mest korrekt at Rollback/backout MQ Transaktionen her - for at være sikker på at Message'n fjernes fra køen |
332 |
|
try |
333 |
|
{ |
334 |
|
if (mqMgr != null) |
335 |
|
{ |
336 |
|
mqMgr.Backout(); |
337 |
|
} |
338 |
|
} |
339 |
|
catch (Exception e2) |
340 |
|
{ |
341 |
|
this.addLogEntry("Error backing out from MQ Transaction: " + e2.Message); |
342 |
|
} |
343 |
|
|
344 |
statusData.lastrunOk = false; |
statusData.lastrunOk = false; |
345 |
|
|
346 |
statusData.lastErrorMessage = name + ".transportMq2Sql error: " + e.GetType().FullName + " " + e.Message; |
statusData.lastErrorMessage = name + ".transportMq2Sql error: " + e.GetType().FullName + " " + e.Message; |