<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hi Ana,</p>
<p>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.</p>
<p>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.<br>
</p>
Please refer to samples in
<a class="moz-txt-link-freetext" href="https://github.com/Evolveum/midpoint/tree/master/samples/resources/scriptedsql">https://github.com/Evolveum/midpoint/tree/master/samples/resources/scriptedsql</a><br>
<br>
Or have you tried this with Resource Wizard? ...<br>
<br>
Regards,<br>
Ivan<br>
<br>
<div class="moz-cite-prefix">On 08/11/2016 10:21 PM, Ana Pereyra
wrote:<br>
</div>
<blockquote
cite="mid:CAO5EgRpKn6ssX1KJarzZbT7kSHP2dK=GC+Dt_rFyA30FjytYLg@mail.gmail.com"
type="cite">
<div dir="ltr">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:
<div><br>
</div>
<div>
<div>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):
<a class="moz-txt-link-freetext" href="resource:9dfa9c75-5004-4569-9e62-b40a3f47ef89(ScriptedSQL">resource:9dfa9c75-5004-4569-9e62-b40a3f47ef89(ScriptedSQL</a>
Connector): oracle.jdbc.driver.T4CConnection.isValid(I)Z</div>
<div>java.lang.AbstractMethodError:
oracle.jdbc.driver.T4CConnection.isValid(I)Z</div>
<div> at
org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnection.test(ScriptedSQLConnection.java:129)
~[na:na]</div>
<div> at
org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnector.checkAlive(ScriptedSQLConnector.java:55)
~[na:na]</div>
<div> at
org.identityconnectors.framework.impl.api.local.ConnectorPoolManager$ConnectorPoolHandler.testObject(ConnectorPoolManager.java:149)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at
org.identityconnectors.framework.impl.api.local.ConnectorPoolManager$ConnectorPoolHandler.testObject(ConnectorPoolManager.java:83)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at
org.identityconnectors.framework.impl.api.local.ObjectPool.borrowObject(ObjectPool.java:250)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at
org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:87)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at com.sun.proxy.$Proxy226.schema(Unknown Source)
~[na:na]</div>
<div> at
sun.reflect.GeneratedMethodAccessor574.invoke(Unknown
Source) ~[na:na]</div>
<div> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_101]</div>
<div> at
java.lang.reflect.Method.invoke(Method.java:606)
~[na:1.7.0_101]</div>
<div> at
org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at com.sun.proxy.$Proxy226.schema(Unknown Source)
~[na:na]</div>
<div> at
sun.reflect.GeneratedMethodAccessor574.invoke(Unknown
Source) ~[na:na]</div>
<div> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_101]</div>
<div> at
java.lang.reflect.Method.invoke(Method.java:606)
~[na:1.7.0_101]</div>
<div> at
org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:99)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at com.sun.proxy.$Proxy226.schema(Unknown Source)
~[na:na]</div>
<div> at
sun.reflect.GeneratedMethodAccessor574.invoke(Unknown
Source) ~[na:na]</div>
<div> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.7.0_101]</div>
<div> at
java.lang.reflect.Method.invoke(Method.java:606)
~[na:1.7.0_101]</div>
<div> at
org.identityconnectors.framework.impl.api.LoggingProxy.invoke(LoggingProxy.java:83)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at com.sun.proxy.$Proxy226.schema(Unknown Source)
~[na:na]</div>
<div> at
org.identityconnectors.framework.impl.api.AbstractConnectorFacade.schema(AbstractConnectorFacade.java:145)
~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]</div>
<div> at
com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl.retrieveResourceSchema(ConnectorInstanceIcfImpl.java:657)
[provisioning-impl-3.4.jar:na]</div>
<div> at
com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanceIcfImpl.initialize(ConnectorInstanceIcfImpl.java:567)
[provisioning-impl-3.4.jar:na]</div>
<div> at
com.evolveum.midpoint.provisioning.impl.ConnectorManager.createConfiguredConnectorInstance(ConnectorManager.java:170)
[provisioning-impl-3.4.jar:na]</div>
<div> at
com.evolveum.midpoint.provisioning.impl.ConnectorManager.getConfiguredConnectorInstance(ConnectorManager.java:131)
[provisioning-impl-3.4.jar:na]</div>
<div> at
com.evolveum.midpoint.provisioning.impl.ResourceManager.getConnectorInstance(ResourceManager.java:836)
[provisioning-impl-3.4.jar:na]</div>
<div> at
com.evolveum.midpoint.provisioning.impl.ResourceManager.testConnection(ResourceManager.java:563)
[provisioning-impl-3.4.jar:na]</div>
<div> at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.testResource(ProvisioningServiceImpl.java:931)
[provisioning-impl-3.4.jar:na]</div>
<div>...</div>
<div><br>
</div>
<div>The values I filled are the following:</div>
<div><br>
</div>
<div>
<div>Name Quoting: None</div>
<div>Host: xxxx</div>
<div>TCP Port: 1521</div>
<div>User: xxxx</div>
<div>User Password: xxxx</div>
<div><br>
</div>
<div>Database: xxxx<br>
</div>
<div>Table: xxxx</div>
<div>Key Column: xxxx</div>
<div>Password Column: xxxx</div>
<div>JDBC Driver: oracle.jdbc.driver.OracleDriver</div>
<div>JDBC Connection URL: jdbc:oracle:thin:@xxxx:1521:ORCL</div>
</div>
<div><br>
</div>
<div>The version of the data base is Oracle 10XE. We are using
Oracle Thin JDBC driver, and the identity connector is the
following:</div>
<div>org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnector
v1.1.2.0-SNAPSHOT.</div>
<div><br>
</div>
<div>Any ideas on what this could be? Thanks in advanced!</div>
<div><br>
</div>
<div>Ana</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ivan Noris
Senior Identity Engineer
evolveum.com
</pre>
</body>
</html>