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

[Graham Ballantyne]

Hi Villam,

Good thought, but moving the end tag to the same line didn't make a difference; it's still throwing
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())'



On Jan 12, 2024, at 11:52, Viliam Repan via midPoint <midpoint at lists.evolveum.com> wrote:

Hi Graham,

In your resource I see:
<icscscriptedsql:scriptRoots>/opt/midpoint/midpoint_home/sorobject-scripted-sql/
</icscscriptedsql:scriptRoots>
where end tag is on new line, meaning path to scripts also contains "\n”, could this be the mistake?

AFAIK classpath “.” seems ok.

Best regards,

viliam

On 12 Jan 2024, at 10: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> za uživatele Graham Ballantyne via midPoint <midpoint at lists.evolveum.com>
Odesláno: pátek 12. ledna 2024 1:30
Komu: midpoint at lists.evolveum.com <midpoint at lists.evolveum.com>
Kopie: Graham Ballantyne <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
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/20240115/f2fe5e3a/attachment.htm>