If i remove the "insertable = false, updatable = false" toplink will not
incialize because one column will be in two JoinColumn
Exemple:
@JoinColumn(name = "CDPAIS", referencedColumnName = "CDPAIS")
@ManyToOne(fetch = FetchType.LAZY)
private Pais pais;
@JoinColumns({ @JoinColumn(name = "CDPAIS", referencedColumnName =
"CDPAIS", insertable = false, updatable = false),
@JoinColumn(name = "SGESTADO", referencedColumnName =
"SGESTADO")})
@ManyToOne(fetch = FetchType.LAZY)
private Estado estado;
The column CDPAIS is in two foreign keys on for mapping Pais, and another
for mapping Estado whit SGESTADO.
So the data for column CDPAIS came from entity Pais, and the value for
column SGESTADO cames from Estado entity.
Em Fri, 19 Dec 2008 09:59:34 -0300, Gordon Yorke <gordon.yorke_at_oracle.com>
escreveu:
> This is because you have marked the columns as not updatable and not
> insertable. (insertable = false, updatable = false) TopLink will not
> write values to columns you have configured to not be writable, that
> would violate your configuration and no doubt raise SQL exceptions.
> These columns must be marked as writable if you wish TopLink to write to
> them.
> --Gordon
>
> Guilherme Namen Pimenta wrote:
>> Hello.
>> Could someone help me to implement mappgin one column in two foreign
>> keys.
>> To be more especifc i want to implemet this kind of relationship:
>>
>> @JoinColumns({
>> @JoinColumn(name = "CDPAIS", referencedColumnName = "CDPAIS",
>> insertable = false, updatable = false),
>> @JoinColumn(name = "SGESTADO", referencedColumnName =
>> "SGESTADO",
>> insertable = false, updatable = false),
>> @JoinColumn(name = "CDMUNICIPIO", referencedColumnName =
>> "CDMUNICIPIO", insertable = false, updatable = false),
>> @JoinColumn(name = "CDBAIRRO", referencedColumnName =
>> "CDBAIRRO")})
>> @ManyToOne(fetch = FetchType.LAZY)
>> private Bairro bairro;
>>
>> @JoinColumns({
>> @JoinColumn(name = "CDPAIS", referencedColumnName = "CDPAIS",
>> insertable = false, updatable = false),
>> @JoinColumn(name = "SGESTADO", referencedColumnName =
>> "SGESTADO")})
>> @ManyToOne(fetch = FetchType.LAZY)
>> private Estado estado;
>>
>> @JoinColumns({
>> @JoinColumn(name = "CDPAIS", referencedColumnName = "CDPAIS",
>> insertable = false, updatable = false),
>> @JoinColumn(name = "SGESTADO", referencedColumnName =
>> "SGESTADO",
>> insertable = false, updatable = false),
>> @JoinColumn(name = "CDMUNICIPIO", referencedColumnName =
>> "CDMUNICIPIO")})
>> @ManyToOne(fetch = FetchType.LAZY)
>> private Municipio municipio;
>>
>> @JoinColumn(name = "CDPAIS", referencedColumnName = "CDPAIS")
>> @ManyToOne(fetch = FetchType.LAZY)
>> private Pais pais;
>>
>> TopLink can't generete correct insert an update sql setence for this
>> mapping, it simple ignores the municipio, estado and bairro.
>> Thanks
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
>> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>
--
Usando o revolucionário cliente de e-mail do Opera:
http://www.opera.com/mail/