OIPA Setup

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

  1. Edit amm.filter.properties from /opt/IBM/WebSphere/AppServer/properties.
  2. Remove or comment out the lines listed below:

    3. #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.2.12.jar, coherence-common-13.0.0.jar, coherence-processingpattern-13.0.0.jar, commons-beanutils-core-1.8.3.jar, commons-codec-1.12.jar, commons-configuration-1.10.jar, commons-dbcp2-2.6.0.jar, commons-dbutils-1.7-85907f3.jar, commons-digester-1.8.jar, commons-fileupload-1.3.3.jar, commons-httpclient-3.1.jar, commons-jxpath-1.3.jar, commons-lang3-3.9.jar, commons-pool2-2.6.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, janino-3.0.14.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.1.0.0.jar, model-11.1.0.0.jar, nekohtml-1.9.16.jar, pas.ape-11.1.0.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, saxon-9.1.0.8.jar, saxon-dom-9.1.0.8.jar, slf4j-api-1.7.26.jar, slf4j-log4j12-1.7.26.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.jar, 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

  1. 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 OIPA Shared Library.

  2. Copy the following files from the installation media into the conf sub-directory:

    • coherence-cache-config.xml
    • coherence-config.xml
    • PAS.properties
    • logging.properties
    • EDKeyValue.dat

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

    • commons-collections-4.4.2.jar

    • commons-logging-1.2-9f99a00.jar

    • el-api-2.2.jar
    • eclipselink-2.7.4.jar
    • jakarta.persistence-2.2.3.jar
    • spring-instrument-5.2.3.RELEASE.jar

  4. 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

  5. Download 'Coherence Stand-Alone Install' of version 12.2.1.3.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.

  6. Download log4j-1.2.17.jar from https://archive.apache.org/dist/logging/log4j/1.2.17/log4j-1.2.17.jar and copy it to libs sub-directory.

  7. Use a text editor to open the PAS.properties file that you just copied to the server.

    The PAS.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.

  8. 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: Refer to the latest System Properties document in the Oracle Insurance Policy Administration Documentation Library published on the OHC for a complete list of all properties and allowed values.

  9. Identify the default locale in the PAS.properties file. The locale selected will determine the translation that is loaded in the database for OIPA when it launches. The default setting is English.

    • application.defaultLocale

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

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

  11. 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 new application log location i.e. if application log location is /home/OIPA/logs then set this value as java.util.logging.FileHandler.pattern = %h/OIPA/logs/oipa%u.log. Also same time make sure that directory is created and has r/w permission.

Web Application Utility Setup

  1. Create a directory on the WebSphere server to store various configuration files for the Web Application Utility (i.e., /opt/oracle/paletteconfig/ or C:\oracle\paletteconfig).
  2. Create sub-directories inside the directory from Step 1 called conf, libs and uploads.
  3. Create a file PaletteWebApplication.properties in the conf subdirectory.
  4. Open the PaletteWebApplication.properties file and add/edit the download.dir property to point to the uploads subdirectory created in Step 2.