czuroski
czuroski

Reputation: 4332

Parameter index is out of range

I am getting the following error when trying to update an object using nhibernate. I am attempting to update a field which is a foreign key. Any thoughts why I might be getting this error? I can't figure it out from that error and my log4net log doesn't give any hints either.

Thanks

    System.IndexOutOfRangeException was unhandled by user code
  Message="Parameter index is out of range."
  Source="MySql.Data"
  StackTrace:
       at MySql.Data.MySqlClient.MySqlParameterCollection.CheckIndex(Int32 index)
       at MySql.Data.MySqlClient.MySqlParameterCollection.GetParameter(Int32 index)
       at System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(Int32 index)
       at NHibernate.Type.Int32Type.Set(IDbCommand rs, Object value, Int32 index)
       at NHibernate.Type.NullableType.NullSafeSet(IDbCommand cmd, Object value, Int32 index)
       at NHibernate.Type.NullableType.NullSafeSet(IDbCommand st, Object value, Int32 index, ISessionImplementor session)
       at NHibernate.Persister.Entity.AbstractEntityPersister.Dehydrate(Object id, Object[] fields, Object rowId, Boolean[] includeProperty, Boolean[][] includeColumns, Int32 table, IDbCommand statement, ISessionImplementor session, Int32 index)
       at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
       at NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, 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, Object rowId, ISessionImplementor session)
       at NHibernate.Action.EntityUpdateAction.Execute()
       at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
       at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
       at NHibernate.Engine.ActionQueue.ExecuteActions()
       at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)
       at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)
       at NHibernate.Impl.SessionImpl.Flush()
       at NHibernate.Transaction.AdoTransaction.Commit()
       at DataAccessLayer.NHibernateDataProvider.UpdateItem_temp(items_temp item_temp) in C:\Documents and Settings\user\My Documents\Visual Studio 2008\Projects\mySolution\DataAccessLayer\NHibernateDataProvider.cs:line 225
       at InventoryDataClean.Controllers.ImportController.Edit(Int32 id, FormCollection formValues) in C:\Documents and Settings\user\My Documents\Visual Studio 2008\Projects\mySolution\InventoryDataClean\Controllers\ImportController.cs:line 101
       at lambda_method(ExecutionScope , ControllerBase , Object[] )
       at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
       at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
  InnerException: 

Here is my item mapping -

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DataTransfer" namespace="DataTransfer">
  <class name="DataTransfer.items_temp, DataTransfer" table="items_temp">
    <id name="id" unsaved-value="any" >
      <generator class="assigned"/>
    </id>
    <property name="assetid"/>
    <property name="description"/>
    <property name="caretaker"/>
    <property name="category"/>
    <property name="status"  />
    <property name="vendor" />

    <many-to-one name="statusName" class="status" column="status" />
  </class>
</hibernate-mapping>

Here is my status mapping -

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="DataTransfer" namespace="DataTransfer">
  <class name="DataTransfer.status, DataTransfer" table="status">
    <id name="id" unsaved-value="0">
      <generator class="assigned"/>
    </id>
    <property name="name"/>
    <property name="def"/>

  </class>
</hibernate-mapping>

and here is my update function -

public void UpdateItem_temp(items_temp item_temp)
        {
            ITransaction t = _session.BeginTransaction();
            try
            {
                _session.SaveOrUpdate(item_temp);
                t.Commit();
            }
            catch (Exception)
            {
                t.Rollback();
                throw;
            }
            finally
            {
                t.Dispose();
            }
        }

Upvotes: 8

Views: 9227

Answers (5)

Javier Medina
Javier Medina

Reputation: 41

try this

many-to-one name="statusName" class="status" column="status" insert="false" update="false"

or in mapping by code

ManyToOne<status>(x => x.statusName, map => {map.Column("status"); map.Update(false); map.Insert(false);});

Upvotes: 4

Lucien de Voux
Lucien de Voux

Reputation: 21

I also got this when I erroneously had two column names that were the same in my hibernate mapping.

Something as silly as:

<property name="OrderId" column="order_id" />
<property name="OnlineOrderId" column="order_id" />

Upvotes: 2

kͩeͣmͮpͥ ͩ
kͩeͣmͮpͥ ͩ

Reputation: 7846

You mapped the items_temp.status twice - once as a property and once as a many-to-one reference.

<property name="status"  />
<many-to-one name="statusName" class="status" column="status" />

If you want to do this, you need to change the column name of one of these.

Upvotes: 11

Kevin Gorski
Kevin Gorski

Reputation: 3771

I've encountered an exception that looks like this before when trying to save or update an entity with a mismatch between the mappings and the table; specifically when a column name has been misspelled or the column exists only in one of the two locations.

Upvotes: 1

Daniel Dyson
Daniel Dyson

Reputation: 13230

This could be due to the order in which NHibernate is attempting to save data to the database. I would suspect that it is because it is trying to set the foreign key id in the main table before the foreign key entry is in the referenced table. It would help if you post your mappings and data schema, as well as the code for assigning and saving the property

Upvotes: 0

Related Questions