User Tools

Site Tools


installation:04-ms-sql

MS SQL Database

Overview

If you want to use MS SQL database instead of default PostgreSQL, you need to change the following modules in default installation:

  • AIM.war
  • proof-code-admin.war
  • proof-code-user.war
  • proof-form-admin.war
  • proof-form-user.war
  • aducid-useradmin.war
  • ADUCID.properties

All modified files (except ADUCID.properties, where you need to enter your MSSQL DB hostname) are already prepared on distribution DVD in the /root/mssql directory of the virtual machine.

List of modifications

AIM.war

In the directory /opt/tomcat/webapps/AIM/WEB-INF, the file spring-resources.xml_mssql has been renamed to spring-resources.xml

Other .war files

In the directory WEB-INF/lib, the file provider-shared-*.jar has been modified.

This file contains several files named dispatcher-servlet-provider-shared.xml*. The file dispatcher-servlet-provider-shared.xml_mssql was renamed to dispatcher-servlet-provider-shared.xml

ADUCID.properties

You need to change syntax of database specification (default is commented with #)

#DB_AIM_NAME=aim
DB_AIM_NAME=//[hostname];databaseName=aim;

#DB_PROVIDER_NAME=provider
DB_PROVIDER_NAME=//[hostname];databaseName=provider;

installation/04-ms-sql.txt · Last modified: 2020/03/25 21:16 by mpospisek