Appendix A - Deployment in IBM WebSphere Application server

1 minute read

Required knowledge

This is not an introduction to IBM WebSphere administration, the user must as a minimum know how to:

  • Open and log into the Integrated Solutions Console.
  • Create a JDBC data source and install JDBC drivers
  • Create JDBC login credentials
  • Install an Enterprise Application

Refer to official IBM WebSphere documentation and support for assistance.

  • Carry out the configuration steps described in section 7 “Configure the SICS API Server environment”. Modifications to web.xml and other files must be carried out in the SicsServer.war file directly. All file path references in the instructions should therefore be read as the files within SicsServer.war.
  • Log in to the WebSphere Integrated Solutions Console
  • Create a JDBC datasource for SICS, including JDBC provider if required
  • Create JDBC login credentials for the database user used by SICS API Server
  • Install SicsServer.war as an Enterprise Application; make sure to set up the resource reference for the JDBC data source.
  • Start the Enterprise Application
  • After SICS API Server is started, carry out the verification steps described in section “Verify Correct Startup of SICS API Server”. NB: If the entry for SICSServerJNDI in sics-database-sources.xml is set up to use parameterized SQL then statement cache size should be set to 0. Statement cache size should instead be set up in WebSphere. Furthermore if the data source is an Oracle data source in combination with parameterized SQL, then the custom property, connectionProperties must be added and set to fixedString=true, for the Oracle data source. The property should be defined like this in the WebSphere Integrated Solutions Console:

image15.png

Figure 25 - WebSphere Connection Properties

Deploy Procedure with Application Managed Database Connection

  • Carry out the configuration steps described in section 7 “Configure the SICS API Server environment” and 10.1 “Application managed database connection”. The JDBC driver jars and modifications should be added/updated directly in SicsServer.war. All file path references in the instructions should therefore be read as the files within SicsServer.war.
  • Log in to the WebSphere Integrated Solutions Console
  • Install SicsServer.war as an Enterprise Application
  • Start the Enterprise Application
  • After SICS API Server is started, carry out the verification steps described in section “Verify Correct Startup of SICS API Server”.