Hi, I am using Appfuse 1.9.4, JSF, Eclipse 3.2 and tomcat plugin of sysdeo.
I have a difficult time to set it up for debugging even I followed first Matt's instruction on http://raibledesigns.com/wiki/Wiki.jsp?page=AppFuseEclipse. I also found a few site giving the instructions but still not working for me. This is what I did: 1. downloaded and installed eclipse, tomcat and sysdeo tomcat plugin; 2. import the appfuse project to eclipse and run ant compile. Fine. 3. put the following appfuse.xml (context.xml) to tomcat_home/conf/catalina/localhost directory <Context path="/appfuse" reloadable="true" docBase="C:\Documents and Settings\QDING\my projects2\appfuse" workDir="C:\Documents and Settings\QDING\my projects2\appfuse\work"> <Logger className="org.apache.catalina.logger.SystemOutLogger" verbosity="4" timestamp="true"/> </Context> 4. starting tomcat within eclipse is fine. 5. run -> debug to configure the debugging. I don't see web application type. So, under Java Application, I created a new configuration "appfuse". Project: appfuse; Main class: ?????. I don't know what should be put in there. I tried org.apache.catalina.startup.Bootstrap as the main class; then I got the error java.lang.NoClassDefFoundError: org/apache/catalina/startup/Bootstrap How do you guys debug through appfuse based the application within eclipse? Would you please share with me your configuration steps? Thank you very much. Qin ________________________________ From: Pete Gould [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 25, 2007 10:16 AM To: users@appfuse.dev.java.net Subject: Re: [appfuse-user] Getting JDBC Exception if application not used for more than 8 hours Hiya, Seems to be a couple of different ways of addressing this problem (none of which I've tried ;p), but maybe this will be of some use to you before someone who knows what they're talking about offers a hand! 1. Increase the wait_timeout setting in your mysql.ini or mysql.cnf file.. which seems to be quoted at a lot of places doing a quick google on those terms. Got to assume that there's some good reason the the default is 8 hours though! Ref for system properties is here: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#opti on_mysqld_wait_timeout 2. Implement something along the lines of what's suggested in section "26.4.5.3.4: I have a servlet/application that works fine for a day, and then stops working overnight" of http://dev.mysql.com/doc/refman/5.0/es/connector-j-usagenotes-troublesho oting.html Cheers, Pete On 9/25/07, sparqle <[EMAIL PROTECTED]> wrote: Hello, I am using Appfuse2.0 RC1, and I get the following JDBC exception every morning on my application (if I am the first person to login). I am guessing that this is happening due to a timeout of the MySQL connections. I tried changing the URL of my database to include the "autoReconnect=true" (in jdbc.properties and applicationContext-resources). Still, I keep getting the same error every morning. Is there any other setting that needs to be changed? regards 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(H ibernateTransactionManager.java:510) at org.springframework.transaction.support.AbstractPlatformTransactionManag er.getTransaction (AbstractPlatformTransactionManager.java:350) at org.springframework.transaction.interceptor.TransactionAspectSupport.cre ateTransactionIfNecessary(TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invok e (TransactionInterceptor.java:102) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref lectiveMethodInvocation.java:166) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke (JdkDynamicAopProxy.java:204) at $Proxy25.loadUserByUsername(Unknown Source) at org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser(D aoAuthenticationProvider.java:100) at org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvide r.authenticate(AbstractUserDetailsAuthenticationProvider.java:119) at org.acegisecurity.providers.ProviderManager.doAuthentication(ProviderMan ager.java :195) at org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAut henticationManager.java:45) at org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthen tication(AuthenticationProcessingFilter.java :71) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin gFilter.java:211) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt erChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H ttpSessionContextIntegrationFilter.java:286) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(Filt erChainProxy.java :275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1 49) 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(ApplicationFilt erChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java :213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.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:1 51) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 4) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc essConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow erWorkerThread.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.readFromUnderlyingStreamIfNeces sary(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(DelegatingCon nection.java:331) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.set AutoCommit (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.AbstractPlatformTransactionManag er.getTransaction(AbstractPlatformTransactionManager.java:350) at org.springframework.transaction.interceptor.TransactionAspectSupport.cre ateTransactionIfNecessary (TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invok e(TransactionInterceptor.java:102) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:166) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo pProxy.java:204) at $Proxy25.loadUserByUsername(Unknown Source) at org.acegisecurity.providers.dao.DaoAuthenticationProvider.retrieveUser (DaoAuthenticationProvider.java:100) at org.acegisecurity.providers.dao.AbstractUserDetailsAuthenticationProvide r.authenticate(AbstractUserDetailsAuthenticationProvider.java:119) at org.acegisecurity.providers.ProviderManager.doAuthentication (ProviderManager.java:195) at org.acegisecurity.AbstractAuthenticationManager.authenticate(AbstractAut henticationManager.java:45) at org.acegisecurity.ui.webapp.AuthenticationProcessingFilter.attemptAuthen tication (AuthenticationProcessingFilter.java:71) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessin gFilter.java:211) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter (FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(H ttpSessionContextIntegrationFilter.java:286) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter (FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:1 49) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java :98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.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/Getting-JDBC-Exception-if-application-not-used-for -more-than-8-hours-tf4515722s2369.html#a12879969 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
