Transaction implementation for websites


Author
Message
Marcel Heitlager
Marcel Heitlager
StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)
Group: StrataFrame Users
Posts: 84, Visits: 835
Hi,

On a couple of occasions we noticed that when a person saves data on webpage 1 and another person saves data on webpage 2 at about the same time, I get an error that shows that the transaction wasn't able to start.  (actually in the catch when I do a Rollback it says the transaction didn't start)

Both webpages start a transaction with the same transaction key.  Should the keys be dynamically created?  Or is the failure unrelated to the transaction key?  The database is SQL Server Express 2005.

Thanks,

Marcel
Marcel Heitlager
Marcel Heitlager
StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)StrataFrame User (164 reputation)
Group: StrataFrame Users
Posts: 84, Visits: 835
Marcel,

You can answer your own question at:

http://forum.strataframe.net/FindPost22512.aspx

Sincerely,

Marcel
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search