[Andromda-devel] AndroMDA/JIRA Commented: (HIB-125) limit the length of all our constraints and column names (default max length = 30)

[Chad B. (JIRA) <ji...@an...>]

    [ http://jira.andromda.org/browse/HIB-125?page=comments#action_12717 ] 

Chad Brandon commented on HIB-125:
----------------------------------

Even if the suffix has been shortened, we still need to enforce max length (because you'll still run into the problem).

> limit the length of all our constraints and column names (default max length = 30)
> ----------------------------------------------------------------------------------
>
>          Key: HIB-125
>          URL: http://jira.andromda.org/browse/HIB-125
>      Project: Hibernate Cartridge
>         Type: Bug

>     Versions: 3.1-RC1
>     Reporter: coffee li
>     Assignee: Carlos Cuenca

>
> at hibernate cartridge's template file: hibernate.hbm.xml.vm: 
> Code: 
>             <key foreign-key="${entity.tableName}_INHERITANCE_FKC">                    
>                 <column name="$entity.subclassKeyColumn" sql-type="$identifier.sqlType"/> 
>             </key> 
> I think the suffix _INHERITANCE_FKC for inheritance foreign key is too long. 
> So when I execute the generated DDL under oracle, following error may occur: 
> Code: 
>     [sql] [ERROR] Failed to execute: alter table SIMPLE_KNOWLEDGE add constraint 
>  SIMPLE_KNOWLEDGE_INHERITANCE_FKC foreign key (ID) references KNOWLEDGE 
>     [sql] [ERROR] java.sql.SQLException: ORA-00972: identity is too long 

-- 
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