<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
Hi Villam,
<div><br>
</div>
<div>Good thought, but moving the end tag to the same line didn't make a difference; it's still throwing </div>
<div>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())'</div>
<div><br>
<div>
<div dir="auto" style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="text-align: start; text-indent: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="text-align: start; text-indent: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="text-align: start; text-indent: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="text-align: start; text-indent: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div dir="auto" style="text-align: start; text-indent: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div style="text-align: start; text-indent: 0px; overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
<div style="caret-color: rgb(0, 0, 0); color: rgb(0, 0, 0); letter-spacing: normal; text-transform: none; white-space: normal; word-spacing: 0px; text-decoration: none; -webkit-text-stroke-width: 0px; text-align: start; text-indent: 0px;">
<br>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div><br>
<blockquote type="cite">
<div>On Jan 12, 2024, at 11:52, Viliam Repan via midPoint <midpoint@lists.evolveum.com> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div>Hi Graham,<br>
<br>
In your resource I see:<br>
<icscscriptedsql:scriptRoots>/opt/midpoint/midpoint_home/sorobject-scripted-sql/<br>
</icscscriptedsql:scriptRoots><br>
where end tag is on new line, meaning path to scripts also contains "\n”, could this be the mistake?<br>
<br>
AFAIK classpath “.” seems ok.<br>
<br>
Best regards,<br>
<br>
viliam<br>
<br>
<blockquote type="cite">On 12 Jan 2024, at 10:22, Martin Lízner via midPoint <midpoint@lists.evolveum.com> wrote:<br>
<br>
Hi, could be many reasons, just wild guess:<br>
<br>
• try pointing the classpath resource conf property to /opt/midpoint/midpoint_home/sorobject-scripted-sql/ instead of "."<br>
<br>
M.Od: midPoint <midpoint-bounces@lists.evolveum.com> za uživatele Graham Ballantyne via midPoint <midpoint@lists.evolveum.com><br>
Odesláno: pátek 12. ledna 2024 1:30<br>
Komu: midpoint@lists.evolveum.com <midpoint@lists.evolveum.com><br>
Kopie: Graham Ballantyne <grahamb@sfu.ca><br>
Předmět: [midPoint] Scripted SQL connector example? Getting errors when testing<br>
Hi folks,<br>
<br>
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.<br>
<br>
My resource configuration is here: https://gist.github.com/grahamb/f9cc16a28de7b29665f3bd9b81aa34af<br>
<br>
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:
<br>
<br>
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())'<br>
<br>
and<br>
<br>
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())<br>
<br>
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).<br>
<br>
Any guidance would be much appreciated.<br>
<br>
Thanks,<br>
Graham.<br>
<br>
<br>
– <br>
Graham Ballantyne (he/him)<br>
IAM Architect — IT Services <br>
Simon Fraser University<br>
<br>
_______________________________________________<br>
midPoint mailing list<br>
midPoint@lists.evolveum.com<br>
https://lists.evolveum.com/mailman/listinfo/midpoint<br>
</blockquote>
<br>
<br>
_______________________________________________<br>
midPoint mailing list<br>
midPoint@lists.evolveum.com<br>
https://lists.evolveum.com/mailman/listinfo/midpoint<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</body>
</html>