# Connection pooling

**URL:** <https://forum.inductiveautomation.com/t/connection-pooling/14561>\
**Category:** Ignition\
**Tags:** database\
**Created:** [June 19, 2017, 9:00pm UTC](https://forum.inductiveautomation.com/t/connection-pooling/14561 "2017-06-19T21:00:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![eaolson](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\
**Post date:** [June 19, 2017, 9:00pm UTC](https://forum.inductiveautomation.com/t/connection-pooling/14561/1 "2017-06-19T21:00:55Z")

</div>

How does connection pooling work? I leave most of the parameters at the default, so Initial size = 0, Max active = 8, Max idle = 8, and Test while idle = unchecked. If I understand correctly, Ignition will open up to 8 connections to the database, as needed, and never close them? Then a connection would get removed from the pool if it failed validation when it’s picked up the next time?

I’ve got 14 database connections set up, so that’s a possible 112 database connections. Ignition 7.8.x, Oracle, Linux 64-bit.

We ran into an issue today and I’m told this isn’t really a problem, but I’d like to understand how it works.

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [June 19, 2017, 10:07pm UTC](https://forum.inductiveautomation.com/t/connection-pooling/14561/2 "2017-06-19T22:07:07Z")

</div>

Hello,

Your assessment is correct.

Ignition uses Apache Commons DBCP for its database pooling. Here is some examples and documentation on the subject:

[http://www.tomcatexpert.com/blog/2010/04/01/configuring-jdbc-pool-high-concurrency](http://www.tomcatexpert.com/blog/2010/04/01/configuring-jdbc-pool-high-concurrency)  
[https://commons.apache.org/proper/commons-dbcp/configuration.html](https://commons.apache.org/proper/commons-dbcp/configuration.html)
