Req #64603 [Opn->Csd]: Implement check_liveness for PDO_Firebird

Edit report at https://bugs.php.net/bug.php?id=64603&edit=1 ID: 64603 Updated by: ramsey@php.net Reported by: slavb18 at gmail dot com Summary: Implement check_liveness for PDO_Firebird -Status: Open +Status: Closed Type: Feature/Change Request Package: PDO Firebird Operating System: Any PHP Version: 5.3.23 -Assigned To: +Assigned To: ramsey Block user comment: N Private report: N New Comment: The fix for this bug has been committed. If you are still experiencing this bug, try to check out latest source from https://github.com/php/php-src and re-test. Thank you for the report, and for helping us make PHP better. Fixed in https://github.com/php/php-src/pull/12757 Previous Comments: ------------------------------------------------------------------------ [2021-06-09 14:09:59] cmb@php.net Related To: Bug #80546 ------------------------------------------------------------------------ [2021-06-09 10:41:15] cmb@php.net > with pdo_firebird_check_liveness now works ok, Right. When a new persistent connection is established, and the driver implements the check_liveness method, it is called, and if the connection is no longer alive, a new connection is established. ------------------------------------------------------------------------ [2013-09-18 05:28:10] slavb18 at gmail dot com with pdo_firebird_check_liveness now works ok, no more shutdown connections returned to php ------------------------------------------------------------------------ [2013-05-25 09:21:01] michael at mjburgess dot co dot uk I've confirmed this ------------------------------------------------------------------------ [2013-04-07 07:24:16] slavb18 at gmail dot com may be there is also third way to resolve problem 1. PDO class should have function public function isValid(){ return TRUE; // or some embedded functional like start/finish transaction ? dont know how it work with other drivers } 2. derived class override & implement method isValid() (like in my example) 3. php before returning PDO class from connection pool should call isValid() method, and if validation the result is false, then automatically refresh connection ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=64603 -- Edit this bug report at https://bugs.php.net/bug.php?id=64603&edit=1