August 26, 2007 at 11:59 pm
In a high load asp.net environment, I am getting an error.
The transation active in this session has been committed or aborted by another session.
Here is the code , I am getting error.
1 object returnObject = null;
2 SqlTransaction sqlTrans = null;
3 try
4 {
5 //Getting new SqlConnection
6 comm.Connection = GetConnection();
7 //Opening connection
8 OpenConn(comm.Connection);
9 //beginning transaction
10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );
11 //setting transaction to SqlCommand object
12 comm.Transaction = sqlTrans;
13 //executing operation
14 returnObject = comm.ExecuteScalar();
15 //trying to commit.
16 sqlTrans.Commit();
17
18
19 }
20 catch (SqlException sex)
21 {
22 if (sqlTrans != null)
23 {
24 sqlTrans.Rollback();
25 }
26 }
27 finally
28 {
29 comm.Connection.Close();
30 }
Could you please explain , am I doing smthg wrong ?
bahadir cambel
softwareandlife.blogspot.com
August 27, 2007 at 8:36 am
Haven't seen this before. It looks like it could be a bug. I'd call Microsoft's PSS.
August 27, 2007 at 10:29 am
Thanks Steve
bahadir cambel
softwareandlife.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply