# Increase amount of connections

**URL:** <https://forum.inductiveautomation.com/t/increase-amount-of-connections/25904>\
**Category:** Ignition\
**Created:** [June 18, 2019, 10:43am UTC](https://forum.inductiveautomation.com/t/increase-amount-of-connections/25904 "2019-06-18T10:43:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tom\_Smits](https://avatars.discourse-cdn.com/v4/letter/t/76d3ee/32.png) [@Tom\_Smits](https://forum.inductiveautomation.com/u/Tom_Smits)\
**Post date:** [June 18, 2019, 10:43am UTC](https://forum.inductiveautomation.com/t/increase-amount-of-connections/25904/1 "2019-06-18T10:43:33Z")

</div>

Hi all,

In my project I wrote a bunch of new queries. After I wrote those query’s the connection with the database sometimes will fail. The error I get is " Connection Pool Exception: Cannot get a connection, pool error Timeout waiting for idle object".  
I think I get this error because the connection pool is out of connections. Is there any way to increase the maximum amount of connections?

See the picture below for more information.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/63401d0f0d6c931bd086c14cf779315bf230262c.png)

Thanks in advance

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 18, 2019, 11:18am UTC](https://forum.inductiveautomation.com/t/increase-amount-of-connections/25904/2 "2019-06-18T11:18:02Z")

</div>

That would be a setting in the database. Without knowing what database you are using, that is as far as I can go.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 18, 2019, 11:23am UTC](https://forum.inductiveautomation.com/t/increase-amount-of-connections/25904/3 "2019-06-18T11:23:03Z")

</div>

Sorry, Just noticed your max connection is set to 8. If you go to the settings of the database connection in the gateway, the max/min/idle connections numbers are under advanced settings. It may still be worth looking at the pool size in the database at some point, though.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [June 18, 2019, 1:37pm UTC](https://forum.inductiveautomation.com/t/increase-amount-of-connections/25904/4 "2019-06-18T13:37:30Z")

</div>

Also worthwhile to see if you have transactions you aren’t closing (or are keeping open a long time). They will hang on to connections until the timeout, which will decrease your available connections.

---

<div class="post-metadata">

**Author:** ![Tom\_Smits](https://avatars.discourse-cdn.com/v4/letter/t/76d3ee/32.png) [@Tom\_Smits](https://forum.inductiveautomation.com/u/Tom_Smits)\
**Post date:** [June 19, 2019, 2:12pm UTC](https://forum.inductiveautomation.com/t/increase-amount-of-connections/25904/5 "2019-06-19T14:12:02Z")

</div>

Thanks Jordan,

This was indeed the answer I was looking for. Since I increased the maximum amount of connections the database connections haven’t failed anymore. Despite I think it is a good idea to check the prestation of my query’s.