Quote from my previous answer: - do not access the db object after the thread that created the object has returned (because the connection is automatically closed and transaction committed).
Massimo On May 16, 7:51 am, Kacper Krupa <[email protected]> wrote: > From trunk i still get: > ProgrammingError: Cannot operate on a closed database. > > On 15 Maj, 21:07, mdipierro <[email protected]> wrote: > > > This is a bit can of worms. > > > Not all database divers are thread safe (in the sense that they allows > > you to use the same open connection safely in multiple threads). > > sqlite is not thread safe and to prevent problems it blocks access > > from a different thread than the one that created the thread. The > > programming error below is a sqlite error, not a web2py error. > > > Anyway, sqlite also allows you to avoid this check in case you really > > need to use it in multiple threads but assumes you have a lock > > mechanism to avoid problems. > > > The web2py in thunk disabled the check. I needed this in order to get > > the web2py ajax shell working (and it is *almost* working). Disabling > > the check allows you to access the db object from multiple threads but > > does not avoid he underlying problems which may lead to database > > corruption. > > > I really should recommend that you do not pass one db object between > > threads. There many subtleties that can lead to data corruption. If > > you really have to do it make sure you: > > - implement a lock mechanism > > - do not access the db object after the thread that created the object > > has returned (because the connection is automatically close and > > transaction committed). > > > Massimo > > > On May 15, 11:22 am, Kacper Krupa <[email protected]> wrote: > > > > Hi, > > > > I've written application which creates another thread and do things > > > inside it. But why i can't use ORM in it? I'm using sqlite3 and i > > > always get: > > > > ProgrammingError: SQLite objects created in a thread can only be used > > > in that same thread.The object was created in thread id 28329984 and > > > this is thread id 28687360 > > > > Any ideas? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
