Type Exception Report
Message Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Cannot open connection
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Cannot open connection org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:431) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) br.com.sesc.portal.service.ArticleService$$EnhancerBySpringCGLIB$$3e49d3bf.incrementVisit(<generated>) br.com.sesc.portal.filter.AmountVisitorsFilter.doFilter(AmountVisitorsFilter.java:99) br.com.sesc.portal.cache.CacheFilter.doFilter(CacheFilter.java:53) br.com.sesc.portal.filter.MobileFilter.doFilter(MobileFilter.java:90) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Cannot open connection org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1389) org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317) org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1399) org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:63) org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:67) org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) br.com.sesc.portal.service.ArticleService$$EnhancerBySpringCGLIB$$3e49d3bf.incrementVisit(<generated>) br.com.sesc.portal.filter.AmountVisitorsFilter.doFilter(AmountVisitorsFilter.java:99) br.com.sesc.portal.cache.CacheFilter.doFilter(CacheFilter.java:53) br.com.sesc.portal.filter.MobileFilter.doFilter(MobileFilter.java:90) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
org.hibernate.exception.JDBCConnectionException: Cannot open connection org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:99) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60) org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:67) org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) br.com.sesc.portal.service.ArticleService$$EnhancerBySpringCGLIB$$3e49d3bf.incrementVisit(<generated>) br.com.sesc.portal.filter.AmountVisitorsFilter.doFilter(AmountVisitorsFilter.java:99) br.com.sesc.portal.cache.CacheFilter.doFilter(CacheFilter.java:53) br.com.sesc.portal.filter.MobileFilter.doFilter(MobileFilter.java:90) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:347) org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:228) org.apache.tomcat.jdbc.pool.PooledConnection.reconnect(PooledConnection.java:400) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:851) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:674) org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:136) org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60) org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:67) org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) br.com.sesc.portal.service.ArticleService$$EnhancerBySpringCGLIB$$3e49d3bf.incrementVisit(<generated>) br.com.sesc.portal.filter.AmountVisitorsFilter.doFilter(AmountVisitorsFilter.java:99) br.com.sesc.portal.cache.CacheFilter.doFilter(CacheFilter.java:53) br.com.sesc.portal.filter.MobileFilter.doFilter(MobileFilter.java:90) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
oracle.net.ns.NetException: The Network Adapter could not establish the connection oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:571) oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548) oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682) oracle.net.ns.NSProtocol.connect(NSProtocol.java:309) oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:347) org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:228) org.apache.tomcat.jdbc.pool.PooledConnection.reconnect(PooledConnection.java:400) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:851) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:674) org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:136) org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60) org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:67) org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) br.com.sesc.portal.service.ArticleService$$EnhancerBySpringCGLIB$$3e49d3bf.incrementVisit(<generated>) br.com.sesc.portal.filter.AmountVisitorsFilter.doFilter(AmountVisitorsFilter.java:99) br.com.sesc.portal.cache.CacheFilter.doFilter(CacheFilter.java:53) br.com.sesc.portal.filter.MobileFilter.doFilter(MobileFilter.java:90) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
java.io.IOException: Connection refused, socket connect lapse 1 ms. portal-prd-oracle.c1kcsnxmfkpd.us-west-2.rds.amazonaws.com/172.27.1.32 1521 2000 1 true oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:233) oracle.net.nt.ConnOption.connect(ConnOption.java:174) oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510) oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548) oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682) oracle.net.ns.NSProtocol.connect(NSProtocol.java:309) oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:347) org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:228) org.apache.tomcat.jdbc.pool.PooledConnection.reconnect(PooledConnection.java:400) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:851) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:674) org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:136) org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60) org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:67) org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) br.com.sesc.portal.service.ArticleService$$EnhancerBySpringCGLIB$$3e49d3bf.incrementVisit(<generated>) br.com.sesc.portal.filter.AmountVisitorsFilter.doFilter(AmountVisitorsFilter.java:99) br.com.sesc.portal.cache.CacheFilter.doFilter(CacheFilter.java:53) br.com.sesc.portal.filter.MobileFilter.doFilter(MobileFilter.java:90) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
java.net.ConnectException: Connection refused sun.nio.ch.Net.connect0(Native Method) sun.nio.ch.Net.connect(Net.java:482) sun.nio.ch.Net.connect(Net.java:474) sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:647) java.nio.channels.SocketChannel.open(SocketChannel.java:189) oracle.net.nt.TimeoutSocketChannel.connect(TimeoutSocketChannel.java:99) oracle.net.nt.TimeoutSocketChannel.<init>(TimeoutSocketChannel.java:77) oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:192) oracle.net.nt.ConnOption.connect(ConnOption.java:174) oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510) oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548) oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682) oracle.net.ns.NSProtocol.connect(NSProtocol.java:309) oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588) oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:347) org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:228) org.apache.tomcat.jdbc.pool.PooledConnection.reconnect(PooledConnection.java:400) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:851) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:674) org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:136) org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:71) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:160) org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:81) org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1473) org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:60) org.springframework.orm.jpa.DefaultJpaDialect.beginTransaction(DefaultJpaDialect.java:67) org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427) org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655) br.com.sesc.portal.service.ArticleService$$EnhancerBySpringCGLIB$$3e49d3bf.incrementVisit(<generated>) br.com.sesc.portal.filter.AmountVisitorsFilter.doFilter(AmountVisitorsFilter.java:99) br.com.sesc.portal.cache.CacheFilter.doFilter(CacheFilter.java:53) br.com.sesc.portal.filter.MobileFilter.doFilter(MobileFilter.java:90) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209) com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244) org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:178) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Note The full stack trace of the root cause is available in the server logs.