Try using the latest and see if that fixes the problem... you can change the version in the pom later (if it works)
2008/7/22 java_user_ <[EMAIL PROTECTED]>: > > 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] > >
