[
https://issues.apache.org/jira/browse/CAY-1188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12707929#action_12707929
]
Øyvind Harboe commented on CAY-1188:
------------------------------------
If you create a new table with a reserved word => failure.
I can imagine creating a column with a reserved word would fail to.
The problem is that one has to know that all reserved keywords are safe in all
contexts... Very tricky. Better not to use reserved words for columns/tables.
It's not what I know about that will bite me it is what I don't :-)
> 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.
