nhibernate doesn't get a chance to update?

I am building a small web application, where the user is granted the ability t开发者_Go百科o rate items. In my application I am using nhibernate and asp.net mvc.

All the rating requests are sent by jquery (ajax/post). When the user votes an item, I check if the item has been previously voted. If so, I update the last voting value to the new one received. If not, I just add a new rating to my table.

I have noticed something very strange. This works well, but when I click several times really fast something gets screwed up. I get multiple ratings, it seems as if nhibernate doesn't bother checking if the user has previously voted and just returns a false value.

Is this possible? How can I see what's going under the hood?

thank you

You probably have a concurrency problem. I assume that you get a thread and transaction per click. Clicking very fast results in parallel transactions which can't see what others are doing.

You have a typical problem that items which aren't in the database (the new votes) can't be locked.

The solutions are:

• Use lock to avoid multiple votes of the same user being stored at the same time. This doesn't work when you have multiple servers (or AppDomains) on the same database, because the lock is restricted to the AppDomain.
• Use table locks in the database to lock out the whole votes table that only one transaction can add votes at the same time.

Have you turned on NHibernate logging?

Add the following to the hibernate.config.xml file:

<property name="show_sql">true</property>

The sql generated can be seen in the console or test runner output if you are running unit tests. You can also configure log4net to write NHibernate logging information to file (See https://web.archive.org/web/20110514164829/http://blogs.hibernatingrhinos.com/nhibernate/archive/2008/07/01/how-to-configure-log4net-for-use-with-nhibernate.aspx)

Lastly, how are you using NHibernate? Are you using a repository pattern? Its hard to determine what is wrong with your application without some idea of the code.