I am using the JARs that came with appfuse 2.0.1 mysql-connector-java-5.0.5.jar
J. David Mendoza R. wrote: > > Are you using the latest mysql jdbc jar? > > 2008/7/21 java_user_ <[EMAIL PROTECTED]>: > >> >> Has anyone figured out what is causing the CommunicationsException after >> 8+ >> hours on idle time? >> It is a stale connection and adding "autoReconnect=true" in the JDBC URL >> has >> not fixed the issue. >> >> There appears to be a few threads on the forum discussing the issue but I >> have not seen a final resolution... >> >> Thanks >> >> >> org.springframework.transaction.CannotCreateTransactionException: Could >> not >> open Hibernate Session for transaction; nested exception is >> org.hibernate.TransactionException: JDBC begin failed: >> Caused by: org.hibernate.TransactionException: JDBC begin failed: >> at >> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68) >> at >> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326) >> at >> >> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510) >> at >> >> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350) >> at >> >> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262) >> at >> >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102) >> at >> >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) >> at >> >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >> at $Proxy25.loadUserByUsername(Unknown Source) >> at >> >> org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:100) >> at >> >> org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:119) >> at >> >> org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:195) >> at >> >> org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:45) >> at >> >> org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:71) >> at >> >> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:211) >> at >> >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) >> at >> >> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:286) >> at >> >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) >> at >> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) >> at >> >> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) >> at >> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) >> at >> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) >> at >> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> at >> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) >> at >> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) >> at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) >> at >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) >> at >> >> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) >> at >> >> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) >> at >> >> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) >> at >> >> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) >> at java.lang.Thread.run(Unknown Source) >> Caused by: com.mysql.jdbc.CommunicationsException: Communications link >> failure due to underlying exception: >> >> ** BEGIN NESTED EXCEPTION ** >> >> java.net.SocketException >> MESSAGE: Software caused connection abort: recv failed >> >> STACKTRACE: >> >> java.net.SocketException: Software caused connection abort: recv failed >> at java.net.SocketInputStream.socketRead0(Native Method) >> at java.net.SocketInputStream.read(Unknown Source) >> at >> >> com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113) >> at >> >> com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160) >> at >> >> com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188) >> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1960) >> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2375) >> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2874) >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623) >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715) >> at com.mysql.jdbc.Connection.execSQL(Connection.java:3243) >> at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5371) >> at >> >> org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331) >> at >> >> org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317) >> at >> org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63) >> at >> org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326) >> at >> >> org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510) >> at >> >> org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350) >> at >> >> org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262) >> at >> >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102) >> at >> >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) >> at >> >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) >> at $Proxy25.loadUserByUsername(Unknown Source) >> at >> >> org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:100) >> at >> >> org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:119) >> at >> >> org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager.java:195) >> at >> >> org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:45) >> at >> >> org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:71) >> at >> >> org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:211) >> at >> >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) >> at >> >> org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:286) >> at >> >> org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) >> at >> org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) >> at >> >> org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) >> at >> >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) >> at >> >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) >> at >> >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) >> at >> >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> at >> >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) >> at >> >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) >> >> -- >> View this message in context: >> http://www.nabble.com/CommunicationsException-tp18569133s2369p18569133.html >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > -- View this message in context: http://www.nabble.com/CommunicationsException-tp18569133s2369p18587206.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
