EntityManagerFactory sessão fechada

Programação Java
, , ,
#1

Sobre este tópico: Alteração no banco de dados e atualizar da entidade - Resolvido

Resolveu, mas agora dá outro erro de EntityManagerFactory is closed

Criei esta classe:

package br.com.netsoft.dao;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

public class JPAUtility {

	private static final EntityManagerFactory emFactory;
	static {
		emFactory = Persistence.createEntityManagerFactory("desif");
	}

	public static EntityManager getEntityManager() {
		return emFactory.createEntityManager();
	}

	public static void close() {
		emFactory.close();
	}
}

No DAO genérico, criei estes métodos:

protected EntityManager getEntityManager() {
	return JPAUtility.getEntityManager();
}

private void jpaFechar() {
	JPAUtility.close();
}

private void fechar() {
	getEntityManager().clear();
	jpaFechar();
}

Método de buscar

public Set<?> listar(GHEntity entidadeUm, GHEntity entidadeDois,
			Integer primeiroRegistro, Integer totalRegistros,
			String... ordenacao) throws Exception {
	getEntityManager();
	List aux = new ArrayList<>();
	Session sessao = (Session) getEntityManager().getDelegate();
	Criteria crit = sessao.createCriteria(entidadeUm.getClass());
	montaRestricoes(entidadeUm, entidadeDois, crit,
			new DadosDeSuporteAPesquisa());
	contarTodos(entidadeUm, entidadeDois);
	ordenar(crit, ordenacao);
	if (primeiroRegistro >= 0 && totalRegistros > 0) {
		if (!(total.equals(new Long(0)))) {
			crit.setFirstResult(primeiroRegistro);
			crit.setMaxResults(totalRegistros);
		}
	}
	aux = crit.list();
	sessao.evict(entidadeUm);
	jpaFechar();
	return aux;
}

Entendi que o problema é que o EntityManagerFactory, fechou. Mas ainda não descobri como ajustar

00:04:45,845 ERROR [stderr] (default task-17) java.lang.IllegalStateException: EntityManagerFactory is closed

00:04:45,845 ERROR [stderr] (default task-17) 	at org.hibernate.jpa.internal.EntityManagerFactoryImpl.validateNotClosed(EntityManagerFactoryImpl.java:388)

00:04:45,845 ERROR [stderr] (default task-17) 	at org.hibernate.jpa.internal.EntityManagerFactoryImpl.internalCreateEntityManager(EntityManagerFactoryImpl.java:342)

00:04:45,848 ERROR [stderr] (default task-17) 	at org.hibernate.jpa.internal.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:313)

00:04:45,850 ERROR [stderr] (default task-17) 	at br.com.netsoft.dao.JPAUtility.getEntityManager(JPAUtility.java:15)

00:04:45,850 ERROR [stderr] (default task-17) 	at br.com.netsoft.dao.GHDAO.getEntityManager(GHDAO.java:71)

00:04:45,850 ERROR [stderr] (default task-17) 	at br.com.netsoft.dao.GHDAO.listar(GHDAO.java:106)

00:04:45,850 ERROR [stderr] (default task-17) 	at br.com.netsoft.configuracao.auth.JwtUserDetailsService.loadUserByUsername(JwtUserDetailsService.java:28)

00:04:45,850 ERROR [stderr] (default task-17) 	at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$UserDetailsServiceDelegator.loadUserByUsername(WebSecurityConfigurerAdapter.java:442)

00:04:45,851 ERROR [stderr] (default task-17) 	at br.com.netsoft.configuracao.auth.JwtAuthorizationTokenFilter.doFilterInternal(JwtAuthorizationTokenFilter.java:74)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

00:04:45,851 ERROR [stderr] (default task-17) 	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)

00:04:45,852 ERROR [stderr] (default task-17) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

00:04:45,862 ERROR [stderr] (default task-17) 	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)

00:04:45,862 ERROR [stderr] (default task-17) 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

00:04:45,862 ERROR [stderr] (default task-17) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

00:04:45,862 ERROR [stderr] (default task-17) 	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)

00:04:45,862 ERROR [stderr] (default task-17) 	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)

00:04:45,862 ERROR [stderr] (default task-17) 	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

00:04:45,863 ERROR [stderr] (default task-17) 	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

00:04:45,863 ERROR [stderr] (default task-17) 	at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

00:04:45,863 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

00:04:45,864 ERROR [stderr] (default task-17) 	at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:248)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:77)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:167)

00:04:45,864 ERROR [stderr] (default task-17) 	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)

00:04:45,865 ERROR [stderr] (default task-17) 	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:761)

00:04:45,865 ERROR [stderr] (default task-17) 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

00:04:45,865 ERROR [stderr] (default task-17) 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

00:04:45,865 ERROR [stderr] (default task-17) 	at java.lang.Thread.run(Thread.java:748)

00:04:45,865 ERROR [io.undertow.request] (default task-17) UT005023: Exception handling request to /des-if-web/admin/usuarioEmpresaRecurso/buscar: java.lang.NullPointerException
	at br.com.netsoft.configuracao.auth.JwtUserFactory.mapToGrantedAuthorities(JwtUserFactory.java:28) [classes:]
	at br.com.netsoft.configuracao.auth.JwtUserFactory.create(JwtUserFactory.java:21) [classes:]
	at br.com.netsoft.configuracao.auth.JwtUserDetailsService.loadUserByUsername(JwtUserDetailsService.java:38) [classes:]
	at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$UserDetailsServiceDelegator.loadUserByUsername(WebSecurityConfigurerAdapter.java:442) [spring-security-config-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at br.com.netsoft.configuracao.auth.JwtAuthorizationTokenFilter.doFilterInternal(JwtAuthorizationTokenFilter.java:74) [classes:]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:248) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:77) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:167) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:761) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
#2

@guilhermebhte

Cara se está usando JPA para que um Session??? Basta fazer algo mais simples…

{

 EntityManager em = getEntityManager();
 em.getTransaction().begin();
 Query query = em.createQuery("SELECT * FOM Tabela");
 List<EntidadeUm> lista = (List<EntitdadeUm>) query.getResultList();
 em.close();

}

Com isso você faz a pesquisa com JPA, sei que tem mais código mas você pode automatizar em métodos de pesquisa para facilitar o trabalho…até pode utilizar NamedQuery para organizar seus códigos sql dentro da calsse de entidade.

#3

Cara, não sei se é uma boa prática fechar seu EM, eu n faço isso.
Pq com JPA mtos subobjetos retornados da consulta são carregados só qnd vc for acessá-los, ai como vc fechou seu EM, vai dar erro mesmo.

#4

Entendi.

O problema que dá erro de conexões abertas. Assim quando passa de 100.

#5

Tirando o método jpaFechar();.

Por esta consulta: SELECT COUNT(*) from pg_stat_activity;, quando ficar superior a 120.

Não entendi porque só aumenta.

Mostra este erro:

11:13:16,277 ERROR [br.com.netsoft.desif.controller.usuario.UsuarioEmpresaController] (default task-29) Erro ao pesquisar br.com.netsoft.desif.controller.usuario.UsuarioEmpresaController: org.hibernate.exception.GenericJDBCException: Could not open connection
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:63) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:162) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:160) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1885) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.doQuery(Loader.java:910) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2554) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2540) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.Loader.list(Loader.java:2365) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at br.com.netsoft.dao.GHDAO.contarTodos(GHDAO.java:139) [classes:]
	at br.com.netsoft.dao.GHDAO.listar(GHDAO.java:112) [classes:]
	at br.com.netsoft.desif.servico.usuario.UsuarioEmpresaServico.listar(UsuarioEmpresaServico.java:38) [classes:]
	at br.com.netsoft.desif.servico.usuario.UsuarioEmpresaServico.pesquisar(UsuarioEmpresaServico.java:74) [classes:]
	at br.com.netsoft.desif.controller.usuario.UsuarioEmpresaController.buscar(UsuarioEmpresaController.java:50) [classes:]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_131]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_131]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_131]
	at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_131]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:220) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:134) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) [spring-webmvc-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
	at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:86) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at br.com.netsoft.configuracao.auth.JwtAuthorizationTokenFilter.doFilterInternal(JwtAuthorizationTokenFilter.java:90) [classes:]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:248) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:77) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:167) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:761) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/desif-ds
	at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:154)
	at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228) [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
	... 101 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/desif-ds
	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:442)
	at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:421)
	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:515)
	at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)
	... 104 more
Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (30000 [ms])
	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:511)
	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:461)
	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:433)
	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:379)
	... 107 more
#6

Porque entendi que para usar o createCriteria, tem que ter sessão.

#7

Neste caso o problema é que vc está sempre criando uma nova, n reaproveitando as q ja tem.

#8

Sim, imaginei isto. Mas como resolver ?

Se eu criar o EntityManager assim, não dá este erro, mas quando altero no banco ou no sistema ele não mostra na aplicação, somente se reiniciar o servidor.

protected EntityManager entityManager;
    public EntityManager getEntityManager() {
    	if (entityManager == null) {
    		EntityManagerFactory factory = Persistence
    				.createEntityManagerFactory("desif");
    		entityManager = factory.createEntityManager();
    	}
    	return entityManager;
    }
#9

mas e pq ta criando uma factory nova pra criar um EM?
a factory é única.

#10

Em qual linha exata dá o erro que a conexao está fechada? Em algum momento voce debugando fechou a conexão antes?

#11

Então estava fazendo alterações e não estavam mostrando na tela. Foi ajustado conforme este tópico: Alteração no banco de dados e atualizar da entidade - Resolvido

Ai começou a dar este erro.

#12

Entendo quem fecha a conexão é este método:

private void jpaFechar() {
	JPAUtility.close();
}

Quando chega a 120 não faz mais consulta no BD

Mostra este erro:

13:25:34,674 INFO  [stdout] (default task-27) Hibernate: select distinct count(distinct (this_.PK_USUARIO)) as y0_ from USUARIOS.TB_USUARIO this_ where this_.DS_LOGIN=?

13:26:04,675 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-27) SQL Error: 0, SQLState: null
13:26:04,676 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-27) javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/desif-ds
13:26:04,677 ERROR [stderr] (default task-27) org.hibernate.exception.GenericJDBCException: Could not open connection

13:26:04,678 ERROR [stderr] (default task-27) 	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)

13:26:04,678 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)

13:26:04,678 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)

13:26:04,679 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:235)

13:26:04,679 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:171)

13:26:04,680 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:63)

13:26:04,680 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:162)

13:26:04,680 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186)

13:26:04,681 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:160)

13:26:04,681 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1885)

13:26:04,681 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)

13:26:04,682 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)

13:26:04,682 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.doQuery(Loader.java:910)

13:26:04,682 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)

13:26:04,682 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.doList(Loader.java:2554)

13:26:04,683 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.doList(Loader.java:2540)

13:26:04,683 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)

13:26:04,683 ERROR [stderr] (default task-27) 	at org.hibernate.loader.Loader.list(Loader.java:2365)

13:26:04,684 ERROR [stderr] (default task-27) 	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126)

13:26:04,684 ERROR [stderr] (default task-27) 	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1682)

13:26:04,685 ERROR [stderr] (default task-27) 	at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)

13:26:04,685 ERROR [stderr] (default task-27) 	at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:402)

13:26:04,685 ERROR [stderr] (default task-27) 	at br.com.netsoft.dao.GHDAO.contarTodos(GHDAO.java:150)

13:26:04,686 ERROR [stderr] (default task-27) 	at br.com.netsoft.dao.GHDAO.listar(GHDAO.java:123)

13:26:04,686 ERROR [stderr] (default task-27) 	at br.com.netsoft.configuracao.auth.JwtUserDetailsService.loadUserByUsername(JwtUserDetailsService.java:28)

13:26:04,686 ERROR [stderr] (default task-27) 	at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$UserDetailsServiceDelegator.loadUserByUsername(WebSecurityConfigurerAdapter.java:442)

13:26:04,687 ERROR [stderr] (default task-27) 	at br.com.netsoft.configuracao.auth.JwtAuthorizationTokenFilter.doFilterInternal(JwtAuthorizationTokenFilter.java:74)

13:26:04,687 ERROR [stderr] (default task-27) 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

13:26:04,687 ERROR [stderr] (default task-27) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

13:26:04,688 ERROR [stderr] (default task-27) 	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)

13:26:04,688 ERROR [stderr] (default task-27) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

13:26:04,688 ERROR [stderr] (default task-27) 	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)

13:26:04,688 ERROR [stderr] (default task-27) 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

13:26:04,689 ERROR [stderr] (default task-27) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

13:26:04,689 ERROR [stderr] (default task-27) 	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)

13:26:04,689 ERROR [stderr] (default task-27) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

13:26:04,689 ERROR [stderr] (default task-27) 	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)

13:26:04,690 ERROR [stderr] (default task-27) 	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

13:26:04,690 ERROR [stderr] (default task-27) 	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

13:26:04,690 ERROR [stderr] (default task-27) 	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)

13:26:04,690 ERROR [stderr] (default task-27) 	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)

13:26:04,691 ERROR [stderr] (default task-27) 	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

13:26:04,691 ERROR [stderr] (default task-27) 	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

13:26:04,691 ERROR [stderr] (default task-27) 	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)

13:26:04,691 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)

13:26:04,691 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)

13:26:04,691 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

13:26:04,692 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

13:26:04,692 ERROR [stderr] (default task-27) 	at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

13:26:04,692 ERROR [stderr] (default task-27) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

13:26:04,692 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

13:26:04,692 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

13:26:04,692 ERROR [stderr] (default task-27) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

13:26:04,693 ERROR [stderr] (default task-27) 	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

13:26:04,693 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

13:26:04,693 ERROR [stderr] (default task-27) 	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)

13:26:04,693 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)

13:26:04,693 ERROR [stderr] (default task-27) 	at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)

13:26:04,693 ERROR [stderr] (default task-27) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

13:26:04,693 ERROR [stderr] (default task-27) 	at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

13:26:04,694 ERROR [stderr] (default task-27) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

13:26:04,694 ERROR [stderr] (default task-27) 	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

13:26:04,694 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)

13:26:04,694 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:248)

13:26:04,694 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:77)

13:26:04,694 ERROR [stderr] (default task-27) 	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:167)

13:26:04,695 ERROR [stderr] (default task-27) 	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)

13:26:04,695 ERROR [stderr] (default task-27) 	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:761)

13:26:04,695 ERROR [stderr] (default task-27) 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

13:26:04,695 ERROR [stderr] (default task-27) 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

13:26:04,695 ERROR [stderr] (default task-27) 	at java.lang.Thread.run(Thread.java:748)

13:26:04,696 ERROR [stderr] (default task-27) Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/desif-ds

13:26:04,696 ERROR [stderr] (default task-27) 	at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:154)

13:26:04,696 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:139)

13:26:04,696 ERROR [stderr] (default task-27) 	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:380)

13:26:04,697 ERROR [stderr] (default task-27) 	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:228)

13:26:04,697 ERROR [stderr] (default task-27) 	... 67 more

13:26:04,698 ERROR [stderr] (default task-27) Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/desif-ds

13:26:04,698 ERROR [stderr] (default task-27) 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:442)

13:26:04,698 ERROR [stderr] (default task-27) 	at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:421)

13:26:04,698 ERROR [stderr] (default task-27) 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:515)

13:26:04,699 ERROR [stderr] (default task-27) 	at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)

13:26:04,699 ERROR [stderr] (default task-27) 	... 70 more

13:26:04,700 ERROR [stderr] (default task-27) Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (30000 [ms])

13:26:04,700 ERROR [stderr] (default task-27) 	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:511)

13:26:04,700 ERROR [stderr] (default task-27) 	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:461)

13:26:04,700 ERROR [stderr] (default task-27) 	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:433)

13:26:04,702 ERROR [stderr] (default task-27) 	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:379)

13:26:04,702 ERROR [stderr] (default task-27) 	... 73 more

13:26:04,702 ERROR [io.undertow.request] (default task-27) UT005023: Exception handling request to /des-if-web/admin/paisRecurso/buscar: java.lang.NullPointerException
	at br.com.netsoft.configuracao.auth.JwtUserFactory.mapToGrantedAuthorities(JwtUserFactory.java:28) [classes:]
	at br.com.netsoft.configuracao.auth.JwtUserFactory.create(JwtUserFactory.java:21) [classes:]
	at br.com.netsoft.configuracao.auth.JwtUserDetailsService.loadUserByUsername(JwtUserDetailsService.java:38) [classes:]
	at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$UserDetailsServiceDelegator.loadUserByUsername(WebSecurityConfigurerAdapter.java:442) [spring-security-config-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at br.com.netsoft.configuracao.auth.JwtAuthorizationTokenFilter.doFilterInternal(JwtAuthorizationTokenFilter.java:74) [classes:]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177) [spring-security-web-4.2.1.RELEASE.jar:4.2.1.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) [spring-web-4.3.5.RELEASE.jar:4.3.5.RELEASE]
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:248) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:77) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:167) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:761) [undertow-core-1.1.8.Final.jar:1.1.8.Final]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
	at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
#13

Voce deve fechar a session (entitymanager no JPA), não a factory. Factory é do contexto da aplicação, que só pode ser fechado quando a aplicação stopar.

#14

Correto. Mas qual método devo utilizar para fechar a session.

Tentei usar close(), mas não funciona e lança exceção, neste código, estou perdido, kkk

Pesquisei no google, mas não consegui entender o que diz nos locais que achei na pesquisa.

public Set<?> listar(GHEntity entidadeUm, GHEntity entidadeDois,
			Integer primeiroRegistro, Integer totalRegistros,
			String... ordenacao) throws Exception {
	getEntityManager();
	List aux = new ArrayList<>();
	Session sessao = (Session) getEntityManager().getDelegate();
	Criteria crit = sessao.createCriteria(entidadeUm.getClass());
	montaRestricoes(entidadeUm, entidadeDois, crit,
			new DadosDeSuporteAPesquisa());
	contarTodos(entidadeUm, entidadeDois);
	ordenar(crit, ordenacao);
	if (primeiroRegistro >= 0 && totalRegistros > 0) {
		if (!(total.equals(new Long(0)))) {
			crit.setFirstResult(primeiroRegistro);
			crit.setMaxResults(totalRegistros);
		}
	}
	aux = crit.list();
	sessao.evict(entidadeUm);
	jpaFechar();
	return aux;
}
#15

É bem simples:

EntityManager em = JPAUtility.getEntityManager(); //vai abrir a session da implementação do Hibernate
try {
   //faz tudo que é necessário no banco
   //...
   //nada mais deve necessitar do banco a partir daqui, apenas objeto java sem tocar em lazy, etc
   //...
}
finally {
  em.Close(); //vai fechar a session da implementação do Hibernate
}
#16

Obrigado.

Até então está ok, sem problemas.

#17

Fiz vários testes e até o momento está ok.

Obrigado @javaflex…

#18

Ficando assim:

public Set<?> listar(GHEntity entidadeUm, GHEntity entidadeDois,
			Integer primeiroRegistro, Integer totalRegistros,
			String... ordenacao) throws Exception {
		EntityManager em = JPAUtility.getEntityManager();
		RecordDataSet<GHEntity> linkedHashSet;
		try {
			List aux = new ArrayList<>();
			Session sessao = (Session) em.getDelegate();
			Criteria crit = sessao.createCriteria(entidadeUm.getClass());
			montaRestricoes(entidadeUm, entidadeDois, crit,
					new DadosDeSuporteAPesquisa());
			contarTodos(entidadeUm, entidadeDois);
			ordenar(crit, ordenacao);
			if (primeiroRegistro >= 0 && totalRegistros > 0) {
				if (!(total.equals(new Long(0)))) {
					crit.setFirstResult(primeiroRegistro);
					crit.setMaxResults(totalRegistros);
				}
			}
			aux = crit.list();
			linkedHashSet = new RecordDataSet<GHEntity>(aux);
			linkedHashSet.setTotal(total);
			sessao.evict(entidadeUm);
		} finally {
			em.close();
		}
		return linkedHashSet;
	}