The code used for connecting and retrieving data from PostgreSQL is quite simply this:
 dbconn = getDatabase('name_of_psycopgda')()
 rows = queryForResults(dbconn, sql)
 return rows
Running this bit of code fails about 3 out 4 times; the traceback:
    rows = queryForResults(dbconn, sql)
  File "/usr/share/Zope32/src/zope/app/rdb/", line 408, in queryForResults
    raise DatabaseException(str(error))
DatabaseException: Shouldn't load state for 0x28 when the connection is closed
I've tried setting the threadsafety=2 on the database adapter to no avail.  Has anyone else seen this problem?
p.s. Zope 3.2
Zope3-users mailing list

Reply via email to