SQL Server and concurrent select/update
Posted: Wed 07 May 2014 05:28
Hi,
I use SQL Server 12, native client and MARS activated. First I run a select with a join on two table to do some validation. During iterating over all rows, I do updates on selected records.
Everything worked fine for over a year now, but it seems since the update to UniDAC 5.2, this doesn't work anymore, if I want to set a "Date" field to something else than "null" in my update statement. I always get an error like "Lock request time out period exceeded."
My select statement is
my first update statement is (this works):
my second update statement is (this doesn't work):
Were there any changes between UniDac 4.x to 5.x that could cause these problems?
cu Christian
I use SQL Server 12, native client and MARS activated. First I run a select with a join on two table to do some validation. During iterating over all rows, I do updates on selected records.
Everything worked fine for over a year now, but it seems since the update to UniDAC 5.2, this doesn't work anymore, if I want to set a "Date" field to something else than "null" in my update statement. I always get an error like "Lock request time out period exceeded."
My select statement is
Code: Select all
select
A.ALLNAMES, A.ATHLETEID, A.CLUBID, A.CLUBID_ALT, A.FIRSTNAME, A.GENDER,
A.LASTNAME, A.LASTNAME_UPPER, A.NAMEPREFIX,
AD.LICENSE, AD.LICENSE_ALT, AD.LICVALID_FROM, AD.LICVALID_UNTIL,
AD.LICVALID_FROM_ALT, AD.LICVALID_UNTIL_ALT
from ATHLETE A left join ATHLETEDETAIL AD on A.ATHLETEID = AD.ATHLETEDETAILIDCode: Select all
update ATHLETE set LASTNAME_UPPER = :PLASTNAME_UPPER where ATHLETEID = :PATHLETEIDmy second update statement is (this doesn't work):
Code: Select all
update ATHLETEDETAIL
set LICVALID_FROM = :PLICVALID_FROM, LICVALID_UNTIL = :PLICVALID_UNTIL
where ATHLETEDETAILID = :PATHLETEDETAILIDcu Christian