Re: [PDO] Question on Persistent PDO Connections

Lukas Kahwe Smith wrote:
 >
 > On 04.11.2009, at 16:43, Ulf Wendel wrote:
 >
 >> Hackish - if it is undefined wheter pooled PDO connections are cleaned
 >> up before reuse or not, I consider it undefined how drivers behave and
 >> furthermore, I consider it not as a bug if extensions change their
 >> behaviour at any time.
 >
 >
 > a slightly more "reasonable" scenario would be having to set session
 > variables like on oracle:
 > ALTER SESSION SET NLS_NUMERIC_CHARACTERS='. '
 > ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
 >
 > would be nice to have to set this only once for connections being
 > reused, since often times its hopeless to get the DBA to make such
 > adjustments permanent.


These can be set as environment variables before starting the web
server.  Or they can be set in a logon trigger; this trigger won't be
called if oci_pconnect() is able to reuse a "session" from a previous
PHP script.

Chris


-- 
Blog: http://blogs.oracle.com/opal
Twitter:  http://twitter.com/ghrd