Hi I am trying to get a zope site to use sqlite database. I have the following setup Zope 2.9 ZSQLiteDA ZSQLiteDA-0.4.1 Pysqlite 2.3.2 I can connection to the database but whenever it try to render a page template that uses a SQL Method to get data from the database I get the following error Error Type: ProgrammingError Error Value: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 3968 and this is thread id 4328 Chris Hoy
I found that ZSQLiteDA does some evil connection pooling resulting in the error you see. You may want to check out http://www.zope.org/ Members/zoping/ZSQLite3DApkg instead. Stefan P.S. I have a fixed version of ZSQLiteDA 0.4.0 hanging around. Holler if you want it. On 8. Nov 2006, at 18:34, Chris Hoy wrote:
Zope 2.9 ZSQLiteDA ZSQLiteDA-0.4.1 Pysqlite 2.3.2
I can connection to the database but whenever it try to render a page template that uses a SQL Method to get data from the database I get the following error
Error Type: ProgrammingError Error Value: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 3968 and this is thread id 4328
-- It doesn't necessarily do it in chronological order, though. --Douglas Adams
participants (2)
-
Chris Hoy -
Stefan H. Holek