<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello Keith,</p>
<p>you might want to use "oracle.jdbc.driver.OracleDriver" instead
of "oracle.jdbc.OracleDriver".</p>
<p><br>
</p>
<p>Best regards,</p>
<p>Sven<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 24.03.21 um 14:23 schrieb Keith
LeValley via midPoint:<br>
</div>
<blockquote type="cite"
cite="mid:CAAkzTLz+_j==3kqnVksxjFF8Ca=_sgXNMWRKXVsREuGoUL+PYA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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)"
moz-do-not-send="true">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" moz-do-not-send="true">klevalley2@davenport.edu<br>
</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
</body>
</html>