[
https://issues.apache.org/jira/browse/CAY-1389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13036157#comment-13036157
]
murali krishna commented on CAY-1389:
-------------------------------------
keep all DB keywords in an array and compare with dbentity name while creating
entities.
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira
