# Database connection

**URL:** <https://discourse.cakephp.org/t/database-connection/6035>\
**Category:** Need Help\
**Created:** [May 2, 2019, 10:59am UTC](https://discourse.cakephp.org/t/database-connection/6035 "2019-05-02T10:59:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![yannickfogang](https://avatars.discourse-cdn.com/v4/letter/y/9f8e36/32.png) [@yannickfogang](https://discourse.cakephp.org/u/yannickfogang)\
**Post date:** [May 2, 2019, 10:59am UTC](https://discourse.cakephp.org/t/database-connection/6035/1 "2019-05-02T10:59:26Z")

</div>

Hello everyone, I used PDO directly in a model Cakephp 3.6 to make a request a little complex and for reasons of performance, after that my Models lose the connection to my database, `$this->getConnection()` in my model return null, how can I reconnect my Models automatically?

---

<div class="post-metadata">

**Author:** ![FinlayDaG33k](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/finlaydag33k/32/1049_2.png) [@FinlayDaG33k](https://discourse.cakephp.org/u/FinlayDaG33k)\
**Post date:** [May 3, 2019, 2:51pm UTC](https://discourse.cakephp.org/t/database-connection/6035/2 "2019-05-03T14:51:50Z")

</div>

How do you mean “used PDO directly in a model”?  
Like you actually added another PDO connection manually in a model?

---

<div class="post-metadata">

**Author:** ![jimgwhit](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/jimgwhit/32/378_2.png) [@jimgwhit](https://discourse.cakephp.org/u/jimgwhit)\
**Post date:** [May 3, 2019, 6:10pm UTC](https://discourse.cakephp.org/t/database-connection/6035/3 "2019-05-03T18:10:07Z")

</div>

A very simplified example in model:

```auto
    public function getPets() // params would be used in real app
    {
        $dbh = ConnectionManager::get('default');
        $sql = "SELECT * FROM dc_pets Where `adopted` = :adpt";
        $sth = $dbh->prepare($sql);
        $params = ['adpt' => 0];
        $sth->execute($params);
        return $sth->fetchAll(\PDO::FETCH_OBJ);
    }

```

Of course if for real I’d pass in an offset and a rows per page to paginate