[sqlalchemy] Re: Using SQLAlchemy with Plone/Zope

[Andreas Jung]

--On 16. Mai 2008 08:58:38 -0700 Mike <[EMAIL PROTECTED]> wrote:

Hi,

We are using SQLAlchemy 4.X in Zope using SQLAlchemyDA, found here:

http://opensource.zopyx.com/projects/SQLAlchemyDA

This uses SA 0.4.0. We are connecting to MS SQL 2000. While this works
in Zope for normal SQL commands, if we try to execute a stored
procedure, we get the following traceback:


[Traceback (most recent call last):
  File "sqltest.py", line 14, in ?
    print cur.fetchall()
  File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/
SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1231, in
__repr__
    return repr(tuple(self))
  File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/
SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1223, in
__iter__
    yield self.__parent._get_col(self.__row, i)
  File "/opt/Plone-2.5/Python-2.4.3/lib/python2.4/site-packages/
SQLAlchemy-0.4.0-py2.4.egg/sqlalchemy/engine/base.py", line 1468, in
_get_col
    rec = self._key_cache[key]
AttributeError: 'ResultProxy' object has no attribute '_key_cache'


I'm not sure how to go about troubleshooting this.

You're basically on the wrong list. This issue belong on the SQLAlchemy mailing list. There is no indication for a anything related to Zope.

Would upgrading it
to SQLAlchemy 0.4.5 fix it?

Andreas

Try it out yourself and see what's happening. Nobody know about your particular setup, code etc. - but you do.

pgpeOiaMvryu8.pgp
Description: PGP signature