Re: [ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-19 Thread Sachin Tekale
On 2010-11-17 18:12, Shane Hathaway wrote: 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 Are there any

Re: [ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-19 Thread Shane Hathaway
On 11/19/2010 10:39 AM, Sachin Tekale wrote: On 2010-11-17 18:12, Shane Hathaway wrote: 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 Are there any

[ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-18 Thread Martin.Gfeller
my suggestion: use mxodbc. involve shane so he can fold it into the main relstorage line in the future. maybe even budget some money to pay him so he has interest in the outcome of the mssql/odbc adapter for relstorage. We have made very good experience with mxODBC to connect to SQL Server.

[ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-17 Thread Sachin Tekale
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 . Is there solution to overcome this problem, Without introducing too many layers? Can we use PyMSSQL

[ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-17 Thread Sachin Tekale
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 . Is there solution to overcome this problem, Without introducing too many layers? Can we use PyMSSQL and ADODB Python extension to

Re: [ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-17 Thread Alan Runyan
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 . unsure about that. probably depends on the client access library. Is there solution to overcome this problem, Without introducing too many

Re: [ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-17 Thread Laurence Rowe
On 17 November 2010 16:34, Alan Runyan runy...@gmail.com wrote: 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 . unsure about that. probably depends on the client access library. At least

Re: [ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-17 Thread Laurence Rowe
On 17 November 2010 17:05, Laurence Rowe l...@lrowe.co.uk wrote: On 17 November 2010 16:34, Alan Runyan runy...@gmail.com wrote: 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 . unsure

Re: [ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-17 Thread Shane Hathaway
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

Re: [ZODB-Dev] RelStorage support to Microsoft SQLServer

2010-11-17 Thread 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