Additional Information
Application managed database connection #
Complete the following steps to set up application managed connections to the database.
- Define and test a database connection in the file
sics-database-sources.xmlused by SICS workstation. - On success, copy the connection entry to file
%CATALINA_HOME%/webapps/SicsServer/WEB-INF/classes/sics-database-sources.xml - Copy the required JDBC jar(s) into
%CATALINA_HOME%/webapps/SicsServer/WEB-INF/lib(similar to the same step for 3.1 “Configure database connection”) - Uncomment and specify the following servlet init-parameters in
%CATALINA_HOME%/webapps/SicsServer/WEB-INF/web.xml:
| Parameter | Description | Required |
|---|---|---|
| DATABASE | The name attribute of the connection specified in %CATALINA_HOME%/webapps/SicsServer/WEB-INF/classes/sics-database-sources.xml |
Yes |
| USER | Database user name, same as you would enter in the login screen in SICS Workstation. | Yes |
| PASSWORD | Database password of the user described above. The password may be encrypted. In the SICS installation folder, there is a file named encrypt.bat. This bat file takes a plain-text string (the password) as input, calls a SICS utility program and outputs an encrypted version of the string. This encrypted value will always be prefixed with % so as to later recognize it as an encrypted value. Such an encrypted password can be provided in the PASSWORD field in web.xml. Remember to include the % prefix. |
Yes |
| ENVIRONMENT | Database schema with SICS data, see closer description under 3.1 “Configure database connection”. | No |
| OS_AUTHENTICATION | Set to Y (for Yes) to use OSAUTHENTICATION (in which case the above PASSWORD is not needed) or N (for No) to use a PASSWORD-authenticated login. The authentication method depends on how the USER is defined in the [Oracle or SQL Server] database server. |
No |