You can transform manually after the List()
Diego
On Wed, Sep 29, 2010 at 11:42, harshil hameed <[email protected]> wrote:
> thanx Ian Nelson,
> any body give me an alternate way.
>
>
>
> On Wed, Sep 29, 2010 at 1:53 PM, Ian Nelson <[email protected]> wrote:
>
>> This is symptomatic of bug 1090 - Query cache does not work when using
>> Criteria API to create a projection query with a result transformer
>>
>> See http://216.121.112.228/browse/NH-1090
>>
>> <http://216.121.112.228/browse/NH-1090>Regards
>> Ian
>>
>> Ian Nelson
>> http://ianfnelson.com
>> http://iannelsonsystems.com
>>
>>
>>
>> On Wed, Sep 29, 2010 at 06:45, harshil <[email protected]> wrote:
>>
>>> Hi friends,
>>>
>>> After enabling Query Cache, SetResultTransformer in Criteria API
>>> getting error
>>>
>>> Unable to cast object of type ' MYDTO' to type 'System.Object[]'.
>>>
>>> >>>in the sample my DTO name is 'MYDTO'
>>>
>>> Error:
>>> NHibernate.Util.ADOExceptionReporter - Unable to cast object of type
>>> 'MYDTO' to type 'System.Object[]'.
>>>
>>>
>>> ICriteria criteria = base.CreateCriteria();
>>> ProjectionList projectionList =
>>> Projections.ProjectionList();
>>> projectionList.Add(Projections.Property("Id"), "ID");
>>> projectionList.Add(Projections.Property(ColumnAlias),
>>> "ColumnValue");
>>> projectionList.Add(Projections.Property(AccountCode),
>>> "AccountCode");
>>> criteria.SetProjection(projectionList);
>>>
>>>
>>> criteria.SetResultTransformer(NHibernate.Transform.Transformers.AliasToBean(typeof(MYDTO)));
>>> IList<MYDTO> MYDTOList=criteria.List<MYDTO>(); <<< in this
>>> point i get error
>>>
>>>
>>> Please find the error complete details
>>>
>>> WARN
>>>
>>> NHibernate.Util.ADOExceptionReporter - System.InvalidCastException:
>>> Unable to cast object of type 'MYDTO' to type 'System.Object[]'.
>>> at NHibernate.Cache.StandardQueryCache.Put(QueryKey key,
>>> ICacheAssembler[] returnTypes, IList result, Boolean
>>> isNaturalKeyLookup, ISessionImplementor session)
>>> at
>>> NHibernate.Loader.Loader.PutResultInQueryCache(ISessionImplementor
>>> session, QueryParameters queryParameters, IType[] resultTypes,
>>> IQueryCache queryCache, QueryKey key, IList result)
>>> at NHibernate.Loader.Loader.ListUsingQueryCache(ISessionImplementor
>>> session, QueryParameters queryParameters, ISet`1 querySpaces, IType[]
>>> resultTypes)
>>> at NHibernate.Loader.Loader.List(ISessionImplementor session,
>>> QueryParameters queryParameters, ISet`1 querySpaces, IType[]
>>> resultTypes)
>>> at
>>> NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor
>>> session)
>>> at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList
>>> results)
>>>
>>>
>>> ERROR
>>>
>>> NHibernate.Util.ADOExceptionReporter - Unable to cast object of type
>>> 'MYDTO' to type 'System.Object[]'
>>>
>>>
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "nhusers" group.
>>> To post to this group, send email to [email protected].
>>> To unsubscribe from this group, send email to
>>> [email protected]<nhusers%[email protected]>
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/nhusers?hl=en.
>>>
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "nhusers" group.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to
>> [email protected]<nhusers%[email protected]>
>> .
>> For more options, visit this group at
>> http://groups.google.com/group/nhusers?hl=en.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
