NHibernate returns overwritten values

JackBigMac · **Joined:** Tue May 17, 2005 2:48 pm **Posts:** 47

I have a class Country with a corresponding table Country in the database. When I get the countries from the database using NHibernate, I get older values and not the current values of a record in the database. When I change 'England' to 'UK', save the object and call GetAll (see code excerpt below), I still get 'England' instead of 'UK' as expected. I checked in the database and the record has changed. Does NHibernate has some caching going on?

Hibernate version:
0.99.1.0

Mapping documents:

Code:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" assembly="MyApp.Domain">
   <class name="Country" table="Country">

      <id name="ID" type="Int32" column="id" unsaved-value="0">
         <generator class="identity"/>
      </id>

      <property name="Name" column="name" type="String" length="50" />
   </class>
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

Code:

public IList GetAll(Type type, params string[] sortProperties)
    {
        ICriteria crit = session.CreateCriteria(type);
        if (sortProperties != null)
        {
            foreach (string sortProperty in sortProperties)
            {
                crit.AddOrder(Order.Asc(sortProperty));
            }
        }
        return crit.List();
    }

...

IList countries = GetAll(typeof(Country), null);

Name and version of the database you are using:
SQL Server 2005

JackBigMac · **Joined:** Tue May 17, 2005 2:48 pm **Posts:** 47

I made a test application to show my problem. It's an ASP. NET 2.0 web application. On the page is a GridView where all records from the Country table are shown. When I edit a country, the old value is shown in the GridView instead of the value I just entered.
I'm starting to think it has something to do with handling NHibernate sessions within the ASP.NET application.
Can you anyone please take a quick look at my test application to see what's wrong? You can download it at http://members.chello.nl/n.gruson

Thanks in advance,
Jack

martijnb · **Joined:** Sat May 14, 2005 8:40 am **Posts:** 130

Can it be possible that the ObjectDataSource caches results between postbacks? I don't think this issue has anything to do with NHibernate.

Btw, that GetAll() method looks very familiar ;)

JackBigMac · **Joined:** Tue May 17, 2005 2:48 pm **Posts:** 47

I added a Test.aspx which does not use GridView or ObjectDataSource to rule out that these components are responsible for the problem. I still get the same behaviour in Test.aspx.

Link: http://members.chello.nl/n.gruson. Could anyone take a second look?

Thanks,
Jack

mattiasjte · **Joined:** Sun Dec 11, 2005 12:22 pm **Posts:** 5

I'm having the same problem with .NET 2.0 and 1.0.1 version of hibernate. No idea why it occurs.