I've heard nothing from NHUSERS group on how to resolve this. I'd be interested in hearing your workaround of mapping PolicyNumber twice. It sounds ugly, but perhaps the only option. I can't quite figure out how to do this though?
On Jan 26, 10:38 am, Corey Coogan <coreycoo...@yahoo.com> wrote: > Thanks Hudson. I actually posed the question to NHUsers right after > my last reply here. When I find something out, I'll share here. The > DB can't be changed. It's legacy and has an entire insurance company > running expecting that primary key. The brass here won't even > consider it. Thanks for asking though. I am a huge anti-fan of > composite keys as well. > > Corey > > On Jan 26, 9:09 am, Hudson Akridge <hudson.akri...@gmail.com> wrote: > > > It's no different. Your problem isn't a FNH problem, it's an NH problem. > > Also, you may be able to head over to the nhusers > > <http://groups.google.com/group/nhusers>google group and ask your question > > there, they have more experience solving strange edge case scenario's. If > > they can figure it out and get you the xml for it, then we can figure out > > the FNH versions of those xml elements. > > > The only workaround I can think of involves mapping the PolicyNumber column > > twice on the parent table, which is an awful workaround imo (But that would > > allow you to map PolicyNumber as the second property). Is there any way we > > can change the DB schema to move away from CompositeId's (Probably not, but > > figured I'd ask)? > > > On Tue, Jan 26, 2010 at 8:46 AM, Corey Coogan <coreycoo...@yahoo.com> wrote: > > > Thanks for the help here Hudson. I appreciate your continued support. > > > > How would this be possible from an XML mapping strategy? > > > > On Jan 25, 4:28 pm, Hudson Akridge <hudson.akri...@gmail.com> wrote: > > > > Can't have two properties mapped to the same field in NHibernate. That's > > > the > > > > index out of range exception. It's expecting there to be n columns, but > > > > there's really n-1 columns (for the repeat). > > > > > I'm in the middle of a bunch of non-FNH related stuff atm (also known as > > > day > > > > job), but let me think on this and see what we can do about getting > > > around > > > > this. We should be very close to resolving the issue. I was hoping the > > > none > > > > modifier for access would prevent NHibernate from attempting to include > > > the > > > > column in the query a second time. Guess not. More thoughts later. > > > > > On Mon, Jan 25, 2010 at 3:50 PM, Corey Coogan <coreycoo...@yahoo.com> > > > wrote: > > > > > This is almost working. At least I can build the sessionfactory now. > > > > > My tests against SqlLite are failing though. Thanks for all your help. > > > > > > Details below: > > > > > > -------------------------- > > > > > Relevant Mapping > > > > > -------------------------- > > > > > mapping.Map(x => x.PolicyNumberMapping, "POLICY_NUMBER").Access.None > > > > > (); > > > > > > mapping.HasMany(x => x.CreditCards) > > > > > .KeyColumn("POL_NBR") > > > > > .PropertyRef("PolicyNumberMapping"); > > > > > > - <composite-id mapped="false" unsaved-value="undefined"> > > > > > - <key-property name="PolicyNumber" type="System.String, mscorlib, > > > > > Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> > > > > > <column name="`POLICY_NUMBER`" /> > > > > > </key-property> > > > > > - <key-property name="PolicyDateTime" type="System.Nullable`1 > > > > > [[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, > > > > > PublicKeyToken=b77a5c561934e089]], mscorlib, Version=2.0.0.0, > > > > > Culture=neutral, PublicKeyToken=b77a5c561934e089"> > > > > > <column name="`POLICY_DATE_TIME`" /> > > > > > </key-property> > > > > > </composite-id> > > > > > - <property access="none" name="PolicyNumberMapping" > > > > > type="System.String, mscorlib, Version=2.0.0.0, Culture=neutral, > > > > > PublicKeyToken=b77a5c561934e089"> > > > > > <column name="`POLICY_NUMBER`" /> > > > > > </property> > > > > > > ----------------------- > > > > > ERROR > > > > > ----------------------- > > > > > Test method > > > > NHibernate.Spike.Test.Unit.Mappings.When_policy_is_mapped.Can_map_policy > > > > > threw exception: System.ArgumentOutOfRangeException: Index was out of > > > > > 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(Int32 index) > > > > > at System.Data.SQLite.SQLiteParameterCollection.GetParameter(Int32 > > > > > index) > > > > > at > > > > System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item > > > > > (Int32 index) > > > > > at NHibernate.Type.DateTimeType.Set(IDbCommand st, 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.Type.ComponentType.NullSafeSet(IDbCommand st, Object > > > > > value, Int32 begin, 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.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() > > > > > at > > > > NHibernate.Spike.Test.Unit.Mappings.When_policy_is_mapped.Can_map_policy > > > > > () in > > > > > > On Jan 21, 4:03 pm, Hudson Akridge <hudson.akri...@gmail.com> wrote: > > > > > > We are deep in NHibernate magic territory :) If that still doesn't > > > work > > > > > for > > > > > > you, I'll see what I can do about setting up a test environment to > > > what > > > > > > you've got and giving it a go. It's an interesting problem, and I'd > > > like > > > > > to > > > > > > know what the final solution will be. My knowledge in this area is > > > purely > > > > > > theoretical ;) > > > > > > > On Thu, Jan 21, 2010 at 4:00 PM, Corey Coogan <coreycoo...@yahoo.com > > > > > > wrote: > > > > > > > I'll give that a try tomorrow. > > > > > > > > Thanks, > > > > > > > Corey > > > > > > > > On Jan 21, 2:45 pm, Hudson Akridge <hudson.akri...@gmail.com> > > > wrote: > > > > > > > > Ah, that might make sense actually. Because you technically > > > > > > > > don't > > > > > have > > > > > > > > PolicyNumber mapped as a property, it's part of your composite > > > key. > > > > > Try > > > > > > > > something like this: > > > > > > > > Map(x=> PolicyNumberForNH, "PolicyNumber").Access.None(); > > > > > > > > > Then change your property-ref to PolicyNumberForNH and see if > > > > > NHibernate > > > > > > > > gets the clue then. I believe it actually needs a <property> to > > > map a > > > > > > > > property-ref to, and not just a POCO property. > > > > > > > > > On Thu, Jan 21, 2010 at 2:26 PM, Corey Coogan < > > > coreycoo...@yahoo.com > > > > > > > > wrote: > > > > > > > > > I spoke too soon. My claim that it worked was a case of > > > mistaken > > > > > > > > > identity on a test that was being run but recently changed. > > > > > > > > > > Here's what this syntax is producing in an HBM. > > > > > > > > > > - <bag cascade="save-update" name="CreditCards" > > > > > > > > > mutable="true"> > > > > > > > > > - <key property-ref="PolicyNumber"> > > > > > > > > > <column name="`PolNbr`" /> > > > > > > > > > </key> > > > > > > > > > <one-to-many class="Aah.Policy.InfoLayer.CrdtCardAcctRecord, > > > > > > > > > NHibernate.Spike.Data, Version=1.0.0.0, Culture=neutral, > > > > > > > > > PublicKeyToken=null" /> > > > > > > > > > </bag> > > > > > > > > > > I don't think that is right? I get an error during > > > configuration > > > > > from > > > > > > > > > NH that it can't find property PolicyNumber on my Policy > > > > > > > > > object > > > > > > > > > (Parent class to CreditCards). That message is very > > > > > > > > > misleading > > > and > > > > > > > > > led to hours of chasing the wrong stuff. > > > > > > > > > > On Jan 20, 11:41 am, Hudson Akridge <hudson.akri...@gmail.com> > > > > > wrote: > > > > > > > > > > Awesome, glad to be of assistance :) > > > > > > > > > > > On Wed, Jan 20, 2010 at 11:40 AM, Corey Coogan < > > > > > > > coreycoo...@yahoo.com > > > > > > > > > >wrote: > > > > > > > > > > > > This worked like a charm and is exactly what I needed. > > > > > > > > > > > > Thanks again! > > > > > > > > > > > > On Jan 20, 9:34 am, Hudson Akridge < > > > hudson.akri...@gmail.com> > > > > > > > wrote: > > > > > > > > > > > > Understood. Ok, well, let's see if this works: > > > > > > > > > > > > HasMany(x=> > > > > > > x.CreditCards).AsBag().KeyColumn("PolNbr").PropertyRef("PolicyNumber"); > > > > > > > > > > > > > The PropertyRef should allow you to map to a non-key > > > column > > > > > in > > > > > > > the > > > > > > > > > parent > > > > > > > > > > > > table. On the References() side it allows you to map to > > > > > > > > > > > > a > > > non > > > > > key > > > > > > > > > > > property > > > > > > > > > > > > in the related table. PropertyRef is for mapping lagacy > > > data > > > > > > > > > > > specifically. > > > > > > > > > > > > > If that doesn't work, do a quick ExportTo() in your > > > config > > > > > and > > > > > > > paste > > > > > > > > > the > > > > > > > > > > > > hbm.xml mappings if you could, so I can make sure FNH is > > > > > writing > > > > > > > the > > > > > > > > > > > correct > > > > > > > > > > > > XML. > > ... > > read more » -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to fluent-nhibern...@googlegroups.com. To unsubscribe from this group, send email to fluent-nhibernate+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en.
