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

Andrey Razumovsky commented on CAY-1188:
----------------------------------------

Well, I tried to add validation for the keywords (actually I took them from 
only one list) and immediately got a bunch of warnings for my datamap, which 
worked well for a long time. So I think this feature can bring more headache 
that profit. Such column names as "comment", "date" (or even "file") are quite 
popular, but they do exist in the keyword list.

> Add method that lists "bad names" and show warning in Cayenne modeler
> ---------------------------------------------------------------------
>
>                 Key: CAY-1188
>                 URL: https://issues.apache.org/jira/browse/CAY-1188
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0M5
>            Reporter: Øyvind Harboe
>            Assignee: Andrey Razumovsky
>
> When creating database models directly in Cayenne, there are names for fields 
> which are incompatible with databases. E.g. naming a field "file" works fine 
> in Derby, but fails in MS SQL server.
> It would be nice if the modeler gave a warning about such bad namechoices. 
> In addition to a global list of bad names, each adapter could ammend names 
> that probably shouldn't be used.
> The main problem is that such bad name choices will only be deteced upon 
> deployment, so testing against Derby and deploying against MS SQL/Oracle can 
> cause unecessary headaches.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to