Upgrading the EcoSys Application on Tomcat - EcoSys - 9.4 - Installation & Upgrade - Hexagon

If you are upgrading from EcoSys 9.3 and prior, ensure that you first have upgraded Tomcat to version 10.1.

Use the following steps to update the EcoSys web application on the Tomcat application server.

1. Stop the Tomcat service.

2. Delete the following folders:

   • <TOMCAT_HOME>\work\Catalina\localhost\ecosys

   • <TOMCAT_HOME>\webapps\ecosys

3. Replace the ecosys.war file in <TOMCAT_HOME>\webapps with the ecosys.war file in the \deploy folder of the EcoSys application/upgrade package.

4. Review the JDBC Settings

   1. Go to ...\Program Files\Apache Software Foundation\Tomcat\conf and open the server.xml with a text editor.

   2. Choose the database connection string below that matches the database platform

   3. Review the current recommendations and modify the existing server.xml to match the new recommendations

   For Oracle

   <!-- ESFM webapp Context -->

   <Context path="/ecosys" docBase="ecosys" debug="0" crossContext="true">

   <Resource name="jdbc/esfm" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"

   maxActive="200" maxIdle="10" maxWait="1200000" removeAbandoned="true" removeAbandonedTimeout="1200"

   logAbandoned="true" username="fmuser" password="xxxxxx"

   driverClassName="oracle.jdbc.OracleDriver"

   url="jdbc:oracle:thin:@localhost:1521:global" accessToUnderlyingConnectionAllowed="true"

   testOnBorrow="true" validationQuery="SELECT 1 FROM DUAL" validationQueryTimeout="2"

   </Context>

   For MSSQL

   <!-- ESFM webapp Context -->

   <Context path="/ecosys" docBase="ecosys" debug="0" crossContext="true">

   <Resource name="jdbc/esfm" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"

   maxActive="200" maxIdle="10" maxWait="1200000" removeAbandoned="true" removeAbandonedTimeout="1200"

   logAbandoned="true" username="fmuser" password="xxxxxx"

   driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"

   url="jdbc:sqlserver://localhost:1433;database=esfm" accessToUnderlyingConnectionAllowed="true" testOnBorrow="true"/>

   </Context>

5. Start the Tomcat service.

To upgrade from Ecosys 8.8 or prior versions to Ecosys 9.0 or greater, refer to Upgrading from EcoSys 8.8 or prior to EcoSys 9.0 or greater (see Upgrading from EcoSys prior versions to EcoSys 9.0 or greater).

Remove the Java option -XX:MaxPermSize if previously set, as it is no longer required.