[midPoint] Midpoint 4.3 - JDBC Driver is not found on classpath

[Andrea Picconi]

Hi Richard,

any news about our problem?

Thank you and regards,
Andrea


From: Andrea Picconi
Sent: Friday, April 22, 2022 10:49 AM
To: midPoint General Discussion <midpoint at lists.evolveum.com>
Cc: Richard Richter <virgo at evolveum.com>
Subject: RE: Midpoint 4.3 - JDBC Driver is not found on classpath

Hi Richard,

thank you for your quickly response.
We will move to 4.4 soon, we must first study some changes within our system, so for now we have taken this step.

We start Midpoint via . service, here our -Dloader.path=

[cid:image001.png at 01D85A18.A36E4F20]

Thank you and regards,
Andrea

From: midPoint <midpoint-bounces at lists.evolveum.com<mailto:midpoint-bounces at lists.evolveum.com>> On Behalf Of Richard Richter via midPoint
Sent: Thursday, April 21, 2022 7:24 PM
To: midPoint General Discussion <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Cc: Richard Richter <virgo at evolveum.com<mailto:virgo at evolveum.com>>
Subject: Re: [midPoint] Midpoint 4.3 - JDBC Driver is not found on classpath

Hi Andrea

I hope this transition is only to get to the 4.4, as 4.3 has become unsupported two weeks ago... but to your question:

Broad problem: We use Spring Boot as the main framework for midPoint application. Here and there something changes in Spring Boot, or something changes in midPoint - and in MP 4.2 and 4.3 there was a bit of a mess around loading these additional libraries. This was taken care of by the provided scripts (midpoint.sh or start.sh) but not if you didn't use them.

So my question is - how exactly are you starting your midpoint? Is it service or shell script? Please, check midpoint.sh in the version you want to run and search for the start command and its -Dloader.path=... argument in particular (and also how -cp and PropertiesLauncher class name is used instead of simple -jar argument).

This was fixed in 4.4 and is automagically treated inside WAR again.

Regards

Richard Richter
midPoint Developer

________________________________
From: "midPoint General Discussion" <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
To: "midPoint General Discussion" <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Cc: "Andrea Picconi" <andrea.picconi at innovery.net<mailto:andrea.picconi at innovery.net>>, "Jacopo Giuliano" <jacopo.giuliano at innovery.net<mailto:jacopo.giuliano at innovery.net>>
Sent: Thursday, April 21, 2022 4:57:56 PM
Subject: [midPoint] Midpoint 4.3 - JDBC Driver is not found on classpath

Hi all,

I am having trouble trying to connect our Oracle database using the Database table connector v1.4.4.6.
We just upgraded from version 4.1 to 4.3 (going through the 4.2) leaving the /var folder unchanged, but now it appears at the time of the connection test, for every Oracle DB, this error:

[cid:image002.png at 01D85A18.A36E4F20]

While in 4.1 we had no problems with the ojdbc7.jar driver, in this new one we also tried to update it to 8, but always with the same result.

Now the ojdbc8.jar file is placed it in the locations below:

/opt/midpoint/var/lib/ojdbc8.jar

-------

This is our classPath:

[cid:image003.png at 01D85A18.A36E4F20]


We also tried to change the permissions in the jar file to do more tests, besides restarting the service and the machines several times.

Any idea to resolve the problem?

Thank you and regards,


[cid:image004.jpg at 01D85A18.A36E4F20]
Andrea Picconi
IAM Engineer
MAIL: ANDREA.PICCONI at INNOVERY.NET<mailto:ANDREA.PICCONI at INNOVERY.NET>
PHONE: +39  06 51963439  (ext. 196)
MOBILE: -

WWW.INNOVERY.NET<http://WWW.INNOVERY.NET>
STRADA QUATTRO SNC, PAL A6
CENTRO DIREZIONALE MILANOFIORI | 20057 ASSAGO (MI)

[cid:image005.jpg at 01D85A18.A36E4F20]



_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com<mailto: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/20220427/f94df7ed/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 164745 bytes
Desc: image001.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220427/f94df7ed/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 8765 bytes
Desc: image002.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220427/f94df7ed/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 2509 bytes
Desc: image003.png
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220427/f94df7ed/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 2583 bytes
Desc: image004.jpg
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220427/f94df7ed/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 1986 bytes
Desc: image005.jpg
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20220427/f94df7ed/attachment-0003.jpg>