[nhibernate-issues] [JIRA] Created: (NH-840) Include Inner Exception on 'Duplicate identifier in table for:' exception msg

[NHibernate J. <mik...@us...>]

Include Inner Exception on 'Duplicate identifier in table for:'  exception msg
------------------------------------------------------------------------------

         Key: NH-840
         URL: http://jira.nhibernate.org/browse/NH-840
     Project: NHibernate
        Type: Improvement
  Components: Core  
    Versions: LATER, 1.2.0.Beta3    
    Reporter: Shane Walters
    Priority: Minor


Using:
   NHibernate 1.2.Beta2
   DotNet 2.0
   MS Sql Server 2000


I encountered the following error in 1.2 Beta 2.

NHibernate.HibernateException: Duplicate identifier in table for: [Singletree.Core.Domain.Folder#89193]
   at NHibernate.Persister.Entity.AbstractEntityPersister.Check(Int32 rows, Object id, Int32 tableNumber, IExpectation expectation, IDbCommand statement)
   at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
   at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, ISessionImplementor session)
   at NHibernate.Impl.ScheduledUpdate.Execute()
   at NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
   at NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
   at NHibernate.Impl.SessionImpl.Execute()


Took me the better part of a day to figure out that I had a trigger which was affecting the row count.  If the TooManyRowsAffectedException is passed to MessageHelper.InfoString, then we get a message that makes it much easier to determine what is happening.

In  NHibernate.Persister.Entity.AbstractEntityPersister.Check(int rows, object id, int tableNumber, IExpectation expectation, IDbCommand statement)

            catch (TooManyRowsAffectedException ex)
			{
				throw new HibernateException(
					"Duplicate identifier in table for: " +
					MessageHelper.InfoString(this, id, Factory),ex);
			}

Now we get a better msg:
NHibernate.HibernateException: Duplicate identifier in table for: [Singletree.Webpdm.Core.Domain.Folder#89193] ---> NHibernate.AdoNet.TooManyRowsAffectedException: Unexpected row count: 2; expected: 1



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira