Re: Tomcat 8 DB Connection Pooling

2015-06-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Douglas, On 6/12/15 8:13 PM, Douglas Schaible wrote: > Hi Chris, > > I have the connection pool defined in /etc/tomcat8/context.xml. Is > that the wrong place the define it? Most likely. That file (if I'm guessing correctly about your package man

Re: Tomcat 8 DB Connection Pooling

2015-06-12 Thread Douglas Schaible
Hi Chris, I have the connection pool defined in /etc/tomcat8/context.xml. Is that the wrong place the define it? Is what is defined there being copied into each application? I underplayed some sample application and I am now seeing 10 time the number of apps being deployed DB connections.

Re: Tomcat 8 DB Connection Pooling

2015-06-12 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Douglas, In addition to what Filip posted... On 6/11/15 12:18 PM, Douglas Schaible wrote: > Good Day All, > > I am having a problem with a connection pool and I was hoping for > some guidance. > > I have defined the connection pool below for two

Re: Tomcat 8 DB Connection Pooling

2015-06-11 Thread Filip Hanik
Configuration reference: https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html On Thu, Jun 11, 2015 at 6:58 PM, Filip Hanik wrote: > set the properties > > logAbandoned="true" > removeAbandoned="true" > removeAbandonedTimeout="60" (value is in seconds, should be larger than > your longest runn

Re: Tomcat 8 DB Connection Pooling

2015-06-11 Thread Filip Hanik
set the properties logAbandoned="true" removeAbandoned="true" removeAbandonedTimeout="60" (value is in seconds, should be larger than your longest running transaction) timeBetweenEvictionRunsMillis="15000" (value is in milliseconds) if you have a leak (meaning your code is not returning the conne

Tomcat 8 DB Connection Pooling

2015-06-11 Thread Douglas Schaible
Good Day All, I am having a problem with a connection pool and I was hoping for some guidance. I have defined the connection pool below for two deployed applications to use. When I bounce the server I can see that it immediately crates 100 connections to the DB. (I am ok with this, but that i