-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Theo,
On 3/24/16 1:19 PM, Theo Sweeny wrote: > 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-identificati on":Connection > > reset; nested exception is java.net.SocketException: Connection > reset That looks like an error with a Spring-related component, not Tomcat. (Right?). There are plenty of folks here who might be able to answer this question, but I think this is actually off-topic for this list. (No problem; carry on. Just pointing it out). > 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(t hreshold=1500);QueryTimeoutInterceptor(queryTimeout=10),ResetAbandonedTi mer" > > maxWait="-1"/> > > Are there any conflicts within this config that could be resulting > in this issue? I don't believe your JNDI DataSource has anything to do with making outgoing connections to OAuth providers... - -chris -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEYEARECAAYFAlb0Qx0ACgkQ9CaO5/Lv0PA7KACfYVLubbNfIxKrInh9SNwY/JHf h+kAnRRevkPjZBdCl0RD53QdtsndtXGe =h3bQ -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
