I have a log in process that locks user accounts if security questions are not answered properly.
If a user account gets locked , I update the db ( outside of the application ) to unlock the user. If the user tries to log back in before their session has timed out....Hibernate fetches the stale user Object via a named query. How do I force a refresh - direct db read so the User object is refreshed??
I tried query hints, but understand this addresses 2nd level cache? and it didn't work. I tried invalidating the http session to remove any saved data there, I need a similar operation for Hibernate to clear the User Object??


Anyone?

I am trying to force a fresh user object read for one named query.

Thanks for you help.