[midPoint] ScriptedSQL connector error

[Ivan Noris]

Hi Ana,

I was maybe not following this thread fully because I was on vacation,
but have you prepared the groovy scripts for actual scripted sql
operations? It seems to me that the error might be caused also by the
test groovy script.

Are you sure you have set the configuration parameters for ScriptedSQL
connector in the resource, and not for DatabaseTable connector? The
setup you mentioned looks like the one for DatabaseTable connector.

Please refer to samples in
https://github.com/Evolveum/midpoint/tree/master/samples/resources/scriptedsql

Or have you tried this with Resource Wizard? ...

Regards,
Ivan

On 08/11/2016 10:21 PM, Ana Pereyra wrote:
> Hi everyone. I'm trying to set up a connection with scripted sql
> driver. When I fill in the values for the authentication fields, I get
> the following error:
>
> 2016-08-10 17:41:19,265 [] [http-bio-8080-exec-3] ERROR
> (com.evolveum.midpoint.provisioning.ucf.impl.IcfUtil): ICF Exception
> java.lang.AbstractMethodError in
> connector:03a06cfe-5096-49e0-873d-ec47b57a3f0e(ICF
> org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnector
> v1.1.2.0-SNAPSHOT):
> resource:9dfa9c75-5004-4569-9e62-b40a3f47ef89(ScriptedSQL Connector):
> oracle.jdbc.driver.T4CConnection.isValid(I)Z
> java.lang.AbstractMethodError:
> oracle.jdbc.driver.T4CConnection.isValid(I)Z
>         at
> org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnection.test(ScriptedSQLConnection.java:129)
> ~[na:na]
>         at
> org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnector.checkAlive(ScriptedSQLConnector.java:55)
> ~[na:na]
>         at
> org.identityconnectors.framework.impl.api.local.ConnectorPoolManager$ConnectorPoolHandler.testObject(ConnectorPoolManager.java:149)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at
> org.identityconnectors.framework.impl.api.local.ConnectorPoolManager$ConnectorPoolHandler.testObject(ConnectorPoolManager.java:83)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at
> org.identityconnectors.framework.impl.api.local.ObjectPool.borrowObject(ObjectPool.java:250)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at
> org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:87)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at com.sun.proxy.$Proxy226.schema(Unknown Source) ~[na:na]
>         at sun.reflect.GeneratedMethodAccessor574.invoke(Unknown
> Source) ~[na:na]
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_101]
>         at java.lang.reflect.Method.invoke(Method.java:606)
> ~[na:1.7.0_101]
>         at
> org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at com.sun.proxy.$Proxy226.schema(Unknown Source) ~[na:na]
>         at sun.reflect.GeneratedMethodAccessor574.invoke(Unknown
> Source) ~[na:na]
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_101]
>         at java.lang.reflect.Method.invoke(Method.java:606)
> ~[na:1.7.0_101]
>         at
> org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:99)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at com.sun.proxy.$Proxy226.schema(Unknown Source) ~[na:na]
>         at sun.reflect.GeneratedMethodAccessor574.invoke(Unknown
> Source) ~[na:na]
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.7.0_101]
>         at java.lang.reflect.Method.invoke(Method.java:606)
> ~[na:1.7.0_101]
>         at
> org.identityconnectors.framework.impl.api.LoggingProxy.invoke(LoggingProxy.java:83)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at com.sun.proxy.$Proxy226.schema(Unknown Source) ~[na:na]
>         at
> org.identityconnectors.framework.impl.api.AbstractConnectorFacade.schema(AbstractConnectorFacade.java:145)
> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>         at
> com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl.retrieveResourceSchema(ConnectorInstanceIcfImpl.java:657)
> [provisioning-impl-3.4.jar:na]
>         at
> com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl.initialize(ConnectorInstanceIcfImpl.java:567)
> [provisioning-impl-3.4.jar:na]
>         at
> com.evolveum.midpoint.provisioning.impl.ConnectorManager.createConfiguredConnectorInstance(ConnectorManager.java:170)
> [provisioning-impl-3.4.jar:na]
>         at
> com.evolveum.midpoint.provisioning.impl.ConnectorManager.getConfiguredConnectorInstance(ConnectorManager.java:131)
> [provisioning-impl-3.4.jar:na]
>         at
> com.evolveum.midpoint.provisioning.impl.ResourceManager.getConnectorInstance(ResourceManager.java:836)
> [provisioning-impl-3.4.jar:na]
>         at
> com.evolveum.midpoint.provisioning.impl.ResourceManager.testConnection(ResourceManager.java:563)
> [provisioning-impl-3.4.jar:na]
>         at
> com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.testResource(ProvisioningServiceImpl.java:931)
> [provisioning-impl-3.4.jar:na]
> ...
>
> The values I filled are the following:
>
> Name Quoting: None
> Host: xxxx
> TCP Port: 1521
> User: xxxx
> User Password: xxxx
>
> Database: xxxx
> Table: xxxx
> Key Column: xxxx
> Password Column: xxxx
> JDBC Driver: oracle.jdbc.driver.OracleDriver
> JDBC Connection URL: jdbc:oracle:thin:@xxxx:1521:ORCL
>
> The version of the data base is Oracle 10XE. We are using Oracle Thin
> JDBC driver, and the identity connector is the following:
> org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnector
> v1.1.2.0-SNAPSHOT.
>
> Any ideas on what this could be? Thanks in advanced!
>
> Ana
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

-- 
Ivan Noris
Senior Identity Engineer
evolveum.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160815/2db1d878/attachment.htm>