I'm using the framework in a windows service application that runs multiple threads. on my local desktop everything works fine but when I deploy the application to a dual processor machine it seems like the transaction counter within the framework gets currupted. the number of COMMIT TRANSACTION statements isn't equal to the number of COMMIT TRANSACTION statements. this results in a transaction that never gets commited. Do you have any idea what could be the reason for this problem or how to work around it?
Regards, Martin
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It's possible that there is an exception being thrown internally in the framework that I am missing and that this is leading to the transaction count being out of sync, however since the program works on a single CPU I'm doubtful that this is the case.
I don't have the code in front of me so I'll need to check if there is and locks around the code that updates the transaction counters (from memory I don't think there is).
I've got locks around other parts of the framework higher up in the call stack (eg retrieveObject, etc) and I would have thought that this would protect the transaction count as well, but I'll need to check.
Also, I don't have a dual CPU machine to test with - if you'd like to donate one I'd be happy to try it out :-) !! (just kidding).
- Richard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm using the framework in a windows service application that runs multiple threads. on my local desktop everything works fine but when I deploy the application to a dual processor machine it seems like the transaction counter within the framework gets currupted. the number of COMMIT TRANSACTION statements isn't equal to the number of COMMIT TRANSACTION statements. this results in a transaction that never gets commited. Do you have any idea what could be the reason for this problem or how to work around it?
Regards, Martin
Hi Martin,
It's possible that there is an exception being thrown internally in the framework that I am missing and that this is leading to the transaction count being out of sync, however since the program works on a single CPU I'm doubtful that this is the case.
I don't have the code in front of me so I'll need to check if there is and locks around the code that updates the transaction counters (from memory I don't think there is).
I've got locks around other parts of the framework higher up in the call stack (eg retrieveObject, etc) and I would have thought that this would protect the transaction count as well, but I'll need to check.
Also, I don't have a dual CPU machine to test with - if you'd like to donate one I'd be happy to try it out :-) !! (just kidding).
- Richard.