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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
