Caching is not seen

[Swapna latha]

Hi, i have used spring+hibernate and configured ehcache. But every time its hitting DB. Secondary cache is not working. Please tell me where i am wrong.

ehcache.xml

<?xml version="1.0" encoding="UTF-8"?>
<ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:noNamespaceSchemaLocation="ehcache.xsd"
         updateCheck="true" monitoring="autodetect"
         dynamicConfig="true">

<defaultCache maxElementsInMemory="100" 
eternal="false" 
 />

<cache name="com.astro.action.Customer" 
maxElementsInMemory="100" 
eternal="false" 
 />

<cache name="query.emailExist" 
maxElementsInMemory="100" 
eternal="false" 
 />

<cache name="newCustomer" 
maxElementsInMemory="100" 
eternal="false" 
 />

<cache name="emailExist" 
maxElementsInMemory="100" 
eternal="false" 
 />



 <!-- <cache>
        <searchable>
            <searchAttribute name="email" class="com.astro.action.Customer"/>
        </searchable>
    </cache> -->
    </ehcache>
    

Customer.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.astro.model.Customer" 
		table="ADDRESS" entity-name="address">
		 <cache usage="read-only"/> 
			
        <id name="email" type="string">
            <column name="EMAIL" />
        </id>
        
        <property name="customerId">
            <column name="CUSTOMER_ID" length="45"/>
        </property>
	 	<property name="name" type="string">
            <column name="NAME" length="45" not-null="true" />
        </property>
       
        <property name="createdDate" type="timestamp">
            <column name="CREATED_DATE" length="19" not-null="true" />
        </property>
       <!--  <property name="email" type="string">
            <column name="EMAIL" length="19" not-null="true" />
        </property> -->
         <property name="address" type="string">
            <column name="ADDRESS" length="100" not-null="true" />
        </property>
        <property name="telephone" type="string">
            <column name="TELEPHONE" length="19" not-null="true" />
        </property>
        <property name="countryCode" type="string">
            <column name="COUNTRYNAME" length="19" not-null="true" />
        </property>
        <property name="pincode" type="string">
            <column name="PINCODE" length="19" not-null="true" />
        </property>
        <property name="terms" type="boolean">
            <column name="TERMS"  length="19" not-null="true" />
        </property>
    </class>
     <class name="com.astro.model.Customer" 
		table="NEWCUSTOMER" entity-name="newCustomer">
		<cache usage="read-only"/>
        <id name="email">
        <column name="email" length="35"/>
        </id>
	 	<property name="password">
            <column name="password" length="15" not-null="true"/>
        </property>
         <property name="createdDate">
            <column name="createdDate" not-null="true" />
        </property>
    </class>
    <sql-query name="customerExist" >
   <return class="newCustomer"/>
   select * from newastro.newcustomer c where c.email=? and c.password=?
   </sql-query>
   <sql-query name="emailExist" >
   <return class="newCustomer"/>
   select * from newastro.newcustomer c where c.email=? 
 <!-- select * from customer c where c.email=? -->
   </sql-query>
    <sql-query name="addressDetails" >
   
   <return class="address"/>
   select * from newastro.address c where c.email=?
   
   </sql-query>
   
    <!--  <query name="customerExist">
     
<![CDATA[from Customer customer where customer.email=? and customer.password=?]]>
</query> --> 
    
 <!--   <query name="findcustomerByemail">
<![CDATA[from Customer customer where customer.email=?]]>
</query>
    
 <query name="findcustomerByname">
<![CDATA[from Customer customer where customer.name=?]]>
</query>
<query name="customerExist">
<![CDATA[from Customer customer where customer.email=? and customer.password=?]]>
</query>
<query name="recoverPassword">
<![CDATA[from Customer u where u.name=? and u.email=?]]>
</query> 
<query name="customerDetails">
<![CDATA[from Customer c where c.email=? and c.password=?]]>
</query>  -->
</hibernate-mapping>

HibernateSessionFactory.java

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation=" http://www.springframework.org/schema/beans 
       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
       http://www.springframework.org/schema/tx 
       http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
 
<!-- Hibernate session factory -->
<bean id="sessionFactory" 
    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
 
    <property name="dataSource">
      <ref bean="dataSource"/>
    </property>
 
    <property name="hibernateProperties">
       <props>
         <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
         <prop key="hibernate.show_sql">true</prop>
        <prop key="hibernate.hbm2ddl.auto">update</prop> 
        <prop key="c3p0.min_size">10</prop>
        <prop key="c3p0.max_size">25</prop>
        <prop key="c3p0.acquire_increment">1</prop> 
        <prop key="c3p0.max_statements">50</prop>
        <prop key="c3p0.idle_test_period">3600</prop> 
        <prop key="c3p0.timeout">14400</prop>
         <prop key="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</prop>
         <prop key="hibernate.cache.provider_configuration_file_resource_path">/ehcache.xml</prop>
       <prop key="hibernate.cache.use_query_cache">true</prop>
<prop key="hibernate.max_fetch_depth">4</prop>
<prop key="hibernate.cache.use_second_level_cache">true</prop>
<!-- <prop key="hibernate.cache.use_query_cache">true</prop> -->
<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
       
       </props>
    </property>
    <property name="mappingResources">
		<list>
          <value>com/astro/hibernate/hbm/Customer.hbm.xml</value>
           <value>com/astro/hibernate/hbm/Contact.hbm.xml</value>
            <value>com/astro/hibernate/hbm/Country.hbm.xml</value>
            <value>com/astro/hibernate/hbm/Category.hbm.xml</value>
            <value>com/astro/hibernate/hbm/Item.hbm.xml</value>
            <value>com/astro/hibernate/hbm/Question.hbm.xml</value>
		</list>
    </property>	
 
</bean>
</beans>

thanks

swapna kori