[Zope-DB] dco2 and bind variables

Jim Abramson jabramson at wgen.net
Wed Oct 8 14:22:09 EDT 2003

Rather than rolling my own subclass of DCO2 (sounds like fun but...), I'm inclined to start using external methods instead of sql methods, which import DCO2 and now I have direct access to the execute() method.

Ideally, I'd like to pass the zope database connection object to the external method, let the method call execute/fetchall, and return the results, because sometimes the same sql is run against different connections. A few quick tests of this worked just fine, hooray. But does it introduce any risk, as far as the pooling of connections or handling of transactions that may be going on elsewhere in zope? Is there some pitfall I'm not aware of here? It almost seems, well, too easy...

Thanks for advice.

-----Original Message-----
From: Matthew T. Kromer [mailto:matt at zope.com]
Sent: Friday, October 03, 2003 4:02 PM
To: b.maryniuk at forbis.lt
Cc: zope-db at zope.org
Subject: Re: [Zope-DB] dco2 and bind variables

Bo M. Maryniuck wrote:

>On Friday 03 October 2003 15:33, Matthew T. Kromer wrote:
>>No :(
>And what about binding array in DCOracle2?

The question was with regards to SQL Methods in Zope, which don't know 
anything about binds.

Matt Kromer
Zope Corporation  http://www.zope.com/ 

Zope-DB mailing list
Zope-DB at zope.org

More information about the Zope-DB mailing list