Installing and deploying EcoSys on IBM WebSphere Application Server
Setting the Java Heap Size and JVM Arguments
-
From the WebSphere Application Server Administration Console expand Servers > Server Types and select WebSphere Application Servers.
-
Select the server to run EcoSys, then under Server Infrastructure, expand Java and Process Management, and select Process Definition.
-
Under Additional Properties, select Java Virtual Machine.
-
Set the initial heap size and max heap size according to the EcoSys Server Sizing Recommendations.
-
Add the following to the Generic JVM Arguments
-DESFM_HOME=C:\EcoSys\ESFM_HOME
Create user/password for the database java connection
-
Expand Security and select Global Security.
-
Expand Java Authentication and Authorization Service and select J2C authentication data. Click New.
-
Enter the fmuser credentials created during database creation. Default is fmuser/fmuser.
Adding EcoSys as a Shared Library on WebSphere
-
Expand Environment, and select Shared Libraries.
-
Select the shared library scope and click New.
-
Enter a name ecosys for the shared library name.
-
In the Classpath text box add the required library files as following:
C:\EcoSys\alt\lib\intgserver-wrapper.jar
C:\EcoSys\alt\lib\log4j-1.2.17.jar -
Click OK and Save.
Adding JDBC Provider in WebSphere – Microsoft SQL Database
-
Expand Resources and JDBC then select JDBC Providers.
-
Select the Scope of the JDBC provider and click New.
-
Select SQL Server as the Database type, Provider type as Microsoft SQL Server JDBC Driver and Implementation type as Connection pool data source, and click Next.
-
Enter the folder location of the sqljdbc.jar file which is saved as WebSphere variable ${MICROSOFT_JDNC_DRIVER_PATH}. Click Next, and Finish.
Adding the Data Source in WebSphere – Microsoft SQL Database
-
Expand Resources > JDBC > Data Sources and click New.
-
Enter the information below and click Next.
Datasource Name: ecosys
JNDI Name: jdbc/esfm -
Select an existing JDBC provider and select the JDBC provider created in the previous step. Click Next.
-
Enter the database specific details for the data source and click Next.
-
Enter the security aliases information as shown below.
Component-Managed authentication alias, choose: fmuser
Mapping-configuration alias: leave as ‘none’
Container-managed authentication alias, choose: fmuser -
Click Next, click Finish, and click Save.
-
Check the box next to the datasource and click Test Connection.
Setting Default Isolation Level (Microsoft SQL Database)
-
Make sure the default isolation level of the data source is set to 2 as per this article:
http://www-01.ibm.com/support/knowledgecenter/SS7JFU_7.0.0/com.ibm.websphere.express.iseries.doc/info/iseriesexp/ae/cdat_isolevel.html?cp=SS7JFU_7.0.0%2F2-8-7-2-2
-
Skip to the section on Deploying the EcoSys Application on WebSphere below.
Adding JDBC Data Source in WebSphere – Oracle Database
-
Expand Resources and JDBC and select JDBC Providers.
-
Select the Scope of the JDBC provider and click New.
-
Select Oracle as the database type, Provider type as Oracle JDBC Driver and Implementation type as Connection pool data source. Click Next.
-
Enter the folder location of the ojdbc6.jar file. Click Next and then Finish.
Adding the Data Source in WebSphere – Oracle Database
-
Expand Resources > JDBC > Data Sources and click New.
-
Enter the information below and click Next.
Datasource Name: ecosys
JNDI Name: jdbc/esfm -
Select an existing JDBC provider and select the JDBC provider created in the previous step. Click Next.
-
Type the URL for the database, replace the server name, port number and SID to match the database settings jdbc:oracle:thin:@servername:port:databaseName and click Next.
-
Enter the security aliases information as shown below.
Component-Managed authentication alias, choose: fmuser
Mapping-configuration alias: leave as ‘none’
Container-managed authentication alias, choose: fmuser -
Click Next, click Finish and click Save.
-
Check the box next to the datasource and click Test Connection.
Deploying the EcoSys Application on WebSphere
-
Expand Applications > Application > WebSphere Enterprise Applications and click Install.
-
Select Browse and choose the ecosys.ear (from C:\EcoSys\deploy). Click Next.
-
Leave the default Fast Path selected and click Next.
-
Check the box for Precompile JavaServer Pages files and click Next.
-
On the Map resource references to resources screen click Browse.
-
Select the EcoSys JNDI and click Apply and then Finish.
-
-
Check the box to map the module to the server and click Next and then Finish.
-
After the application has finished deploying click the Save at the bottom.
Map Resource References to Resources.
-
Select the EcoSys enterprise application, and select shared library references under references.
-
Check the EcoSys application and click Reference Shared Libraries.
-
Highlight the available ecosys library and click the arrow so it moves to the selected box. Click OK.
-
Check the EcoSys Application module and click Reference Shared Libraries.
-
Highlight the available EcoSys library and click the arrow so it moves to the selected box. Click OK.
-
Click OK and Save.
Start the EcoSys Application
-
Expand Applications > WebSphere enterprise applications.
-
Check the box next to ecosys, and click Start.