Hi Everyone, I have a couple of issues with the in-build Tomcat connection pooling under Tomee 1.6.0 Plus.
I am defining everything in conf/tomee.xml <Resource id="database" type="javax.sql.DataSource"> jdbcDriver = com.mysql.jdbc.Driver jdbcUrl = jdbc:mysql://0.0.0.0:0000/db-name userName = username password = password jtaManaged = false accessToUnderlyingConnectionAllowed = true connectionProperties = autoReconnect=true;characterEncoding=UTF-8; defaultAutoCommit = true timeBetweenEvictionRunsMillis=5000 initialSize = 3 maxActive = 100 maxIdle = 100 maxOpenPreparedStatements = -1 maxWaitTime = 10000 millisecond MinEvictableIdleTimeMillis = 60000 minIdle = 4 numTestsPerEvictionRun = 5 passwordCipher = PlainText poolPreparedStatements = true testOnBorrow = true testOnReturn = false testWhileIdle = true validationQuery = SELECT 1; validationInterval = 30000 maxConnLifetimeMillis = 300000 timeBetweenEvictionRunsmillis = 30000 removeAbandoned = true removeAbandonedTimeout = 300 logAbandoned = true </Resource> looking at this is jconsole, some of the settings are not being applied; MinEvictableIdleTimeMillis = 60000 timeBetweenEvictionRunsmillis = 5000 This seems to be causing the poolsweeper not to be enabled, which is not removing old connections from the pool etc. Is anyone else seeing this issue? I can supply more screenshots if required. -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au
