[Zope] ZPyGreSQLDA

[Ross J. Reedstrom]

Hey all - 
I'm just back from a couple weeks of vacation, and I'm slogging through
the (over a thousand!) messages in my Zope lists folder. I'll be getting
back into looking at ZPyGreSQLDA next week (actual work needs to get
caught up, as well) Just before I left, Maurice Davis (the original
ZPyGreSQLDA author) resurfaced, as was going to take a look at it again.
In the process, we discovered that what I posted was my latest hacked up
version, but without the additions to the README that I remember making.
(Why does one always delete the backups _just_ before discovering that
the current version is wrong?)

As to my difficulties: I'm still not clear on when Zope will fire the
various transaction methods. With my latest work, if I cause a SQL error
(with a table name typo, for example), that DB connection no longer uses
transactions at all, and needs to be closed/reopened to start using them
again.

I also need to understand the DB connection pool code: under some
conditions, I seemed to be getting a growing number of connections to
the backend. All this was a month (or more) ago, and early in the Zope2
release cycle, which is nearly prehistoric in Zope/Internet development
time. It all needs a bit more going over.

Ross

On Wed, Oct 06, 1999 at 04:28:35PM +0200, Fredrick Rybarczyk wrote:
> Tom Deprez wrote:
> 
> > Thanks for the reply,
> >
> > Do you use ZPyGreSQLDA-0.3-rjr2.tar.gz for this?
> 
> Yup.
> 
> > Do you experience some difficulties like the author tells on the product page?
> 
> Well, I think the difficulties Ross refers to concern how he is supposed to meet
> with digicools requirements on database adapters. Check out
> http://www.zope.org/Members/petrilli/DARoadmap I think I saw a note somewhere
> claiming ZPyGreSQLDA being compliant with level 2. Note that it is in a state of
> development though.
> 
> > Are these difficulties very annoying?
> 
> Hmm. I haven't had any problems YET but I'm still developing my app. I sometimes
> wonder about what will happen when I launch it onto the net and the load
> increases a bit :-)
> 
> I hope this helps and I suggest that you point specific questions to
> reedstrm@rice.edu or perhaps andreas@mtg.co.at  (Hope they don't mind me hanging
> them out like this :-} )
> 
> -Fredrick
> 
> >
> > Regards, Tom.
> 
> --
> +-----------------------------------------------------+
> | Fredrick Rybarczyk  voice +46 46 222 9369           |
> | Research Engineer   fax   +46 46 222 3682           |
> | LUB NetLab          http://www.lub.lu.se/~fredrick/ |
> +-----------------------------------------------------+
> 
> 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
> 
> (Related lists - please, no cross posts or HTML encoding!
> 
> To receive general Zope announcements, see:
> http://www.zope.org/mailman/listinfo/zope-announce
> 
> For developer-specific issues, zope-dev@zope.org -
> http://www.zope.org/mailman/listinfo/zope-dev )

-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005