Tomcat 8 Connection Reset Issue

[Theo Sweeny]

Hello - we are running Tomcat v8.0.21 on RH7 with Java7.


Recently we changed the datasource's to use connection pooling but as a result 
we are seeing connection timeouts in the logs as seen here -


2016-03-24 16:27:36,638 14321113 [http-nio-20180-exec-3] INFO  
org.springframework.security.oauth2.provider.endpoint.TokenEndpoint 
Correlation-Identifier=77063426-8942-4259-aafd-cd9bc1d03305, 
Timestamp=2016-03-24T14:54:46.084Z - Handling error: ResourceAccessException, 
I/O error on POST request for 
"https://localhost:8080/membership/programmes/ATRP/member-identification":Connection
 reset; nested exception is java.net.SocketException: Connection reset


The timeouts occur about every 1 in 3 attempts.


Here is the new datasource config -


<Resource name="jdbc/MyDataSource"
        auth="Container"
        factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
        type="javax.sql.DataSource"
        driverClassName="oracle.jdbc.OracleDriver"
        url="jdbc:oracle:thin:@myhost:1521:MYSID"
        username="MYUSER"
        password="xxxxxxxxx"
        removeAbandoned="True"
        removeAbandonedTimeout="30"
        logAbandoned="True"
        abandonWhenPercentageFull="0"
        testOnBorrow="True"
        testOnReturn="False"
        testWhileIdle="True"
        maxActive="32"
        initialSize="8"
        maxIdle="8"
        minIdle="8"
        minEvictableIdleTimeMillis="15000"
        validationQuery="select 1 from dual"
        validationInterval="15000"
        validationQueryTimeout="15"
        timeBetweenEvictionRunsMillis="15000"
        logValidationErrors="True"
        
jdbcInterceptors="ConnectionState;StatementFinalizer;SlowQueryReport(threshold=1500);QueryTimeoutInterceptor(queryTimeout=10),ResetAbandonedTimer"
        maxWait="-1"/>

Are there any conflicts within this config that could be resulting in this 
issue?


Thank you,


Theo

Avios Group (AGL) Ltd is a limited company registered in England (registered 
number 2260073 and VAT number 512566754) whose registered address is Astral 
Towers, Betts Way, London Road, Crawley, West Sussex RH10 9XY . Avios Group 
(AGL) Limited is part of the IAG group of companies This email and any files 
transmitted with it are confidential and intended solely for the use of the 
individual or entity to whom they are addressed. If you have received this 
email in error please notify the system manager.