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

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
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

On 19 Jun 2008, at 09:24, Wes Gamble 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

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

Will advise,
Wes

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

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

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Wes Gamble 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

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---