[ http://jira.andromda.org/browse/HIB-125?page=comments#action_12724 ]
Carlos Cuenca commented on HIB-125: ----------------------------------- This also have some kind of relation with, HIB-14 we should ensure that cutting names does not end with duplicate ones. For column names we should ensure within the table, but for other objects like foreign keys we should ensure for the hole model, since some DB does not allow to have the same foreign key name even if it is on diferent tables > 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 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
