Connection pool [SOLVED]

[stoffman]

Hi,

Does Zeos support connection pooling (especially on postgres, but not limited to) ? If so can someone explain how can I configure my ZConnections (running in different threads) to use the pool? thank.

[marsupilami]

Hello stoffman,

Zeos supports using connection pools. This are a different driver though. If you want to pool your connection, use "pooled.postgres". Connections will be pooled from there.
But the base principle for threads in Zeos still applies there: one conenction may only be used in one thread at the same time. Zeos is not thread safe beyond that.

Best regards,

Jan

[stoffman]

Hi Jan,

I'm not sure what you mean by use "pooled.postgers" (I'm really new to zeos)

The only thing that resemble your suggestion is the protocol property in ZConnection that has: "pooled.*" value

[aehimself]

"pooled." is a prefix, not a standalone protocol. If you need a pooled connection of "mysql" protocols, enter "pooled.mysql"; if you need "oracle", enter "pooled.oracle" and so on.

[stoffman]

Thanks.