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

[Viliam Repan]

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