cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrey Razumovsky (JIRA)" <j...@apache.org>
Subject [jira] Commented: (CAY-1389) Cayenne Modeler should warn about reserved words
Date Tue, 09 Feb 2010 11:39:31 GMT

    [ https://issues.apache.org/jira/browse/CAY-1389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12831423#action_12831423
] 

Andrey Razumovsky commented on CAY-1389:
----------------------------------------

This is duplicate of CAY-1188. We've closed that one as "Won't fix".. You can find some discussion
there

> 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.


Mime
View raw message