Service Layer Setup

  1. Create a directory on the WebLogic server to store various configuration files for ServiceLayer (i.e., /opt/oracle/serviceLayer/ or C:\oracle\serviceLayer).
  2. Create subdirectories inside the directory from Step 1 called conf, libs, and war.
  3. Copy PASService-weblogic.warfile from the Service Layer distribution zip file into the war subdirectory
  4. Copy the following configuration files from Service Layer distribution zip/conf  directory into the conf directory:
    1. service-coherence-cache-config.xml
    2. service-coherence-config.xml
    3. Service.properties
    4. logging.properties
  5. Copy the following files from the Service Layer distribution zip/libs directory into the libs directory:
    1. commons-logging-1.2-9f99a00.jar
  6. Copy the below jars from Oracle Installation directory (path as mentioned below) to the libs folder.
    1. .. ../Middleware/Oracle_Home/oracle_common/modules/oracle.osdt/osdt_core.jar
    2. .. ../Middleware/Oracle_Home/oracle_common/modules/oracle.osdt/osdt_cert.jar
    3. .. ../Middleware/Oracle_Home/oracle_common/modules/oracle.pki/oraclepki.jar
    4. .. ../Middleware/Oracle_Home/coherence/lib/coherence.jar
  7. Create a directory to store database driver jar files for ServiceLayer(i.e., /opt/oracle/db_drivers/ or C:\oracle\db_drivers).
  8. Copy the database drivers for your database into this directory.
    1. Oracle - the necessary driver, ojdbc8-12.2.0.1.jar, is included in the libs directory of the OIPA Media Pack.
    2. Microsoft SQL Server – download the sqljdbc4.jar library version 4.0  from  https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4/4.0 
    3. IBM DB2 – the two necessary .jar files (db2jcc4 and db2jcc4_license_cu) are included with the purchase of the DB2 software. These files are not available for download. Contact your IT department if you need assistance locating these files.
  9. 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, SQL Server 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.
  10. The properties setting must match the type of database being used. 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.
    1. application.databaseType
    2. jpa.databasePlatform

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

    4. Edit the path mention for property "java.util.logging.FileHandler.pattern" with 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.

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

  12. Edit the path mention for property "java.util.logging.FileHandler.pattern" with 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.