Re: [PDO] Question on Persistent PDO Connections

From: Date: Thu, 05 Nov 2009 17:43:03 +0000
Subject: Re: [PDO] Question on Persistent PDO Connections
References: 1 2 3 4  Groups: php.pdo 
Request: Send a blank email to pdo+get-298@lists.php.net to get a copy of this message
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

« previous php.pdo (#298) next »