Hi,

I have a site that use many native SQL queries like the following:

DAO.GetMyList()
{
string sql = "select dto_columns from tablea";
IQuery query = Session.CreateSQLQuery(sql).SetResultTransformer(Transformers.AliasToBean<InspectionDTO>());
return query.List<dto>();
}

When I run this site in my developement environment which is 32 bits developement IIS in VS 2010, everything is fine. However, when I deploy this to a IIS 7.5 site 64bits ASP.NET 4.0, connections are never return to pool.

Btw, I am using Session Per Request pattern to manage NHibernate sessions.

Is this a known issue? or did I miss any necessary code? or should I upgrade to NHibernate 3.1?

Thanks for any possible help!

HZ

I have figured out the cause. My Session par Request httpmodules was not activated in IIS 7.x due to a web.config change in IIS 7.x. Therefore, the end_request event handler was never called so the Session.close was not called.

Anyway, hope this helps others who may experience the same problem.