Re: error creating connection pool

2018-02-22 Thread Felix Schumacher


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

2018-02-13 Thread Bauer, Margaret M (Peggy)
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

2018-02-13 Thread 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?


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.