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 <[email protected]>:
> 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 <[email protected]>:
>>
>>> 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] as:
>>> [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
>>>
>>>
>> --
>> 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
>>
>> --
> 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
>
>
--
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
