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

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 performan

[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

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 requir

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 turn

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

2010-11-17 Thread Laurence Rowe
On 17 November 2010 17:05, Laurence Rowe wrote: > On 17 November 2010 16:34, Alan Runyan 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 dep

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

2010-11-17 Thread Laurence Rowe
On 17 November 2010 16:34, Alan Runyan 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 when I look

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 man

[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 imple

[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 a