[midPoint] ScriptedSQL connector error

[Ana Pereyra]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160811/738f67f9/attachment.htm>