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 > layers? > 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. Shane _______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev