-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Mark,
On 3/5/14, 8:56 AM, Mark Thomas wrote: > On 05/03/2014 13:38, Christopher Schultz wrote: >>>> My DataSource configuration: > >>>> <Resource name="jdbc/diagnosis" description="JDBC connection >>>> to main CHADIS database" auth="Container" >>>> type="javax.sql.DataSource" maxActive="1" maxIdle="1" >>>> maxWait="10000" url="[url]" username="[user]" >>>> password="[user]" driverClassName="com.mysql.jdbc.Driver" >>>> removeAbandoned="true" removeAbandonedTimeout="30" >>>> logAbandoned="true" testOnBorrow="true" validationQuery="/* >>>> ping */ SELECT 1" /> > >>>> Note that I have a single database connection in the pool. > >>> Not with DBCP 2 you don't. maxActive has been renamed to >>> maxTotal so you'll have the default (8 from memory) >>> connections in the pool. This is likely to be a common problem. >>> We probably need to add something to catch this, report a >>> warning and set the correct attribute. > >> Okay, I'll take a look at that. What I can observe practically >> is that only a single connection to my MySQL database has been >> made, whatever the reason. Perhaps that's part of the trouble. > > Hmm. I don't recall exactly when this was renamed in DBCP 2. It is > always possible the build you are using does what you think it > does. I checked the configuration reference for DBCP 2, and two important configuration properties were renames: maxActive->maxTotal and maxWait->maxWaitMillis. When a connection couldn't be obtained (for whatever reason... possibly POOL-248), the checkout was waiting forever instead of timing-out after 10 seconds. I'm re-testing with the modified configuration, but still with a stock 8.0.3. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJTFzk3AAoJEBzwKT+lPKRYAs0P/0/nCg1LQnTnemwrDgExFkXW HtONMDSyJE77UrIemf+apSBq0OU34Vym4tBJf8asx+kyRSZifVWQp01lzl9CPZm7 d5RIfbsvfCimafsKGipqAFskNeFNCXH6RNEMwcAR0gMBijIlQd0IArL9OOuSJVHA OrYaq38Yi56Tq2ENcjDTn+fjyJ/IEcluNuoI2lBqgTM3UmRxF1ItjditTzTkC4NW oc3BLguoyOokOymJ9AQn2PuP0EtrrwnWS69Q/HiKaNLmrawVGDqoA2QDjlZF3XkM Q2hP4EJSoDPFxIrTF+JiEv6pPt2PbtlC+JrjT04tJdnApl29Q2zalHdnudOSO9M5 80ivyU7mEgW1gwR5m48FKGZGB8l5UkQu+RdvvhvTfipqmN5rdqP/NjSsRok13YiV HqE3g/8bcAMejDAjl916xa68npRXQLHPmKJMMSoc6Ri731INKflsAukScc5EIMmi BI/EiJXgyNUK2L5MaWGgjrHNyzIlo1v8WFZAoMw0u5BtnNeWRSs/TE43sYUuiosu FC8mJzg6U0f1CdSCCuIvm7Z3BwK4x9VW8ox30DomPA3Fs+p8O3PwAhLfjGEnMfDN YgBmgS1WcXEfCQZZ5+VLrW7IiVotUB+3rY+Fd6Alo/vweXf230jJWIMY+BMa86rD kk30PQpoyViGIztqxyHZ =SLmC -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
