<div dir="ltr">Hi Ana,<div><br></div><div>which version of JDBC driver you are using?</div><div>Can you try it with the newest/older version?</div><div>And if you use lowercase "orcl" in connection URL?</div><div class="gmail_extra"><br></div><div class="gmail_extra">Best regards,</div><div class="gmail_extra"><br></div><div class="gmail_extra">-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Gustáv Pálos</div><div>Identity Engineer</div><a href="http://evolveum.com/" rel="noreferrer" target="_blank" style="font-size:12.8px">evolveum.com</a></div><div dir="ltr"><br></div></div><div class="gmail_quote">2016-08-11 22:21 GMT+02:00 Ana Pereyra <span dir="ltr"><<a href="mailto:apereyra@identicum.com" target="_blank">apereyra@identicum.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><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.<wbr>provisioning.ucf.impl.IcfUtil)<wbr>: ICF Exception java.lang.AbstractMethodError in connector:03a06cfe-5096-49e0-<wbr>873d-ec47b57a3f0e(ICF org.forgerock.openicf.<wbr>connectors.scriptedsql.<wbr>ScriptedSQLConnector v1.1.2.0-SNAPSHOT): resource:9dfa9c75-5004-4569-<wbr>9e62-b40a3f47ef89(ScriptedSQL Connector): oracle.jdbc.driver.<wbr>T4CConnection.isValid(I)Z</div><div>java.lang.AbstractMethodError: oracle.jdbc.driver.<wbr>T4CConnection.isValid(I)Z</div><div> at org.forgerock.openicf.<wbr>connectors.scriptedsql.<wbr>ScriptedSQLConnection.test(<wbr>ScriptedSQLConnection.java:<wbr>129) ~[na:na]</div><div> at org.forgerock.openicf.<wbr>connectors.scriptedsql.<wbr>ScriptedSQLConnector.<wbr>checkAlive(<wbr>ScriptedSQLConnector.java:55) ~[na:na]</div><div> at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>ConnectorPoolManager$<wbr>ConnectorPoolHandler.<wbr>testObject(<wbr>ConnectorPoolManager.java:149) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>ConnectorPoolManager$<wbr>ConnectorPoolHandler.<wbr>testObject(<wbr>ConnectorPoolManager.java:83) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>ObjectPool.borrowObject(<wbr>ObjectPool.java:250) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>operations.<wbr>ConnectorAPIOperationRunnerPro<wbr>xy.invoke(<wbr>ConnectorAPIOperationRunnerPro<wbr>xy.java:87) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at com.sun.proxy.$Proxy226.<wbr>schema(Unknown Source) ~[na:na]</div><div> at sun.reflect.<wbr>GeneratedMethodAccessor574.<wbr>invoke(Unknown Source) ~[na:na]</div><div> at sun.reflect.<wbr>DelegatingMethodAccessorImpl.<wbr>invoke(<wbr>DelegatingMethodAccessorImpl.<wbr>java:43) ~[na:1.7.0_101]</div><div> at java.lang.reflect.Method.<wbr>invoke(Method.java:606) ~[na:1.7.0_101]</div><div> at org.identityconnectors.<wbr>framework.impl.api.local.<wbr>operations.<wbr>ThreadClassLoaderManagerProxy.<wbr>invoke(<wbr>ThreadClassLoaderManagerProxy.<wbr>java:96) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at com.sun.proxy.$Proxy226.<wbr>schema(Unknown Source) ~[na:na]</div><div> at sun.reflect.<wbr>GeneratedMethodAccessor574.<wbr>invoke(Unknown Source) ~[na:na]</div><div> at sun.reflect.<wbr>DelegatingMethodAccessorImpl.<wbr>invoke(<wbr>DelegatingMethodAccessorImpl.<wbr>java:43) ~[na:1.7.0_101]</div><div> at java.lang.reflect.Method.<wbr>invoke(Method.java:606) ~[na:1.7.0_101]</div><div> at org.identityconnectors.<wbr>framework.impl.api.<wbr>DelegatingTimeoutProxy.invoke(<wbr>DelegatingTimeoutProxy.java:<wbr>99) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at com.sun.proxy.$Proxy226.<wbr>schema(Unknown Source) ~[na:na]</div><div> at sun.reflect.<wbr>GeneratedMethodAccessor574.<wbr>invoke(Unknown Source) ~[na:na]</div><div> at sun.reflect.<wbr>DelegatingMethodAccessorImpl.<wbr>invoke(<wbr>DelegatingMethodAccessorImpl.<wbr>java:43) ~[na:1.7.0_101]</div><div> at java.lang.reflect.Method.<wbr>invoke(Method.java:606) ~[na:1.7.0_101]</div><div> at org.identityconnectors.<wbr>framework.impl.api.<wbr>LoggingProxy.invoke(<wbr>LoggingProxy.java:83) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at com.sun.proxy.$Proxy226.<wbr>schema(Unknown Source) ~[na:na]</div><div> at org.identityconnectors.<wbr>framework.impl.api.<wbr>AbstractConnectorFacade.<wbr>schema(<wbr>AbstractConnectorFacade.java:<wbr>145) ~[connector-framework-<wbr>internal-1.4.3.0-SNAPSHOT.jar:<wbr>na]</div><div> at com.evolveum.midpoint.<wbr>provisioning.ucf.impl.<wbr>ConnectorInstanceIcfImpl.<wbr>retrieveResourceSchema(<wbr>ConnectorInstanceIcfImpl.java:<wbr>657) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.<wbr>provisioning.ucf.impl.<wbr>ConnectorInstanceIcfImpl.<wbr>initialize(<wbr>ConnectorInstanceIcfImpl.java:<wbr>567) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ConnectorManager.<wbr>createConfiguredConnectorInsta<wbr>nce(ConnectorManager.java:170) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ConnectorManager.<wbr>getConfiguredConnectorInstance<wbr>(ConnectorManager.java:131) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ResourceManager.<wbr>getConnectorInstance(<wbr>ResourceManager.java:836) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ResourceManager.<wbr>testConnection(<wbr>ResourceManager.java:563) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ProvisioningServiceImpl.<wbr>testResource(<wbr>ProvisioningServiceImpl.java:<wbr>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.<wbr>OracleDriver</div><div>JDBC Connection URL: jdbc:oracle:thin:@xxxx:1521:<wbr>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.<wbr>connectors.scriptedsql.<wbr>ScriptedSQLConnector v1.1.2.0-SNAPSHOT.</div><div><br></div><div>Any ideas on what this could be? Thanks in advanced!</div><span class=""><font color="#888888"><div><br></div><div>Ana</div><div data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"></div></div></div></div></div></div></div></div></div></div>
</font></span></div></div>
<br>______________________________<wbr>_________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/<wbr>mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>
</div></div>