This content has been marked as final.
Show 2 replies
-
1. Re: sql server locking
adrian.brock Feb 24, 2004 6:21 AM (in response to glyn_walters)You often get problems with MSSQL server
when there are no indices supporting your primary or foreign key constraints.
JBossCMP just adds the constraints, it does not add the indicies.
Regards,
Adrian -
2. Re: sql server locking
glyn_walters Feb 26, 2004 7:33 AM (in response to glyn_walters)Thanks for the advice. I have seen a few issues users on these boards have been having with sql server. Particularly the way sql server may promote a row lock to a page or table lock. I am stuck with using sql server and am nervous about whether I will be creating problems for myself trying to use it in a clustered environment but will carry on with it and monitor the locking situation.