Maciej Wisniowski wrote at 2006-9-27 17:49 +0200: > ... >Thanks again for explanations. Seems that I'll change my DA's >(DCOracle2 and ZCxOracleDA) to use connection pool like psycopg >does. After quick look at their (psycopg) solution I think it is really good >and solves (or may solve) few other issues too - like closing >all connections with 'Close connection' button (useless with >_v_ implementation). Implementing reconnect of broken connection >i.e. when database was restarted shouldn't be too difficult too.
Pool based connections can be tricky as well: When a DA instance is accessed several times during the same request, it *MUST* use the same connection. Otherwise, you will get the same hazardous behaviour as with "_v_" variables being lost, just more often and more reliable... I know that the "ZPsycopgDA" which comes with "psycopg 1.x" uses "_v_" variables. I do not know whether that of "psycopg 2.x" uses a connection pool and uses it in the correct way. I only know that the correct connection pool use is tricky... -- Dieter _______________________________________________ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db