Hi again, Yes, we thought that might be the case. We tried changing the isolation level on this connection to "snapshot". Now I'm getting different errors, and more frequent.
One error I get is this: Mod_python error: "PythonHandler jobtracking.api.controller" Traceback (most recent call last): File "/usr/lib/python2.4/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result = object(req) File "/usr/lib/python2.4/site-packages/jobtracking-1.0_r20-py2.4.egg/jobtracking/api/controller.py" , line 30, in handler visit = s.query(VisitIdentity).get_by(visit_key=visit_key.value) File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 95, in get_by File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 255, in select_whereclause File "build/bdist.linux-i686/egg/sqlalchemy/orm/query.py", line 458, in compile File "build/bdist.linux-i686/egg/sqlalchemy/orm/interfaces.py", line 75, in setup File "build/bdist.linux-i686/egg/sqlalchemy/orm/interfaces.py", line 64, in _get_context_strategy AttributeError: 'ColumnProperty' object has no attribute 'strategy' and another error is "object not subscriptable" when doing something like "eststatus = result.fetchone()[0]" Any ideas? Arnar TypeError: unsubscriptable object On 2/9/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > before I read the next 10 replies in this thread, this seems like an issue > of too high of a transaction isolation level going on (something that > plagued my SQL server apps when i was writing them, though that was years > ago). cant the connection itself have a more lenient isolation level set > ? > > > Arnar Birgisson wrote: > > > > Hi all, > > > > I'm using SA to build queries (no orm) and handle connection pooling > > on a linux machine, connecting to mssql via freetds. > > > > This was working very well with SQL Server 2000, but a couple of weeks > > ago we upgraded to 2005. Since then the SA app has been having some > > problems. I've checked that I'm using the latest (0.64) version of > > freetds - which was released to provide support for sql server 2005. > > > > Now, I won't go into the specific problems (mainly b/c I'm not sure > > what's going on) but my dba suggested that I add "with (nolock)" after > > each table alias in every query (I'm only doing selects). The problem > > is that the queries are built and executed with SA. Can I plug into > > some hooks or something to do this? > > > > Arnar > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---