Guest User

Untitled

a guest
Nov 21st, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.06 KB | None | 0 0
  1. brandCache - [ name = brandCache cacheHits = 0 onDiskHits = 0 offHeapHits = 0 inMemoryHits = 0 misses = 0 onDiskMisses = 0 offHeapMisses = 0 inMemoryMisses = 0 size = 0 averageGetTime = 0.0 evictionCount = 0 ]
  2.  
  3. Statistics[start time=1511262597502,sessions opened=4,sessions closed=3,transactions=3,successful transactions=3,optimistic lock failures=0,flushes=9,connections obtained=4,statements prepared=132,statements closed=0,second level cache puts=0,second level cache hits=0,second level cache misses=0,entities loaded=6622,entities updated=15,entities inserted=15,entities deleted=0,entities fetched=1,collections loaded=27,collections updated=0,collections removed=3,collections recreated=3,collections fetched=27,naturalId queries executed to database=0,naturalId cache puts=0,naturalId cache hits=0,naturalId cache misses=0,naturalId max query time=0,queries executed to database=54,query cache puts=0,query cache hits=0,query cache misses=0,update timestamps cache puts=53,update timestamps cache hits=0,update timestamps cache misses=0,max query time=31113
  4.  
  5. 21-Nov-17 11:08 0 .ehcache-diskstore.lock
  6. 21-Nov-17 11:52 0 brand%0043ache.data
  7.  
  8. <bean id="viapromDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
  9. destroy-method="close">
  10. <property name="driverClass" value="com.mysql.jdbc.Driver" />
  11. <property name="jdbcUrl" value="${viaprom.data.db.url}" />
  12. <property name="user" value="${viaprom.data.db.username}" />
  13. <property name="password" value="${viaprom.data.db.password}" />
  14.  
  15. <!-- these are C3P0 properties -->
  16.  
  17. <property name="initialPoolSize" value="100" />
  18. <property name="acquireIncrement" value="5" />
  19. <property name="minPoolSize" value="5" />
  20. <property name="maxPoolSize" value="200" />
  21. <property name="maxIdleTime" value="7200" />
  22. <property name="checkoutTimeout" value="1000" />
  23. <property name="automaticTestTable" value="C3P0_TEST_TABLE"></property>
  24. <property name="testConnectionOnCheckin" value="true"></property>
  25. <property name="idleConnectionTestPeriod" value="60"></property>
  26.  
  27. </bean>
  28. <bean id="viaPromSessionFactory"
  29. class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  30. <property name="dataSource" ref="viapromDataSource" />
  31. <property name="configLocation" value="classpath:hibernate_viaprom_mappings.cfg.xml" />
  32. <property name="hibernateProperties">
  33. <props>
  34. <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
  35. <prop key="hibernate.show_sql">true</prop>
  36. <prop key="hibernate.cache.use_second_level_cache">true</prop>
  37. <prop key="hibernate.cache.use_query_cache">true</prop>
  38. <prop key="hibernate.generate_statistics">true</prop>
  39. <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop>
  40. <!-- <prop key="connection.pool_size">10</prop> -->
  41. <!-- <prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext</prop> -->
  42. </props>
  43. </property>
  44. </bean>
  45. <bean id="cacheManager" class="org.springframework.cache.ehcache.EhCacheCacheManager">
  46. <property name="cacheManager" ref="ehcache" />
  47. </bean>
  48. <bean id="ehcache"
  49. class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean">
  50. <property name="configLocation" value="classpath:/ehcache.xml" />
  51. <property name="shared" value="true" />
  52. </bean>
  53.  
  54. <ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  55. xsi:noNamespaceSchemaLocation="ehcache.xsd" updateCheck="true"
  56. monitoring="autodetect" dynamicConfig="true">
  57.  
  58. <diskStore path="java.io.tmpdir/ehcache" />
  59.  
  60. <defaultCache
  61. maxElementsInMemory="10000"
  62. eternal="false"
  63. timeToIdleSeconds="150"
  64. timeToLiveSeconds="120"
  65. overflowToDisk="true"
  66. diskPersistent="false"
  67. diskExpiryThreadIntervalSeconds="120"
  68. memoryStoreEvictionPolicy="LRU" statistics="true" />
  69. <cache name="brandCache" statistics="true" maxElementsInMemory="100" eternal="true" overflowToDisk="true" />
  70. </ehcache>
  71.  
  72. @Cacheable(value="brandCache", key="T(java.util.Objects).hash(#brand)")
  73. public ProductBrandDTO getProductBrand(String brand) {
  74. ProductBrandDTO productBrand = null;
  75. try {
  76. log.debug("brand {} " , brand );
  77. Session session = viaPromSessionFactory.getCurrentSession();
  78. Criteria criteria = session.createCriteria(ProductBrandDTO.class, "productBrand");
  79. criteria.add(Restrictions.eqOrIsNull("productBrand.brandName", StringUtils.trimToNull(brand)));
  80. productBrand = (ProductBrandDTO) criteria.uniqueResult();
  81. if (productBrand == null) {
  82. productBrand = new ProductBrandDTO();
  83. productBrand.setBrandName(brand);
  84. session.saveOrUpdate(productBrand);
  85. }
  86. } catch (Exception e) {
  87. log.error(e.getMessage(),e);
  88. }
  89. return productBrand;
  90. }
  91.  
  92. <dependency>
  93. <groupId>org.hibernate</groupId>
  94. <artifactId>hibernate-ehcache</artifactId>
  95. <version>4.3.5.Final</version>
  96. </dependency>
  97.  
  98. <properties>
  99. <spring.version>4.0.5.RELEASE</spring.version>
  100. <jackson.version>2.4.4</jackson.version>
  101. <hibernate.version>4.3.5.Final</hibernate.version>
  102. <log4j.version>1.2.17</log4j.version>
  103. <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  104. <springframework.version>4.3.1.RELEASE</springframework.version>
  105. <springsecurity.version>4.1.1.RELEASE</springsecurity.version>
  106. <jackson.library>2.7.5</jackson.library>
  107. <org.aspectj-version>1.7.4</org.aspectj-version>
  108. <java.mail.version>1.4.7</java.mail.version>
  109. <commons.logging.version>1.2</commons.logging.version>
  110. <!-- SLF4J -->
  111. <slf4j.version>1.7.5</slf4j.version>
  112. <!-- Log4j 2 -->
  113. <log4j2.version>2.2</log4j2.version>
  114. <!-- Log4j -->
  115. <log4j.version>1.2.17</log4j.version>
  116. </properties>
Add Comment
Please, Sign In to add comment