<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi, could be many reasons, just wild guess:</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<ul data-editing-info="{"orderedStyleType":1,"unorderedStyleType":2}" style="margin-block: 0px;">
<li style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); list-style-type: "- ";">
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">try pointing the classpath resource conf property to
</span><span style="letter-spacing: normal; font-family: ui-monospace, SFMono-Regular, "SF Mono", Menlo, Consolas, "Liberation Mono", monospace; font-size: 12px; color: rgb(31, 35, 40); background-color: rgb(255, 255, 255); font-weight: 400;">/opt/midpoint/midpoint_home/sorobject-scripted-sql/</span><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> instead
of "."</span></div>
</li></ul>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
M.</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Od:</b> midPoint <midpoint-bounces@lists.evolveum.com> za uživatele Graham Ballantyne via midPoint <midpoint@lists.evolveum.com><br>
<b>Odesláno:</b> pátek 12. ledna 2024 1:30<br>
<b>Komu:</b> midpoint@lists.evolveum.com <midpoint@lists.evolveum.com><br>
<b>Kopie:</b> Graham Ballantyne <grahamb@sfu.ca><br>
<b>Předmět:</b> [midPoint] Scripted SQL connector example? Getting errors when testing</font>
<div> </div>
</div>
<div style="line-break:after-white-space">Hi folks,
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>My resource configuration is here: <a href="https://gist.github.com/grahamb/f9cc16a28de7b29665f3bd9b81aa34af">https://gist.github.com/grahamb/f9cc16a28de7b29665f3bd9b81aa34af</a></div>
<div><br>
</div>
<div>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: </div>
<div><br>
</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>and</div>
<div><br>
</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>I've been using the samples from <a href="https://github.com/Evolveum/midpoint-samples/tree/master/samples/resources/scriptedsql">https://github.com/Evolveum/midpoint-samples/tree/master/samples/resources/scriptedsql</a> as my basis. I had to make some
changes to the XML to get it to upload (mostly the username and JDBC URL parameters).</div>
<div><br>
</div>
<div>Any guidance would be much appreciated.</div>
<div><br>
</div>
<div>
<div>Thanks,</div>
<div>Graham.</div>
</div>
<br>
<br>
<div>
<div dir="auto" style="color:rgb(0,0,0); letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; line-break:after-white-space">
<div dir="auto" style="color:rgb(0,0,0); letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; line-break:after-white-space">
<div dir="auto" style="color:rgb(0,0,0); letter-spacing:normal; text-align:start; text-indent:0px; text-transform:none; white-space:normal; word-spacing:0px; text-decoration:none; line-break:after-white-space">
<div>– <br>
Graham Ballantyne (he/him)<br>
IAM Architect — IT Services <br>
Simon Fraser University<br>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</body>
</html>