Cayenne Modeler should warn about reserved words
------------------------------------------------
Key: CAY-1389
URL: https://issues.apache.org/jira/browse/CAY-1389
Project: Cayenne
Issue Type: New Feature
Components: Modeler
Affects Versions: 3.0RC2
Environment: Java JDK 6, Cayenne 3.0RC2, Tomcat 6.0.20, Ubuntu 9.10,
MySQL 5.1.41
Reporter: Lucas Holt
Priority: Trivial
Cayenne modeler is a great tool, but it would be nice if it did not allow a
user to use reserved words when creating a database table, warned about them or
"renamed" them to safe alternatives with an _ or some other character.
This isn't easy because each database has reserved words, but it would make
life a whole lot nicer.
http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html
I just had an issue where I used a reserved word in a table and cayenne just
kept spitting out vague errors on the insert statement when commitChanges() was
called on the data content. An alternative solution would be to use ` ` when
referring to names when doing queries under mysql so that these words can be
used.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
