Dapper hangs on execution

I have - IDbConnection - sql = @ "UPDATE tablename SET json =: json, lastupdate = SYSDATE WHERE id =: id"

var param = new DynamicParameters();
param.Add(":json", json, DbType.AnsiString);
param.Add(":id", currentTemplate.Id);

if (connection == null || connection.State != ConnectionState.Open) continue;
connection.Execute(sql, param);  // hangs here.
connection.Query(sql, param);  // tried this and this also hangs.

      

Encoding stops when connected. Performance. There is no mistake or anything else. It just hangs.

: json is the serialized object returned by JsonConvert.

: id - string

I also tried removing the parameters and including the values ​​in the SQL itself.

+2


source to share


1 answer


In my case, I had an uncommitted transaction in another session as described here: Oracle Update Hangs



+1


source







All Articles