Hi Francesco, thanks for advice I now am reading my tables! Manfredo
2014-11-27 5:19 GMT-03:00 Francesco Chicchiriccò <[email protected]>: > 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 Excellencehttp://www.tirasa.net/ > > Involved at The Apache Software Foundation: > member, Syncope PMC chair, Cocoon PMC, Olingo > PMChttp://people.apache.org/~ilgrosso/ > >
