[Zope] locking help

[Mark Twiddy]

Hi all,

Thanks for all the help

Ive installed PoPy-1.36 and ZPoPyDA-0.64 and it works like a bastard :))))

Thanks all
Mark

On Wed, 11 Oct 2000, Philipp Auersperg wrote:

> this Postgres adapter is not multithreaded, check out the ZPoPyDA from zope.org. 
> That is an alternative Postgres adapter that is multithreaded and does not lock up.
> 
> phil
> *********** REPLY SEPARATOR  ***********
> 
> On 11.10.2000 at 08:48 Mark Twiddy wrote:
> 
> >Hi thanks for the reply
> >The problem is whenever i do really big query everything stops and waits.
> >
> >im using
> >ZPyGreSQLDA-0.3-rjr2
> >and 
> >py-PyGreSQL-2.4
> >
> >thanks 
> >Mark
> >On Tue, 10 Oct 2000, Mike Renfro wrote:
> >
> >> On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote:
> >> 
> >> > Can someone please tell me what is going on. while querying a
> >> > postgres database i am unable to access any crap from zope. I have
> >> > tried creating a db connection in a enternal method and querying
> >> > through that but it still locks and wont serve any requests.
> >> 
> >> Don't know if this will help, but my Zope/Postgresql experience has
> >> gone remarkably well.
> >> 
> >> I have the following packages installed on an otherwise regular Debian
> >> 2.2 machine:
> >> 
> >> libpgsql2         7.0.2-6     Shared library libpq.so.2 for PostgreSQL
> >> postgresql        7.0.2-6     Object-relational SQL database, descended fr
> >> postgresql-client 7.0.2-6     Front-end programs for PostgreSQL
> >> postgresql-dev    7.0.2-6     Header files for libpq (postgresql library)
> >> postgresql-doc    7.0.2-6     Documentation for the PostgreSQL database.
> >> python-pygresql   7.0.2-6     PostgreSQL module for Python
> >> zope              2.2.2-1     The Z Object Publishing Environment
> >> zope-pygresqlda   0.3rjr2-1   A Zope Database Adapter for PostgreSQL
> >> 
> >> Between those packages, following the PostgreSQL tutorial at
> >> postgresql.org, and following the Z SQL Methods User's Guide
> >> (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm
> >> working fine. Where are the actual errors?
> >> 
> >> -- 
> >> Mike Renfro  / R&D Engineer, Center for Manufacturing Research,
> >> 931 372-3601 / Tennessee Technological University -- renfro@tntech.edu
> >> 
> >> _______________________________________________
> >> Zope maillist  -  Zope@zope.org
> >> http://lists.zope.org/mailman/listinfo/zope
> >> **   No cross posts or HTML encoding!  **
> >> (Related lists - 
> >>  http://lists.zope.org/mailman/listinfo/zope-announce
> >>  http://lists.zope.org/mailman/listinfo/zope-dev )
> >> 
> >
> >
> >_______________________________________________
> >Zope maillist  -  Zope@zope.org
> >http://lists.zope.org/mailman/listinfo/zope
> >**   No cross posts or HTML encoding!  **
> >(Related lists - 
> > http://lists.zope.org/mailman/listinfo/zope-announce
> > http://lists.zope.org/mailman/listinfo/zope-dev )
> 
> 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>