Ups sorry I didnt read! When using src's example:
p>Example Sprring Configuration:</p> * * <bean id="rolesUserSource" class="org.jasig.services.persondir.support.jdbc.NamedParameterJdbcPersonAttributeDao"> * <property name="dataSource" ref="PersonDB" /> * <property name="sql"> * <value> * SELECT rolename AS scsRoleName * from s_external_role * where oprid = UPPER(:username) * </value> * </property> * <property name="usernameAttributeProvider" ref="usernameAttributeProvider" /> * <property name="userAttributeNames"> * <set> * <value>scsRoleName</value> * </set> * </property> * </bean> I get following error; rg.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 215 in XML document from ServletContext resource [/WEB-INF/deployerConfigContext.xml] is invalid; nested exception is org.xml.sax.SAXParseException; lineNumber: 215; columnNumber: 7; cvc-complex-type.2.4.a: Invalid content was found starting with element 'set'. One of '{"http://www.springframework.org/schema/beans":meta, " http://www.springframework.org/schema/beans":constructor-arg, " http://www.springframework.org/schema/beans":property, " http://www.springframework.org/schema/beans":qualifier, " http://www.springframework.org/schema/beans":lookup-method, " http://www.springframework.org/schema/beans":replaced-method, WC[##other:" http://www.springframework.org/schema/beans"]}' is expected. at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334) So apparently the example isnt accurate. With more time I'll try to figure out what is needed. Thank you! 2015-08-26 16:24 GMT-03:00 Misagh Moayyed <mmoay...@unicon.net>: > The ctor arguments you’re calling don’t exist. You want to set properties > instead for that class: > > > https://github.com/Jasig/person-directory/blob/master/person-directory-impl/src/main/java/org/jasig/services/persondir/support/jdbc/NamedParameterJdbcPersonAttributeDao.java > > > > > > *From:* Manfredo Hopp [mailto:mhopp.coni...@gmail.com] > *Sent:* Wednesday, August 26, 2015 12:20 PM > *To:* cas-user@lists.jasig.org > *Subject:* Re: [cas-user] Resolving attirbutes dao results in "no value > specified for parameter 2" > > > > Hi test with NamedParameterJdbcPersonAttributeDao results in : > > > > > > 2015-08-26 16:07:34,851 ERROR > [org.springframework.web.context.ContextLoader] - <Context initialization > failed> > > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'centralAuthenticationService' defined in ServletContext > resource [/WEB-INF/spring-configuration/applicationContext.xml]: Cannot > resolve reference to bean 'authenticationManager' while setting constructor > argument; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'authenticationManager' defined in ServletContext resource > [/WEB-INF/deployerConfigContext.xml]: Cannot resolve reference to bean > 'primaryPrincipalResolver' while setting constructor argument with key > [<primaryAuthenticationHandler>]; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'primaryPrincipalResolver' defined in ServletContext > resource [/WEB-INF/deployerConfigContext.xml]: Cannot resolve reference to > bean 'attributeRepository' while setting bean property > 'attributeRepository'; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'attributeRepository' defined in ServletContext resource > [/WEB-INF/deployerConfigContext.xml]: Cannot resolve reference to bean > 'singleRowJdbcPersonAttributeDao' while setting bean property > 'personAttributeDaos' with key [0]; nested exception is > org.springframework.beans.factory.BeanCreationException: Error creating > bean with name 'singleRowJdbcPersonAttributeDao' defined in ServletContext > resource [/WEB-INF/deployerConfigContext.xml]: Could not resolve matching > constructor (hint: specify index/type/name arguments for simple parameters > to avoid type ambiguities) > > at > org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:326) > > at > org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:107) > > at > org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:623) > > at > org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1075) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:979) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:487) > > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458) > > at > org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296) > > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293) > > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) > > > > > > ConfigContext: > > > > <bean id="singleRowJdbcPersonAttributeDao" > > > class="org.jasig.services.persondir.support.jdbc.NamedParameterJdbcPersonAttributeDao"> > > <constructor-arg index="0" ref="dataSourceSarauth" /> > > <constructor-arg index="1" > > value="(SELECT id , a , b , c, email > FROM usr WHERE {0} > > UNION > > (SELECT d , a , b , c, email FROM regpend WHERE {0} )" /> > > <property name="queryAttributeMapping"> > > <map> > > <entry key="username" > value="id" /> > > </map> > > </property> > > <property name="resultAttributeMapping"> > > <map> > > <entry key="id" value="id" /> > > .... > > > > > > Regards Manfredo > > > > 2015-08-24 3:57 GMT-03:00 Misagh M <misagh.moay...@gmail.com>: > > Try using NamedParameterJdbcPersonAttributeDao instead. > > On Wednesday, August 19, 2015 at 3:26:37 PM UTC-7, Manfredo Hopp wrote: > > See my previous mail which describes details of this issue. > > > > Same result for version 1.7.0 (latest?) > > > > Regards Manfredo > > > > 2015-08-19 17:45 GMT-03:00 Misagh Moayyed <mmoa...@unicon.net>: > > 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:mhopp....@gmail.com <mhopp....@gmail.com>] > *Sent:* Wednesday, August 19, 2015 11:26 AM > *To:* cas-...@lists.jasig.org > *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 cas-...@lists.jasig.org as: mmoa...@unicon.net > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > -- > > You are currently subscribed to cas-...@lists.jasig.org as: > mhopp....@gmail.com > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > > > -- > > You are currently subscribed to cas-...@lists.jasig.org as: > jasig-cas-user...@googlegroups.com > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > -- > > You are currently subscribed to cas-user@lists.jasig.org as: > mhopp.coni...@gmail.com > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > > > > > -- > > You are currently subscribed to cas-user@lists.jasig.org as: > mmoay...@unicon.net > > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > -- > You are currently subscribed to cas-user@lists.jasig.org as: > mhopp.coni...@gmail.com > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/cas-user > > -- You are currently subscribed to cas-user@lists.jasig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user