cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <>
Subject [jira] Commented: (CAY-1389) Cayenne Modeler should warn about reserved words
Date Tue, 09 Feb 2010 09:01:29 GMT


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

View raw message