This “may” be an issue with person directory. Don’t know yet, but your other option for now would be to have 2 DAOs and merge the result together finally.
What version of person directory is this by the way? Can you dulicate the problem with the latest? From: Manfredo Hopp [mailto:[email protected]] Sent: Wednesday, August 19, 2015 11:26 AM To: [email protected] Subject: [cas-user] Resolving attirbutes dao results in "no value specified for parameter 2" Hello I am using singleRowJdbcPersonAttributeDao to resolve principal attributes defined as: singleRowJdbcPersonAttributeDao class="org.jasig.services.persondir.support.jdbc.SingleRowJdbcPersonAttributeDao"> <constructor-arg index="0" ref="dataSourceA" /> <constructor-arg index="1" value="(SELECT a, b, c , d FROM u WHERE {0} UNION (SELECT a, b ,c d FROM r WHERE {0})" /> <property name="queryAttributeMapping"> <map> <entry key="username" value="id" /> </map> </property> And get SQLException->No value specified for parameter 2 NO replacement for second {0}, so I am not able to use this query. Is there any reason for the behaviour of this implementation? Regards Manfredo -- You are currently subscribed to [email protected] <mailto:[email protected]> as: [email protected] <mailto:[email protected]> To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
