<property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
		<property name="hibernate.c3p0.min_size">1</property>
		<property name="hibernate.c3p0.max_size">10</property>
		<property name="hibernate.c3p0.timeout">3000</property>
		<property name="hibernate.c3p0.max_statements">50</property>
		<property name="hibernate.c3p0.idle_test_period">300</property>

			SessionFactory factory = HibernateUtil.getSessionFactory();
			Session hSession = factory.openSession();
			Transaction tx = null;
			
			long total = 0;
			try {
				tx = hSession.beginTransaction();
				Criteria count = hSession.createCriteria(UserTable.class);
				count.setProjection(Projections.rowCount());
				total = (long) count.uniqueResult();
				tx.commit();
			} catch (Exception e) {
				if (tx != null)
					tx.rollback();
			} finally {
				hSession.close();
			}