Bugs item #1097643, was opened at 2005-01-07 12:48 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=1097643&group_id=22866
Category: JBossCMP Group: v4.0 Status: Open Resolution: None Priority: 5 Submitted By: Richard C. L. Li (clli) Assigned to: Nobody/Anonymous (nobody) Summary: Alter Table not Working in MySQL Initial Comment: I tried to use the following options in CMP deployment: <create-table>true</create-table> <alter-table>true</alter-table> The deployment is deployed to: JBoss 4.0.1 + MySQL 4.x + WindowsXP I found that the app server generates an exception and the CMP Entity Beans cannot be deployed. The exception is caused by the SQL that trying to add a column to an existing column. Finally I figure out in the docs that the alter table feature compares column names in uppercases so that the lower case column names in default mapping cause trouble. I tried to dig into the source codes and figure the comparison is made to DB column names and uppercased column names. I just wonder why not compare both names in uppercase, but only one in uppercase and the other not? I already make a patch for myself which make both names to uppercase before comparison. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1097643&group_id=22866 ------------------------------------------------------- The SF.Net email is sponsored by: Beat the post-holiday blues Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek. It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt _______________________________________________ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development