Bugs item #544342, was opened at 2002-04-15 13:48 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=544342&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: frederik sauer (fredsa) Assigned to: Nobody/Anonymous (nobody) Summary: SQL table aliases also exceed db limits Initial Comment: Using custom Finder method (CMP2.0) JBoss can generate long table aliases which exceed datbase limitations. Also refer to these related bugs: 516835 pk constraint name too long 532262 relationship table names too long In the following JBoss generated example query the table alias "t2_si_oDTSecurityGroups_RELATION" exceeds Oracle's limitations causing an "ORA-00972: identifier is too long": SELECT t0_secgrp.ODT_SECURITY_GROUP_ID FROM SYSTEM_IDENTITY t1_si, ODT_SECURITY_GROUP t0_secgrp, SYSTEM_ID_TO_SECURITY_GROUP t2_si_oDTSecurityGroups_RELATION WHERE t1_si.SYSTEM_ID = :1 AND (t1_si.SYSTEM_ID=t2_si_oDTSecurityGroups_RELATION.SYST EM_ID AND t0_secgrp.ODT_SECURITY_GROUP_ID=t2_si_oDTSecurityGroup s_RELATION.ODT_SECURITY_GROUP_ID) ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376685&aid=544342&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development