Michel Pelletier wrote:
-----Original Message----- From: Nemeth Miklos [mailto:nemeth@iqsoft.hu]
Do the Oracle or PostgreSQL database adapters and the ZSQL technology support connection pooling?
Oracle Yes, PostgreSQL is not written by DC so I don't know. I suspect yes.
If I create a connection object, supposedly it may only be used by a single thread.
Not on Oracle. The Oracle DA is fully concurrent. Postgres, I don't know. Possible not. Note that if a DA is not concurrent it's not Zope's fault, it's usually because the client libraries to interface that database are not concurrent.
I guess that what he meant is _not_ concurrency per se, but whetaher you can have multiple _connections_ with different transactions for each running thread. So when I define a DA and I have 3 working threads running concurrently, will Zope automatically get a separate _connection_ for each thread, either form a pool or pre-allocated per thread ? ----------- Hannu