Last time I had this problem was due to differences in column names such as idAddress and idaddress. I suggest to check if all column names are following the same name convention.
You can use a regular expression in *.hbm.xml such as that: * column\="[A-Z][a-zA-Z0-9~]+" (first letter of the column is upper case) * column\="[a-z][a-zA-Z0-9~]+" (first letter of the column is lower case) On Wed, Apr 7, 2010 at 7:47 AM, Kenneth <[email protected]> wrote: > Guess it goes under: > > > http://groups.google.com/group/nhusers/browse_thread/thread/9fdb20d515514e82/3c8f9d8e70f694e8?lnk=gst&q=columns#3c8f9d8e70f694e8 > > On Apr 7, 9:32 am, Kenneth <[email protected]> wrote: > > Taken from NHProf: > > SELECT cancellati0_.Subscription_id as Subscrip3_1_, > > cancellati0_.Id as Id1_, > > cancellati0_.Id as Id5_0_, > > cancellati0_.Date as Date5_0_, > > cancellati0_.Subscription_id as Subscrip3_5_0_ > > FROM [CancellationDate] cancellati0_ > > WHERE cancellati0_.Subscription_id = 1 /* @p0 */ > > > > Maps: > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default- > > access="property" auto-import="true" default-cascade="none" default- > > lazy="true"> > > <class xmlns="urn:nhibernate-mapping-2.2" mutable="true" > > name="SubscriptionWithData.CancellationDate, SubscriptionWithData, > > Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" > > table="`CancellationDate`"> > > <id name="Id" type="System.Int32, mscorlib, Version=2.0.0.0, > > Culture=neutral, PublicKeyToken=b77a5c561934e089"> > > <column name="Id" /> > > <generator class="identity" /> > > </id> > > <property name="Date" type="System.DateTime, mscorlib, > > Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> > > <column name="Date" not-null="true" /> > > </property> > > <many-to-one cascade="none" > > class="SubscriptionWithData.Subscription, SubscriptionWithData, > > Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" > > name="Subscription"> > > <column name="Subscription_id" /> > > </many-to-one> > > </class> > > </hibernate-mapping> > > > > Is there a reason why NH selects the same column multiple twice? > > > > Ken > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- Humberto C Marchezi --------------------------------------------------------- Master in Electrical Engineering - Automation Software Consultant and Developer at the Town Hall of Vitória -- 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.
