<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Hi,<br></div><div><br data-mce-bogus="1"></div><div>with midPoint 4.2 the real issue is different. The startup command line changed and the critical missing option is here:<br data-mce-bogus="1"></div><div><a href="https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75">https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75</a><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>That is: <strong> <!--StartFragment-->-Dloader.path=WEB-INF/classes,WEB-INF/lib,WEB-INF/lib-provided,<span class="pl-smi">%MIDPOINT_HOME%</span>\lib</strong><!--EndFragment--><br data-mce-bogus="1"></div><div>(the ^ character is to continue with the line and probably not relevant for your case)<br></div><div><br data-mce-bogus="1"></div><div>Please, adjust it accordingly for your case, replace %MIDPOINT_HOME% with the actual value. Hope this helps and sorry about this change, but it was necessary on our path to newer Spring Boot. We're considering some options how to hide this hassle, but at this moment this is the way and affects everyone who does not use our scripts. (And yes, I'm aware we broke the support for Windows service, it's actually part of this change and at this moment we don't have a fix. Sorry about it too.)<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Best regards<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Richard Richter<br data-mce-bogus="1"></div><div>midPoint developer<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>To: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>Cc: </b>"Sven Lukrafka" <sven.lukrafka@daasi.de><br><b>Sent: </b>Wednesday, March 24, 2021 2:30:57 PM<br><b>Subject: </b>Re: [midPoint] Message Configuration error: JDBC Driver is not found on classpath<br></div><div><br></div><div data-marker="__QUOTED_TEXT__"><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>
<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="line-height:1.42857;font-weight:700;float:left;width:100px;text-align:right;text-overflow:ellipsis;white-space:nowrap;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">Operation</dt>
<dd style="line-height:1.42857;margin-left:130px;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'"><span id="gmail-id4ef" style="font-weight:700">ICF schema</span></dd>
<dt id="gmail-id4f0" style="line-height:1.42857;font-weight:700;float:left;width:100px;text-align:right;text-overflow:ellipsis;white-space:nowrap;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">Message</dt>
<dd id="gmail-id4f1" style="line-height:1.42857;margin-left:130px;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">Configuration
error: JDBC Driver is not found on classpath.</dd>
<dd style="line-height:1.42857;margin-left:130px;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">
<table class="gmail-paramtable" style="border-collapse:collapse;border-spacing:0px;background-color:transparent;border:0px"></table>
</dd>
<dt id="gmail-id4f2" style="line-height:1.42857;font-weight:700;float:left;width:100px;text-align:right;text-overflow:ellipsis;white-space:nowrap;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">Context</dt>
<dd style="line-height:1.42857;margin-left:130px;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">
<table class="gmail-paramtable" style="border-collapse:collapse;border-spacing:0px;background-color:transparent;border:0px"><tbody><tr class="gmail-paramtable-row"><th class="gmail-paramtable-name" style="padding:0px;text-align:left;vertical-align:top">connector</th><td class="gmail-paramtable-value" style="padding:0px 20px 0px 5px;white-space:pre-wrap">[class org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl]</td></tr></tbody></table>
</dd>
<dt id="gmail-id4f3" style="line-height:1.42857;font-weight:700;float:left;width:100px;text-align:right;text-overflow:ellipsis;white-space:nowrap;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">Error</dt>
<dd id="gmail-id4f4" style="line-height:1.42857;margin-left:130px;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'">Configuration
error: JDBC Driver is not found on classpath.</dd>
<dd style="line-height:1.42857;margin-left:130px;color:rgb( 51 , 51 , 51 );font-family:'sans pro' 'helvetica neue'"><a style="background-color:transparent;color:rgb( 60 , 141 , 188 )">show</a><br data-mce-bogus="1"></dd>
<dd class="gmail-stacktrace" id="gmail-id4f5" style="line-height:1.42857;margin-left:130px;font-family:monospace;white-space:pre-wrap;font-size:11px;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">
<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" rel="nofollow noopener noreferrer">klevalley2@davenport.edu<br>
</a><br data-mce-bogus="1"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre">_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank" rel="nofollow noopener noreferrer">midPoint@lists.evolveum.com</a>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank" rel="nofollow noopener noreferrer">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>_______________________________________________<br>midPoint mailing list<br>midPoint@lists.evolveum.com<br>https://lists.evolveum.com/mailman/listinfo/midpoint<br></div></div></body></html>