Re: error creating connection pool
Am 13. Februar 2018 15:20:00 MEZ schrieb "Bruce L. Riddle" : >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? Have you looked in other log files for error messages? I can only guess some possible misinformed from the given one (which I believe is a message generated by the app and not tomcat) Check that * you have configured a database resource * the DB resource has the correct name (equal to the one configured in your app) * you have placed the db driver jar in a directory the app or rather tomcat expects it Regards, Felix > > >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. - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: [E] error creating connection pool
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. 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
error creating connection pool
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.