Re: [Zope] Zope2.9 sqllite

[Stefan H. Holek]

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


___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
http://mail.zope.org/mailman/listinfo/zope-announce

http://mail.zope.org/mailman/listinfo/zope-dev )

[Zope] Zope2.9 sqllite

[Chris Hoy]

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



___
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )