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: [email protected]
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: [email protected]
> 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]
