Service Layer Setup

Note: For a WebSphere 9.0.0.9 deployment, the .jar files need to be installed only once. If Service Layer Is reinstalled, the existing files may be re-used.

1. Edit amm.filter.properties from /opt/IBM/WebSphere/AppServer/properties

2. Remove or comment the lines listed below:

#Ignore-Scanning-Archives = ant.jar, \

  • axis.jar, \
  • CICS.jar, \
  • db2java.zip, \
  • db2jcc4.jar, \
  • dfjcics.jar, \
  • ibmjndi.jar, \
  • jaxrpc.jar, \
  • jakarta.oro.jar, \
  • ldapbp.jar, \
  • mailapi.jar, \
  • msbase.jar, \
  • mssqlserver.jar, \
  • saaj.jar, \
  • wsdl4j.jar, \
  • sqljdbc.jar, \
  • struts.jar, \
  • struts-scaffold.jar

3. Add the lines listed below:

Ignore-Scanning-Archives

ant.jar, axis.jar, CICS.jar, db2java.zip, db2jcc.jar, db2jcc_javax.jar,
dfjcics.jar, ibmjndi.jar, jaxrpc.jar, jakarta.oro.jar, ldapbp.jar,
mailapi.jar, msbase.jar, mssqlserver.jar, saaj.jar, wsdl4j.jar,
sqljdbc.jar, struts.jar, struts-scaffold.jar, antisamy-1.5.3.jar,
aopalliance-repackaged-2.5.0-b32.jar, ape-11.3.1.0.jar,
backport-util-concurrent-2.2.jar, bcel-6.0.jar, bll-11.3.1.0.jar,
bval-core-1.1.2.jar, bval-jsr303-0.5.jar, cglib-nodep-3.3.0.jar,
coherence-common-12.5.0.jar, coherence-processingpattern-12.5.0.jar,
commons-beanutils-core-1.8.3.jar, commons-codec-1.10.jar, commons-configuration-1.10.jar,
commons-dbcp2-2.1.1.jar, commons-dbutils-1.7-85907f3.jar, commons-digester-1.8.jar,
commons-fileupload-1.3.1.jar, commons-httpclient-3.1.jar, commons-jxpath-1.3.jar,
commons-lang3-3.1.jar, commons-pool2-3.1.jar, cycle.agent-11.3.1.0.jar,
cycle.interface-11.3.1.0.jar, dal-11.3.1.0.jar, dcl-11.3.1.0.jar,
dom4j-2.1.3.jar, el-ri-1.2.jar, ext-11.3.1.0.jar,
extensibility-11.3.1.0.jar, FastInfoset-1.2.13.jar, freemarker-2.3.30.jar,
global.dal-11.3.1.0.jar, global.dcl-11.3.1.0.jar, global.processing-11.3.1.0.jar,
global.utl-11.3.1.0.jar, icu4j-55.1.jar, janino-3.0.7.jar, jaxb-api-2.0.jar,
jaxen-1.2.0.jar, jaxws-api-2.1.jar, jep-2.4.1.jar, jibx-bind-1.3.1.jar,
jibx-extras-1.3.1.jar, jibx-run-1.2.5.jar, krysalis-jCharts-1.0.0-alpha-1.jar,
list.txt, log4j-1.2.17.jar, mail-1.4.jar, math-11.3.1.0.jar, model-11.3.1.0.jar,
nekohtml-1.9.16.jar, pas.ape-11.3.1.0.jar, pas.bll-11.3.1.0.jar, pas.cycle-11.3.1.0.jar,
pas.dal-11.3.1.0.jar, pas.dcl-11.3.1.0.jar, pas.di.ext-11.3.1.0.jar,
pas.helper-11.3.1.0.jar, pas.model-11.3.1.0.jar, pas.oipa-11.3.1.0.jar,
pas.uip-11.3.1.0.jar, resource-11.3.1.0.jar,service.api-11.3.1.0.jar,
service.bll-11.3.1.0.jar,service.dal-11.3.1.0.jar,service.delegate-11.3.1.0.jar,
service.model-11.3.1.0.jar,service.shared-11.3.1.0.jar, saxon-9.1.0.8.jar,
saxon-dom-9.1.0.8.jar, slf4j-api-1.7.30.jar, slf4j-log4j12-1.7.30.jar,
spring-aop-5.2.9.RELEASE.jar, spring-beans-5.2.9.RELEASE.jar, spring-context-5.2.9.RELEASE.jar,
spring-core-5.2.9.RELEASE.jar, spring-expression-5.2.9.RELEASE.jar, spring-jdbc-5.2.9.RELEASE,
spring-orm-5.2.9.RELEASE.jar, spring-tx-5.2.9.RELEASE.jar, spring-web-5.2.9.RELEASE.jar,
sre.interface-11.3.1.0.jar, sre-11.3.1.0.jar, uip-11.3.1.0.jar, utl-11.3.1.0.jar,
validation-api-1.1.0.Final.jar, web-11.3.1.0.jar, xml-apis-ext-1.3.04.jar,
xws-security-3.0.jar, javax.ws.rs-api-2.0.1.jar, asm-all-repackaged-2.5.0-b32.jar

4. Create a directory on the WebSphere server to store various configuration files for ServiceLayer (e.g., /opt/oracle/ServiceLayer/ or C:\oracle\ServiceLayer).

5. Create sub-directories inside the directory from Step 4 called conf and libs.

Note: Make a note of the path to the libs directory. It will be used later in the classpath for setting up the ServiceLayer Shared Library.

6. Copy the following configuration files from Service Layer distribution zip/conf directory into the conf directory:

  • service-coherence-cache-config.xml
  • service-coherence-config.xml
  • Service.properties
  • logging.properties

7. Copy the following files from the installation media to the libs sub-directory:

  • commons-logging-1.2-9f99a00.jar

  • javax.ws.rs-api-2.0.1.jar
  • commons-collections-3.2.2.jar

  • eclipselink-2.7.4.jar

  • javax.persistence-2.1.1.jar

  • spring-instrument-5.2.9.RELEASE.jar

  • ojdbc8-12.2.0.1.jar

8. Download aspectj-1.8.10.jar from http://www.eclipse.org/downloads/download.php?file=/tools/aspectj/aspectj-1.8.10.jar

  • Open aspectj-1.8.10.jar with an unzipping software and copy aspectjrt.jar and aspectjweaver.jar from the lib folder into the libs sub-directory.

Note: Delete aspectjrt.jar from ./IBM/WebSphere/AppServer/lib

9. Download 'Coherence Stand-Alone Install' of version 12.2.1.2.0 from http://www.oracle.com/technetwork/middleware/coherence/downloads/coherence-archive-165749.html and upon execution of the jar file coherence will get installed and coherence.jar can be found in $ORACLE_HOME/coherence/lib, copy the same into libs folder.

10. Use a text editor to open the Service.properties file that you just copied to the server.

The Service.properties file contains properties for Oracle, and DB2 database types, with the Oracle settings active by default. The inactive settings are commented out with a '#' character at the start of each line. To change a setting, remove the '#' from the required property setting, and insert it at the beginning of the setting you want to de-activate.

11. The properties setting must match the type of database being used. The two properties that are used to do this are:

  • application.databaseType
  • jpa.databasePlatform

Note: For a complete list of all properties and allowed values, refer to the System Properties document available in the current release Documentation Library under Policy Administration Libraries of Oracle Help Center.

12. If using an Oracle database, please skip this step. If using a DB2 database, you will need to modify the Service.properties file to include configuration for case-insensitive searching:

  • Modify the Service.properties file to change the following line from the default setting of "false" to "true": search.field.text.caseInsensitive=true

13. Use a text editor to open the logging.properties file that you just copied to the server.

  • Edit the path mention for property "java.util.logging.FileHandler.pattern" with a new application log location i.e. if application log location is /home/ServiceLayer/logs then set this value as java.util.logging.FileHandler.pattern = %h/ServiceLayer/logs/servicelayer%u.log. Also, same time make sure that directory is created and has r/w permission.