You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Pranay Bhagde (JIRA)" <ji...@apache.org> on 2014/12/04 07:30:12 UTC
[jira] [Created] (OPENJPA-2550) Length of Join Columns
Pranay Bhagde created OPENJPA-2550:
--------------------------------------
Summary: Length of Join Columns
Key: OPENJPA-2550
URL: https://issues.apache.org/jira/browse/OPENJPA-2550
Project: OpenJPA
Issue Type: Question
Components: jpa
Affects Versions: 2.3.0
Reporter: Pranay Bhagde
Hi,
we have observed a certain inconsistency in our schema creation scripts:
If we use a JPA join column on a column in another entity that has a restricted length, this length is not automatically used for the join column.
We use OpenJPA maven plugin for generating DDL from the annotated entities.
Let me give you an example:
JPA Entity Definitions:
EssentialOrderDataBE:
@Id
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumns({
@JoinColumn(name = "EORD_CODE_CODEID", referencedColumnName = "CODE_CODEID", nullable = false),
@JoinColumn(name = "EORD_CODE_SLUN_NUMBER", referencedColumnName = "CODE_SLUN_NUMBER", nullable = false),
@JoinColumn(name = "EORD_CODE_GRAN_NUMBER", referencedColumnName = "CODE_GRAN_NUMBER", nullable = false),
@JoinColumn(name = "EORD_CODE_BMGR_NUMBER", referencedColumnName = "CODE_BMGR_NUMBER", nullable = false) })
private CodeBE code;
CodeBE:
@Id
@Column(name = "CODE_CODEID", length = 5)
private String codeId;
In the database :
V1EREORD
EORD_CODE_CODEID VARCHAR 254
V1ERCODE
CODE_CODEID VARCHAR 5
Could you help us in finding answers to the following questions :
Why is the openjpa transformater which we are using not using the correct length for the join column ?
How can we make it work ? Adjust the Entities ? Additional configuration ? …
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)