Re: Using SQLAlchemy with Plone/Zope

--On 16. Mai 2008 18:06:46 +0200 Andreas Jung <lists <at> zopyx.com> wrote:

>
>
> --On 16. Mai 2008 08:58:38 -0700 Mike <kyosohma <at> gmail.com> 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.

Sorry, you're on the right list. Somehow I saw this mail in the context
of the Zope lists.

Andreas