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

**URL:** <https://www.ruby-forum.com/t/rails-2-1-w-ms-sql-server-2008-warning-re-lock-option/140863>\
**Category:** Rails\
**Created:** [June 19, 2008, 10:24am UTC](https://www.ruby-forum.com/t/rails-2-1-w-ms-sql-server-2008-warning-re-lock-option/140863 "2008-06-19T10:24:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [June 19, 2008, 10:24am UTC](https://www.ruby-forum.com/t/rails-2-1-w-ms-sql-server-2008-warning-re-lock-option/140863/1 "2008-06-19T10:24:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [June 19, 2008, 12:22pm UTC](https://www.ruby-forum.com/t/rails-2-1-w-ms-sql-server-2008-warning-re-lock-option/140863/2 "2008-06-19T12:22:34Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [June 19, 2008, 7:49pm UTC](https://www.ruby-forum.com/t/rails-2-1-w-ms-sql-server-2008-warning-re-lock-option/140863/3 "2008-06-19T19:49:16Z")

</div>

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

Will advise,  
Wes

---

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [June 20, 2008, 1:33am UTC](https://www.ruby-forum.com/t/rails-2-1-w-ms-sql-server-2008-warning-re-lock-option/140863/4 "2008-06-20T01:33:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [June 20, 2008, 1:53am UTC](https://www.ruby-forum.com/t/rails-2-1-w-ms-sql-server-2008-warning-re-lock-option/140863/5 "2008-06-20T01:53:14Z")

</div>

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