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.
> Is there solution to overcome this problem, Without introducing too many
> Can we use PyMSSQL and ADODB Python extension to implement the
> relstorage Adapter for MS-SQL.
> Has any one tried this before?
> Are there any other major concerns you would have for developing MS-SQL
> adapter component?
> Please point us in right direction on the subject.
Using mxODBC is a good start, but you still need SQL designed for
MS-SQL, since SQL is only loosely standardized. I could help you out.
Email me privately if you are interested.
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org