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

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

     [ http://jira.nhibernate.org/browse/NH-840?page=all ]
     
Sergey Koshcheyev closed NH-840:
--------------------------------

    Resolution: Fixed

> 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: 1.2.0.Beta2
>     Reporter: Shane Walters
>     Priority: Minor
>      Fix For: 1.2.0.Beta3

>
> 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