[DB-SIG] Reuse of DB-API 2.0 cursors for multiple queries?
mal at egenix.com
Thu Jan 29 21:44:49 CET 2009
On 2009-01-29 21:15, Alex Willmer wrote:
> (Reposted to DB-SIG from clp)
> This week, I used the adodbapi module against an SQL Server Express
> database. I was surprised to get an exception, when I attempted to
> submit a second query with my cursor object. The full session is
> With cx_Oracle I've become used to reusing a cursor for subsequent
> queries. The PEP doesn't specify either way, that I can see. Is this
> behaviour left to the implementation, or should I be able to expect a
> cursor is reusable?
This should be possible. In fact the statement caching mechanism outlined
in the DB-API spec relies on this: if you pass in the same query twice,
the module can opt to reuse the already prepared statement.
mxODBC works that way and we've been using this mechanism to cache
pre-prepared cursors for common queries in our apps for years.
Professional Python Services directly from the Source (#1, Jan 29 2009)
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
::: Try our new mxODBC.Connect Python Database Interface for free ! ::::
eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48
D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
Registered at Amtsgericht Duesseldorf: HRB 46611
More information about the DB-SIG