IMO you are using a "try-catch" technique to study how work with NHibernate. http://nhforge.org/doc/nh/en/index.html#mapping-declaration-id
<http://nhforge.org/doc/nh/en/index.html#mapping-declaration-id>in addition http://nhforge.org/content/Books.aspx <http://nhforge.org/content/Books.aspx>btw try to create the DB using NHibernate and then check the differences. Configuration cfg = ....; new SchemaExport(cfg).Create(false, true); On Tue, Oct 26, 2010 at 4:20 PM, [email protected] < [email protected]> wrote: > If I remove > > <generator class="foreign"> > <param name="property">structural</param> > </generator> > > it gives an error: > > The element 'id' in namespace 'urn:nhibernate-mapping-2.2' has > incomplete content. List of possible elements expected: > 'urn:nhibernate-mapping-2.2:meta urn:nhibernate-mapping-2.2:column > urn:nhibernate-mapping-2.2:generator'. > > How do I fix this? > > Thanks, > > Robert > > On Oct 26, 1:56 pm, Fabio Maulo <[email protected]> wrote: > > It is available btw with > > <generator class="foreign"> > > <param name="property">structural</param> > > </generator> > > you are saying to NH that he must assign the ID and, probably, you have > an > > identity in the Structural table. > > > > On Tue, Oct 26, 2010 at 3:46 PM, [email protected] < > > > > > > > > [email protected]> wrote: > > > No, I'm not generating the database with NHibernate. Not completely > > > sure that feature was available in version 1.2. > > > > > Thanks, > > > > > Robert > > > > > On Oct 26, 1:32 pm, Fabio Maulo <[email protected]> wrote: > > > > <generator class="foreign"> > > > > <param name="property">structural</param> > > > > </generator> > > > > > > are you generating the DB using NH ? > > > > > > On Tue, Oct 26, 2010 at 3:17 PM, [email protected] < > > > > > > [email protected]> wrote: > > > > > When trying to map a class and a composite with multiple sub-types > to > > > > > the same table, I get the error "Cannot insert explicit value for > > > > > identity column in table 'Structural' when IDENTITY_INSERT is set > to > > > > > OFF." when attempting to create an instance of "Structural" that > > > > > pertains to the mapping file below. I am using NHibernate 1.2 if it > > > > > matters. I found the following article that suggest this type of > > > > > mapping is possible: > > > > > > http://colinjack.blogspot.com/2008/03/nhibernate-working-around-lack-. > > > .. > > > > > > > <?xml version="1.0" encoding="utf-8" ?> > > > > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> > > > > > <class name="Esl.Domain.Buildings.Structural, Esl.Domain" > > > > > table="Structural"> > > > > > <id name="id" access="field" column="Id"> > > > > > <generator class="native" /> > > > > > </id> > > > > > <property name="isDirty" column="IsDirty" > > > access="field"/> > > > > > <property name="solarHeatGain" > column="SolarHeatGain" > > > > > access="field" type="Nullables.NHibernate.NullableDoubleType, > > > > > Nullables.NHibernate" /> > > > > > <property name="wallCavityInsulation" > > > > > column="WallCavityInsulation" > > > > > access="field" type="Nullables.NHibernate.NullableDoubleType, > > > > > Nullables.NHibernate" /> > > > > > <property name="wallContinuousInsulation" > > > > > column="WallContinuousInsulation" access="field" > > > > > type="Nullables.NHibernate.NullableDoubleType, > Nullables.NHibernate" / > > > > > > > <property name="wallExteriorFinish" > > > > > column="WallExteriorFinish" > > > > > access="field" /> > > > > > <property name="uValue" column="UValue" > access="field" > > > > > type="Nullables.NHibernate.NullableDoubleType, > Nullables.NHibernate" / > > > > > > > <property name="numberOfBedrooms" > > > column="NumberOfBedrooms" > > > > > access="field" type="Nullables.NHibernate.NullableInt32Type, > > > > > Nullables.NHibernate" /> > > > > > <many-to-one name="roof" access="field" > cascade="all" > > > > > class="Esl.Domain.Buildings.Roof, Esl.Domain" column="RoofId" /> > > > > > > > <one-to-one name="foundation" access="field" > cascade="all-delete- > > > > > orphan" /> > > > > > > > <list access="field" name="floors" table="Floors" cascade="all- > > > > > delete-orphan"> > > > > > <key column="StructuralId" /> > > > > > <index column="Position" /> > > > > > <one-to-many > class="Esl.Domain.Buildings.Floor, > > > > > Esl.Domain"/> > > > > > </list> > > > > > </class> > > > > > > > <class name="Esl.Domain.Buildings.Foundation, Esl.Domain" > > > > > table="Structural" discriminator-value="-1"> > > > > > > > <id name="id" access="field" column="Id"> > > > > > <!--This lets us get away breaking out Foundation into a class > > > > > mapping without > > > > > creating another database table or a database migration--> > > > > > <generator class="foreign"> > > > > > <param name="property">structural</param> > > > > > </generator> > > > > > </id> > > > > > <discriminator column="FoundationType" type="integer" /> > > > > > > > <property name="isDirty" column="FoundationIsDirty" > access="field"/ > > > > > > > <property name="insulation" column="FloorOrSlabInsulation" > > > > > access="field" type="Nullables.NHibernate.NullableDoubleType, > > > > > Nullables.NHibernate" /> > > > > > > > <one-to-one constrained="true" name="structural" > access="field"/> > > > > > > > <subclass name="Esl.Domain.Buildings.SlabFoundation, Esl.Domain" > > > > > discriminator-value="0"/> > > > > > <subclass name="Esl.Domain.Buildings.PilingFoundation, > Esl.Domain" > > > > > discriminator-value="1"/> > > > > > <subclass name="Esl.Domain.Buildings.PierAndBeamFoundation, > > > > > Esl.Domain" > > > > > discriminator-value="2"/> > > > > > <subclass name="Esl.Domain.Buildings.ConditionedBelowFoundation, > > > > > Esl.Domain" > > > > > discriminator-value="3"/> > > > > > </class> > > > > > </hibernate-mapping> > > > > > > > Any help would be greatly appreciated. > > > > > > > Thanks, > > > > > > > Robert > > > > > > > -- > > > > > 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]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > <nhusers%[email protected]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > > > > > . > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/nhusers?hl=en. > > > > > > -- > > > > Fabio Maulo > > > > > -- > > > 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]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/nhusers?hl=en. > > > > -- > > Fabio Maulo > > -- > 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. > > -- Fabio Maulo -- 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.
