Hi,
I've created some CDTs with annotations for database table creation and persistence and run into an issue with naming a column in a join table.
Here is a code snippet from my CDT definition:
<xsd:element maxOccurs="unbounded" minOccurs="0" name="roleIds" type="xsd:int"> <xsd:annotation> <xsd:appinfo source="appian.jpa"> @OneToMany(cascade=CascadeType.ALL, indexed=false) @JoinTable(name="FSA_REQUESTED_SYSTEM_ROLE_JOIN") @JoinColumn(name="REQUESTED_SYSTEM_ID", referencedColumnName="ROLE_ID") </xsd:appinfo> </xsd:annotation> </xsd:element>
The issue is that the join table that's been created does not contain a ROLE_ID column, instead it has been called "elt", which is not a particularly helpful name.
Does anyone know how to fix this?
Discussion posts and replies are publicly visible
Have you tried something like this?
@JoinTable(name="FSA_REQUESTED_SYSTEM_ROLE_JOIN", joinColumns=@JoinColumn(name="REQUESTED_SYSTEM_ID"), inverseJoinColumns=@JoinColumn(name="ROLE_ID"))
Doesn't work!