-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: named query with new lines (tabs) not cached using memcached
PostPosted: Wed Mar 26, 2008 1:34 pm 
Newbie

Joined: Wed Mar 26, 2008 8:40 am
Posts: 3
Hibernate version: 1.2.0 (it seems also in 1.2.1)
Mapping documents:

Code:
    <sql-query name="SelectAllSitesDTO">
        <return-scalar column="SiteID" type="Int32"/>
        <return-scalar column="SiteName" type="String"/>
        SELECT
            site_id AS SiteID,
            name AS SiteName
        FROM dbo.tbl_site       
    </sql-query>


log:
2008-03-26 20:22:37,399 [5] INFO NHibernate.Loader.Loader - SELECT
site_id AS SiteID,
name AS SiteName
FROM dbo.tbl_site
2008-03-26 20:22:37,399 [5] DEBUG NHibernate.SQL - SELECT
site_id AS SiteID,
name AS SiteName
FROM dbo.tbl_site
2008-03-26 20:22:37,696 [5] INFO Memcached.ClientLibrary.MemcachedClient - Serializing for key: $$Key$$ for class: $$Class$$
2008-03-26 20:22:37,790 [5] INFO Memcached.ClientLibrary.MemcachedClient - memcached cmd (result code): set NHibernate.Cache.StandardQueryCache@sql:-SELECT-
------------site_id-AS-SiteID,-
------------name-AS-SiteName-
--------FROM-dbo.tbl_site;-parameters:-[];-named-parameters:-{};-first-row:-0 8 3599 4096
(ERROR)
2008-03-26 20:22:37,790 [5] ERROR Memcached.ClientLibrary.MemcachedClient - Error storing data in cache for key: NHibernate.Cache.StandardQueryCache@sql:-SELECT-
------------site_id-AS-SiteID,-
------------name-AS-SiteName-
--------FROM-dbo.tbl_site;-parameters:-[];-named-parameters:-{};-first-row:-0 -- length: 4096. Server response: ERROR
2008-03-26 20:22:37,806 [5] WARN NHibernate.Caches.MemCache.MemCacheClient - could not save: sql: SELECT
site_id AS SiteID,
name AS SiteName
FROM dbo.tbl_site; parameters: []; named parameters: {}; first row: 0 => System.Collections.ArrayList

log from memcached server:
<1828 get NHibernate.Cache.StandardQueryCache@sql:-SELECT-
>1828 END
<1828 ------------site_id-AS-SiteID,-
>1828 ERROR
<1828 ------------name-AS-SiteName-
>1828 ERROR
<1828 --------FROM-dbo.tbl_site;-parameters:-[];-named-parameters:-{};-first-row
:-0
>1828 ERROR
<1816 new client connection
<1804 new client connection
<1792 new client connection
<1792 set NHibernate.Cache.StandardQueryCache@sql:-SELECT-
>1792 ERROR
<1792 ------------site_id-AS-SiteID,-
>1792 ERROR
<1792 ------------name-AS-SiteName-
>1792 ERROR
<1792 --------FROM-dbo.tbl_site;-parameters:-[];-named-parameters:-{};-first-row
:-0 8 3599 4096
>1792 ERROR
<1792
>1792 ERROR
<1792
>1792 ERROR
<1792 ♂
>1792 ERROR
<1792
>1792 ERROR
<1792 ♦♦
>1792 ERROR
<1792 ♠
>1792 ERROR
<1792
>1792 ERROR
<1792 LoadFactorVersioComparer►HashCodeProvideHashSize♦Keys♠Values
>1792 ERROR
<1792
>1792 ERROR
<1792 ♂
>1792 ERROR
<1792 ♠
>1792 ERROR
<1792 ♠A
>1792 ERROR
<1792 ♠`
>1792 ERROR
<1792 MemberType►GenericArguments☺☺☺☺
>1792 ERROR
<1792 ►↕
>1792 ERROR
<1792 get 5lFcH4KU6kS9dCt6hX3RIv0MJN0=
>1792 END

also heard BEEP sound form server! :)

stack:
InnerException: of type <<NHibernate.ADOException>> message:
- Key cannot be null.
Parameter name: key
InnerException: of type <<NHibernate.ADOException>> trace:
- at System.Collections.Hashtable.get_Item(Object key)
at NHibernate.Impl.SessionFactoryObjectFactory.GetNamedInstance(String name)
at NHibernate.Impl.SessionFactoryImpl.GetRealObject(StreamingContext context)
at System.Runtime.Serialization.ObjectManager.ResolveObjectReference(ObjectHolder holder)
at System.Runtime.Serialization.ObjectManager.DoFixups()
at System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage)
at Memcached.ClientLibrary.MemcachedClient.LoadItems(SockIO sock, Hashtable hm, Boolean asString)
at Memcached.ClientLibrary.MemcachedClient.Get(String key, Object hashCode, Boolean asString)
at Memcached.ClientLibrary.MemcachedClient.Get(String key)
at NHibernate.Caches.MemCache.MemCacheClient.Get(Object key)
at NHibernate.Cache.StandardQueryCache.Get(QueryKey key, ICacheAssembler[] returnTypes, ISet spaces, ISessionImplementor session)
at NHibernate.Loader.Loader.GetResultFromQueryCache(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes, IQueryCache queryCache, QueryKey key)
at NHibernate.Loader.Loader.ListUsingQueryCache(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes)
at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes)
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)


Top
 Profile  
 
 Post subject:
PostPosted: Thu Mar 27, 2008 3:36 am 
Newbie

Joined: Wed Mar 26, 2008 8:40 am
Posts: 3
of course i execute query with SetCacheable(true)

Code:
            IList<SiteDto> sites =
                NHibernateSession.GetNamedQuery("SelectAllSitesDTO").SetCacheable(true)
                .SetResultTransformer(
                    new AliasToBeanConstructorResultTransformer(SiteDtoConstructor))
                .List<SiteDto>();


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.