Brad Clements wrote at 2004-7-9 09:35 -0400:
I am using ZsapdbDA with SAPDB (now MaxDB) and have run into problems when Zope has more than one thread.
The folks at SAP suggest that there should be one database connection per thread, rather than sharing one connection across threads.
This is the default for DAs as it is much easier to implement one connection per thread than one connection per DA instance...
I haven't yet looked at the Zsapdb source, but I think it has only one connection for all threads.
Then do look at the source. I would be astonished when you were right... Check whether the connection is maintained in a "_v_" attribute (in this case, it is per thread). Otherwise, the connection would need to be maintained in a module global registry indexed with a DA id (e.g. its ZODB path). -- Dieter