<session-factory>
   <!-- properties -->
   <property name="connection.username">test</property>
   <property name="connection.url">jdbc:mysql://10.1.10.31/airtel_test?autoReconnect=true</property>
   <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
   <property name="connection.password">test</property>
   <property name="connection.driver_class">com.mysql.jdbc.Driver</property>

   <property name="connection.autoReconnect">true</property>
   <property name="connection.autoReconnectForPools">true</property>
   <property name="connection.is-connection-validation-required">true</property>

   <!--  <property name="c3p0.max_size">100</property>
   <property name="c3p0.min_size">10</property>
   <property name="c3p0.timeout">0</property>
   <property name="c3p0.max_statements">50</property>
    <property name="c3p0.acquire_increment">1</property>
   <property name="c3p0.idle_test_period">10</property>

   <property name="hibernate.c3p0.idleConnectionTestPeriod">300</property>
     <property name="hibernate.c3p0.minPoolSize">10</property>
   <property name="hibernate.c3p0.maxPoolSize">100</property>
   <property name="hibernate.c3p0.maxConnectionAge">14400</property>-->



   <!-- new configuration for c3p0 version 0.9.1.2-->
   <property name="hibernate.c3p0.preferredTestQuery">select 1;</property>
   <property name="c3p0.testConnectionOnCheckout">true</property>
   <!-- Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 0
   If this is a number greater than 0, c3p0 will test all idle, pooled but unchecked-out connections, every this number of seconds -->
   <property name="c3p0.acquire_increment">1</property>
   <!-- Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 0
   If this is a number greater than 0, c3p0 will test all idle, pooled but unchecked-out connections, every this number of seconds -->
   <property name="c3p0.idle_test_period">10</property>
   <property name="c3p0.initialPoolSize">3</property><!-- initialPoolSize C3P0 default: 3 -->
   <property name="c3p0.maxIdleTime">18000</property><!-- don't know the value -->
   <!-- maxPoolSize Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 100 -->
   <property name="c3p0.maxPoolSize">100</property>
   <!-- maxStatements Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 0
   The size of c3p0's PreparedStatement cache. Zero means statement caching is turned off. -->
   <property name="c3p0.max_statements">0</property>

   <!-- minPoolSize Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 1 -->
   <property name="c3p0.minPoolSize">10</property>
   <!-- testConnectionOnCheckout Must be set in c3p0.properties, C3P0 default: false
   Don't use it, this feature is very expensive. If set to true, an operation will be performed at every
   connection checkout to verify that the connection is valid. A better choice is to verify connections
   periodically using c3p0.idleConnectionTestPeriod. -->
   <property name="c3p0.testConnectionsOnCheckout">true</property>




   <!-- acquireIncrement Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 1
   Determines how many connections at a time c3p0 will try to acquire when the pool is exhausted. -->
   <property name="hibernate.c3p0.acquire_increment">1</property>

   <!-- Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 0
   If this is a number greater than 0, c3p0 will test all idle, pooled but unchecked-out connections, every this number of seconds -->
   <property name="hibernate.c3p0.idle_test_period">10</property>

   <!-- timeout Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 0
   The seconds a Connection can remain pooled but unused before being discarded. Zero means idle connections never expire. -->
   <property name="hibernate.c3p0.timeout">18000</property>

   <!-- maxPoolSize Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 100 -->
   <property name="hibernate.c3p0.max_size">100</property>

   <!-- maxStatements Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 0
   The size of c3p0's PreparedStatement cache. Zero means statement caching is turned off. -->
   <property name="hibernate.c3p0.max_statements">0</property>
   <!-- minPoolSize Must be set in hibernate.cfg.xml (or hibernate.properties), Hibernate default: 1 -->
   <property name="hibernate.c3p0.min_size">10</property>

   <property name="hibernate.show_sql">false</property>

package com.hibernate;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
/**
* Configures and provides access to Hibernate sessions, tied to the
* current thread of execution.  Follows the Thread Local Session
* pattern, see {@link http://hibernate.org/42.html}.
*/
public class SessionFactory {

    /**
     * Location of hibernate.cfg.xml file.
     * NOTICE: Location should be on the classpath as Hibernate uses
     * #resourceAsStream style lookup for its configuration file. That
     * is place the config file in a Java package - the default location
     * is the default Java package.<br><br>
     * Examples: <br>
     * <code>CONFIG_FILE_LOCATION = "/hibernate.conf.xml".
     * CONFIG_FILE_LOCATION = "/com/foo/bar/myhiberstuff.conf.xml".</code>
     */
    private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml";

    /** Holds a single instance of Session */
    private static final ThreadLocal threadLocal = new ThreadLocal();

    /** The single instance of hibernate configuration */
    private static final Configuration cfg = new Configuration();

    /** The single instance of hibernate SessionFactory */
    private static org.hibernate.SessionFactory sessionFactory;

    /**
     * Returns the ThreadLocal Session instance.  Lazy initialize
     * the <code>SessionFactory</code> if needed.
     *
     *  @return Session
     *  @throws HibernateException
     */
    public static Session currentSession() throws HibernateException {
        Session session = (Session) threadLocal.get();

        if (session == null || session.isOpen() == false) {
            if (sessionFactory == null) {
                try {
                    cfg.configure(CONFIG_FILE_LOCATION);
                    sessionFactory = cfg.buildSessionFactory();
                }
                catch (Exception e) {



                    System.err.println("%%%% Error Creating SessionFactory %%%%");
                    e.printStackTrace();
                }
            }
            session = sessionFactory.openSession();
            threadLocal.set(session);
        }

        return session;
    }

    /**
     *  Close the single hibernate session instance.
     *
     *  @throws HibernateException
     */
    public static void closeSession() throws HibernateException {
        Session session = (Session) threadLocal.get();
        threadLocal.set(null);

        if (session != null) {
            session.close();
        }
    }

    /**
     * Default constructor.
     */
    private SessionFactory() {
    }

}