[ZODB-Dev] RelStorage support to Microsoft SQLServer
Shane Hathaway
shane at hathawaymix.org
Wed Nov 17 13:14:57 EST 2010
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
More information about the ZODB-Dev
mailing list