On 02/03/2023 21:54, jonmcalexan...@wellsfargo.com.INVALID wrote:
Hello gentle beings,

I have a couple of application teams having issues since getting upgraded to 
Tomcat 9.0.71.

Upgrading from which Tomcat version?

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)

Any chance we can see a root cause for that? Something from the JDBC driver?

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. :)

Do you mean static resources stored in a JAR's META-INF/resources directory?

Is the WAR deployed in packed or unpacked form?

Mark

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to