TR: [egenix-users] SQL Server: Experimental Solution

nwingfield at che-llp.com nwingfield at che-llp.com
Mon Oct 27 09:45:24 CET 2003


Sure you do:  self.REQUEST in a product is the same as context.REQUEST in a
Python Script or here.REQUEST in a Zope Page Template.
Nathaniel



                                                                           
             Sébastien                                                     
             Walgraffe                                                     
             <walgraffe at dupuis                                          To 
             .com>                     <egenix-users at lists.egenix.com>     
             Sent by:                                                   cc 
             egenix-users-boun                                             
             ces at lists.egenix.                                     Subject 
             com                       TR: [egenix-users] SQL Server:      
                                       Experimental Solution               
                                                                           
             10/27/2003 05:28                                              
             AM                                                            
                                                                           
                                                                           
                                                                           




Hello

We can t use the solution proposed by nwingfield at che-llp.com. Because we
call ZSQL from a product and we don t have at this place the REQUEST.
With the modifications that you planned in Vesrion 1.0.7, do you think that
it will work if we call ZSQL without REQUEST parameter ?

Thanks

Sebastien Walgraffe

-----Message d'origine-----
De : egenix-users-bounces at lists.egenix.com
[mailto:egenix-users-bounces at lists.egenix.com]De la part de M.-A. Lemburg
Envoyé : jeudi 23 octobre 2003 13:12
À : nwingfield at che-llp.com
Cc : egenix-users at lists.egenix.com
Objet : Re: [egenix-users] SQL Server: Experimental Solution

nwingfield at che-llp.com wrote:
> We have been experiencing many problems with mxODBC and SQL Server,
similar
> to those expressed by others list members (Sébastien Walgraffe, Peter
> Sabaini).  The most common error is this:
> 'HY000', 0, '[Microsoft][ODBC SQL Server Driver]Connection is busy with
> results for another hstmt', 5911
> By eliminating Z SQL methods, we seem to have remedied this error, though
> only time will tell.  We have replaced Z SQL methods with the External
> Method that I am including below.  Another problem that we experienced
was
> that when the connection pool was set greater than one, pages executing
> multiple SQL statements could lock up.  This is because each SQL method
was
> potentially executed on a different connection.  Rather than limit
> ourselves to a connection pool of one, we incorporated some logic into
the
> aforementioned method to maintain one connection per request.  If the
> locking isn't a problem for you, you can strip the extra logic out of
this
> method.
>
> Let me know if this helps.

If this does solve your problems, we'll add a connection option to the
Zope DA which will let you switch on/off this behaviour (grouping
connections per request) for version 1.0.7.

--
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source  (#1, Oct 23 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::


_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
http://lists.egenix.com/mailman/listinfo/egenix-users


_______________________________________________________________________
eGenix.com User Mailing List                     http://www.egenix.com/
http://lists.egenix.com/mailman/listinfo/egenix-users






More information about the egenix-users mailing list