Records locked when using UOW

Posts   
 
    
G.I.
User
Posts: 172
Joined: 09-Jun-2005
# Posted on: 18-Aug-2005 09:09:08   

Hi,

I am using SelfServicing. When I use a UOW I get locked records in my database. Even after I have committed or rollbacked. Even when I use a transaction with ReadUnCommitted.

I don't get locks when I use normal Save behavior of my entities, only when I use a UOW. Why is this? Am I doing something wrong?

I just add some 3 collections, 1 entity and 1 SP to my UOW and then try to commit everything, so it's not that I have that much functionality in my UOW at this moment.

Gr.,

G.I.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 18-Aug-2005 10:50:59   

You mean you run into locked rows which cause a deadlock, or do you later on have problems because locks aren't lifted? This can be related to your other question about connections: do you specify autocommit with the unitofwork? Could you check if the transaction you pass in (if you pass in a transaction) is commited/rolled back? If possible, could you please paste some code ?

Frans Bouma | Lead developer LLBLGen Pro