During the setup procedures of ARIS server using Oracle or Microsoft SQL Server the JDBC driver is provided automatically. You can enhance JDBC drivers manually.
Procedure
Download the JDBC driver from the Microsoft or Oracle Web Sites to a local directory that can be accessed by ARIS Cloud Controller (ACC).
For example: d:\ojdbc<number>.jar.
Enter stopall.
Enhance all related runnables with the new driver in turn. If you have blanks or special characters in the path, you must put it in quotes and use a double backslash instead of a single slash.
Enter:
enhance abs_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance adsadmin_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance apg_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance copernicus_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance umcadmin_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance octopus_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance ecp_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance dashboarding_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
enhance simulation_<s,m,l> with webappsClasspath local file "d:\\ojdbc<number>.jar"
The new file is copied to the <ARIS installation directory>\server\bin\work\work_<runnable>_<s,m,l>\base\lib. The source file can be deleted.
Delete obsolete JDBC driver files from the <ARIS installation directory>\server\bin\work\<runnable>_<s,m,l>\base\lib. If you add the latest file to update your JDBC driver with the enhance ACC command, both driver files, the obsolete file and the latest file are present. As a result, runnables will not start correctly because the JDBC driver to be used cannot be determined.
Start the server runnables. Enter: startall
The driver is available.