import java.util.Properties;
import nix.DAO.entities.common.Contractors;
import nix.DAO.entities.common.Users;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;

public class HibernateUtil {

    private static final SessionFactory concreteSessionFactory;

    static {
        try {
            Properties prop = new Properties();
            prop.setProperty("dialect", "org.hibernate.dialect.PostgreSQLDialect");
            prop.setProperty("hibernate.connection.url", "jdbc:postgresql://127.0.0.1:5432/db");
            prop.setProperty("hibernate.connection.username", "user");
            prop.setProperty("hibernate.connection.password", "12345678");
            prop.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.EhCacheProvider");
            prop.setProperty("hibernate.cache.use_second_level_cache", "true");
            prop.setProperty("hibernate.show_sql", "true");
            prop.setProperty("hibernate.format_sql", "true");
            prop.setProperty("hibernate.generate_statistics", "true");
            prop.setProperty("hibernate.cache.use_structured_entries", "true");
            prop.setProperty("hibernate.hbm2ddl.auto", "update");

            concreteSessionFactory = new AnnotationConfiguration()
                    .addPackage("com.concretepage.persistence")
                    .addProperties(prop)
                    .addAnnotatedClass(Users.class)
                    .addAnnotatedClass(Contractors.class)
                    .buildSessionFactory();
        } catch (Throwable ex) {
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static Session getSession() throws HibernateException {
        return concreteSessionFactory.openSession();
    }

    public static void main(String... args) {
        Session session = getSession();
        session.beginTransaction();
        Users user = (Users) session.get(Users.class, new Integer(1));
        System.out.println(user.getName());
        session.close();
    }
}