[Andromda-devel] AndroMDA/JIRA Commented: (NETCART-2) unidirectional reflexive association, problem with "unique"

[<ji...@an...>]

    [ http://jira.andromda.org/browse/NETCART-2?page=3Dcomments#action_1332=
0 ]=20

Michel L=C3=B6hr commented on NETCART-2:
-----------------------------------

Hi, I would likt to know the state on this issue. It is really bugging me..=
.thanks.

> unidirectional reflexive association, problem with "unique"
> -----------------------------------------------------------
>
>          Key: NETCART-2
>          URL: http://jira.andromda.org/browse/NETCART-2
>      Project: .NET Cartridges
>         Type: Bug

>  Environment: A n d r o M D A  -  3.2-RC1-20060125041715
>     Reporter: EricR
>     Assignee: Naresh Bhatia

>
> I have an unidirectional reflexive association 1-to-(0..1). the associati=
on end got the rolename "previous" and is navigable.
> the generated mapping file contains :
> <many-to-one name=3D"Previous" class=3D"nGEFHib.Domain.MyClassImpl, nGEFH=
ibCore" foreign-key=3D"MY_CLASS_PREVIOUS_FKC" outer-join=3D"auto">
>             <column name=3D"PREVIOUS_FK" not-null=3D"false" sql-type=3D"N=
UMERIC(19,0)" unique=3D"true"/>
>  </many-to-one>
> The constraint "unique=3Dtrue" is an error, since null is allowed in the =
foreign key and that produces an SQL runtime error.

--=20
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.andromda.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira