[midPoint] Scripted SQL connector example? Getting errors when testing

[Graham Ballantyne]

Hi Martin,

Thanks for the suggestion, but that was one of the first things I tried :)

Graham.


On Jan 12, 2024, at 01:22, Martin Lízner via midPoint <midpoint at lists.evolveum.com> wrote:

Hi, could be many reasons, just wild guess:


  *
try pointing the classpath resource conf property to /opt/midpoint/midpoint_home/sorobject-scripted-sql/ instead of "."

M.
________________________________
Od: midPoint <midpoint-bounces at lists.evolveum.com<mailto:midpoint-bounces at lists.evolveum.com>> za uživatele Graham Ballantyne via midPoint <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Odesláno: pátek 12. ledna 2024 1:30
Komu: midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com> <midpoint at lists.evolveum.com<mailto:midpoint at lists.evolveum.com>>
Kopie: Graham Ballantyne <grahamb at sfu.ca<mailto:grahamb at sfu.ca>>
Předmět: [midPoint] Scripted SQL connector example? Getting errors when testing

Hi folks,

I'm trying to set up an inbound Scripted SQL connector against a Postgres database and having no luck. I have what I think should be a minimal configuration with only the test capability turned on, but it's throwing errors.

My resource configuration is here: https://gist.github.com/grahamb/f9cc16a28de7b29665f3bd9b81aa34af

An Upload/Execute from midPoint studio works and the resource is created, but if I try to test the resource, either using the Upload/Test function in Studio, or the Test Connection button on the edit resource screen, it throws an error:

groovy.lang.MissingMethodException(No signature of method: org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConfiguration.validate() is applicable for argument types: () values: []?Possible solutions: validate(), validate(), validate(), wait(), release(), release())'

and

groovy.lang.MissingMethodException(No signature of method: org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConfiguration.validate() is applicable for argument types: () values: []?Possible solutions: validate(), validate(), validate(), wait(), release(), release())

I've been using the samples from https://github.com/Evolveum/midpoint-samples/tree/master/samples/resources/scriptedsql as my basis. I had to make some changes to the XML to get it to upload (mostly the username and JDBC URL parameters).

Any guidance would be much appreciated.

Thanks,
Graham.


–
Graham Ballantyne (he/him)
IAM Architect —  IT Services
Simon Fraser University

_______________________________________________
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/20240112/0b1b1a26/attachment-0001.htm>