Hello gentle beings, I have a couple of application teams having issues since getting upgraded to Tomcat 9.0.71. The main one has to do with an application that has run fine in the past is now exceeding max cursors with their Oracle Database datasource. They are using spring framework to control the Database operations. Here is what their resource looks like:
<Resource name="jdbc/f***" auth="Container" type="javax.sql.DataSource" maxTotal="100" maxIdle="30" maxWaitMillis="15000" username="${datasource.fm.username}" password="${datasource.fm.password}" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@(Description=(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(FAILOVER=ON)(ADDRESS=(PROTOCOL=tcp)(HOST=***************)(PORT=3203))(ADDRESS=(PROTOCOL=tcp)(HOST=*****************)(PORT=3203)))(CONNECT_DATA=(SERVICE_NAME=ceofm_u)))"/> Here is an error from the log file: [3/2/2023 1:50 PM] Burgos, Maria D.: here is the error in catalina.out 02-Mar-2023 13:05:30.944 SEVERE [https-jsse-nio-28443-exec-8] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [f***servlet] in context with path [/f***] threw exception [Request processing failed; nested exception is com.wellsfargo.fms.common.exception.FMSException] with root cause com.wellsfargo.f**.common.exception.F**Exception at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) The other team is having performance issues when using static .jar resources in their war file. One part of the app, on the browser side measurements, is taking 2.2 minutes to load. This started getting worse after moving to 9.0.71. Are there any known issues that could be causing this? Currently waiting for 9.0.73 to get release. :) Thank you, Dream * Excel * Explore * Inspire Jon McAlexander Senior Infrastructure Engineer Asst. Vice President He/His Middleware Product Engineering Enterprise CIO | EAS | Middleware | Infrastructure Solutions 8080 Cobblestone Rd | Urbandale, IA 50322 MAC: F4469-010 Tel 515-988-2508 | Cell 515-988-2508 jonmcalexan...@wellsfargo.com<mailto:jonmcalexan...@wellsfargo.com> This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.