[ http://jira.andromda.org/browse/HIB-125?page=comments#action_12753 ]
Sebastien Arbogast commented on HIB-125: ---------------------------------------- Another alternative would be to allow the custom setting of the key name as it is possible to choose the name of tables and columns, that is via tagged values. Why not define a new tagged value for inheritance relationships that would allow the developer to choose its own name for this key. Moreover, that would be particularyly useful in environments where there are DB object naming standards to cope with. I'd like to do it myself and propose a patch but I guess adding a tagged value implies changing andromda profiles/metafacades so... > 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 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
