User Tools

Site Tools


installation:04-ms-sql

This is an old revision of the document!


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.1585170997.txt.gz · Last modified: 2020/03/25 21:16 by mpospisek