Configuração Jpa+Hibernate+Tomcat+C3PO

ligabue · Fevereiro 20, 2020, 12:23am

Boa noite.

Pessoal estou com um problema que acredito que muitos ja passaram e que tem bastante conteudo aqui no forúm, porém fiz diversas tentativas e nenhuma delas consegui solucionar o problema que é sobre o broken pipe. Minha aplicação esta hospedada na nuvem (Integrator) e meu sistema roda durante o dia e funciona normal, porém de um dia para o outro ocorre o erro:

HTTP Status 500 – Internal Server Error

Type Exception Report

Message Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:979)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Root Cause

javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
	org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)
	org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
	org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:560)
	br.com.loja.projetoloja.dao.UsuarioDao.buscaPorUsuario(UsuarioDao.java:39)
	br.com.loja.projetoloja.dao.UsuarioDao.verificaUsuario(UsuarioDao.java:19)
	br.com.loja.projetoloja.controller.IndexController.efetuaLogin(IndexController.java:35)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Root Cause

org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
	org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
	org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
	org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2115)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1874)
	org.hibernate.loader.Loader.doQuery(Loader.java:919)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
	org.hibernate.loader.Loader.doList(Loader.java:2610)
	org.hibernate.loader.Loader.doList(Loader.java:2593)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422)
	org.hibernate.loader.Loader.list(Loader.java:2417)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
	org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
	org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339)
	org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
	org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
	org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529)
	br.com.loja.projetoloja.dao.UsuarioDao.buscaPorUsuario(UsuarioDao.java:39)
	br.com.loja.projetoloja.dao.UsuarioDao.verificaUsuario(UsuarioDao.java:19)
	br.com.loja.projetoloja.controller.IndexController.efetuaLogin(IndexController.java:35)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Root Cause

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 52960 ms ago.
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2115)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1874)
	org.hibernate.loader.Loader.doQuery(Loader.java:919)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
	org.hibernate.loader.Loader.doList(Loader.java:2610)
	org.hibernate.loader.Loader.doList(Loader.java:2593)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422)
	org.hibernate.loader.Loader.list(Loader.java:2417)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
	org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
	org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339)
	org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
	org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
	org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529)
	br.com.loja.projetoloja.dao.UsuarioDao.buscaPorUsuario(UsuarioDao.java:39)
	br.com.loja.projetoloja.dao.UsuarioDao.verificaUsuario(UsuarioDao.java:19)
	br.com.loja.projetoloja.controller.IndexController.efetuaLogin(IndexController.java:35)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Root Cause

java.net.SocketException: Broken pipe (Write failed)
	java.net.SocketOutputStream.socketWrite0(Native Method)
	java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
	java.net.SocketOutputStream.write(SocketOutputStream.java:155)
	java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
	java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
	com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3227)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
	com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
	org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
	org.hibernate.loader.Loader.getResultSet(Loader.java:2115)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
	org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1874)
	org.hibernate.loader.Loader.doQuery(Loader.java:919)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
	org.hibernate.loader.Loader.doList(Loader.java:2610)
	org.hibernate.loader.Loader.doList(Loader.java:2593)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422)
	org.hibernate.loader.Loader.list(Loader.java:2417)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
	org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
	org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
	org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339)
	org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
	org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
	org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529)
	br.com.loja.projetoloja.dao.UsuarioDao.buscaPorUsuario(UsuarioDao.java:39)
	br.com.loja.projetoloja.dao.UsuarioDao.verificaUsuario(UsuarioDao.java:19)
	br.com.loja.projetoloja.controller.IndexController.efetuaLogin(IndexController.java:35)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

Note The full stack trace of the root cause is available in the server logs.
Apache Tomcat/9.0.4

O Pessoal da Integrator diz que é minha configuração que está errada.

Vou postar meu codigo aqui de repente alguem possar ver o que está errado e me ajudar.

Minha classe do EntityManager:

package br.com.loja.projetoloja.util;

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

public class JPAUtil {
	private static EntityManager em;

	public static EntityManager getEntityManager() {
		if (em == null) {
			EntityManagerFactory emFactory = Persistence
					.createEntityManagerFactory("mysql");
			em = emFactory.createEntityManager();
		}
		return em;
	}	
	
	public static void init() {
		EntityTransaction tx = getEntityManager().getTransaction();
		if (tx == null || !tx.isActive()) {
			System.out.println("Iniciando transacao...");
			tx.begin();
		}
	}
	
	public static void commit() {
		EntityTransaction transaction = getEntityManager().getTransaction();
		if (transaction != null && transaction.isActive()
				&& !transaction.getRollbackOnly()) {
			transaction.commit();
		} else {
			rollback();
		}
	}
	public static void rollback() {
		EntityTransaction transaction = getEntityManager().getTransaction();
		if (transaction.isActive() || transaction.getRollbackOnly()) {
			transaction.rollback();
		}
	}		

}

Meu arquivo persistence.xml

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
	version="2.0">

	<persistence-unit name="mysql">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		
		<class>br.com.loja.projetoloja.modelo.Contato</class>
		<class>br.com.loja.projetoloja.modelo.Usuario</class>
		<class>br.com.loja.projetoloja.modelo.Veiculo</class>
		<class>br.com.loja.projetoloja.modelo.Pessoa</class>
		<class>br.com.loja.projetoloja.modelo.Marca</class>
		<class>br.com.loja.projetoloja.modelo.Modelo</class>
		<class>br.com.loja.projetoloja.modelo.Versao</class>
		<class>br.com.loja.projetoloja.modelo.Venda</class>
		<class>br.com.loja.projetoloja.modelo.Compra</class>
		<class>br.com.loja.projetoloja.modelo.Contasapagar</class>
		<class>br.com.loja.projetoloja.modelo.Logs</class>
		<class>br.com.loja.projetoloja.modelo.ContasPagasePagar</class>
		
		<properties>
		
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>

            <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/XXXXXX?autoReconnect=true"/>  
            <property name="hibernate.connection.username" value="XXXXX" />  
            <property name="hibernate.connection.password" value="XXXXX" />    
                                     
            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" />  
       		<property name="hibernate.connection.provider" value="org.hibernate.connection.C3P0ConnectionProvider" />
			<property name="hibernate.show_sql" value="true" />
			<property name="hibernate.format_sql" value="true" />	       		
       		<property name="hibernate.c3p0.acquire_increment" value="2" />						       		              		  
          	<property name="hibernate.c3p0.min_size" value="5" />  
           	<property name="hibernate.c3p0.max_size" value="100" />  
           	<property name="hibernate.c3p0.timeout" value="300" />  
           	<property name="hibernate.c3p0.max_statements" value="50" />  
           	<property name="hibernate.c3p0.idle_test_period" value="3000" />    
			<property name="hibernate.c3p0.validate" value="true" />
			<property name="hibernate.c3p0.preferred_test_query" value="SELECT 1;" />	
		
						
		</properties>
	</persistence-unit>


</persistence>

Meu pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>Loja</groupId>
	<artifactId>projetoLoja</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>war</packaging>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<jackson.version>1.9.10</jackson.version>
	</properties>

	<build>
		<plugins>
			<plugin>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.1</version>
				<configuration>
					<source>1.8</source> <!-- versao do java -->
					<target>1.8</target>
				</configuration>
			</plugin>
		</plugins>
	</build>

	<dependencies>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.16</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>1.7.1</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>1.7.1</version>
		</dependency>

		<!-- Servlet -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>3.0.1</version>
			<scope>provided</scope>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>javax.servlet.jsp</groupId>
			<artifactId>jsp-api</artifactId>
			<version>2.2</version>
			<scope>provided</scope>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>

		<!-- JPA /Hibernate -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>5.1.0.Final</version>
		</dependency>

		<!-- for JPA, use hibernate-entitymanager instead of hibernate-core -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-entitymanager</artifactId>
			<version>5.1.0.Final</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.6</version>
		</dependency>

		<!-- Sql Server <dependency> <groupId>com.microsoft.sqlserver</groupId> 
			<artifactId>sqljdbc4</artifactId> <version>4.0</version> </dependency> -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>4.2.6.RELEASE</version>
		</dependency>
		
		<dependency>
            <groupId>com.google.code.gson</groupId>
            <artifactId>gson</artifactId>
            <version>2.3</version>
        </dependency>

		<!-- https://mvnrepository.com/artifact/net.sf.jasperreports/jasperreports -->
		<dependency>
			<groupId>net.sf.jasperreports</groupId>
			<artifactId>jasperreports</artifactId>
			<version>4.1.1</version>
		</dependency>
		
		<dependency>
		    <groupId>jaxen</groupId>
		    <artifactId>jaxen</artifactId>
		    <version>1.1.6</version>
		</dependency>
		
		<!-- https://mvnrepository.com/artifact/jsptags/pager-taglib -->
		<dependency>
		    <groupId>jsptags</groupId>
		    <artifactId>pager-taglib</artifactId>
		    <version>2.0</version>
		</dependency>
		
		<!-- Jackson -->
		<dependency>
			<groupId>org.codehaus.jackson</groupId>
			<artifactId>jackson-mapper-asl</artifactId>
			<version>${jackson.version}</version>
		</dependency>	
		
 		<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-c3p0 -->
 		<!--
		<dependency>
		    <groupId>org.hibernate</groupId>
		    <artifactId>hibernate-c3p0</artifactId>
		    <version>5.4.1.Final</version>
		</dependency> -->
		
		 <dependency>  
             <groupId>com.mchange</groupId>  
             <artifactId>mchange-commons-java</artifactId>  
             <version>0.2.10</version>  
         </dependency>  
         <dependency>  
             <groupId>c3p0</groupId>  
             <artifactId>c3p0</artifactId>  
             <version>0.9.1.2</version>  
         </dependency> 
		
		<!-- https://mvnrepository.com/artifact/org.json/json -->
		<dependency>
		    <groupId>org.json</groupId>
		    <artifactId>json</artifactId>
		    <version>20180813</version>
		</dependency>
		
		<!-- https://mvnrepository.com/artifact/com.googlecode.json-simple/json-simple -->
		<dependency>
		    <groupId>com.googlecode.json-simple</groupId>
		    <artifactId>json-simple</artifactId>
		    <version>1.1.1</version>
		</dependency>	
		
<!-- 		<dependency>
		    <groupId>net.sf.jasperreports</groupId>
		    <artifactId>jasperreports</artifactId>
		    <version>5.5.0</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/com.lowagie/itext -->
		<dependency>
		    <groupId>com.lowagie</groupId>
		    <artifactId>itext</artifactId>
		    <version>4.2.0</version>
		</dependency>
																			
	</dependencies>


	<!-- Spring Repository -->
	<repositories>
		<repository>
			<id>spring-milestones</id>
			<name>Spring Milestones</name>
			<url>https://repo.spring.io/libs-milestone</url>
			<snapshots>
				<enabled>false</enabled>
			</snapshots>
		</repository>
	</repositories>
</project>

Meu web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
  	<display-name>projetoLoja</display-name>
  	<welcome-file-list>
    	<welcome-file>index.jsp</welcome-file>
  	</welcome-file-list>  		  	
  	<servlet>
    	<servlet-name>spring mvc</servlet-name>
    	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    	<init-param>
      		<param-name>contextConfigLocation</param-name>
      		<param-value>classpath:applicationContext.xml</param-value>
    	</init-param>
  	</servlet>
  	<servlet-mapping>
    	<servlet-name>spring mvc</servlet-name>
    	<url-pattern>/</url-pattern>
  	</servlet-mapping>
  	<session-config>
    	<session-timeout>30</session-timeout>
  	</session-config>  
	<filter>
	     <filter-name>SetCharacterEncodingFilter</filter-name>
	     <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
	     <init-param>
	         <param-name>encoding</param-name>
	         <param-value>UTF8</param-value>
	     </init-param>
	     <init-param>
	         <param-name>forceEncoding</param-name>
	         <param-value>true</param-value>
	     </init-param>
	</filter>
	<filter-mapping>
		<filter-name>SetCharacterEncodingFilter</filter-name>
	    <url-pattern>/*</url-pattern>
	</filter-mapping>  
</web-app>

Se algume tiver uma ideia ou dica para me dar ficarei muito grato, já que esgotei minhas tentativas.

Att,
Alexandre

javaflex · Fevereiro 20, 2020, 1:48am

Você tem que abrir e fechar a conexão a cada requisição. Não usar Hibernate seria a opção mais eficiente em consumo de recursos.

ligabue · Fevereiro 20, 2020, 8:41pm

Olá javaflex agradeço a resposta, mas o sistema já esta rodando tirar o Hibernate agora demandaria uma mudança brusca no projeto, no caso de abrir e fechar as conexões não seria papel do c3po fazer isso?

javaflex · Fevereiro 20, 2020, 10:39pm

Essas ferramentas são muito exotéricas, prefiro ter o controle da conexão. Exemplo mais fácil: https://developer.jboss.org/wiki/OpenSessionInView

Configuração Jpa+Hibernate+Tomcat+C3PO

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI