Bugs item #532262, was opened at 2002-03-19 18:20 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=532262&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Andrew Scherpbier (scherpbier) >Assigned to: Dain Sundstrom (dsundstrom) Summary: Relationship table names too long Initial Comment: When creating a many to many, bidirectional relationship, the relationship table name generated is longer than what my database (postgres) supports. The name is truncated and deployment proceeds without incidents. Postgres seems to be truncating table names at 31 characters. The table name went from 'Company_marketSegments_MarketSegment_Companies' to 'company_marketsegments_marketse' Upon redeployment, however, the code doesn't find the relationship table with its long name, so it attempts to create it again. This will cause a SQL error since the table actually already exists. This causes (re)deployment to fail with *lots* of stack traces. I've had to resort to shortening the names of the relationship methods to get this to work. This is somewhat related to bug #516835 but is more serious. (At least for me!) It seems to me the table names and column names need to be pushed though a general name mangler so that these sort of things don't happen. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=532262&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
