how test that the connection works in Doctrine 2?

Question

I'm looking for a way to test if a connection is working or not with Doctrine 2. As in my application users can change by themselves the information connections, I want to check if the user has entered the right login and password. How can I do that? I tried to put this code into a try/catch block : ``` try{ $entityManager = $this->getEntityManager() ; $repository = $entityManager->getRepository('Authentification\Entity\User'); $userToIdentify = $repository->findOneBy(array('login' => $this->_username, 'password' => $this->_password)); }catch(Exception $e){ $code = Result::FAILURE ; $identity = "unknow" ; $messages = array( "message" => "Wrong login/password combination", ) ; } ``` The problem is that even if the information connection is correct, I cannot catch the exception. Otherwise I get the following error : ``` Fatal error: Uncaught exception 'Zend\View\Exception\RuntimeException' with message 'Zend\View\Renderer\PhpRenderer::render: Unable to render template "layou…

Accepted Answer

Do not use the `EntityManager` directly. You can instead use following to check the connection parameters:

```
try {
    $entityManager->getConnection()->connect();
} catch (\Exception $e) {
    // failed to connect
}
```

That's sadly the only real way to check if something went wrong, since the exception type changes depending on the driver you use.

For the other exception (the view-related one) you simply have to adjust your view scripts path. I suggest you to keep the skeleton application module enabled so that the default layout is always there: you can override it at any time.

how test that the connection works in Doctrine 2?

Solution

Problem