Thank you for your help. Very new to nhibernate and so its very confusing.
Cheers On Jul 31, 3:38 am, Nexus <[email protected]> wrote: > in the child mapping change this > > CHILD: > > <property name="RegUserId" column="RegUserId" type="Int64" > insert="false"update="false" /> > > You have duplicate mapped once explicit see above and once implicit > see below > > <many-to-one name="RegUsers" column="RegUserId" not- > null="true" class="PaRegUser, App_Code" /> > > Greetings > > On 29 jul, 15:05, Teclioness <[email protected]> wrote: > > > > > Hi, > > > I have a parent child relationship tables set up. In the UI, I show > > the details of parent and child details. After the user make changes > > in UI, I need to save it back to the db, but I am getting following > > error: > > > NHibernate.ADOException was caught > > Message="could notupdate: [PlanningMaps.vo.PaRegAddresses#2][SQL: > >UPDATEPaRegAddresses SET RegUserId = ?, AddressCity = ?, > > AddressCountry = ?, AddressLine = ?, AddressLine1 = ?, AddressPostcode > > = ?, RegUserId = ?, IsBillingAddress = ?, IsShippingAddress = ? WHERE > > RegAddressID = ?]" > > > and innerexception is: > > > System.Data.SqlClient.SqlException: Column name 'RegUserId' appears > > more than once in the result column list. > > > Here is the mapping details: > > PARENT: > > > <?xml version="1.0" encoding="utf-8" ?> > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > > namespace="PlanningMaps.vo" assembly="PlanningMaps.vo"> > > <class name="PaRegUser, __code" table="PaRegUsers" lazy="false"> > > <id name="Id" type="Int64" column="RegUserId"> > > <generator class="identity" /> > > </id> > > <property name="RegTradeName" column="RegTradeName" > > type="String" /> > > <property name="RegTitle" column="RegTitle" type="String" /> > > <property name="RegContactName" column="RegContactName" > > type="String" /> > > <property name="RegPassword" column="RegPassword" > > type="String" /> > > <property name="RegEmail" column="RegEmail" type="String" /> > > <property name="RegPhoneNumber" column="RegPhoneNumber" > > type="String" /> > > <bag name="PaRegAddresses" inverse="true" cascade="all-delete- > > orphan" lazy="false"> > > <key column="RegUserID" /> > > <one-to-many class="PaRegAddresses, App_Code" /> > > </bag> > > </class> > > </hibernate-mapping> > > > CHILD: > > > <?xml version="1.0" encoding="utf-8" ?> > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > > namespace="PlanningMaps.vo" assembly="PlanningMaps.vo"> > > <class name="PaRegAddresses, __code" table="PaRegAddresses" > > lazy="false"> > > <id name="Id" type="Int64" column="RegAddressID"> > > <generator class="identity" /> > > </id> > > <property name="RegUserId" column="RegUserId" type="Int64" /> > > <property name="AddressCity" column="AddressCity" > > type="String" /> > > <property name="AddressCountry" column="AddressCountry" > > type="String" /> > > <property name="AddressLine" column="AddressLine" > > type="String" /> > > <property name="AddressLine1" column="AddressLine1" > > type="String" /> > > <property name="AddressPostcode" column="AddressPostcode" > > type="String" /> > > <many-to-one name="RegUsers" column="RegUserId" not- > > null="true" class="PaRegUser, App_Code" /> > > <property name="IsBillingAddress" column="IsBillingAddress" > > type="Boolean" /> > > <property name="IsShippingAddress" column="IsShippingAddress" > > type="Boolean" /> > > </class> > > </hibernate-mapping> > > > AND THE CODE: > > > public void UpdateRegCustomer( PaRegUser regUser ) { ITransaction tx = > > null; try { if (!session.IsConnected) { session.Reconnect(); } > > > tx = session.BeginTransaction(); > > > if (regUser != null) > > session.Update(regUser); > > tx.Commit(); > > } > > session.Disconnect(); > > } > > catch (Exception ex) > > { > > tx.Rollback(); > > session.Disconnect(); > > log.Error("UpdateRegCustomer( PaRegUser regUser ) method", > > ex); > > throw ex; > > // handle exception > > } > > } > > Pl. let me know what it is I am doing wrong here. and what change I > > need to do to be able toupdateparent and child records. Thank you > > for your help. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
