[ZODB-Dev] RelStorage support to Microsoft SQLServer

[Shane Hathaway]

On 11/17/2010 11:12 AM, Shane Hathaway wrote:
> On 11/17/2010 08:29 AM, Sachin Tekale wrote:
>> Hi all,
>> I have read that there is a problem to implement MS-SQL adapter for
>> Relstorage because the “Two phase commit” feature is not exposed by
>> MS-SQL server .
>
> No, RelStorage does not require two phase commit support from the
> database.  It turns out that a simple commit lock, which  is sufficient
> for preventing deadlocks and unreported conflicts.

I forgot to finish my mid-sentence thought: "It turns out that a simple 
commit lock, which nearly all databases support, is sufficient for 
preventing deadlocks and unreported conflicts."

Shane