Bugs item #951250, was opened at 2004-05-10 06:40 Message generated for change (Comment added) made by starksm 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: 2 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 ---------------------------------------------------------------------- Comment By: Scott M Stark (starksm) Date: 2004-12-29 12:52 Message: Logged In: YES user_id=175228 All issues have been moved to http://jira.jboss.com. Existing issues have been moved. New issues will be closed with this canned reponse. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=951250&group_id=22866 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
