You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Lucas Holt (JIRA)" <ji...@apache.org> on 2010/02/08 22:57:28 UTC
[jira] Created: (CAY-1389) Cayenne Modeler should warn about
reserved words
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.
[jira] Commented: (CAY-1389) Cayenne Modeler should warn about
reserved words
Posted by "Andrey Razumovsky (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (CAY-1389) Cayenne Modeler should warn about
reserved words
Posted by "Andrus Adamchik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAY-1389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12831367#action_12831367 ]
Andrus Adamchik commented on CAY-1389:
--------------------------------------
No comment yet on the feature suggestion, but note that 3.0 supports optional quoting of identifiers. To enable that, select "Quote SQL Identifiers" for a given DataMap in the Modeler.
> 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.