[midPoint] ScriptedSQL connector error

[Pálos Gustáv]

Hi Ana,

which version of JDBC driver you are using?
Can you try it with the newest/older version?
And if you use lowercase "orcl" in connection URL?

Best regards,

-- 
Gustáv Pálos
Identity Engineer
evolveum.com

2016-08-11 22:21 GMT+02:00 Ana Pereyra <apereyra at identicum.com>:

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