This is an old revision of the document!
If you want to use MS SQL database instead of default PostgreSQL, you need to change the following modules in default installation:
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.
In the directory /opt/tomcat/webapps/AIM/WEB-INF, the file spring-resources.xml_mssql has been renamed to spring-resources.xml
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
You need to change syntax of database specification (default is commented with #)
1 2 |
#DB_AIM_NAME=aim DB_AIM_NAME= // [ hostname ];databaseName=aim; |
1 2 |
#DB_PROVIDER_NAME=provider DB_PROVIDER_NAME= // [ hostname ];databaseName=provider; |
Do ADUCID.properties se dává pouze druhá polovina řetězce pro připojení do DB - v případě MS SQL tedy [hostname];databaseName=aim;. V konfiguraci je druhá polovina - jdbc:sqlserver:.