1.在hibernate中createQuery执行hql查询的时候使用查询缓存:
2.在hibernate中createSQLQuery执行sql时使用查询缓存:
这样会报错,原因是That's because the aim of the second level cache is to (ultimately) cache entities that Hib knows about. I haven't verified this but I'm not surprised that caching sql query doesn't work as those are not (directly) translated by hibernate into entities. 解决方法: It's solutioned adding column's types to the query, using the method "addScalar()" like this:
ps:hibernate4中addScalar不再是Hibernate.String而是StringType.INSTANCE.docs:http://docs./hibernate/orm/4.1/javadocs/org/hibernate/type/Type.html |
|
来自: 飞鹰飞龙飞天 > 《hibernate》