I'm not familiar with JetDirect. Please open an issue in jira if you regard this as a bug that should be fixed.
/Oskar 2012/2/8 Michele Lepri <[email protected]>: > Hello and sorry if i resurrect this thread after 5 months, but I solved > 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> > > -- > 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. > -- 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.
