Re: [PDO] Question on Persistent PDO Connections

Ulf Wendel wrote:

PDO specs: define how PDO drivers may/shall behave PDO API: implement bool PDO::resetsPersistentConnection() PDO API: options setPersistentConnectionReset() Choose whatever function name you like as long you end up having: - a clear statement in the PDO specs what whall happen - a documented and portable way to check the status of the implementation of a PDO specific feature (here: persistent - connections).

PDO has a way to detect whether a persistent call was made http://www.php.net/manual/en/pdo.getattribute.php, but there isn't going to be a PDO DB-portable way to tell whether the DB created the connection or reused it or reset etc. So my clear statement (tm) suggestion is "PHP shall not generically make any assummptions about the connection state of a new PDO connection, except that it will not have an open transaction. Some databases may have optimizations that allow global state information to be retained from a persistent connection in one script into another script. The safest practice is to assume that this state is not carried over and must be reset. Refer to the PDO_xxx driver documentation for database specific information". Chris -- Blog: http://blogs.oracle.com/opal Twitter: http://twitter.com/ghrd