You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by Manfredo Hopp <mh...@gmail.com> on 2014/11/25 19:47:18 UTC
search script error using scripted sql
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).
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'.
....
Regards
[1] https://connid.atlassian.net/wiki/display/BASE/Scripted+SQL
Re: search script error using scripted sql
Posted by Manfredo Hopp <mh...@gmail.com>.
Hi Francesco, thanks for advice I now am reading my tables!
Manfredo
2014-11-27 5:19 GMT-03:00 Francesco Chicchiriccò <il...@apache.org>:
> 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/
>
>
Re: search script error using scripted sql
Posted by Francesco Chicchiriccò <il...@apache.org>.
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/