Re: Using SQLAlchemy with Plone/Zope

On May 16, 11:06 am, Andreas Jung <li...@zopyx.com> wrote:
> --On 16. Mai 2008 08:58:38 -0700 Mike <kyoso...@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.
>

I'm confused. This IS the SqlAlchemy list...

> > Would upgrading it
> > to SQLAlchemy 0.4.5 fix it?
>
> Try it out yourself and see what's happening. Nobody know about your
> particular setup, code etc. - but you do.
>
> Andreas
>

We did end up trying it soon after posting and it works now. Sorry to
bother you.

Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy <at> googlegroups.com
To unsubscribe from this group, send email to sqlalchemy-unsubscribe <at> googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---