Bugs item #951250, was opened at 2004-05-10 13:40 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=951250&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: John Wagg (waggj) Assigned to: Nobody/Anonymous (nobody) Summary: Unecessary alias in SQL Initial Comment: I am testing moving from 3.2.1 to 3.2.4 and have run into a problem involving use of aliases. 3.2.4 differs from 3.2.1 in that the sql generated for loading entity beans includes use of an alias which defaults to the table name with an additional id prepended. This is a problem to us because we use (at times) an informix 7.X database which only allows 18 characters for an identifier in SQL. We also have a table with a 16 character table name. So any use of this table (with the default settings) causes an exception. We can work round this because the maximum alias length can be set in standardjbosscmp-jdbc.xml to a small value and it all works. However, I believe this is a bug because I cannot understand why the use of the alias is necessary at all. Aliases in sql are really only necessary when joining tables to distinguish between columns with the same name in different tables. An entity bean would not normally include data from more than one table and so should not normally need an alias. We are running JBoss 3.2.1 and 3.2.4 on Windows XP using jdk 1.4.2_03 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=951250&group_id=22866 ------------------------------------------------------- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
