thibaud
asked on
COM+ locking problem in MTS
I'm currently having a locking problem with COM+ components running in MTS and that are using a SQL-Server 2000 database.
These components are involved in a single MTS Transaction that sequentially will execute a few SELECT's, an UPDATE, an INSERT or a DELETE statement on the database.
Everything works fine until the INSERT is executed. Although the INSERT's SQL syntax is correct, it does not execute on the database and the new record isn't created.
After debugging I found a series of locks on the database that seem to be blocking this table however the application does not raise an error.
Does anyone have an idea on where to look to solve this problem?
These components are involved in a single MTS Transaction that sequentially will execute a few SELECT's, an UPDATE, an INSERT or a DELETE statement on the database.
Everything works fine until the INSERT is executed. Although the INSERT's SQL syntax is correct, it does not execute on the database and the new record isn't created.
After debugging I found a series of locks on the database that seem to be blocking this table however the application does not raise an error.
Does anyone have an idea on where to look to solve this problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
make sure that you are not using any ado batch update functionality. this is a common cause of locking. Also make sure that your tables have good indexes. poor indexes will cause locking when it is not needed.
Hi thibaud,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Split points between: gbaren and rkot2000 and John844
thibaud, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Split points between: gbaren and rkot2000 and John844
thibaud, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
Per recommendation, force-accepted.
Netminder
CS Moderator
gbaren: points for you at https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20328643
John844: points for you at https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20328644
Netminder
CS Moderator
gbaren: points for you at https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20328643
John844: points for you at https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20328644
Can you execute the INSERT from the Query Analyzer?