spring-data-jpa二级缓存(EhCache)配置

最新推荐文章于 2024-04-29 06:00:00 发布

weixin_34228387

最新推荐文章于 2024-04-29 06:00:00 发布

阅读量311

点赞数

文章标签： java 开发工具 python

原文链接：https://my.oschina.net/u/1045177/blog/840322

版权

2019独角兽企业重金招聘Python工程师标准>>>

一、maven配置

<hibernate.version>5.1.4.Final</hibernate.version>

<dependency>
           <groupId>org.hibernate</groupId>
           <artifactId>hibernate-ehcache</artifactId>
           <version>${hibernate.version}</version>
       </dependency>

二、配置xml

<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
       <property name="dataSource" ref="dataSource" />
       <property name="jpaVendorAdapter">
           <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
               <property name="showSql" value="${db.showSql}" />
               <property name="generateDdl" value="${db.generateDdl}" />
               <property name="database" value="${db.database}" />
           </bean>
       </property>
       <property name="packagesToScan">
           <list>
               <value>cn.com.easy.*.model</value>
               <value>cn.com.platform.model</value>
           </list>
       </property>
       <property name="jpaProperties">
           <props>
               
               <prop key="hibernate.cache.use_query_cache">true</prop>
               <prop key="hibernate.cache.use_second_level_cache">true</prop>
               <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop>
               <prop key="hibernate.use_sql_comments">true</prop>
               <prop key="hibernate.format_sql">false</prop>
               <prop key="hibernate.generate_statistics">true</prop>
               <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop>
               <prop key="javax.persistence.sharedCache.mode">ENABLE_SELECTIVE</prop>
           </props>
       </property>
   </bean>

三、配置实体

@Entity
@Table(name = "pf_md_user_roles_mapping")
@DynamicInsert
@DynamicUpdate
@Cache(usage=CacheConcurrencyStrategy.TRANSACTIONAL)
public class UserRolesMappingModel extends BaseEntity {

四、配置 JpaRepository
public interface UserRolesMappingDao extends JpaRepository<UserRolesMappingModel, Long>, JpaSpecificationExecutor<UserRolesMappingModel> {
   @Query("select u from UserModel u where u.id in (select mapping.userId from UserRolesMappingModel mapping where mapping.roleId = ?1)")
   @QueryHints({@QueryHint(name = "org.hibernate.cacheable", value ="true") })
   public Page<UserModel> findUserModelByRoleId(Long roleId, Pageable pageable);

转载于:https://my.oschina.net/u/1045177/blog/840322