I've tried this with SQL CE and it practically gives me the same
error:
System.IndexOutOfRangeException : An SqlCeParameter with
ParameterIndex '5' is not contained by this SqlCeParameterCollection.
The error occurs when NH tries to insert a CatalogItem in the
database:
public class CatalogItem : DomainEntity
{
private String Description { get; set; }
internal virtual Manufacturer Manufacturer { get; private
set; }
internal virtual String Name { get; private set; }
private Double Price { get; set; }
private Product Product { get; set; }
...
}
public class CatalogCategory : DomainEntity
{
private ISet<CatalogItem> Items { get; set; }
internal virtual String Name { get; private set; }
protected CatalogCategory()
{
Items = new HashedSet<CatalogItem>();
}
...
}
The following gets generated from the schema export:
create table "CatalogCategory" (Id UNIQUEIDENTIFIER not null, Name
TEXT, Catalog_id UNIQUEIDENTIFIER, primary key (Id))
create table "CatalogItem" (Id UNIQUEIDENTIFIER not null, Name TEXT,
Price NUMERIC, Description TEXT, Number INTEGER,
CatalogCategory_id UNIQUEIDENTIFIER, primary key (Id))
When NH tries to insert a record into the "CatalogItem" table, it only
has 5 parameters instead of 6. The one that's missing is
CatalogCategory_id. The exception occurs in the GuidType class of NH
in the following function:
public override void Set(IDbCommand cmd, object value, int
index)
{
((IDataParameter)cmd.Parameters[index]).Value = value;
}
Because the Parameters collection only has 5 parameters, an
ArgumentOutOfRangeException is thrown when the specified index is 5.
For some reason, the parameter for the CatalogCategory_id is missing.
Any thoughts?
On 1 mrt, 23:19, Jan Van Ryswyck <[email protected]> wrote:
> Thx for sharing this. I'll investigate this further tomorrow evening
> and try to debug to the point in the code that you mentioned. It will
> probably be something similar. There is a entry in the NH Jira for
> this but for Oracle (NH-1477). Maybe you could add your case as well?
>
> On 1 mrt, 22:00, "Robert Byrne" <[email protected]> wrote:
>
> > I just debugged a problem very similar to this one, again using SQLite.
>
> > The problem (a strange and elusive one) in my case was that I was using a
> > the same column for a discriminator and a many-to-one.
>
> > I tracked the problem down to SqlInsertBuilder.GetParametersTypeArray(), it
> > uses a class called SafetyEnumerable<T> to filteroutparameter types that
> > are not assignable to T (which in this case is SqlType). The problem is that
> > for some reason when you use the same column for a discriminator and a
> > many-to-one, NHibernate doesn't pick up the type correctly, it actually uses
> > the discriminator-value instead of the type, for example, the elements being
> > enumerated look something like:
>
> > {[
> > "Name"=String,
> > "Description"=String,
> > "DataFieldType"='32',
> > "Id"=Int32
> > ]}
>
> > Notice that the value for DataFieldType is the literal string '32' (which is
> > the discriminator-value for this subclass), when it should be Int32 (like
> > the Id column below it). Explicitly specifying the type on the
> > <discriminator> element in the mapping doesn't help.
>
> > Because SafetyEnumerable quietly filtersoutthis type, the parameter is
> > strippedout, and you now have one less parameter than you should, so when
> > the query is bound, you get anindexoutof bounds exception.
>
> > I'm not sure if this is the exact same problem in your case, but if you set
> > a breakpoint in the above method you can have a look at columns.Values and
> > try and look for something similar.
>
> > If there isn't an open bug for this (there should be an exception if the
> > mapping is invalid, or SafetyEnumerable should throw in this case etc) then
> > I'll post one with steps to reproduce. Let me know.
>
> > By the way, the fix in my case was to remove the many-to-one mapping.
> > Thankfully it was an iffy design choice so I could live without it.
>
> > Hopefully this will save someone else a Sunday afternoon :)
>
> > -----Original Message-----
> > From: [email protected] [mailto:[email protected]] On Behalf
>
> > Of Jan Van Ryswyck
> > Sent: 28 February 2009 20:06
> > To: nhusers
> > Subject: [nhusers] ArgumentOutOfRangeException :Indexwasoutofrange.
>
> > Hi,
>
> > I'm getting this weird ArgumentOutOfRangeException whenever I use the
> > PersitenceSpecification class for verifying an entity that has a
> > reference to a value object.
>
> > public class CatalogItem : DomainEntity
> > {
> > internal virtual Manufacturer Manufacturer { get; private
> > set; }
> > internal virtual String Name { get; private set; }
>
> > protected CatalogItem()
> > {}
>
> > public CatalogItem(String name, String manufacturer)
> > {
> > Name = name;
> > Manufacturer = new Manufacturer(manufacturer);
> > }
> > }
>
> > public class CatalogItemMapping : ClassMap<CatalogItem>
> > {
> > public CatalogItemMapping()
> > {
> > Id(catalogItem => catalogItem.Id);
>
> > Component<Manufacturer>(category => category.Manufacturer,
> > m => m.Map(manufacturer =>
> > manufacturer.Name));
>
> > Map(catalogItem => catalogItem.Name);
> > Map(Reveal.Property<CatalogItem>("Price"));
> > }
> > }
>
> > [TestFixture]
> > public class When_verifying_the_class_mapping_of_a_catalog_item
> > : NHibernateSpecification
> > {
> > [Test]
> > public void Then_a_catalog_object_should_be_persistable()
> > {
> > new PersistenceSpecification<CatalogItem>(Session)
> > .VerifyTheMappings();
> > }
> > }
>
> > [TestFixture]
> > public class NHibernateSpecification
> > : Specification
> > {
> > protected ISession Session { get; private set; }
>
> > protected override void Establish_context()
> > {
> > var configuration = new SQLiteConfiguration()
> > .InMemory()
> > .ShowSql()
> > .ToProperties();
>
> > var sessionSource = new SessionSource(configuration, new
> > RetailerPersistenceModel());
> > Session = sessionSource.CreateSession();
>
> > sessionSource.BuildSchema(Session);
> > ProvideInitialData(Session);
>
> > Session.Flush();
> > Session.Clear();
> > }
>
> > protected override void Dispose_context()
> > {
> > Session.Dispose();
> > Session = null;
> > }
>
> > protected virtual void ProvideInitialData(ISession session)
> > {}
> > }
>
> > Here's the error I'm getting:
>
> > TestCase 'Then_a_catalog_object_should_be_persistable'
> > not executed: System.ArgumentOutOfRangeException :Indexwasoutof
> >range. Must be non-negative and less than the size of the collection.
> > Parameter name:index
> > at System.ThrowHelper.ThrowArgumentOutOfRangeException
> > (ExceptionArgument argument, ExceptionResource resource)
> > at System.ThrowHelper.ThrowArgumentOutOfRangeException()
> > at System.Collections.Generic.List`1.get_Item(Int32index)
> > at System.Data.SQLite.SQLiteParameterCollection.GetParameter
> > (Int32
> >index)
> > at
> > System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item
> > (Int32index)
> > at NHibernate.Type.GuidType.Set(IDbCommand cmd, Object value,
> > Int32
> >index)
> > at NHibernate.Type.NullableType.NullSafeSet(IDbCommand cmd,
> > Object
> > value, Int32index)
> > at NHibernate.Type.NullableType.NullSafeSet(IDbCommand st,
> > Object
> > value, Int32index, ISessionImplementor session)
> > at
> > NHibernate.Persister.Entity.AbstractEntityPersister.Dehydrate
> > (Object id, Object[] fields, Object rowId, Boolean[] includeProperty,
> > Boolean[][] includeColumns, Int32 table, IDbCommand statement,
> > ISessionImplementor session, Int32index)
> > at NHibernate.Persister.Entity.AbstractEntityPersister.Insert
> > (Object
> > id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql,
> > Object obj, ISessionImplementor session)
> > at NHibernate.Persister.Entity.AbstractEntityPersister.Insert
> > (Object
> > id, Object[] fields, Object obj, ISessionImplementor session)
> > at NHibernate.Action.EntityInsertAction.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()
> > d:\Builds\FluentNH\src\FluentNHibernate\Testing
> > \PersistenceSpecification.cs(127,0): at
> > FluentNHibernate.Testing.PersistenceSpecification`1.TransactionalSave
> > (Object propertyValue)
> > d:\Builds\FluentNH\src\FluentNHibernate\Testing
> > \PersistenceSpecification.cs(105,0): at
> > FluentNHibernate.Testing.PersistenceSpecification`1.VerifyTheMappings
> > ()
> > C:\Source\SupplyChain\Tests\Retailer.IntegrationTests\Mappings
> > \CatalogItemMappingSpecifications.cs(14,0): at
> > SupplyChain.Retailer.IntegrationTests.Mappings.When_verifying_the_class_mapp
> > ing_of_a_catalog_item.Then_a_catalog_object_should_be_persistable
> > ()
>
> > Sorry for the long post, but this one got me busy for a couple of
> > hours now. This might not be caused by FNH as I found this JIRA ticket
> > of NH itself that mentions something similar:
>
> >http://forum.hibernate.org/viewtopic.php?p=2395409
>
> > I'm still hoping that I'm doing something wrong in my code :-). Any
> > thought?
>
> > Thanks in advance
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
