Hibernate Second Level Cache Example by R4R Team

We know that in the hibernate cache first level cache is automatically generated but on the other hand second level cache we need to generate for making the session and to store the data and reusability the database object.

One small example for making the second level cache:

In this we need some thing which are given below:

1.Pro.java (POJO class)


package HibernateCache;
public class Pro
    private int protId;
    private String proName;
    private double price;
    public void setProId(int proId)
        this.proId = proId;
    public int getProId()
        return proId;
    public void setProName(String proName)
        this.proName = proName;
    public String getProName()
        return proName;
    public void setPrice(double price)
        this.price = price;
    public double getPrice()
        return price;


package HibernateCache;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class Logic { 
    public static void main(String[] args)
        Configuration cfg = new Configuration();
        SessionFactory factory = cfg.buildSessionFactory();
        Session session1 = factory.openSession();
        Object o=session1.load(Pro.class,new Integer(105));
        Pro s=(Pro)o;
        System.out.println("Loaded object product name is___"+s.getProName());
        System.out.println("Object Loaded successfully.....!!");
        catch (Exception e) {
        System.out.println("6 seconds compelted......!!!!!!!!");
        Session session2 = factory.openSession();
        Object o2=session2.load(Pro.class,new Integer(105));
        Pro s2=(Pro)o2;
        System.out.println("Loaded object product name is___"+s2.getProName());
        System.out.println("Object loaded from the database...!!");
        Session session3 = factory.openSession();
        Object o3=session3.load(Pro.class,new Integer(105));
        Pro s3=(Pro)o3;
        System.out.println("Loaded object product name is___"+s3.getProName());
        System.out.println("Object loaded from global cache successfully.....!!");

Summary of Logic.java

1. From line numbers 16 – 22 we opened session1 and loaded object and closed session1, this time object will be loaded from the database as its the first time

2. Then from 27 – 31 we have been waited for 6 seconds,  but in our ehcache.xml we have given timeToIdleSeconds=”5″ , i mean after 5 seconds object will be removed from the global cache

3. And again in ForOurLogic.java line numbers 35 – 41 we opened second session and loaded the object, this time hibernate will loads the object from the database, and closed the session

4. Immediately from 43 – 49 we opened session3 and loaded the object, this time hibernate will loads the object form the global session not from the database


<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
<class name="HibernateCache.Pro" table="products">
<cache usage="read-only" />
<id name="proId" column="pid"  />
<property name="proName" column="pname" length="10"/>
<property name="price"/>


<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate_pro?zeroDateTimeBehavior=convertToNull</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">root</property>
<property name="cache.provider_class">
<property name="dialect">org.hibernate.dialect.MySql</property>
<property name="show_sql">true</property>
<property name="hbm2ddl.auto">update</property>
<mapping resource="Pro.hbm.xml"></mapping>


<?xml version="1.0"?> 
<defaultCache maxElementsInMemory="100" eternal="false" timeToIdleSeconds="120" timeToLiveSeconds="200" />
<cache name="HibernateCache.Pro" maxElementsInMemory="100" eternal="false" timeToIdleSeconds="5" timeToLiveSeconds="200" />

Summary of ehcache.xml

1. In ehcache.xml, if eternal=”true” then we should not write timeToIdealSeconds, timeToLiveSeconds,  hibernate will take care about those values

2. So if you want to give values manually better eternal=”false” always,  so that we can assign values into timeToIdealSeconds, timeToLiveSeconds manually, and play ;)

3. timeToIdealSeconds=”seconds” means, if the object in the global chche is ideal, means not using by any other class or object then it will be waited for some time we specified and deleted from the global cache if time is exceeds more than timeToIdealSeconds value

4. timeToLiveSeconds=”seconds” means, the other Session or class using this object or not, i mean may be it is using by other sessions or may not, what ever the situation might be, once it competed the time specified timeToLiveSeconds, then it will be removed from the global cache by hibernate

5. Actually <defaultCache … /> will reflects to all the pojo classes in our application,  and we can also assign the ehcache values to specified pojo class by <cache name=”– your pojo class name —” …….. />
Leave a Comment:
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!