Re: [nhusers] Jet Access Driver and IndexOutOfRange exception on OleDbParameterCollection
Michele Lepri
this problem overriding UseNamedPrefixInSql
public override bool UseNamedPrefixInSql
{
get { return true; }
}
in the JetDriver class.
Hope it help.
michele
--
http://michelelepri.blogspot.com/
Il 27/07/2011 06:39, Doc Saintly ha scritto:
> I'm using nHibernate 3.x along with the Jet driver to work with a
> Microsoft Access database.
>
> I've been going back and forth to get this to work, and currently I'm
> getting this IndexOutOfRange exception whenever I try to do a
> session.Flush after updating some objects:
> Invalid index 21 for this OleDbParameterCollection with Count=21.
>
> I've caught the IndexOutOfRangeException and noticed that the Data
> property on the exception is empty. Is this normal?
>
> I've seen some threads online suggesting various solutions, but most
> of which involve having a composite Id. At one point, I had a unique-
> key constraint between System and Number, but removing it didn't seem
> to solve the problem either.
>
> I appreciate any help anyone can offer.
>
> Here is the main mapping file.
>
> <?xml version="1.0" encoding="utf-8" ?>
> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
>
> <class name="TieInManager.TieIn, TieInManager" table="TieIns">
>
> <id name="Id" column="TieIn_ID" type="Int32" unsaved-value="0">
> <generator class="native"/>
> </id>
>
> <many-to-one name="System" column="System_ID" not-null="true"
> class="TieInManager.TieInSystem, TieInManager" />
>
> <property name="Number" column="TieIn_Number" type="Int32" not-
> null="true" />
>
> <property name="UPN" column="TieIn_Number" type="Int32" not-
> null="false" />
>
> <property name="FlowStream" column="TieIn_FlowStream" type="Int32"
> not-null="false" />
>
> <many-to-one name="Building" column="Building_ID" not-null="false"
> class="TieInManager.Building, TieInManager" />
>
> <many-to-one name="Level" column="Level_ID" not-null="false"
> class="TieInManager.Level, TieInManager" />
>
> <many-to-one name="Sector" column="Sector_ID" not-null="false"
> class="TieInManager.Sector, TieInManager" />
>
> <property name="LocationNotes" column="TieIn_LocNotes" not-
> null="false" type="string" length="255" />
>
> <property name="Size" column="TieIn_Size" type="single" not-
> null="false" />
>
> <many-to-one name="Package" column="Package_ID" not-null="false"
> class="TieInManager.Package, TieInManager" />
>
> <many-to-one name="Scope" column="Scope_ID" not-null="false"
> class="TieInManager.Scope, TieInManager" />
>
> <property name="HotTap" column="TieIn_HotTap" type="boolean" not-
> null="true" />
>
> <property name="Removed" column="TieIn_Removed" type="boolean" not-
> null="true" />
>
> <property name="MadeBy" column="TieIn_MadeBy" type="string" not-
> null="false" length="50" />
>
> <property name="MadeDate" column="TieIn_MadeDate" type="datetime"
> not-null="false" />
>
> <property name="EditedBy" column="TieIn_EditedBy" type="string"
> not-null="false" length="50" />
>
> <property name="EditedDate" column="TieIn_EditedDate"
> type="datetime" not-null="false" />
>
> <property name="ShutDownTime" column="TieIn_ShutDownTime"
> type="string" not-null="false" length="255" />
>
> <property name="ShutDownComment" column="TieIn_ShutDownComment"
> type="string" not-null="false" length="255" />
>
> <property name="Changed" column="TieIn_Changed" type="boolean" not-
> null="true" />
>
> <property name="ChangedDescription"
> column="TieIn_ChangedDescription" type="string" not-null="false"
> length="255" />
>
> <set name="Drawings" table="Drawings" lazy="false"
> fetch="subselect">
> <key column="TieIn_ID"/>
> <element column = "DrawingName" type="string" not-null="false"/>
> </set>
>
> </class>
> </hibernate-mapping>
Oskar Berggren
regard this as a bug that should be fixed.
/Oskar
2012/2/8 Michele Lepri <michel...@gmail.com>:
> --
> You received this message because you are subscribed to the Google Groups "nhusers" group.
> To post to this group, send email to nhu...@googlegroups.com.
> To unsubscribe from this group, send email to nhusers+u...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
>