Done http://issues.appfuse.org/browse/APF-976
Nathan ----- "Matt Raible" <[EMAIL PROTECTED]> wrote: > Can you please enter an issue for this in JIRA? > > http://issues.appfuse.org/browse/APF > > Thanks, > > Matt > > On 12/7/07, Ron Anderson <[EMAIL PROTECTED]> wrote: > > > > Finally found the problem. It is in dbcp 1.2.2 version. > > (see this bug https://issues.apache.org/jira/browse/DBCP-244) > > > > The fix is to change dbcp version back to 1.2.1 (in POM). Worked > like a > > champ for me after two days of screwing with various options. > > > > Very hard to replicate on a db with any load as the wait_timeout > doesn't > > expire. Stopping and starting the mysqld service did work for me as > long as > > I was the first to hit it. Otherwise someone else would see the > ugly stack > > trace. > > > > Ron > > > > > > Ron Anderson wrote: > > > > > > It will also fail after the mysql variable 'wait_timeout' expires > which is > > > defaulted to 8 hours. So if no one access the app overnight, the > first > > > user to login in the morning has this error. Will try changing > this > > > variable to verify. > > > > > > Have also been trying to catch the exception so users don't see an > ugly > > > stack trace but no luck so far. > > > > > > Have tried catching it in the userDao, have put a global exception > mapping > > > in my struts.xml and have tried setting up exceptionMappings in my > > > security.xml AuthenticationProcessingFilter but with no success. > > > > > > struts.xml > > > > > > <global-exception-mappings> > > > <exception-mapping > > > > exception="org.springframework.dao.DataAccessException" > > > result="dataAccessFailure" /> > > > <exception-mapping > > > > > > > exception="org.springframework.transaction.CannotCreateTransactionException" > > > result="dataAccessFailure" /> > > > <exception-mapping > > > exception="org.hibernate.TransactionException" > > > result="dataAccessFailure" /> > > > </global-exception-mappings> > > > > > > security.xml AuthenticationProcessingFilter > > > > > > <property name="exceptionMappings"> > > > <props> > > > <prop > > > > key="org.hibernate.TransactionException">/login.jsp?error=true</prop> > > > <prop > > > > key="org.springframework.transaction.CannotCreateTransactionException">/login.jsp?error=true</prop> > > > </props> > > > </property> > > > > > > Anyone have a work around for this or know how to catch the > exception? > > > > > > Ron > > > > > > ----- Original Message ---- > > > From: Nathan Anderson <[EMAIL PROTECTED]> > > > To: users@appfuse.dev.java.net > > > Sent: Wednesday, December 5, 2007 1:25:50 PM > > > Subject: Re: [appfuse-user] Could not open Hibernate Session for > > > transaction; nested exception is > > > > > > > > > I have an app that has this same problem running on: > > > mysql-server-5.0 5.0.45-1ubuntu3 > > > > > > You are right it appears to be at the first login attempt that it > > > fails, after that the app works normally. > > > > > > I hate bugs that are so hard to test [since they take so long to > > > appear]. > > > > > > Nathan > > > > > > > > > ----- "Matt Raible" <[EMAIL PROTECTED]> wrote: > > >> Server version: 5.0.41-community MySQL Community Edition (GPL) > > >> > > >> > > >> > > >> On Dec 5, 2007 , at 9:48 AM, Ron Anderson wrote: > > >> > > >> > > >> > > >> > > >> Which mysql server version are the demo's running on? I'm using > > >> 5.0.22. > > >> > > >> > > >> ----- Original Message ---- > > >> From: Matt Raible < [EMAIL PROTECTED] > > > >> To: users@appfuse.dev.java.net > > >> Sent: Wednesday, December 5, 2007 9:44:17 AM > > >> Subject: Re: [appfuse-user] Could not open Hibernate Session for > > >> transaction; nested exception is > > >> > > >> I haven't seen this problem on the AppFuse demos, but I'm still > using > > >> 5.0.5. I'd suggest hanging out in AppFuse's IRC - sometimes Mark > > >> Matthews (MySQL JDBC Guy) is there. Doesn't look like he's there > now, > > >> but maybe later today . > > >> > > >> You could try posting to the MySQL mailing list. > > >> > > >> Matt > > >> > > >> > > >> On Dec 5, 2007 , at 9:40 AM, Ron Anderson wrote: > > >> > > >> > > > >> > Has anyone solved this problem? I've upgraded to latest mysql > > >> > connector > > >> > 5.0.8 and have the same problem described here (and on some > other > > >> > posts > > >> > related to this issue). > > >> > > > >> > The way to recreate it is to stop and restart mysqld. The first > > >> > time you > > >> > login, you'll see this error. It won't happen again after you > > >> refresh > > >> > and/or re-login. > > >> > > > >> > Ron > > >> > > > >> > > > >> > > > >> > > > >> > kace wrote: > > >> >> > > >> >> Hi fellas, > > >> >> > > >> >> I just got this same error when I tried accessing my app. It's > > >> >> been three > > >> >> days since I last accessed it. Did you guys get this issue > > >> resolved? > > >> >> > > >> >> I am using appfuse 2 final jsf. > > >> >> > > >> >> Thanks > > >> >> > > >> >> ..kace > > >> >> > > >> >> Ealden Escañan wrote: > > >> >>> > > >> >>> On 10/11/07 , Matt Raible < [EMAIL PROTECTED] > wrote: > > >> >>>> > > >> >>>> If you're using M5 (not 2.0 Final), you shouldn't have to > change > > >> >>>> anything. I was just suspicious that the changes I made > might be > > >> >>>> causing the problem. I haven't seen any issues on the demo > site. > > >> >>> > > >> >>> The demo site might be accessed regularly so the problem > might > > >> >>> not be > > >> >>> apparent there... > > >> >>> > > >> >>>> You might try upgrading to the latest MySQL driver (from > > >> >>>> dev.mysql.com ). > > >> >>> > > >> >>> Alright. Will be trying 5.0.8 and 5.1.5. > > >> >>> > > >> >>> Also, what me and Sanath are experiencing looks to be the > same as > > >> >>> http://www.nabble.com/How-to-deal-with-potential-stale- > > >> >>> connections-in-pool--tf4387600s2369.html#a13168040 > > >> >>> > > >> >>> -- > > >> >>> Ealden Esto E. Escañan > > >> >>> http://ealden.net > > >> >>> > > >> >>> > > >> > -------------------------------------------------------------------- > > >> >>> - > > >> >>> To unsubscribe, e-mail: > [EMAIL PROTECTED] > > >> >>> For additional commands, e-mail: > [EMAIL PROTECTED] > > >> >>> > > >> >>> > > >> >>> > > >> >> > > >> >> > > >> > > > >> > -- > > >> > View this message in context: > http://www.nabble.com/Could-not-open- > > >> > Hibernate-Session-for-transaction--nested-exception-is- > > >> > tf4592354s2369.html#a14176572 > > >> > Sent from the AppFuse - User mailing list archive at Nabble.com > . > > >> > > > >> > > > >> > --------------------------------------------------------------------- > > >> > To unsubscribe, e-mail: [EMAIL PROTECTED] > > >> > For additional commands, e-mail: > [EMAIL PROTECTED] > > >> > > > >> > > >> > --------------------------------------------------------------------- > > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > > >> For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > -- > > View this message in context: > http://www.nabble.com/Re%3A-Could-not-open-Hibernate-Session-for-transaction--nested-exception-is-tf4951286s2369.html#a14220132 > > Sent from the AppFuse - User mailing list archive at Nabble.com. > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
