I don't think NHibernate provides you the exact problem, But I can tell you why this is probably happening. I've had this error before and it was when I was trying to put more information into a column than it allowed. such as shoving a 50 character property into a 4 character field. This can be easy to figure out if you take a look at your schema and do some validation on your entities before you execute a save.
Maybe look into using an interceptor to perform the validation of your entity for the required lengths. On Tue, Apr 21, 2009 at 6:04 PM, DanVan <[email protected]> wrote: > > I am calling Save on an nHibernate object that has many children > attached to it. Upon save, sometimes an error happens when nHibernate > starts inserting into my sql database ("The data was truncated while > converting from one data type to another." for instance). Following > are the top lines of the Exception. My question is, how do I figure > out which table/column is the culprit within my save error? > > at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) > at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& > pCursor, Boolean& isBaseTableCursor) > at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand > (CommandBehavior behavior, String method, ResultSetOptions options) > at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() > at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand > cmd) > at NHibernate.Id.Insert.AbstractSelectingDelegate.PerformInsert > (SqlCommandInfo insertSQL, ISessionImplementor session, IBinder > binder) > at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object > [] fields, Boolean[] notNull, SqlCommandInfo sql, Object obj, > ISessionImplementor session) > at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object > [] fields, Object obj, ISessionImplementor session) > at NHibernate.Action.EntityIdentityInsertAction.Execute() > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
