<sql-query name="getMoreComment" cache-region="com.vrwuhan.web.domain.Gazetteer" cacheable="true" >
select * from gazcomment
</sql-query>
----------->
<sql-query name="getMoreComment" cache-region="com.vrwuhan.web.domain.Gazetteer" cacheable="true" >
<return alias="gaz" class="XX.XX.Gazcomment"
select gaz.ID as {gaz.id},gaz.Name as {gaz.name} --等等
from gazcomment gaz
</sql-query> Query query = getSession().getNamedQuery(name);
query.setParameter(0, code);
query.setMaxResults(10);
//query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
query.list(); 试试
select * from gazcomment
</sql-query>
----------->改成:
<sql-query name="getMoreComment" cache-region="com.vrwuhan.web.domain.Gazetteer" cacheable="true" >
<return alias="gaz" class="XX.XX.Gazcomment" />
select gaz.ID as {gaz.id},gaz.Name as {gaz.name} --等等
from gazcomment gaz
</sql-query>
class,这里不能返回一个map吗?返回的字段不是固定的。
这可能是导致你对它用cache失效的原因吧(猜测性意见)