<div dir="ltr">I am having trouble trying to connect to an Oracle database using the Database table connector v1.4.4.0<div><br></div><div>I have already downloaded the ojdbc8.jar file and have placed it in the locations below:</div><div><br></div><div>[root@midPointDemo var]# find / -name ojdbc8.jar<br>/opt/midpoint-4.2/var/lib/ojdbc8.jar<br>/opt/midpoint-4.2/var/ojdbc8.jar<br>/opt/midpoint-4.2/lib/ojdbc8.jar</div><div><br></div><div>-----------------------------------------------------------------------------</div><div>Below is my service file that I use to run midpoint:</div><div><br></div><div>[Unit]<br>Description=MidPoint Standalone Service<br>[Service]<br>User=midpoint<br>WorkingDirectory=/opt/midpoint-4.2<br>ExecStart=/usr/bin/java -Xmx2048m -Dmidpoint.home=/opt/midpoint-4.2/var -jar /opt/midpoint-4.2/lib/midpoint.war<br>SuccessExitStatus=143<br>[Install]<br>WantedBy=multi-user.target<br></div><div><br></div><div>---------------------------------------------------------------------------------</div><div>This is the config I am using for the class path</div><div><br></div><div><gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver><br></div><div><br></div><div>I have also tried oracle.jdbc,driver.OracleDriver and neither are working.  The error I am getting is:</div><div><br></div><div><dt id="gmail-id4ee" style="box-sizing:border-box;line-height:1.42857;font-weight:700;float:left;width:100px;clear:left;text-align:right;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Operation</dt><dd style="box-sizing:border-box;line-height:1.42857;margin-left:130px;word-break:break-word;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><span id="gmail-id4ef" style="box-sizing:border-box;font-weight:700">ICF schema</span></dd><dt id="gmail-id4f0" style="box-sizing:border-box;line-height:1.42857;font-weight:700;float:left;width:100px;clear:left;text-align:right;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Message</dt><dd id="gmail-id4f1" style="box-sizing:border-box;line-height:1.42857;margin-left:130px;word-break:break-word;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Configuration error: JDBC Driver is not found on classpath.</dd><dd style="box-sizing:border-box;line-height:1.42857;margin-left:130px;word-break:break-word;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><table class="gmail-paramtable" style="border-collapse:collapse;border-spacing:0px;background-color:transparent;border:0px"></table></dd><dt id="gmail-id4f2" style="box-sizing:border-box;line-height:1.42857;font-weight:700;float:left;width:100px;clear:left;text-align:right;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Context</dt><dd style="box-sizing:border-box;line-height:1.42857;margin-left:130px;word-break:break-word;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><table class="gmail-paramtable" style="border-collapse:collapse;border-spacing:0px;background-color:transparent;border:0px"><tbody style="box-sizing:border-box"><tr class="gmail-paramtable-row" style="box-sizing:border-box"><th class="gmail-paramtable-name" style="box-sizing:border-box;padding:0px;text-align:left;vertical-align:top">connector</th><td class="gmail-paramtable-value" style="box-sizing:border-box;padding:0px 20px 0px 5px;white-space:pre-wrap;word-break:break-all">[class org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl]</td></tr></tbody></table></dd><dt id="gmail-id4f3" style="box-sizing:border-box;line-height:1.42857;font-weight:700;float:left;width:100px;clear:left;text-align:right;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Error</dt><dd id="gmail-id4f4" style="box-sizing:border-box;line-height:1.42857;margin-left:130px;word-break:break-word;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px">Configuration error: JDBC Driver is not found on classpath.</dd><dd style="box-sizing:border-box;line-height:1.42857;margin-left:130px;word-break:break-word;color:rgb(51,51,51);font-family:"Source Sans Pro","Helvetica Neue",Helvetica,Arial,sans-serif;font-size:14px"><a id="gmail-id4eb" style="box-sizing:border-box;background-color:transparent;color:rgb(60,141,188)">show</a></dd><dd class="gmail-stacktrace" id="gmail-id4f5" style="box-sizing:border-box;line-height:1.42857;margin-left:130px;font-family:monospace;white-space:pre-wrap;font-size:11px;word-break:break-word;color:rgb(51,51,51)">com.evolveum.midpoint.util.exception.ConfigurationException: Configuration error: JDBC Driver is not found on classpath.</dd></div><div><div><br></div><div><br></div><div><br></div><div>Not really sure where to troubleshoot from here.  My assumption is the ojdbc8.jar file isn't getting picked up by midpoint but I have tried placing it every location I can think off where midpoint might look, any suggestions or help would be appreciated.</div><div><br></div><div>PS- I did cat the jar and it is in fact a binary file, I have restarted both the service and the server itself multiple times, and I changed the ownership of the jar to the midpoint service account just to ensure it wasn't a strange permissions issue.</div><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr">Keith LeValley<br><div><font face="arial, helvetica, sans-serif">Identity Services Architect</font>, Davenport University</div><div>phone:  (616) 732-1102</div><div><a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu<br></a></div></div></div></div></div></div></div></div></div></div></div>