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>

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

Reply via email to