[midPoint] Message Configuration error: JDBC Driver is not found on classpath

[Richard Richter]

Hi, 

with midPoint 4.2 the real issue is different. The startup command line changed and the critical missing option is here: 
[ 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 ] 

That is: -Dloader.path=WEB-INF/classes,WEB-INF/lib,WEB-INF/lib-provided, %MIDPOINT_HOME% \lib 
(the ^ character is to continue with the line and probably not relevant for your case) 

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.) 

Best regards 

Richard Richter 
midPoint developer 


From: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
To: "midPoint General Discussion" <midpoint at lists.evolveum.com> 
Cc: "Sven Lukrafka" <sven.lukrafka at daasi.de> 
Sent: Wednesday, March 24, 2021 2:30:57 PM 
Subject: Re: [midPoint] Message Configuration error: JDBC Driver is not found on classpath 



Hello Keith, 

you might want to use "oracle.jdbc.driver.OracleDriver" instead of "oracle.jdbc.OracleDriver". 




Best regards, 

Sven 



Am 24.03.21 um 14:23 schrieb Keith LeValley via midPoint: 



I am having trouble trying to connect to an Oracle database using the Database table connector v1.4.4.0 

I have already downloaded the ojdbc8.jar file and have placed it in the locations below: 

[root at midPointDemo var]# find / -name ojdbc8.jar 
/opt/midpoint-4.2/var/lib/ojdbc8.jar 
/opt/midpoint-4.2/var/ojdbc8.jar 
/opt/midpoint-4.2/lib/ojdbc8.jar 

----------------------------------------------------------------------------- 
Below is my service file that I use to run midpoint: 

[Unit] 
Description=MidPoint Standalone Service 
[Service] 
User=midpoint 
WorkingDirectory=/opt/midpoint-4.2 
ExecStart=/usr/bin/java -Xmx2048m -Dmidpoint.home=/opt/midpoint-4.2/var -jar /opt/midpoint-4.2/lib/midpoint.war 
SuccessExitStatus=143 
[Install] 
WantedBy=multi-user.target 

--------------------------------------------------------------------------------- 
This is the config I am using for the class path 

<gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver> 

I have also tried oracle.jdbc,driver.OracleDriver and neither are working. The error I am getting is: 

Operation ICF schema Message Configuration error: JDBC Driver is not found on classpath. Context connector 	[class org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl] Error Configuration error: JDBC Driver is not found on classpath. show 
com.evolveum.midpoint.util.exception.ConfigurationException: Configuration error: JDBC Driver is not found on classpath. 



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. 

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. 

-- 
Keith LeValley 
Identity Services Architect , Davenport University 
phone: (616) 732-1102 
[ mailto:klevalley2 at davenport.edu | klevalley2 at davenport.edu
                             ] 

_______________________________________________
midPoint mailing list [ mailto:midPoint at lists.evolveum.com | midPoint at lists.evolveum.com ] [ https://lists.evolveum.com/mailman/listinfo/midpoint | https://lists.evolveum.com/mailman/listinfo/midpoint ] 



_______________________________________________ 
midPoint mailing list 
midPoint at lists.evolveum.com 
https://lists.evolveum.com/mailman/listinfo/midpoint 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/d6255bbc/attachment-0001.htm>