Rails 2.1 w/MS SQL Server 2008 warning re: ":lock option"

Rails
1

All,

I’m successfully running my 2.1 app. against MS SQL Server 2008. One of
my actions generated these messages, though:

Warning: SQLServer :lock option ‘nil’ not supported

It doesn’t appear to hurt anything, but I was wondering if anyone had
seen this before and could shed some light on what it might mean.

Thanks,
Wes

2

On 19 Jun 2008, at 09:24, Wes G. wrote:

All,

I’m successfully running my 2.1 app. against MS SQL Server 2008.
One of
my actions generated these messages, though:

Warning: SQLServer :lock option ‘nil’ not supported

It doesn’t appear to hurt anything, but I was wondering if anyone had
seen this before and could shed some light on what it might mean.

What’s the code that generates this? If the consequence of this is
that you’re not locking a row when you thought you were then you might
end up with nasty race conditions or something further down the line.

Fred

3

I’m not sure yet. It just popped up after my upgrade to 2.1.

Will advise,
Wes

4

Fred,

I suspect that it is this query that generates the complaint.

SELECT TOP 1 [DataSetInfo].DataSetID FROM [DataSetInfo] INNER JOIN
DataTables ON DataSetInfo.DataSetID = DataTables.DataSetID WHERE
([DataSetInfo].[DataSetID] = 386) AND
(([DataTables].JobReferenceNumber = 1223))

Wes

5

Wes G. wrote:

Fred,

I suspect that it is this query that generates the complaint.

SELECT TOP 1 [DataSetInfo].DataSetID FROM [DataSetInfo] INNER JOIN
DataTables ON DataSetInfo.DataSetID = DataTables.DataSetID WHERE
([DataSetInfo].[DataSetID] = 386) AND
(([DataTables].JobReferenceNumber = 1223))

Wes

In addition, it appears that the following options are present when
these queries are executed:

select [DataSetInfo].DataSetID
conditions [DataSetInfo].[DataSetID] = 571
limit 1
offset lock

But I have no idea how the :offset => :lock option is getting in there.

Wes