[ http://jira.andromda.org/browse/HIB-125?page=comments#action_12716 ]
Mark Hofmann commented on HIB-125: ---------------------------------- Ah, ok. Sorry, I am using 3.1. I just helped myself by changing the template to generate shorter names. I saw a discussion in the forum: http://galaxy.andromda.org/forum/viewtopic.php?t=491&highlight=ora00972+identifier+long where Wouter talked about making it a namespace property and that it's a general bug since identifiers shouldn't become longer than the max value of 30 characters (or whatever is set). So, is this bug fixed? Then someone should close this issue ;-) Mark > 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
