ManagedWebSessionContext is deprecated, use WebSessionContext instead. session.Dispose() is more true-to-form than close (always dispose disposable objects).
It's _completely_ useless and misleading to call session.Update() on an object that you just loaded from the session. The object is already known and tracked by the session. The transaction will be automatically rollbacked on dispose unless it has been committed, so no need to duplicate the built-in try-catch logic of the using statement. ISessionFactory is thread safe, so no need to lock around call to OpenSession(). But I don't see any obvious problem that would cause the mentioned exception in the code you have posted. /Oskar 2013/3/7 Włodzimierz <[email protected]>: > > Hello, > > I am trying to work with managed sessions in my web application (MVC4). I > have read tutorials but I feel I am doing something wrong. I don't know why > but I feel that I get the same session for many request because I often get > "Open data reader..." exception. The problem is that I get this exception > even if I am sure that I have not used any command, especially in > BeginTransaction().... Commit() block. There is some example function below: > > >> >> ISession session = NHibernateSessionManager.CurrentSession; >> >> using (ITransaction tx = session.BeginTransaction()) >> { >> var account = session.Query<....................> >> >> try >> { >> var q = session.Load<..........................> >> >> q.someProperty = 'a'; >> >> session.Update(q); >> tx.Commit(); >> } >> catch (Exception e) >> { >> tx.Rollback(); >> } >> } > > > > My nhibernate web.config configuration file: > >> <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2"> >> <session-factory> >> <property >> name="current_session_context_class">NHibernate.Context.ManagedWebSessionContext, >> NHibernate</property> >> <property >> name="dialect">NHibernate.Dialect.PostgreSQL82Dialect</property> >> <property >> name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property> >> <property name="connection.connection_string">...</property> >> <property >> name="proxyfactory.factory_class">NHibernate.Bytecode.DefaultProxyFactoryFactory, >> NHibernate</property> >> <property name="show_sql">true</property> >> ... >> </session-factory> >> </hibernate-configuration> > > > As you can see, I have set ManagedWebSessionContext to get one session per > request. I assume that I that it will be new session per each every request, > by using this code in global.asax.cs: > >> protected void Application_BeginRequest(object sender, EventArgs >> e) >> { >> ManagedWebSessionContext.Bind( >> HttpContext.Current, >> NHibernateSessionManager.SessionFactory.OpenSession()); >> } >> >> protected void Application_EndRequest(object sender, EventArgs e) >> { >> ISession session = ManagedWebSessionContext.Unbind( >> HttpContext.Current, >> NHibernateSessionManager.SessionFactory); >> >> if (session != null) >> { >> if (session.Transaction != null && >> session.Transaction.IsActive) >> session.Transaction.Rollback(); >> >> session.Close(); >> } >> } > > > It uses NHibernateSessionManager class listed below to manage sessions: > >> public class NHibernateSessionManager >> { >> private static object SyncObject = new object(); >> private static ISessionFactory _SessionFactory = null; >> >> internal static ISessionFactory SessionFactory >> { >> get >> { >> lock (SyncObject) >> { >> if (_SessionFactory == null) >> { >> Configuration configuration = new >> Configuration().Configure(); >> _SessionFactory = >> configuration.BuildSessionFactory(); >> } >> >> return _SessionFactory; >> } >> } >> } >> >> public static ISession OpenSession() >> { >> lock (SyncObject) >> { >> return SessionFactory.OpenSession(); >> } >> } >> >> public static ISession CurrentSession >> { >> get >> { >> return SessionFactory.GetCurrentSession(); >> } >> } >> } > > > Any help would be appreciated. If you have some tested and working code, > such help would be great as well. > > Best regards. > > > > > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
