List records = session.find(
                "from HibernateConsumptionRecord as record where record.userId = ?"
                + " and record.consumptionDate >= ? and record.consumptionDate <= ?",
                new Object[] { userId, startDate,  endDate},
                new Type[] { Hibernate.STRING, Hibernate.DATE, Hibernate.DATE }
            );

public class TVMHibernateUtil {

    private static Logger logger = Logger.getLogger("TVMHibernateUtil");

    // Used for log messages (DEBUGGING)
    private String CLASS_NAME = "tellarian.valuation.valuator.session.TVMHibernateUtil";

    // For Connection
    private static String file = "/hibernate.cfg.xml";
   
   
    //Get a SessionFactory
    private static final SessionFactory sessionFactory;

    static {
        try {
            // Create the SessionFactory
            URL url = TVMHibernateUtil.class.getResource(file);
            sessionFactory = new Configuration().configure(url).buildSessionFactory();
        } catch (Throwable ex) {
            logger.error("Initial SessionFactory creation failed.", ex);
            throw new ExceptionInInitializerError(ex);
        }
    }
   
    /**
     * <p>
     * Sets the associated session context. The container calls this method after the instance creation.
     * </p>
     */
    public static Session openSession() throws HibernateException{
        try {
            Session session;
           
             session = sessionFactory.openSession();
                       
            return session;
        } catch (HibernateException e) {
            logger.debug("Error while opening hibernate session: " + e);
            throw e;
        }
    }
   
   
    public static void closeSession(Session session) throws HibernateException{
        try {
           if(!session.isOpen()){
               session.close();
           }       
        } catch (HibernateException e) {
            logger.debug("Error while closing hibernate session: " + e);
            throw e;
        }
    }
}

public class TVMHibernateManager {

    private static Logger logger = Logger.getLogger("TVMHibernateManager");
   
    private static String CLASS_NAME = "TVMHibernateManager";
   
    /**
     * Persist a record to the database
     */   
    public void saveRecord(HibernateConsumptionRecord record){
        try {
            Session session = TVMHibernateUtil.openSession();
           
            session.save(record);
            session.flush();
           
            TVMHibernateUtil.closeSession(session);
        } catch (Exception e){
            e.printStackTrace();   
        }
    }
   
    /**
     * Find all records that correspond to this user Id
     */
    public List getRecordsByUserId(String userId) throws TellarianException{
        String methodName = "getRecordsByUserId";
       
        try {
            Session session = TVMHibernateUtil.openSession();
           
            List records = session.find(
                "from HibernateConsumptionRecord as record where record.userId = ?",
                userId,
                Hibernate.STRING
            );                                   
           
            TVMHibernateUtil.closeSession(session);
           
            return records;
        } catch (HibernateException e){
            logger.error(e);
            throw new TellarianException(CLASS_NAME, methodName,
                    "Could not find hibernate records by User Id: " + userId);
        }
    }
   
    /**
     * Find all records that correspond to this user Id and were made
     * between the given dates.
     */
    public List getRecordsByUserIdAndDates(String userId,
            Date startDate, Date endDate) throws TellarianException{
        String methodName = "getRecordsByUserIdAndDates";
       
        try {
            Session session = TVMHibernateUtil.openSession();
           
            List records = session.find(
                "from HibernateConsumptionRecord as record where record.userId = ?"
                + " and record.consumptionDate >= ? and record.consumptionDate <= ?",
                new Object[] { userId, startDate,  endDate},
                new Type[] { Hibernate.STRING, Hibernate.DATE, Hibernate.DATE }
            );                                   
           
            TVMHibernateUtil.closeSession(session);
           
            return records;
        } catch (HibernateException e){
            SimpleDateFormat dateFormat = new SimpleDateFormat();
           
            logger.error(e);
           
            throw new TellarianException(CLASS_NAME, methodName,
                    "Could not find hibernate records by User Id: " + userId
                    + " between dates: " + dateFormat.format(startDate) + " and "
                    + dateFormat.format(endDate));
        }
    }
   
    /**
     * Find all records that correspond to this cost center
     */
    public List getRecordsByCostCenter(String costCenterId) throws TellarianException{
        String methodName = "getRecordsByCostCenter";
       
        try {
            Session session = TVMHibernateUtil.openSession();
           
            List records = session.find(
                "from HibernateConsumptionRecord as record where record.costCenterId = ?",
                costCenterId,
                Hibernate.STRING
            );                                   
           
            TVMHibernateUtil.closeSession(session);
           
            return records;
        } catch (HibernateException e){
            logger.error(e);
            throw new TellarianException(CLASS_NAME, methodName,
                    "Could not find hibernate records by Cost Center: " + costCenterId);
        }
    }
   
    /**
     * Find all records that correspond to this cost center and were made
     * between the given dates.
     */
    public List getRecordsByCostCenterAndDates(String costCenterId,
            Date startDate, Date endDate) throws TellarianException {
        String methodName = "getRecordsByCostCenterAndDates";
        try {
            Session session = TVMHibernateUtil.openSession();
           
            List records = session.find(
                "from HibernateConsumptionRecord as record where record.costCenterId = ?"
                + " and record.consumptionDate >= ? and record.consumptionDate <= ?",
                new Object[] { costCenterId, startDate,  endDate},
                new Type[] { Hibernate.STRING, Hibernate.DATE, Hibernate.DATE }
            );                                   
           
            TVMHibernateUtil.closeSession(session);
           
            return records;
        } catch (HibernateException e){
            SimpleDateFormat dateFormat = new SimpleDateFormat();
           
            logger.error(e);
           
            throw new TellarianException(CLASS_NAME, methodName,
                    "Could not find hibernate records by Cost Center: " + costCenterId
                    + " between dates: " + dateFormat.format(startDate) + " and "
                    + dateFormat.format(endDate));
        }
    } 
}

logger.error(e);