Re: [sqlalchemy] how to handle deadlock

2010-05-06 Thread gary clark
try: Perform table transaction break except: rollback delay try again to perform table transaction I'm sure you will get the gist of the above and why. I also set my isolation_level to READ UNCOMMITED. Thanks, Garyc --- On Thu, 5/6/10, rajasekhar911

[sqlalchemy] setting the transaction isolation_level?

2010-04-27 Thread gary clark
Hello, I'm using SQLAlchemy with sqlite 3.6.23. I would like to know how you set the transaction isolation_level=immediate. I think this will help with the deadlocks I was having. Just dont know how to implement this. Thanks, Garyc -- You received this message because you are subscribed to

Re: [sqlalchemy] setting the transaction isolation_level?

2010-04-27 Thread gary clark
? To: sqlalchemy@googlegroups.com Date: Tuesday, April 27, 2010, 3:30 PM gary clark wrote: Hello, I'm using SQLAlchemy with sqlite 3.6.23. I would like to know how you set the transaction isolation_level=immediate. I think this will help with the deadlocks I was having. Just dont know

Re: [sqlalchemy] Re: Database locking

2010-04-26 Thread gary clark
Thanks Michael. I am going to do some more research on SQLAlchemy and how it handles locks and its interaction with sqlite. I will try and post my findings next week. Thanks, Garyc --- On Mon, 4/26/10, Michael Bayer mike...@zzzcomputing.com wrote: From: Michael Bayer mike...@zzzcomputing.com