Click here to Skip to main content
15,891,513 members
Home / Discussions / C#
   

C#

 
GeneralRe: I dont solved this error! Pin
Pete O'Hanlon17-Apr-08 10:01
mvePete O'Hanlon17-Apr-08 10:01 
GeneralRe: I dont solved this error! Pin
wwwxyz17-Apr-08 10:18
wwwxyz17-Apr-08 10:18 
GeneralRe: I dont solved this error! Pin
wwwxyz17-Apr-08 5:17
wwwxyz17-Apr-08 5:17 
GeneralRe: I dont solved this error! Pin
MidwestLimey17-Apr-08 16:14
professionalMidwestLimey17-Apr-08 16:14 
Generalfile.copy not copying .zip files Pin
markymark8217-Apr-08 3:20
markymark8217-Apr-08 3:20 
GeneralRe: file.copy not copying .zip files Pin
Reelix17-Apr-08 4:01
Reelix17-Apr-08 4:01 
GeneralRe: file.copy not copying .zip files Pin
led mike17-Apr-08 4:37
led mike17-Apr-08 4:37 
QuestionUncommiteed SQLTransaction causing the problem Pin
atuldeore17-Apr-08 3:03
atuldeore17-Apr-08 3:03 
Hi All,

I thought it would be simple solution but not really being able to crack it.
I have a webservice which acts as data provider to the client which is a windows application. The webservice has various web methods and I have written them in a way that they share same SQLTransaction object while retrieving data.
WebService has BeginTransaction(), CommitTransaction() and RollbackTransaction() methods. when I want to perform an operation (which typically consists of 3/4 webmethod calls) I call BeginTransaction() first and CommitTransaction() or RollbackTransaction() after the operation is finished or in case of exception.

The problem:
If the user makes the application to end using task manager after BeginTransaction() has been called and before CommitTransaction() or RollbackTransaction() is called. When next time the application is launched, it fails to fetch data and gets stuck attempting to retieve it. This is because the previous transaction is still locking the tables!

Well, It might take long to read the post but I thought it was important to explain it in detail.

Can anyone think of any way out?

Thanks in Advance
AD

Every bit counts

GeneralRe: Uncommiteed SQLTransaction causing the problem Pin
Reelix17-Apr-08 3:58
Reelix17-Apr-08 3:58 
GeneralRe: Uncommiteed SQLTransaction causing the problem Pin
atuldeore17-Apr-08 4:56
atuldeore17-Apr-08 4:56 
GeneralRegistryKey.OpenRemoteBaseKey() problem Pin
heidihund17-Apr-08 3:02
heidihund17-Apr-08 3:02 
GeneralRe: RegistryKey.OpenRemoteBaseKey() problem Pin
Ed.Poore17-Apr-08 4:39
Ed.Poore17-Apr-08 4:39 
GeneralRe: RegistryKey.OpenRemoteBaseKey() problem Pin
heidihund17-Apr-08 21:50
heidihund17-Apr-08 21:50 
GeneralRe: RegistryKey.OpenRemoteBaseKey() problem Pin
Ed.Poore17-Apr-08 23:07
Ed.Poore17-Apr-08 23:07 
AnswerRe: RegistryKey.OpenRemoteBaseKey() problem Pin
heidihund20-Apr-08 21:07
heidihund20-Apr-08 21:07 
GeneralRe: RegistryKey.OpenRemoteBaseKey() problem Pin
Dave Kreskowiak17-Apr-08 5:07
mveDave Kreskowiak17-Apr-08 5:07 
Generalmy game code Pin
stephen bempah17-Apr-08 2:42
stephen bempah17-Apr-08 2:42 
GeneralRe: my game code Pin
laserbaronen17-Apr-08 2:52
laserbaronen17-Apr-08 2:52 
GeneralRe: my game code Pin
Pete O'Hanlon17-Apr-08 3:01
mvePete O'Hanlon17-Apr-08 3:01 
GeneralRe: my game code Pin
Dave Kreskowiak17-Apr-08 5:03
mveDave Kreskowiak17-Apr-08 5:03 
GeneralMTOM Pin
JustRonald17-Apr-08 2:25
JustRonald17-Apr-08 2:25 
AnswerRe: MTOM Pin
atuldeore17-Apr-08 3:16
atuldeore17-Apr-08 3:16 
GeneralRe: MTOM Pin
JustRonald17-Apr-08 3:52
JustRonald17-Apr-08 3:52 
Generalexception in ReaderWriterLock Pin
George_George17-Apr-08 1:47
George_George17-Apr-08 1:47 
Generalapp.config wtf Pin
Razvan Dimescu17-Apr-08 1:00
Razvan Dimescu17-Apr-08 1:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.