Make sure the backend DB has enough connections. DB connections total should be the sum of all your datasurces maxActive connections plus a couple for good luck. To me, it appears DB is not permitting enough connections or your maxActive in your datasource config is set to high.
<Resource name="DataSourceName" auth="Container" url="jdbc:mysql://<FQDN>:3306/xxxxxxxx" driverClassName="com.mysql.jdbc.Driver" password="XXXXXXXXX" username="user" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true" testOnBorrow="true" testOnReturn="false" validationQuery="SELECT 1" validationInterval="30000" * maxActive="10"* minIdle="10" maxWait="10000" initialSize="10" jmxEnabled="true" /> On Tue, Feb 13, 2018 at 9:20 AM, Bruce L. Riddle < bruce.l.rid...@dartmouth.edu> wrote: > We are running a CDC Application PHIN MS that uses Tomcat 8.5.11. > > As the application starts, we are getting a message that says > > 'error creating connection pool for dbid.' > > > Our assumption is that the message is coming from TomCat. Please, > > what does the message mean and how to we research a possible > > resolution? > > > Thanks. > > > A segment from the LOG: > > > ocalhost-startStop-1|02/13|08:28:35|Processing folderMap: > C:\PHINMS3.0/config/sender/foldermap.xml| > localhost-startStop-1|02/13|08:28:35|Loading decryption keystore| > localhost-startStop-1|02/13|08:28:35|=== Spawning queue 0 ============| > Thread-6|02/13|08:28:35|Initializing requeue cachepath from > C:\PHINMS3.0/\shared\requeueCache| > Thread-6|02/13|08:28:35|Spawning multi database poller 1...| > Thread-7|02/13|08:28:35|Connection established| > Thread-7|02/13|08:28:35|Waiting for records ...| > localhost-startStop-1|02/13|08:28:35|Error creating connection pool for > dbid: NHSCR_DB| > localhost-startStop-1|02/13|08:28:35|| > > Bruce > > > > Bruce Riddle > NHSCR / Dartmouth College > Phone: 603-653-6620 > PO Box 186, Hanover NH 03755 > > STATEMENT OF CONFIDENTIALITY: This email may contain > privileged and confidential information and is intended for use only by the > individual(s) to whom it is addressed. You are hereby notified > that any unauthorized distribution or copying of this > transmission is prohibited. If you have received this message > in error, please contact the sender immediately and > delete this electronic message > and any attachments from your system. > > -- *Peggy Bauer* CAO Production Support 214-770-1782