Dear All

I currently encounter a problem
I dont know if anybody else here having same experience with me or not.
I dont know if it is Middlegen's problem or problem from somewhere else

Problem is

I have a table
BILL_TYPE_GROUP_MEMBERS which reference to BILL_TYPE_GROUPS_TLI's Uniqe colum BILL_TYPE_GROUPS_TLI_ID

and BILL_TYPE_GROUPS_TLI_ID is defined as foregin key and not-null
for BILL_TYPE_GROUP_MEMBERS Table

But when Middlengen generate mapping files
this BILL_TYPE_GROUPS_TLI_ID is not declared as not-null=true.

see below mapping files,

And more wild thing is BILL_TYPE_GROUP_MEMBERS also
reference to some other Tables primary's key . those primary keys
are not defined as not null foreign keys for BILL_TYPE_GROUP_MEMBERS , but in mapping files generated by middlegen,
those foreign keys are defined as not-null="true". So it is totally another
way around which what I expected or what Table 's constrains defined.

Do you have any idea about this problem? It is problem from Middlegen or
problem from somewhere else?I used sqldeveloper to check my table's constrains, they all look correct.

<class
name="com.bearingpoint.infonova.psm.hibernate.BillTypeGroupMember"
table="BILL_TYPE_GROUP_MEMBERS"
>


<!-- bi-directional one-to-one association to BillTypeGroupsTli -->
<many-to-one
name="billTypeGroupsTli"
class="com.bearingpoint.infonova.psm.hibernate.BillTypeGroupsTli "
unique="true"
>
<meta attribute="field-description">
@hibernate.many-to-one
unique="true"
@hibernate.column name="BILL_TYPE_GROUPS_TLI_ID"
</meta>
<column name="BILL_TYPE_GROUPS_TLI_ID" />
</many-to-one>

Your not showing everything to help but it does indicate you selected the relationship to be a bi-directional one-to-one releationship. Is that what you wanted? It does have specific rendering rules depending on the association.

Thanks for your reply
Did you find some thing wrong here below?
It should have not-null="true",but it is missing in below file gernerated by middlegen

<!-- bi-directional one-to-one association to BillTypeGroupsTli -->
<many-to-one
name="billTypeGroupsTli"
class="com.bearingpoint.infonova.psm.hibernate.BillTypeGroupsTli "
unique="true"
>

Its a part of the one-to-one templates which are a little bit more involved than plain many-to-one templates. I have not got alot of time to look at this (and I have not finished other work I have promissed Max). The templates are easy to change so I suggest you make the change and if all is good submit the patch. Thank you.