Configuring Frevvo v7.3.2 Database on SQL Server

This forum post will be applicable if you want to use SQL Server as a Frevvo Database for configuring the Rich Form v7.3.2 in Adeptia Suite.

In case, you are using SQL as a backend database then it is mandatory to change the jar. The compatible version of SQL jar (mssql-jdbc-6.1.4.jre8-preview.jar) with Rich Form 7.3.2 can be downloaded from this forum post. The Steps to change the jar file are written below:

1. Stop Kernel and WebRunner. 
2. Go to the  .../<AdeptiaInstallFolder>\AdeptiaServer\ServerKernel\dependency
3. Search for 'mssql-jdbc-7.4.1.jre8.jar' file and delete it.
4. Now, copy the downloaded "mssql-jdbc-6.1.4.jre8-preview.jar" file and paste it here.

After updating the jar, you need to replace the jar entry in the KernelClasspath.txt and WebRunnerClasspath.txt files. Follow the steps below:

1. Go to the  .../<AdeptiaInstallFolder>\AdeptiaServer\ServerKernel\etc
2. Open KernelClasspath.txt and WebRunnerClasspath.txt file in edit mode.
3. Search for 'mssql-jdbc-7.4.1.jre8.jar' entry and replace it with 'mssql-jdbc-6.1.4.jre8-preview.jar'.
4. Save both the files. 

After updating the jar, you need to replace the jar entry in the logs-archive-cleanup.bat (for Windows) or logs-archive-cleanup. sh (for Linux) file. Follow the steps below:

1. Go to folder ...\AdeptiaServer\ServerKernel.
2. Open logs-archive-cleanup.bat (For Windows) or logs-archive-cleanup.sh(For Linux) file in edit mode.
3. Replace the 'mssql-jdbc-7.4.1.jre8.jar' entry with 'mssql-jdbc-6.1.4.jre8-preview.jar'.
4. Save the file. 
5. Start Kernel and Webrunner.