<p dir="ltr">Hi, thank you very much for answering. I'm using ojdbc14.jar. I tried with "orcl" in lowercase, but I still get the same error. In addition to that, when I get that error, the application displays a 500 error with the following message (I got the same error before trying the url in lowercase):<br></p>
<p dir="ltr">500 Internal Server Error</p>
<p dir="ltr">Unexpected error occurred, if necessary please contact system administrator.</p>
<p dir="ltr">8/12/16 2:33 PM org.apache.wicket.WicketRuntimeException: Method onRequest of interface org.apache.wicket.behavior.IBehaviorListener targeted at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1@4359a62e on component [AjaxSubmitButton [Component id = testConnection]] threw an exception<br></p>
<p dir="ltr">Any ideas? Thanks in advance.<br></p>
<p dir="ltr">Ana</p>
<div class="gmail_quote">El ago. 12, 2016 4:20 AM, "Pálos Gustáv" <<a href="mailto:gustav.palos@evolveum.com">gustav.palos@evolveum.com</a>> escribió:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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 data-smartmail="gmail_signature"><div dir="ltr"><div>Gustáv Pálos</div><div>Identity Engineer</div><a href="http://evolveum.com/" rel="noreferrer" style="font-size:12.8px" target="_blank">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.provisi<wbr>oning.ucf.impl.IcfUtil): ICF Exception java.lang.AbstractMethodError in connector:03a06cfe-5096-49e0-8<wbr>73d-ec47b57a3f0e(ICF org.forgerock.openicf.connecto<wbr>rs.scriptedsql.ScriptedSQLConn<wbr>ector v1.1.2.0-SNAPSHOT): resource:9dfa9c75-5004-4569-9e<wbr>62-b40a3f47ef89(ScriptedSQL Connector): oracle.jdbc.driver.T4CConnecti<wbr>on.isValid(I)Z</div><div>java.lang.AbstractMethodError: oracle.jdbc.driver.T4CConnecti<wbr>on.isValid(I)Z</div><div> at org.forgerock.openicf.connecto<wbr>rs.scriptedsql.ScriptedSQLConn<wbr>ection.test(ScriptedSQLConnect<wbr>ion.java:129) ~[na:na]</div><div> at org.forgerock.openicf.connecto<wbr>rs.scriptedsql.ScriptedSQLConn<wbr>ector.checkAlive(ScriptedSQLCo<wbr>nnector.java:55) ~[na:na]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.local.ConnectorPoo<wbr>lManager$ConnectorPoolHandler.<wbr>testObject(ConnectorPoolManage<wbr>r.java:149) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.local.ConnectorPoo<wbr>lManager$ConnectorPoolHandler.<wbr>testObject(ConnectorPoolManage<wbr>r.java:83) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.local.ObjectPool.<wbr>borrowObject(ObjectPool.java:<wbr>250) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.local.operations.C<wbr>onnectorAPIOperationRunnerProx<wbr>y.invoke(ConnectorAPIOperation<wbr>RunnerProxy.java:87) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at com.sun.proxy.$Proxy226.schema<wbr>(Unknown Source) ~[na:na]</div><div> at sun.reflect.GeneratedMethodAcc<wbr>essor574.invoke(Unknown Source) ~[na:na]</div><div> at sun.reflect.DelegatingMethodAc<wbr>cessorImpl.invoke(DelegatingMe<wbr>thodAccessorImpl.java:43) ~[na:1.7.0_101]</div><div> at java.lang.reflect.Method.invok<wbr>e(Method.java:606) ~[na:1.7.0_101]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.local.operations.T<wbr>hreadClassLoaderManagerProxy.i<wbr>nvoke(ThreadClassLoaderManager<wbr>Proxy.java:96) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at com.sun.proxy.$Proxy226.schema<wbr>(Unknown Source) ~[na:na]</div><div> at sun.reflect.GeneratedMethodAcc<wbr>essor574.invoke(Unknown Source) ~[na:na]</div><div> at sun.reflect.DelegatingMethodAc<wbr>cessorImpl.invoke(DelegatingMe<wbr>thodAccessorImpl.java:43) ~[na:1.7.0_101]</div><div> at java.lang.reflect.Method.invok<wbr>e(Method.java:606) ~[na:1.7.0_101]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.DelegatingTimeoutP<wbr>roxy.invoke(DelegatingTimeoutP<wbr>roxy.java:99) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at com.sun.proxy.$Proxy226.schema<wbr>(Unknown Source) ~[na:na]</div><div> at sun.reflect.GeneratedMethodAcc<wbr>essor574.invoke(Unknown Source) ~[na:na]</div><div> at sun.reflect.DelegatingMethodAc<wbr>cessorImpl.invoke(DelegatingMe<wbr>thodAccessorImpl.java:43) ~[na:1.7.0_101]</div><div> at java.lang.reflect.Method.invok<wbr>e(Method.java:606) ~[na:1.7.0_101]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.LoggingProxy.<wbr>invoke(LoggingProxy.java:83) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at com.sun.proxy.$Proxy226.schema<wbr>(Unknown Source) ~[na:na]</div><div> at org.identityconnectors.framewo<wbr>rk.impl.api.AbstractConnectorF<wbr>acade.schema(AbstractConnector<wbr>Facade.java:145) ~[connector-framework-internal<wbr>-1.4.3.0-SNAPSHOT.jar:na]</div><div> at com.evolveum.midpoint.provisio<wbr>ning.ucf.impl.ConnectorInstanc<wbr>eIcfImpl.retrieveResourceSchem<wbr>a(ConnectorInstanceIcfImpl.<wbr>java:657) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.provisio<wbr>ning.ucf.impl.ConnectorInstanc<wbr>eIcfImpl.initialize(ConnectorI<wbr>nstanceIcfImpl.java:567) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.provisio<wbr>ning.impl.ConnectorManager.cre<wbr>ateConfiguredConnectorInstance<wbr>(ConnectorManager.java:170) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.provisio<wbr>ning.impl.ConnectorManager.get<wbr>ConfiguredConnectorInstance(<wbr>ConnectorManager.java:131) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.provisio<wbr>ning.impl.ResourceManager.getC<wbr>onnectorInstance(ResourceManag<wbr>er.java:836) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.provisio<wbr>ning.impl.ResourceManager.test<wbr>Connection(ResourceManager.<wbr>java:563) [provisioning-impl-3.4.jar:na]</div><div> at com.evolveum.midpoint.provisio<wbr>ning.impl.ProvisioningServiceI<wbr>mpl.testResource(ProvisioningS<wbr>erviceImpl.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.OracleDrive<wbr>r</div><div>JDBC Connection URL: jdbc:oracle:thin:@xxxx:1521:OR<wbr>CL</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.connecto<wbr>rs.scriptedsql.ScriptedSQLConn<wbr>ector v1.1.2.0-SNAPSHOT.</div><div><br></div><div>Any ideas on what this could be? Thanks in advanced!</div><span><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" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mail<wbr>man/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>
</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>