Hi ,,
Currently i am facing a problem regarding Foreign Key Updation in the child
table.
For Example :
There are two tables
1. LabRegnMAS
2. PATREGN.
The cs files and HBM files are as given:
LABREGNMA.hbm.xml
---------------------------------------
<class name="LABREGNMA" table="LABREGNMAS" lazy="true" >
<id name="LABREGID">
<column name="LABREGID" sql-type="int" not-null="true" />
<generator class="identity" />
</id>
<!--<version name="VERNO" column="VERNO" />-->
<property name="VERNO">
<column name="VERNO" sql-type="int" not-null="false" />
</property>
<property name="LABNO">
<column name="LABNO" sql-type="int" not-null="false" />
</property>
<property name="BILLNO">
<column name="BILLNO" sql-type="int" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false" name="PATREGN">
-- value of this is not getting inserted.
<column name="PREGNO" sql-type="int" not-null="true"/>
</many-to-one>
<property name="OPIPNO">
<column name="OPIPNO" sql-type="int" not-null="false" />
</property>
<property name="OPIP">
<column name="OPIP" sql-type="char" not-null="false" />
</property>
<property name="LABDATE">
<column name="LABDATE" sql-type="datetime" not-null="true" />
</property>
<property name="REPORTON">
<column name="REPORTON" sql-type="datetime" not-null="false" />
</property>
<property name="REPORTAT">
<column name="REPORTAT" sql-type="varchar" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false"
name="CONSULTANT"> value of this is getting inserted.
<column name="REFDRCODE" sql-type="int" not-null="true" />
</many-to-one>
<property name="SAMCOLDT">
<column name="SAMCOLDT" sql-type="datetime" not-null="true" />
</property>
</class>
2. PATREGN.hbm.xml
--------------------------------------------
<class name="PATREGN" table="PATREGN" lazy="true" >
<id name="PREGNO">
<column name="PREGNO" sql-type="int" not-null="true" />
<!--<generator class="identity" />-->
</id>
<version name="VERNO" column="VERNO" />
<property name="PREGDATE">
<column name="PREGDATE" sql-type="datetime" not-null="false" />
</property>
<property name="VALIDIDYDATE">
<column name="VALIDIDYDATE" sql-type="datetime" not-null="false" />
</property>
<property name="EMPNO">
<column name="EMPNO" sql-type="int" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false"
name="RELATIONMST">
<column name="PRELATION" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="PATTYPEMST">
<column name="PTYPE" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="SALUTATIONMST">
<column name="PPREFIX" sql-type="nvarchar" not-null="false" />
</many-to-one>
<property name="PNAME">
<column name="PNAME" sql-type="nvarchar" not-null="false" />
</property>
<property name="PDOB">
<column name="PDOB" sql-type="datetime" not-null="false" />
</property>
<property name="PAGE">
<column name="PAGE" sql-type="int" not-null="false" />
</property>
<property name="PAGETYPE">
<column name="PAGETYPE" sql-type="char" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false" name="GENDERMST">
<column name="PSEX" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="MARITALSTATUSMST">
<column name="PMSTATUS" sql-type="nvarchar" not-null="false" />
</many-to-one>
<property name="PFHNAME">
<column name="PFHNAME" sql-type="nvarchar" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false"
name="RELIGIONMST">
<column name="PRELIGION" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="OCCUPATIONMST">
<column name="POCCPN" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="BLOODGROUPMST">
<column name="PBLDGRP" sql-type="nvarchar" not-null="false" />
</many-to-one>
<property name="MNAME">
<column name="MNAME" sql-type="nvarchar" not-null="false" />
</property>
<property name="LNAME">
<column name="LNAME" sql-type="nvarchar" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false" name="RACEMST">
<column name="RACECODE" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false" name="ETHNICMST">
<column name="ETHNICCODE" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="LANGUAGEMST">
<column name="LANCODE" sql-type="nvarchar" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="DISABILITYMST">
<column name="DISCODE" sql-type="nvarchar" not-null="false" />
</many-to-one>
<property name="NEONATYESNO">
<column name="NEONATYESNO" sql-type="char" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false"
name="CONSULTDRCODE" class="CONSULTANT">
<column name="CONSULTDRCODE" sql-type="int" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false" name="REFDRCODE"
class="CONSULTANT">
<column name="REFDRCODE" sql-type="int" not-null="false" />
</many-to-one>
<property name="EDUCODE">
<column name="EDUCODE" sql-type="int" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false"
name="INCOMEGRPMST">
<column name="INCCODE" sql-type="nvarchar" not-null="false" />
</many-to-one>
<property name="BIRTHPLACE">
<column name="BIRTHPLACE" sql-type="nvarchar" not-null="false" />
</property>
<property name="IDONBODY">
<column name="IDONBODY" sql-type="nvarchar" not-null="false" />
</property>
<property name="ISACTIVE">
<column name="ISACTIVE" sql-type="char" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false"
name="MEDUSERCODE_MEDUSER" class="MEDUSER">
<column name="MEDUSERCODE" sql-type="int" not-null="false" />
</many-to-one>
<many-to-one insert="true" update="false" lazy="false"
name="CREATEDBY_MEDUSER" class="MEDUSER">
<column name="CREATEDBY" sql-type="int" not-null="false" />
</many-to-one>
<property name="CREATEDON">
<column name="CREATEDON" sql-type="datetime" not-null="false" />
</property>
<many-to-one insert="true" update="false" lazy="false"
name="MODIFIEDBY_MEDUSER" class="MEDUSER">
<column name="MODIFIEDBY" sql-type="int" not-null="false" />
</many-to-one>
<property name="MODIFIEDON">
<column name="MODIFIEDON" sql-type="datetime" not-null="false" />
</property>
</class>
The problem is that the Primary key value of PATREGN table is not getting
updated in the LABREGNMAS table, but the table "LABREGNMAS" , which holds
the reference of other tables, their foreign key are updated except the
PATREGN primary key.
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/tHR4oXZYXEMJ.
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.
