[midPoint] ScriptedSQL connector error
Ana Pereyra
apereyra at identicum.com
Mon Aug 15 18:14:42 CEST 2016
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):
500 Internal Server Error
Unexpected error occurred, if necessary please contact system administrator.
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 at 4359a62e on
component [AjaxSubmitButton [Component id = testConnection]] threw an
exception
Any ideas? Thanks in advance.
Ana
El ago. 12, 2016 4:20 AM, "Pálos Gustáv" <gustav.palos at evolveum.com>
escribió:
> 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.T4CConnecti
>> on.isValid(I)Z
>> at org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConn
>> ection.test(ScriptedSQLConnection.java:129) ~[na:na]
>> at org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConn
>> ector.checkAlive(ScriptedSQLConnector.java:55) ~[na:na]
>> at org.identityconnectors.framework.impl.api.local.ConnectorPoo
>> lManager$ConnectorPoolHandler.testObject(ConnectorPoolManager.java:149)
>> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>> at org.identityconnectors.framework.impl.api.local.ConnectorPoo
>> lManager$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.C
>> onnectorAPIOperationRunnerProxy.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.T
>> hreadClassLoaderManagerProxy.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.DelegatingTimeoutP
>> roxy.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.AbstractConnectorF
>> acade.schema(AbstractConnectorFacade.java:145)
>> ~[connector-framework-internal-1.4.3.0-SNAPSHOT.jar:na]
>> at com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanc
>> eIcfImpl.retrieveResourceSchema(ConnectorInstanceIcfImpl.java:657)
>> [provisioning-impl-3.4.jar:na]
>> at com.evolveum.midpoint.provisioning.ucf.impl.ConnectorInstanc
>> eIcfImpl.initialize(ConnectorInstanceIcfImpl.java:567)
>> [provisioning-impl-3.4.jar:na]
>> at com.evolveum.midpoint.provisioning.impl.ConnectorManager.cre
>> ateConfiguredConnectorInstance(ConnectorManager.java:170)
>> [provisioning-impl-3.4.jar:na]
>> at com.evolveum.midpoint.provisioning.impl.ConnectorManager.get
>> ConfiguredConnectorInstance(ConnectorManager.java:131)
>> [provisioning-impl-3.4.jar:na]
>> at com.evolveum.midpoint.provisioning.impl.ResourceManager.getC
>> onnectorInstance(ResourceManager.java:836) [provisioning-impl-3.4.jar:na]
>> at com.evolveum.midpoint.provisioning.impl.ResourceManager.test
>> Connection(ResourceManager.java:563) [provisioning-impl-3.4.jar:na]
>> at com.evolveum.midpoint.provisioning.impl.ProvisioningServiceI
>> mpl.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
>>
>>
>
>
>
> _______________________________________________
> 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/20160815/539bf3b4/attachment.htm>
More information about the midPoint
mailing list