I googled for it (http://www.google.com/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=5S3&q=MysqlIO.java%3A1913+EOFException&btnG=Search) an found many ppl complaining about the same issue. The most common cause is that MySQL is closing connections after some time and Hibernate still try to use its references to the closed connections.
Some suggestions I found that could help you on that: 1. Try setting you connection url along these lines... jdbc:mysql://127.0.0.1/myDB?autoReconnect=true note the "autoReconnect=true" (http://forums.mysql.com/read.php?39,21289,23786#msg-23786) it looks like this is a deprecated feature in newer versions but there is a property enableDeprecatedAutoreconnect, default is false, which can change that. see this discussion (http://mail-archives.apache.org/mod_mbox/ofbiz-user/200610.mbox/[EMAIL PROTECTED]) 2. Increase MySQL timeout values net_read_timeout, net_write_timeout and wait_timeout (http://forums.mysql.com/read.php?39,202502,216636#msg-216636) 3. Set up a timer to refresh all your connections before MySQL close them. (http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=78&t=002538) 4. Update your MySQL database and driver Hope that helps, Pedro Burglin Anshu Dhamija wrote: > > Hi > > The error is following there is no other exception preceding it > > i am using appfuse-basic-struts 2.0.1 with mysql database. > > > > org.springframework.transaction.CannotCreateTransactionException: Could > not > open Hibernate Session for transaction; nested exception is > org.hibernate.TransactionException: JDBC begin failed: > at > org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(Hiber > nateTransactionManager.java:521) > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.g > etTransaction(AbstractPlatformTransactionManager.java:350) > at > org.springframework.transaction.interceptor.TransactionAspectSupport.createT > ransactionIfNecessary(TransactionAspectSupport.java:261) > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr > ansactionInterceptor.java:101) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect > iveMethodInvocation.java:171) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro > xy.java:204) > at $Proxy23.loadUserByUsername(Unknown Source) > at > org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAu > thenticationProvider.java:127) > at > org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.au > thenticate(AbstractUserDetailsAuthenticationProvider.java:119) > at > org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager > .java:195) > at > org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthent > icationManager.java:45) > at > org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentica > tion(AuthenticationProcessingFilter.java:71) > at > org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil > ter.java:252) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh > ainProxy.java:275) > at > org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS > essionContextIntegrationFilter.java:249) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh > ainProxy.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(Application > FilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:206) > at > org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(Char > acterEncodingFilter.java:96) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF > ilter.java:75) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > va:175) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128 > ) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102 > ) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > :109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) > at > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) > at > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) > at > org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) > at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) > at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java > :889) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav > a:690) > at java.lang.Thread.run(Thread.java:619) > 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(Hiber > nateTransactionManager.java:490) > ... 36 more > Caused by: com.mysql.jdbc.CommunicationsException: Communications link > failure due to underlying exception: > > ** BEGIN NESTED EXCEPTION ** > > java.io.EOFException > > STACKTRACE: > > java.io.EOFException > at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913) > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2304) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) > at com.mysql.jdbc.Connection.execSQL(Connection.java:3118) > at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5215) > at > org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnect > ion.java:331) > at > org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnect > ion.java:331) > at > org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAuto > Commit(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(Hiber > nateTransactionManager.java:490) > at > org.springframework.transaction.support.AbstractPlatformTransactionManager.g > etTransaction(AbstractPlatformTransactionManager.java:350) > at > org.springframework.transaction.interceptor.TransactionAspectSupport.createT > ransactionIfNecessary(TransactionAspectSupport.java:261) > at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Tr > ansactionInterceptor.java:101) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect > iveMethodInvocation.java:171) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro > xy.java:204) > at $Proxy23.loadUserByUsername(Unknown Source) > at > org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(DaoAu > thenticationProvider.java:127) > at > org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvider.au > thenticate(AbstractUserDetailsAuthenticationProvider.java:119) > at > org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderManager > .java:195) > at > org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAuthent > icationManager.java:45) > at > org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthentica > tion(AuthenticationProcessingFilter.java:71) > at > org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil > ter.java:252) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh > ainProxy.java:275) > at > org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS > essionContextIntegrationFilter.java:249) > at > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh > ainProxy.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(Application > FilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:206) > at > org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(Char > acterEncodingFilter.java:96) > at > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestF > ilter.java:75) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application > FilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh > ain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja > va:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja > va:175) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128 > ) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102 > ) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java > :109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) > at > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) > at > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) > at > org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) > at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) > at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java > :889) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav > a:690) > at java.lang.Thread.run(Thread.java:619) > > > ** END NESTED EXCEPTION ** > > > > Last packet sent to the server was 565 ms ago. > at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2515) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) > at com.mysql.jdbc.Connection.execSQL(Connection.java:3118) > at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5215) > at > org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnect > ion.java:331) > at > org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnect > ion.java:331) > at > org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAuto > Commit(PoolingDataSource.java:317) > at > org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63) > ... 38 more > > > > Regards > > Anshu > > > > -----Original Message----- > From: pedro_burglin [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 10, 2008 5:09 PM > To: [email protected] > Subject: Re: [appfuse-user] urgent help needed--login problem > > > > > > Hi Anshu, > > > > Can you run "mvn hibernate3:hbm2dll" and tell us if it succeeds or throws > an > > exception? > > > > Also, can you post the full stacktrace of the exception you are getting? I > > saw on your first post just part of it in the screenshot you included but > I > > am wondering if there isnt any other root exceptions down below. > > > > What database, archetype and version of AppFuse are you using? (I also > cant > > find it in your original post) > > > > Regards, > > Pedro Burglin > > > > > > mraible wrote: > >> > >> Please don't use "urgent" in the subject of your e-mails. > >> > >> If you're using JPA, you likely need to uncomment the OPIVF in your > >> web.xml. > >> > >> Matt > >> > >> On Tue, Jul 8, 2008 at 10:07 PM, Anshu Dhamija > >> <[EMAIL PROTECTED]> wrote: > >>> Hi everyone > >>> > >>> I need an urgent help. When I login into my >>> application > >>> I > >>> get the following error for the first time but for the second time it > >>> works > >>> fine > >>> > >>> Can anyone please help me > >>> > >>> > >>> > >>> Regards > >>> > >>> Anshu > >>> > >>> > >>> > >>> > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > > > > -- > > View this message in context: > http://www.nabble.com/Re%3A-urgent-help-needed--login-problem-tp18354187s236 > 9p18381015.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/Re%3A-urgent-help-needed--login-problem-tp18354187s2369p18462894.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]
