Specify Database Environment

Specify Database Environment

If the SICS Batch Server data is stored in a schema which is not default for the user logged in to the database, the SQL statements issued by the application requires prefixes to table and view names.

If such a prefix is required:

  1. Open WEB-INF/web.xml inside sbs.war.
  2. Change the param-value for ENVIRONMENT to SQL schema.

For example if the schema prefix is SICSPROD it should be:

<init-param>
  <param-name>ENVIRONMENT</param-name>
  <param-value>SICSPROD</param-value>
</init-param>