Error handling when using WireDatabasePDO?

[AAD Web Team]

Is it possible to connect to a non-ProcessWire database using WireDatabasePDO, and have error handling, so if the database is unavailable then the page can recover gracefully? I tried:

try {
	$db = new WireDatabasePDO([ /* dsn, user, pass */ ]);
} catch (\Exception $e) {
	/* Code to handle the problem gracefully */
}

This doesn’t work – it seems that the exception is dealt with by ProcessWire before my code sees it. Is it better just to use PHP’s native PDO object directly? Something such as:

try {
	$dbh = new \PDO($dsn, $user, $password);
} catch (\PDOException $e) {
	/* Code to handle the problem */
}

 

[BitPoet]

WireDatabasePDO's constructur doesn't connect to the database yet. This is either implicitly done when the query or exec(ute) methods are called, or explicitly by invoking $db->pdo(), which will return the underlying plain PDO object.

[AAD Web Team]

Great, thanks! I put the try/catch around the $db->query() method rather new WireDatabasePDO constructor and it worked well.