Sobrecarga de Memoria, Configuração Pool Connection

<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	</properties>

	<dependencies>
		<!-- https://mvnrepository.com/artifact/org.omnifaces/omnifaces -->
		<dependency>
			<groupId>org.omnifaces</groupId>
			<artifactId>omnifaces</artifactId>
			<version>3.3</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.primefaces/primefaces -->
		<dependency>
			<groupId>org.primefaces</groupId>
			<artifactId>primefaces</artifactId>
			<version>7.0</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.jboss.weld.servlet/weld-servlet -->
		<dependency>
			<groupId>org.jboss.weld.servlet</groupId>
			<artifactId>weld-servlet</artifactId>
			<version>2.4.8.Final</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.jboss/jandex -->
		<dependency>
			<groupId>org.jboss</groupId>
			<artifactId>jandex</artifactId>
			<version>2.1.1.Final</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>5.4.6.Final</version>
		</dependency>


		<!--  https://mvnrepository.com/artifact/org.hibernate/hibernate-c3p0 
			<dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-c3p0</artifactId> 
			<version>5.4.9.Final</version> </dependency> -->

		<!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
		<dependency>
			<groupId>com.mchange</groupId>
			<artifactId>c3p0</artifactId>
			<version>0.9.5.4</version>
		</dependency>


		<!-- https://mvnrepository.com/artifact/org.hibernate.common/hibernate-commons-annotations -->
		<dependency>
			<groupId>org.hibernate.common</groupId>
			<artifactId>hibernate-commons-annotations</artifactId>
			<version>5.1.0.Final</version>
		</dependency>



		<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-entitymanager -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-entitymanager</artifactId>
			<version>5.4.6.Final</version>
		</dependency>


		<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.16</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.glassfish/javax.faces -->
		<dependency>
			<groupId>org.glassfish</groupId>
			<artifactId>javax.faces</artifactId>
			<version>2.4.0</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>4.0.1</version>
			<scope>provided</scope>
		</dependency>

		<!-- https://mvnrepository.com/artifact/com.sun.faces/jsf-api -->
		<dependency>
			<groupId>com.sun.faces</groupId>
			<artifactId>jsf-api</artifactId>
			<version>2.2.13</version>
		</dependency>


		<!-- https://mvnrepository.com/artifact/javax/javaee-api -->
		<dependency>
			<groupId>javax</groupId>
			<artifactId>javaee-api</artifactId>
			<version>7.0</version>
			<scope>provided</scope>
		</dependency>

		<dependency>
			<groupId>net.bootsfaces</groupId>
			<artifactId>bootsfaces</artifactId>
			<version>1.4.1</version>
			<scope>compile</scope>
		</dependency>

		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>3.8.1</version>
			<scope>test</scope>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.json/json -->
		<dependency>
			<groupId>org.json</groupId>
			<artifactId>json</artifactId>
			<version>20180813</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.hibernate.validator/hibernate-validator -->
		<dependency>
			<groupId>org.hibernate.validator</groupId>
			<artifactId>hibernate-validator</artifactId>
			<version>6.1.0.Alpha5</version>
		</dependency>

		<dependency>
			<groupId>org.ocpsoft.rewrite</groupId>
			<artifactId>rewrite-servlet</artifactId>
			<version>3.4.1.Final</version>
		</dependency>
		<dependency>
			<groupId>org.ocpsoft.rewrite</groupId>
			<artifactId>rewrite-config-prettyfaces</artifactId>
			<version>3.4.1.Final</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>4.1.0</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/net.sourceforge.barbecue/barbecue -->
		<dependency>
			<groupId>net.sourceforge.barbecue</groupId>
			<artifactId>barbecue</artifactId>
			<version>1.5-beta1</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/net.sf.jasperreports/jasperreports -->
		<dependency>
			<groupId>net.sf.jasperreports</groupId>
			<artifactId>jasperreports</artifactId>
			<version>6.9.0</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/net.sf.jasperreports/jasperreports-fonts -->
		<dependency>
			<groupId>net.sf.jasperreports</groupId>
			<artifactId>jasperreports-fonts</artifactId>
			<version>6.9.0</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/xerces/xercesImpl -->
		<dependency>
			<groupId>xerces</groupId>
			<artifactId>xercesImpl</artifactId>
			<version>2.12.0</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-core -->
		<!-- slf4j-log4j -->
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>1.6.1</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.hsqldb/hsqldb -->
		<dependency>
			<groupId>org.hsqldb</groupId>
			<artifactId>hsqldb</artifactId>
			<version>2.5.0</version>
			<scope>test</scope>
		</dependency>

		<!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
		<dependency>
			<groupId>commons-fileupload</groupId>
			<artifactId>commons-fileupload</artifactId>
			<version>1.4</version>
		</dependency>

		<dependency>
			<groupId>commons-io</groupId>
			<artifactId>commons-io</artifactId>
			<version>2.6</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/joda-time/joda-time -->
		<dependency>
			<groupId>joda-time</groupId>
			<artifactId>joda-time</artifactId>
			<version>2.10.4</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/commons-validator/commons-validator -->
		<dependency>
			<groupId>commons-validator</groupId>
			<artifactId>commons-validator</artifactId>
			<version>1.6</version>
		</dependency>

<!-- 
		<dependency>
			<groupId>com.zaxxer</groupId>
			<artifactId>HikariCP</artifactId>
			<version>3.4.2</version>
		</dependency>
		-->

		<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-hikaricp -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-hikaricp</artifactId>
			<version>5.4.10.Final</version>
		</dependency>


	</dependencies>

	<build>
		<finalName>testbeds</finalName>
		<plugins>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.8.0</version>
				<configuration>
					<source>1.8</source>
					<target>1.8</target>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

<properties>

		<!-- Hibernate Connection Settings -->
		<property name="hibernate.connection.provider_class"
			value="com.zaxxer.hikari.hibernate.HikariConnectionProvider" />
		<property name="hibernate.hikari.dataSourceClassName"
			value="com.mysql.cj.jdbc.MysqlDataSource" />
		<property name="hibernate.hikari.dataSource.url"
			value="jdbc:mysql://localhost:3306/testbeds" />
		<property name="hibernate.hikari.dataSource.user"
			value="root" />
		<property name="hibernate.hikari.dataSource.password"
			value="root" />
		<!--
		<property name="hibernate.hikari.dataSource.cachePrepStmts"
			value="true" />
		<property
			name="hibernate.hikari.dataSource.prepStmtCacheSize" value="250" />
		<property
			name="hibernate.hikari.dataSource.prepStmtCacheSqlLimit"
			value="2048" /> -->

		<property name="hibernate.hikari.minimumIdle" value="0" />
		<property name="hibernate.hikari.maximumPoolSize" value="4" />

		<property name="hibernate.hikari.idleTimeout" value="300" />
		<property name="hibernate.hikari.maxLifetime" value="500" />

		<property name="hibernate.hikari.connectionTimeout"
			value="500" />
		<property name="hibernate.hikari.validationTimeout"
			value="300" />


		<!-- SQL Settings -->
		<property name="hibernate.dialect"
			value="org.hibernate.dialect.MySQL5InnoDBDialect" />
		<property name="hibernate.show_sql" value="false" />
		<property name="hibernate.format_sql" value="false" />
		<property name="hibernate.use_sql_comments" value="false" />

		<property name="hibernate.connection.release_mode"
			value="ON_CLOSE" />


	</properties>

</persistence-unit>

private EntityManagerFactory factory;

public EntityManagerProducer() {
	this.factory = Persistence.createEntityManagerFactory("testbedsPU");
}

@Produces
@RequestScoped
public EntityManager createEntityManager() {
	System.out.println("criar1");
	return factory.createEntityManager();
	
}

public void closeEntityManager(@Disposes EntityManager manager) {
	manager.close();
	this.factory.close();
}

import javax.enterprise.context.Dependent;

import javax.enterprise.inject.Produces;

import javax.enterprise.inject.spi.InjectionPoint;

import javax.inject.Inject;

import javax.persistence.EntityManager;

@Inject
private EntityManager em;

@SuppressWarnings({ "rawtypes", "unchecked" })
@Produces
@Dependent
public <T> DAO<T> createDAO(InjectionPoint point) {
	ParameterizedType type = (ParameterizedType) point.getType();
	Class classe = (Class) type.getActualTypeArguments()[0];
	return new DAOImpl<T>(classe, em);
}

import java.io.Serializable;

import java.util.ArrayList;

import java.util.List;

import java.util.regex.Matcher;

import java.util.regex.Pattern;

import javax.persistence.EntityManager;

import javax.persistence.PersistenceContext;

import javax.persistence.Query;

import javax.persistence.TypedQuery;

/**
 * 
 */
private static final long serialVersionUID = 422152908443386672L;

private EntityManager em;

private final Class<T> classe;

private static final FileXMLService hqlQuery;

static {
	hqlQuery = new FileXMLService("hql.xml");
}

public DAOImpl(Class<T> classe, EntityManager em) {
	this.classe = classe;
	this.em = em;
}

@Override
public T save(T entity) {
	em.persist(entity);
	em.flush();
	return entity;
}

@Override
public T update(T entity) {
	entity = em.merge(entity);
	em.flush();
	return entity;
}

@Override
public List<T> getAll() {
	String hql = "Select e from " + this.classe.getSimpleName() + " e";
	TypedQuery<T> query = em.createQuery(hql, this.classe);
	return query.getResultList();
}

@Override
public List<T> findByHQLQuery(String queryId, int maxResults) {
	String hql = hqlQuery.findValue(queryId);
	TypedQuery<T> query = em.createQuery(hql, this.classe);
	return maxResults == 0 ? query.getResultList() : query.setMaxResults(maxResults).getResultList();

}

@Override
public List<T> findByHQLQuery(String queryId, List<Object> value, int maxResults) {
	String hql = hqlQuery.findValue(queryId);
	Pattern pattern = Pattern.compile("(:\\w+)");
	Matcher matcher = pattern.matcher(hql);
	List<String> params = new ArrayList<>();
	while (matcher.find()) {
		params.add(matcher.group().replace(":", ""));
	}
	// System.out.println();
	// System.out.print(hql);
	TypedQuery<T> query = em.createQuery(hql, this.classe);
	for (int i = 0; i < params.size(); i++) {
		// System.out.println(params.get(i) + " - " + value.get(i));
		query.setParameter(params.get(i), value.get(i));
	}
	// System.out.println();
	// System.out.println();
	
	return maxResults == 0 ? query.getResultList() : query.setMaxResults(maxResults).getResultList();
	//System.out.println("a13");
	// return null;
}

// para aqueles que gosta de anotar as querie na model
@Override
public List<T> findByHQLNamedQuery(String queryNamed, int maxResults) {
	String hql = queryNamed;
	TypedQuery<T> query = em.createNamedQuery(hql, this.classe);
	return maxResults == 0 ? query.getResultList() : query.setMaxResults(maxResults).getResultList();

}

@Override
public List<T> findByHQLNamedQuery(String queryNamed, List<Object> value, int maxResults) {
	String hql = queryNamed;
	Pattern pattern = Pattern.compile("(:\\w+)");
	Matcher matcher = pattern.matcher(hql);
	List<String> params = new ArrayList<>();
	while (matcher.find()) {
		params.add(matcher.group().replace(":", ""));
	}
	// System.out.println();
	// System.out.print(hql);
	TypedQuery<T> query = em.createNamedQuery(hql, this.classe);
	for (int i = 0; i < params.size(); i++) {
		// System.out.println(params.get(i) + " - " + value.get(i));
		query.setParameter(params.get(i), value.get(i));
	}
	// System.out.println();
	// System.out.println();		
	return maxResults == 0 ? query.getResultList() : query.setMaxResults(maxResults).getResultList();
	// return null;
}

@Override
public int updateHQLQuery(String queryId) {
	String hql = hqlQuery.findValue(queryId);
	// System.out.println(hql);
	Query query = em.createQuery(hql);
	int updateCount = query.executeUpdate();
	em.flush();
	return updateCount;
}

@Override
public int updateHQLQuery(String queryId, List<Object> value) {
	String hql = hqlQuery.findValue(queryId);
	Pattern pattern = Pattern.compile("(:\\w+)");
	Matcher matcher = pattern.matcher(hql);
	List<String> params = new ArrayList<>();
	while (matcher.find()) {
		params.add(matcher.group().replace(":", ""));
	}
	// System.out.print(hql);
	Query query = em.createQuery(hql);
	for (int i = 0; i < params.size(); i++) {
		query.setParameter(params.get(i), value.get(i));
	}
	int updateCount = query.executeUpdate();
	em.flush();
	return updateCount;
}

@Override
public void remove(T entity) {
	em.remove(em.contains(entity) ? entity : em.merge(entity));
	em.flush();
}

@Override
public T findById(Serializable id) {
	/*if (em == null)
		System.out.println("em is null");
	
	if (id == null)
		System.out.println("id is null");
	
	if (this.classe == null)
		System.out.println("classe is null");
	
	if (em.find(this.classe, id) == null)
		System.out.println(this.classe + " " + id);*/

	return em.find(this.classe, id);
}

@Override
public Query query(String hql) {
	return em.createQuery(hql);
}

@Override
public T refreshEntity(T entity) {
	if(entity == null) 
		System.out.println(entity);
	em.refresh(entity);
	return entity;
}

@SuppressWarnings("unchecked")
@Override
public List<T> execSQLNative(String SQL) {
	return em.createNativeQuery(SQL, this.classe).getResultList();
}