hibernate的缓存不刷新问题

Question

                     sql = @" select *  from UserInfo ui where ui.IsBusiness<>1 and ui.Status=0 and ui.islogin<>2 and ui.[Unit] like :queryname";
                    ISQLQuery query = session.CreateSQLQuery(sql).AddEntity(typeof(UserInfo));
                    query.SetString("queryname", "%" + queryname + "%");
                    comList = query.SetCacheable(true).List<UserInfo>();

 sql = @" select  *  from UserInfo ui where ui.IsBusiness<>1 and ui.Status=0 and ui.islogin<>2 and (ui.Faculty like :queryname or ui.[Unit] like :queryname or ui.Interests like :queryname or ui.Name like :queryname or ui.Position like :queryname )";
                    ISQLQuery query = session.CreateSQLQuery(sql).AddEntity(typeof(UserInfo));
                    query.SetString("queryname", "%" + queryname + "%");
                    comList = query.SetCacheable(true).List<UserInfo>();

一段代码 根据queryname查询一个大学里的人员 queryname是大学、学院等的名字 只要sql长度比较长 就不刷新缓存
这是怎么回事？
Nhibernate+memcached

Answer 1

把 setCacheable(true)这个去掉