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)