On 25/11/2014 19:47, Manfredo Hopp wrote:
Hello my use case is users && usersroles on different tables so my
solution would be using a scriptedsql connector in order to assign
roles to a user.
To define a scriptedsql I had to
install org.connid.bundles.db.scriptedsql-2.1.7.jar in bundles
directory (it is not included in download).
Hi Manfredo,
nothing strange about this: some connector bundles are defined by
default, other connector bundles - including custom ones you might need
- are to be added in your own overlay project [2].
My question is what should scripts return in particular search and
schema scripts?. I loooked in [1] but there is no sample on how to do
this. I made a simple search script (select * from users) which
results in:
Caused by:
org.identityconnectors.framework.common.exceptions.ConnectorException: Search
script error
at
org.connid.bundles.db.scriptedsql.ScriptedSQLConnector.executeQuery(ScriptedSQLConnector.java:389)
at
org.connid.bundles.db.scriptedsql.ScriptedSQLConnector.executeQuery(ScriptedSQLConnector.java:61)
.....
Caused by: java.lang.IllegalArgumentException: The Attribute set must contain a
'Uid'.
....
See some examples here [3].
HTH
Regards.
[1] https://connid.atlassian.net/wiki/display/BASE/Scripted+SQL
[2]
https://cwiki.apache.org/confluence/display/SYNCOPE/Install+connector+bundles
[3]
https://github.com/Tirasa/ConnIdDBBundle/tree/master/scriptedsql/src/main/resources/samples
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/
