import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {

    private static final SessionFactory sessionFactory = buildSessionFactory();

    private static SessionFactory buildSessionFactory() {
        try {
            // Create the SessionFactory from hibernate.cfg.xml
            return new Configuration().configure().buildSessionFactory();
        }
        catch (Throwable ex) {
            // Make sure you log the exception, as it might be swallowed
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }

}

public class App
{
    public static void test()
    {

        Session session = HibernateUtil.getSessionFactory().openSession();

        session.beginTransaction();
       
        Test test = (Test) session.get(Test.class, 1);

        session.getTransaction().commit();
    }
}

SET GLOBAL general_log = 'ON';

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->
        <property name="connection.driver_class">com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</property>
        <property name="connection.url">jdbc:mysql://localhost/test</property>
        <property name="connection.username">jboss</property>
        <property name="connection.password">password</property>

        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>
       
        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

      <property name="cache.use_query_cache">true</property>
      <property name="cache.use_second_level_cache">true</property>
      <property name="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</property>

       <class-cache class="test.Test" usage="read-only"/>
      
    </session-factory>
   
</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<ehcache>
<defaultCache
   eternal="false"
   timeToIdleSeconds="300"
   timeToLiveSeconds="600"
/>
</ehcache>

package test;

public class TestManager
{

   static public Test getTestFromId(String testId)
   {
      Test test = null;
      if(testId != null)
      {
         Session session = HibernateUtil.getSessionFactory().getCurrentSession();
         session.beginTransaction();

         test = (Test) session.get(Test.class, testId);
   
         session.getTransaction().commit();
         session = HibernateUtil.getSessionFactory().getCurrentSession();
         session.beginTransaction();

         test = (Test) session.get(Test.class, testId);
   
         session.getTransaction().commit();
         session = HibernateUtil.getSessionFactory().getCurrentSession();
         session.beginTransaction();

         test = (Test) session.get(Test.class, testId);
   
         session.getTransaction().commit();
      }
      return test;
   }

}