In the main pom I changed the following property (at the very bottom). <commons.dbcp.version>1.2.1</commons.dbcp.version>
Previously it had been set to 1.2.2 I've been doing some testing and haven't noticed any adverse affects from reverting to this dbcp version. Then did a 'mvn clean package'. BTW I'm using full source so not sure if there are any differences for folks using modular projects. Ron ----- Original Message ---- From: Nathan Anderson <[EMAIL PROTECTED]> To: users@appfuse.dev.java.net Sent: Saturday, December 8, 2007 7:36:44 PM Subject: Re: [appfuse-user] Could not open Hibernate Session for transaction; nested exception is Hi Ron, What change did you make to your pom.xml to force commons-dbcp to version 1.2.1? I'm going to try just adding the dependency, but as you know this is a bit hard to test to see if it worked ;) Thanks Nathan ----- "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]
