Configuring Tomcat for EcoSys - EcoSys - 9.1 - Installation & Upgrade - Hexagon

This configuration was done using the Tomcat Windows Service Installer.

Java Options and Heap Sizes

1. Navigate to ...\Program Files\Apache Software Foundation\Tomcat\bin and run Tomcat9w.exe

   The Java Virtual Machine listed will match the one selected during Tomcat installation.

   

2. Add the following java option:

   -DESFM_HOME=C:\EcoSys\ESFM_HOME

3. Set the initial memory pool and the maximum memory pool to the size recommended in the EcoSys Server Sizing Recommendations document. The defaults are not sufficient to run EcoSys.

Adding the JDBC Connection

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

   1. Choose the database connection string below that matches the database platform and copy and paste it above the closing </host> tag.

   2. Modify the url and password as necessary..

   For Oracle:

   <!-- ESFM webapp Context -->

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

   <Resource name="jdbc/esfm" auth="Container" type="javax.sql.DataSource"

   maxTotal="200" maxIdle="10" maxWaitMillis="-1" removeAbandonedOnBorrow="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"

   maxTotal="200" maxIdle="10" maxWaitMillis="-1" removeAbandonedOnBorrow="true" removeAbandonedTimeout="1200"

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

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

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

   </Context>

Copying the Library Files

1. Copy the intgserver-wrapper.jar from the ...C:\EcoSys\alt\lib folder to the \Program Files\Apache Software Foundation\Tomcat\lib folder.

2. Copy the correct database JDBC driver into ...\Program Files\Apache Software Foundation\Tomcat\lib folder.

   If Primavera API is being used, refer to EcoSys Primavera P6 Adapter Installation

3. Copy the correct database JDBC driver into ...\Program Files\Apache Software Foundation\Tomcat\lib folder.

   JDBC driver version does not depend on Ecosys version, but on the Database server version and the Java version installed on the Application Server.

   To locate the correct JDBC jar file:

   • For Microsoft SQL Server, to view the supported versions of Microsoft SQL JDBC Driver, go to https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16 along with Support Matrix against Java Version and SQL Database version.

     • To download the latest jar file that is compatible with the JDK Version and Database version being used, go to https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16#previous-releases and place the jar file in the ...\Program Files\Apache Software Foundation\Tomcat\lib folder.

   • For Oracle databases, to view the supported version of the ORACLE JDBC, go to https://www.oracle.com/in/database/technologies/appdev/jdbc-downloads.html

     • Download the latest jar file that is compatible with the JDK Version and Database version being used from the page and the jar file in the ...\Program Files\Apache Software Foundation\Tomcat\lib folder.

Deploying EcoSys

1. Copy the ecosys.war file from the C:\EcoSys\deploy folder into the ...\Program Files\Apache Software Foundation\Tomcat\webapps folder.

2. Start Tomcat.

3. Skip to the Validate EcoSys Installation.